Changeset 210 for test

Timestamp:

04/06/09 02:06:38 (3 years ago)

Author:

antonbatenev.ya.ru

Message:

Добавление классов для работы с SQLite, все методы закрыты заглушками

Location:

test/mysql2sqlite

Files:

• avalon.sql (modified) (1 diff)
• mysql2sqlite.php (modified) (1 diff)

test/mysql2sqlite/avalon.sql

@@ -74 +74 @@
         `subject`   VARCHAR(128) NOT NULL,
         `message`   TEXT         NOT NULL,
-        `date`      INTEGER      NOT NULL
+        `date`      INTEGER      NOT NULL,
+        `draft`     INTEGER      NOT NULL
 );
 

test/mysql2sqlite/mysql2sqlite.php

@@ -162 +162 @@
 echo "Process table `message2send`\n";
 
-$sql = "SELECT `id`, `id_parent`, `id_forum`, `subject`, `message`, UNIX_TIMESTAMP(`date`) FROM `message2send`";
-$query = mysql_unbuffered_query($sql, $mysql_connection) or die ("mysql_query: " . mysql_error($mysql_connection) . "\n");
-
-$row = mysql_fetch_row($query);
-
-while ($row !== false)
-{
-        $sql = "INSERT INTO `message2send` VALUES (" . $row[0] . ", " . $row[1] . ", " . $row[2] . ", " . quoteString($row[3]) . ", " . quoteString($row[4]) . ", " . $row[5] . ")";
+$sql = "SELECT `id`, `id_parent`, `id_forum`, `subject`, `message`, UNIX_TIMESTAMP(`date`), `draft` FROM `message2send`";
+$query = mysql_unbuffered_query($sql, $mysql_connection) or die ("mysql_query: " . mysql_error($mysql_connection) . "\n");
+
+$row = mysql_fetch_row($query);
+
+while ($row !== false)
+{
+        $sql = "INSERT INTO `message2send` VALUES (" . $row[0] . ", " . $row[1] . ", " . $row[2] . ", " . quoteString($row[3]) . ", " . quoteString($row[4]) . ", " . $row[5] .  ", " . $row[6] . ")";
 
         if ($sqlite_connection->exec($sql) === false)