Lines Matching +full:table +(+path:plugin +path:sqlite) -(+path:plugin +path:sqlite +path:lang)

238      * Insert or replace the given data into the table
240      * @param string $table
246     public function saveRecord($table, $data, $replace = true)
259         $sql = $command . ' INTO "' . $table . '" (' . implode(',', $columns) . ') VALUES (' . implode(
268             $sql = 'SELECT * FROM "' . $table . '" WHERE rowid = last_insert_rowid()';
320      * Get a config value from the opt table
337      * Set a config value in the opt table
378         $tables = $this->queryAll("SELECT name,sql FROM sqlite_master WHERE type='table'");
381         foreach ($tables as $table) {
382             fwrite($fp, "DROP TABLE IF EXISTS '{$table['name']}';\n");
385         foreach ($tables as $table) {
386             fwrite($fp, $table['sql'] . ";\n");
389         foreach ($tables as $table) {
390             $sql = "SELECT * FROM " . $table['name'];
397                 fwrite($fp, "INSERT INTO '{$table['name']}' VALUES ({$values});\n");
466      * Read the current version from the opt table
468      * The opt table is created here if not found
479             if (!preg_match('/no such table/', $e->getMessage())) {
480                 // if this is not a "no such table" error, there is something wrong see #80
482                     'SQLite: Could not read dbversion from opt table due to unexpected error',
494             // add the opt table - if this fails too, let the exception bubble up
495             $sql = "CREATE TABLE IF NOT EXISTS opts (opt TEXT NOT NULL PRIMARY KEY, val NOT NULL DEFAULT '')";