Lines Matching refs:dbh
15 $dbh = getDbConnection();
16 $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
17 @$dbh->exec('DROP TABLE test_ddl');
18 @$dbh->exec('DROP GENERATOR gen_test_ddl_id');
19 @$dbh->exec('DROP TRIGGER test_ddl_bi');
21 $dbh->exec("CREATE TABLE test_ddl (id INT NOT NULL PRIMARY KEY, text BLOB SUB_TYPE 1)");
22 $dbh->exec("CREATE GENERATOR gen_test_ddl_id");
23 $dbh->exec("CREATE TRIGGER test_ddl_bi FOR test_ddl BEFORE INSERT AS
26 $dbh->setAttribute(PDO::ATTR_AUTOCOMMIT,0);
28 $dbh->beginTransaction();
29 var_dump($dbh->exec("INSERT INTO test_ddl (text) VALUES ('bla')"));
30 var_dump($dbh->exec("UPDATE test_ddl SET text='blabla'"));
31 $dbh->rollback();
33 $dbh->beginTransaction();
34 var_dump($dbh->exec("DELETE FROM test_ddl"));
35 $dbh->commit();
37 @$dbh->exec('DROP TABLE test_ddl');
38 @$dbh->exec('DROP GENERATOR gen_test_ddl_id');
39 @$dbh->exec('DROP TRIGGER test_ddl_bi');
41 unset($dbh);
