Lines Matching refs:db

15 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
16 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
17 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
19 $db->exec('CREATE TABLE test_copy_from (a integer not null primary key, b text, c integer)');
42 $db->beginTransaction();
43 var_dump($db->pgsqlCopyFromArray('test_copy_from',$tableRows));
45 $stmt = $db->query("select * from test_copy_from");
49 $db->rollback();
52 $db->beginTransaction();
53 var_dump($db->pgsqlCopyFromArray('test_copy_from',$tableRowsWithDifferentNullValues,";","NULL"));
54 $stmt = $db->query("select * from test_copy_from");
58 $db->rollback();
61 $db->beginTransaction();
62 var_dump($db->pgsqlCopyFromArray('test_copy_from',$tableRowsWithDifferentNullValuesAndSelectedField…
63 $stmt = $db->query("select * from test_copy_from");
67 $db->rollback();
70 $db->beginTransaction();
72 …var_dump($db->pgsqlCopyFromArray('test_error',$tableRowsWithDifferentNullValuesAndSelectedFields,"…
76 $db->rollback();
79 $db->beginTransaction();
80 var_dump($db->pgsqlCopyFromFile('test_copy_from',$filename));
82 $stmt = $db->query("select * from test_copy_from");
86 $db->rollback();
89 $db->beginTransaction();
90 var_dump($db->pgsqlCopyFromFile('test_copy_from',$filenameWithDifferentNullValues,";","NULL"));
91 $stmt = $db->query("select * from test_copy_from");
95 $db->rollback();
98 $db->beginTransaction();
99 var_dump($db->pgsqlCopyFromFile('test_copy_from',$filenameWithDifferentNullValuesAndSelectedFields,…
100 $stmt = $db->query("select * from test_copy_from");
104 $db->rollback();
107 $db->beginTransaction();
109 …var_dump($db->pgsqlCopyFromFile('test_error',$filenameWithDifferentNullValuesAndSelectedFields,";"…
113 $db->rollback();
116 $db->beginTransaction();
118     var_dump($db->pgsqlCopyFromFile('test_copy_from',"nonexisting/foo.csv",";","NULL",'a,c'));
122 $db->rollback();
132 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
133 $db->query('DROP TABLE IF EXISTS test_copy_from CASCADE');