function getSPNameUrlSafe($spid) {
$spname = getSPName($spid);
$spname = makeURLSave($spname);
return $spname;
}
function createProcedureAndDAL($Database, $tableName, $sps, $spsDel, $prefixSp, $seprator)
{
mysql_select_db($Database);
$result = mysql_query("Select * From {$tableName}") or die('Not Get Data');
$resultTypes = mysql_query("SHOW FIELDS FROM {$Database}.{$tableName}");
$index = 0;
while ($row = mysql_fetch_array($resultTypes)) {
$types[$index] = array(GetRealTypes($row['Type']), mysql_field_len($result, $index));
$index++;
}
$fields = mysql_num_fields($result);
$i = 0;
while ($i < mysql_num_fields($result)) {
$meta = mysql_fetch_field($result, $i);
$recs[$i] = $meta->name;
$maxL[$i] = $meta->max_length;
if ($meta->primary_key == 1) {
$Primary = array($meta->name, $meta->type);
}
$i++;
}
// delete sps
deleteProcedures($tableName, $spsDel, $prefixSp, $seprator);
$lenPerfixSeprator = strlen($prefixSp) + strlen($seprator) + 1;
// create sps and dal
$dalMethods = '';
foreach ($sps as $spname) {
if ($spname == 'SelectAll') {
$sp_name = getSPName($tableName, $spname, $prefixSp, $seprator);
$Query = CreateSelectAll($tableName, $recs, $sp_name, $lenPerfixSeprator);
$result2 = mysql_query($Query[0]) or die("Not Create proc {$sp_name}");
echo "<pre>{$Query['0']}</pre>";
$dalMethods .= $Query[1];
} else {
if ($spname == 'SelectRow') {
$sp_name = getSPName($tableName, $spname, $prefixSp, $seprator);
$Query = CreateSelectRow($tableName, $recs, $Primary, $sp_name, $lenPerfixSeprator);
$result2 = mysql_query($Query[0]) or die("Not Create proc {$sp_name}");
echo "<pre>{$Query['0']}</pre>";
$dalMethods .= $Query[1];
} else {
if ($spname == 'DeleteRow') {
$sp_name = getSPName($tableName, $spname, $prefixSp, $seprator);
$Query = CreateDeleteRow($tableName, $recs, $Primary, $sp_name, $lenPerfixSeprator);
$result2 = mysql_query($Query[0]) or die("Not Create proc {$sp_name}");
echo "<pre>{$Query['0']}</pre>";
$dalMethods .= $Query[1];
} else {
if ($spname == 'UpdateRow') {
$sp_name = getSPName($tableName, $spname, $prefixSp, $seprator);
$Query = CreateUpdate($tableName, $recs, $Primary, $types, $sp_name, $lenPerfixSeprator);
$result2 = mysql_query($Query[0]) or die("Not Create proc {$sp_name}");
echo "<pre>{$Query['0']}</pre>";
$dalMethods .= $Query[1];
} else {
if ($spname == 'Insert') {
$sp_name = getSPName($tableName, $spname, $prefixSp, $seprator);
$Query = CreateInsert($tableName, $recs, $Primary, $types, $sp_name, $lenPerfixSeprator);
$result2 = mysql_query($Query[0]) or die("Not Create proc {$sp_name}");
echo "<pre>{$Query['0']}</pre>";
$dalMethods .= $Query[1];
}
}
}
}
}
}
foreach ($sps as $spname) {
if ($spname == 'CreateDAL') {
CreateDAL($tableName, $dalMethods);
echo "<hr /><pre>Created Data Access Layer</pre>";
}
}
}
