Annotation of embedaddon/php/ext/mysqli/tests/mysqli_commit_oo.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: mysqli_commit()
3: --SKIPIF--
4: <?php
5: require_once('skipif.inc');
6: require_once('skipifemb.inc');
7: require_once('skipifconnectfailure.inc');
8:
9: require_once('connect.inc');
10: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
11: die(sprintf("Cannot connect, [%d] %s", mysqli_connect_errno(), mysqli_connect_error()));
12:
13: if (!have_innodb($link))
14: die(sprintf("Needs InnoDB support, [%d] %s", $link->errno, $link->error));
15: ?>
16: --FILE--
17: <?php
18: require_once("connect.inc");
19:
20: $tmp = NULL;
21: $link = NULL;
22:
23: $mysqli = new mysqli();
24: if (!is_null($tmp = @$mysqli->commit()))
25: printf("[013] Expecting NULL got %s/%s\n", gettype($tmp), $tmp);
26:
27: if (!$mysqli = new my_mysqli($host, $user, $passwd, $db, $port, $socket))
28: printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
29: $host, $user, $db, $port, $socket);
30:
31: if (!is_null($tmp = @$mysqli->commit($link)))
32: printf("[002] Expecting NULL/NULL, got %s/%s, [%d] %s\n",
33: gettype($tmp), $tmp, $mysqli->errno, $mysqli->error);
34:
35: if (true !== ($tmp = $mysqli->commit()))
36: printf("[014] Expecting boolean/true got %s/%s\n", gettype($tmp), $tmp);
37:
38: if (true !== ($tmp = $mysqli->autocommit(false)))
39: printf("[003] Cannot turn off autocommit, expecting true, got %s/%s\n", gettype($tmp), $tmp);
40:
41: if (!$mysqli->query('DROP TABLE IF EXISTS test'))
42: printf("[004] [%d] %s\n", $mysqli->errno, $mysqli->error);
43:
44: if (!$mysqli->query('CREATE TABLE test(id INT) ENGINE = InnoDB'))
45: printf("[005] Cannot create test table, [%d] %s\n", $mysqli->errno, $mysqli->error);
46:
47: if (!$mysqli->query('INSERT INTO test(id) VALUES (1)'))
48: printf("[006] [%d] %s\n", $mysqli->errno, $mysqli->error);
49:
50: $tmp = $mysqli->commit();
51: if ($tmp !== true)
52: printf("[007] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
53:
54: if (!$mysqli->query('ROLLBACK'))
55: printf("[008] [%d] %s\n", $mysqli->errno, $mysqli->error);
56:
57: if (!$res = $mysqli->query('SELECT COUNT(*) AS num FROM test'))
58: printf("[009] [%d] %s\n", $mysqli->errno, $mysqli->error);
59: $tmp = $res->fetch_assoc();
60: if (1 != $tmp['num'])
61: printf("[010] Expecting 1 row in table test, found %d rows\n", $tmp['num']);
62: $res->free();
63:
64: if (!$mysqli->query('DROP TABLE IF EXISTS test'))
65: printf("[011] [%d] %s\n", $mysqli->errno, $mysqli->error);
66:
67: $mysqli->close();
68:
69: if (NULL !== ($tmp = @$mysqli->commit()))
70: printf("[012] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
71:
72: print "done!";
73: ?>
74: --CLEAN--
75: <?php
76: require_once("clean_table.inc");
77: ?>
78: --EXPECTF--
79: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>