Lines Matching refs:db
35 $db = new SQLiteDB('testdb', DOKU_PLUGIN . "sqlite/_test/db");
36 $this->assertInstanceOf(\PDO::class, $db->getPdo());
41 $db = new SQLiteDB('testdb', DOKU_PLUGIN . "sqlite/_test/db");
44 $stmt = $db->query($sql, ['music']);
53 $db = new SQLiteDB('testdb', DOKU_PLUGIN . "sqlite/_test/db");
57 $result = $db->queryRecord($sql, ['one', 'two', 'three']);
60 $result = $db->queryRecord($sql, 'one', 'two', 'three');
65 $result = $db->queryRecord($sql, ['first' => 'one', 'second' => 'two', 'third' => 'three']);
71 $db = new SQLiteDB('testdb', DOKU_PLUGIN . "sqlite/_test/db");
74 $insid = $db->exec($sql, ['test', 'test']);
78 $affected = $db->exec($sql, ['test2', 'music']);
85 $db = new SQLiteDB('testdb', DOKU_PLUGIN . "sqlite/_test/db");
88 $result = $db->queryAll($sql, ['music']);
96 $db = new SQLiteDB('testdb', DOKU_PLUGIN . "sqlite/_test/db");
99 $result = $db->queryRecord($sql, [4]);
105 $db = new SQLiteDB('testdb', DOKU_PLUGIN . "sqlite/_test/db");
113 $newrecord = $db->saveRecord('testdata', $record, false);
116 $newrecord = $db->saveRecord('testdata', $record, true);
123 $newrecord = $db->saveRecord('testdata', $another, false);
129 $db = new SQLiteDB('testdb', DOKU_PLUGIN . "sqlite/_test/db");
132 $result = $db->queryValue($sql, [4]);
138 $db = new SQLiteDB('testdb', DOKU_PLUGIN . "sqlite/_test/db");
142 $result = $db->queryKeyValueList($sql);
148 $result = $db->queryKeyValueList($sql);