Changeset 20924 for lang/php/misc/Hermit/src/Hermit/creator/HermitAutoInsertSqlCreator.php

Timestamp:

10/07/08 20:34:25 (3 months ago)

Author:

nowelium

Message:

CRUD + procedure まで一通り終わり

Files:

• lang/php/misc/Hermit/src/Hermit/creator/HermitAutoInsertSqlCreator.php (modified) (1 diff)

lang/php/misc/Hermit/src/Hermit/creator/HermitAutoInsertSqlCreator.php

@@ -5 +5 @@
  */
 class HermitAutoInsertSqlCreator implements HermitSqlCreator {
+    private $insert;
     public function initialize(PDO $pdo, ReflectionMethod $method, HermitAnnote $annote){
+        $meta = HermitDatabaseMetaFactory::get($pdo);
+        $table = $annote->getTable();
+        $info = $meta->getTableInfo($table);
+        $columns = $info->getColumns();
+        $insert = 'INSERT INTO';
+        $insert .= ' ';
+        $insert .= $table;
+        $insert .= ' (';
+        $insert .= join(', ', $columns);
+        $insert .= ') VALUES (';
+        foreach($columns as $column){
+            $insert .= '/*' . $column . '*/';
+            $insert .= '"' . $column . '"';
+            $insert .= ',';
+        }
+        $insert = substr($insert, 0, -1);
+        $insert .= ')';
+        $this->insert = $insert;
     }
     public function createSql(){
+        return $this->insert;
     }
 }