function getAllTables()
{
$pdo = DbUtil::connect();
$sql = "select table_name from information_schema.tables where table_schema='numeracy'";
//$sql ="DESCRIBE numeracy.m01_user";
$values = $pdo->query($sql);
$count = 1;
$result = "";
$tableArray = array();
if (is_array($values) || is_object($values)) {
foreach ($values as $row) {
$tableName = $row['table_name'];
print "<p class='btn-info'>" . $count++ . " >" . dashesToCamelCase($tableName, true) . "Facade.php</p><br/>";
print "<div class='alert alert-danger clearfix'> <?php<br/>";
print 'namespace com\\numeracy\\facade; <br/>';
print " include_once '../util/DbUtil.php';<br/>\n\t\t\t\t\t\t\t include_once '../util/CommonUtil.php';<br/>";
print " //bo includes<br/>\n\t\t\t\t\t\t\t include_once '../bo/" . dashesToCamelCase($tableName, true) . "BO.php';<br/>\n\t\t\t\t\t\t\t<br/>\n\t\t\t\t\t\t\t // dao includes<br/>\n\t\t\t\t\t\t\t include_once '../dao/" . dashesToCamelCase($tableName, true) . "Dao.php';<br/>\n\t\t\t\t\t\t\t<br/>\n\t\t\t\t\t\t\t // Util<br/>\n\t\t\t\t\t\t\t use com\\numeracy\\util\\DbUtil;<br/>\n\t\t\t\t\t\t\t use com\\numeracy\\util\\CommonUtil;<br/>\n\t\t\t\t\t\t\t<br/>\n\t\t\t\t\t\t\t use com\\numeracy\\BO\\" . dashesToCamelCase($tableName, true) . "BO;<br/>\n\t\t\t\t\t\t\t use com\\numeracy\\Dao\\" . dashesToCamelCase($tableName, true) . "Dao;<br/>";
//print(' require __DIR__ . "\BaseBO.php"; <br/>use com\numeracy\BO\BaseBO; <br/> ' );
//print("class ".dashesToCamelCase($tableName,true)."BO extends BaseBO {<br/>");
print "class " . dashesToCamelCase($tableName, true) . "Facade {<br/>";
$tableArray[] = $row['table_name'];
print "<br/>";
getCreateFunction($tableName);
print "<br/>";
getUpdateFunction($tableName);
print "<br/>";
getDeleteFunction($tableName);
print "<br/>";
getAllFunction($tableName);
print "}<br/>";
print "?><br/></div>";
print "<br/>";
}
}
DbUtil::disconnect();
return $tableArray;
}
//$select_row_function = '';//继承
//$select_count_function = '';//继承
$update_function = " " . 'public function update($where,$data) {' . "\n";
//$delete_function = '';//继承
continue;
} else {
if (stripos($one_line, '`') === 0) {
$start_pos = stripos($one_line, '`');
$end_pos = strripos($one_line, '`');
$l = $end_pos - $start_pos - 1;
$column_name = substr($one_line, $start_pos + 1, $l);
//echo $column_name.'';
$comment_result .= convertComment($one_line, $column_name);
$insert_row_function .= getInsertRowFunction($one_line, $column_name);
$insert_rows_function .= getInsertRowsFunction($one_line, $column_name);
$update_function .= getUpdateFunction($one_line, $column_name);
}
if (stripos($one_line, ')') === 0) {
$insert_row_function .= " " . 'return $this->db->insertRow($this->table_name,$data_for_query);' . "\n " . '}' . "\n";
$insert_rows_function .= " " . '$data_for_query[] = $tmp_data;' . "\n " . '}' . "\n " . 'return $this->db->insertRows($this->table_name,$data_for_query);' . "\n " . '}' . "\n";
$update_function .= ' if(empty($data_for_query)) {';
$update_function .= ' return true;';
$update_function .= ' }';
$update_function .= ' return $this->db->update($this->table_name,$where,$data_for_query);' . "\n " . '}' . "\n";
$dao_file_content .= $comment_result . " \n" . $insert_row_function . " \n" . $insert_rows_function . " \n" . $update_function . '}' . "\n" . '?>';
file_put_contents('../' . $file_name, $dao_file_content);
//break;
}
}
}
fclose($file);
