Return to mysqli_autocommit_oo.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / mysqli / tests

Annotation of embedaddon/php/ext/mysqli/tests/mysqli_autocommit_oo.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: mysqli->autocommit()
                      3: --SKIPIF--
                      4: <?php
                      5:        require_once('skipif.inc');
                      6:        require_once('skipifemb.inc');
                      7:        require_once('skipifconnectfailure.inc');
                      8:        require_once('connect.inc');
                      9: 
                     10:        if (!$link = new my_mysqli($host, $user, $passwd, $db, $port, $socket)) {
                     11:                printf("skip Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
                     12:                        $host, $user, $db, $port, $socket);
                     13:                exit(1);
                     14:        }
                     15: 
                     16:        if (!have_innodb($link))
                     17:                die(sprintf("Needs InnoDB support, [%d] %s", $link->errno, $link->error));
                     18: ?>
                     19: --FILE--
                     20: <?php
                     21:        require_once("connect.inc");
                     22: 
                     23:        if (!$mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket)) {
                     24:                printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
                     25:                        $host, $user, $db, $port, $socket);
                     26:        }
                     27: 
                     28:        if (!is_bool($tmp = $mysqli->autocommit(true)))
                     29:                printf("[002] Expecting boolean/any, got %s/%s\n", gettype($tmp), $tmp);
                     30: 
                     31:        if (!$mysqli->query('SET AUTOCOMMIT = 0'))
                     32:                printf("[003] [%d] %s\n", $mysqli->errno, $mysqli->error);
                     33: 
                     34:        if (!$res = $mysqli->query('SELECT @@autocommit as auto_commit'))
                     35:                printf("[004] [%d] %s\n", $mysqli->errno, $mysqli->error);
                     36: 
                     37:        $tmp = $res->fetch_assoc();
                     38:        $res->free_result();
                     39:        if ($tmp['auto_commit'])
                     40:                printf("[005] Cannot turn off autocommit\n");
                     41: 
                     42:        if (true !== ($tmp = $mysqli->autocommit( true)))
                     43:                printf("[006] Expecting true, got %s/%s\n", gettype($tmp), $tmp);
                     44: 
                     45:        if (!$res = $mysqli->query('SELECT @@autocommit as auto_commit'))
                     46:                printf("[007] [%d] %s\n", $mysqli->errno, $mysqli->error);
                     47:        $tmp = $res->fetch_assoc();
                     48:        $res->free_result();
                     49:        if (!$tmp['auto_commit'])
                     50:                printf("[008] Cannot turn on autocommit\n");
                     51: 
                     52:        if (!$mysqli->query('DROP TABLE IF EXISTS test'))
                     53:                printf("[009] [%d] %s\n", $mysqli->errno, $mysqli->error);
                     54: 
                     55:        if (!$mysqli->query('CREATE TABLE test(id INT) ENGINE = InnoDB')) {
                     56:                printf("[010] Cannot create test table, [%d] %s\n", $mysqli->errno, $mysqli->error);
                     57:        }
                     58: 
                     59:        if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
                     60:                printf("[011] [%d] %s\n", $mysqli->errno, $mysqli->error);
                     61: 
                     62:        if (!$mysqli->query('ROLLBACK'))
                     63:                printf("[012] [%d] %s\n", $mysqli->errno, $mysqli->error);
                     64: 
                     65:        if (!$res = $mysqli->query('SELECT COUNT(*) AS num FROM test'))
                     66:                printf("[013] [%d] %s\n", $mysqli->errno, $mysqli->error);
                     67: 
                     68:        if ((!$tmp = $res->fetch_assoc()) || (1 != $tmp['num']))
                     69:                printf("[014] Expecting 1 row in table test, found %d rows. [%d] %s\n",
                     70:                        $tmp['num'], $mysqli->errno, $mysqli->error);
                     71: 
                     72:        $res->free_result();
                     73: 
                     74:        if (!$mysqli->query('DROP TABLE IF EXISTS test'))
                     75:                printf("[015] [%d] %s\n", $mysqli->errno, $mysqli->error);
                     76: 
                     77:        if (!$mysqli->query('SET AUTOCOMMIT = 1'))
                     78:                printf("[016] [%d] %s\n", $mysqli->errno, $mysqli->error);
                     79: 
                     80:        if (!$res = $mysqli->query('SELECT @@autocommit as auto_commit'))
                     81:                printf("[017] [%d] %s\n", $mysqli->errno, $mysqli->error);
                     82: 
                     83:        $tmp = $res->fetch_assoc();
                     84:        $res->free_result();
                     85:        if (!$tmp['auto_commit'])
                     86:                printf("[018] Cannot turn on autocommit\n");
                     87: 
                     88:        if (true !== ($tmp = $mysqli->autocommit( false)))
                     89:                printf("[019] Expecting true, got %s/%s\n", gettype($tmp), $tmp);
                     90: 
                     91:        if (!$mysqli->query('CREATE TABLE test(id INT) ENGINE = InnoDB')) {
                     92:                printf("[020] Cannot create test table, [%d] %s\n", $mysqli->errno, $mysqli->error);
                     93:        }
                     94: 
                     95:        if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
                     96:                printf("[021] [%d] %s\n", $mysqli->errno, $mysqli->error);
                     97: 
                     98:        if (!$mysqli->query('ROLLBACK'))
                     99:                printf("[022] [%d] %s\n", $mysqli->errno, $mysqli->error);
                    100: 
                    101:        if (!$res = $mysqli->query('SELECT COUNT(*) AS num FROM test'))
                    102:                printf("[023] [%d] %s\n", $mysqli->errno, $mysqli->error);
                    103:        $tmp = $res->fetch_assoc();
                    104:        if (0 != $tmp['num'])
                    105:                printf("[24] Expecting 0 rows in table test, found %d rows\n", $tmp['num']);
                    106:        $res->free_result();
                    107: 
                    108:        if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
                    109:                printf("[025] [%d] %s\n", $mysqli->errno, $mysqli->error);
                    110: 
                    111:        if (!$mysqli->query('COMMIT'))
                    112:                printf("[025] [%d] %s\n", $mysqli->errno, $mysqli->error);
                    113: 
                    114:        if (!$res = $mysqli->query('SELECT COUNT(*) AS num FROM test'))
                    115:                printf("[027] [%d] %s\n", $mysqli->errno, $mysqli->error);
                    116: 
                    117:        if ((!$tmp = $res->fetch_assoc()) || (1 != $tmp['num']))
                    118:                printf("[028] Expecting 1 row in table test, found %d rows. [%d] %s\n",
                    119:                        $tmp['num'], $mysqli->errno, $mysqli->error);
                    120:        $res->free_result();
                    121: 
                    122:        if (!$mysqli->query('DROP TABLE IF EXISTS test'))
                    123:                printf("[029] [%d] %s\n", $mysqli->errno, $mysqli->error);
                    124: 
                    125:        $mysqli->close();
                    126: 
                    127:        if (NULL !== ($tmp = @$mysqli->autocommit( false)))
                    128:                printf("[030] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
                    129: 
                    130:        print "done!";
                    131: ?>
                    132: --CLEAN--
                    133: <?php
                    134:        require_once("clean_table.inc");
                    135: ?>
                    136: --EXPECTF--
                    137: done!