Lines Matching refs:dbh
13 $dbh = PDOTest::factory();
15 $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
16 $dbh->exec("drop table pdo_ac_tab");
17 $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
19 $dbh->exec("create table pdo_ac_tab (col1 varchar2(25))");
23 $dbh->beginTransaction();
25 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 1')");
26 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 2')");
27 $dbh->commit();
32 $dbh->rollback();
37 $dbh->beginTransaction();
39 $dbh->exec("insert into pdo_ac_tab (col1) values ('not committed #1')");
40 $dbh->exec("insert into pdo_ac_tab (col1) values ('data that is too long to fit and will barf')");
41 $dbh->commit();
46 $dbh->rollback();
51 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 3')");
52 $dbh->setAttribute(PDO::ATTR_AUTOCOMMIT, true);
54 var_dump($dbh->getAttribute(PDO::ATTR_AUTOCOMMIT));
56 $dbh->rollback();
65 $dbh->beginTransaction();
66 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 4')");
67 $dbh->setAttribute(PDO::ATTR_AUTOCOMMIT, false);
69 var_dump($dbh->getAttribute(PDO::ATTR_AUTOCOMMIT));
71 $dbh->rollback();
81 var_dump($dbh->getAttribute(PDO::ATTR_AUTOCOMMIT));
83 $dbh->exec("insert into pdo_ac_tab (col1) values ('not committed #2')");
84 $dbh->exec("rollback");
85 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 5')");
86 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 6')");
88 $dbh->exec("commit");