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);