Bj8KY3Zj

1<?php
2# CREATE DATABASE demo;
3# CREATE USER 'demo'@'%' IDENTIFIED BY 'Demo1234';
4# GRANT CREATE, DROP, INSERT, DELETE, UPDATE, SELECT ON demo.* TO 'demo'@'%';
5
6date_default_timezone_set('Asia/Tokyo');
7
8$opts = getopt("", array('user:', 'host:', 'port:', 'pass:'));
9$ERROR = red('ERROR');
10$INFO  = green('INFO');
11
12$user = isset($opts['user']) ? $opts['user'] : 'root';
13$pass = isset($opts['pass']) ? $opts['pass'] : '';
14
15$host =  'localhost';
16$port = isset($opts['port']) ? $opts['port'] : 24100;
17
18
19$conn = new PDO("mysql:host=$host;port=$port", $user, $pass);
20$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
21
22$attributes = array(
23    "AUTOCOMMIT", "ERRMODE", "CASE", "CLIENT_VERSION", "CONNECTION_STATUS",
24    "ORACLE_NULLS", "PERSISTENT", "SERVER_INFO", "SERVER_VERSION",
25    "TIMEOUT"
26);
27
28foreach ($attributes as $val) {
29  //  echo "PDO::ATTR_$val: ";
30//    echo $conn->getAttribute(constant("PDO::ATTR_$val")) . "\n";
31}
32
33
34$conn->query("CREATE TABLE IF NOT EXISTS demo.lostcheck3 (v int PRIMARY KEY) ENGINE=InnoDB ");
35$conn->query("DELETE FROM demo.lostcheck3");
36
37$c = 0;
38while (1) {
39    $q = "INSERT INTO demo.lostcheck3 (v) VALUES($c);";
40    try {
41    $f=    $conn->query($q);
42	print ( $f->errorCode() );
43        printf("[$INFO] $q, Query OK\n", strftime("%Y%m%d %H:%M:%S"));
44    } catch (Exception $e) {
45        printf("[$ERROR] $q FAILED, %s", $e);
46        exit(1);
47    }
48    $c++;
49}
50
51function green($str) {
52    return "\033[1;32m$str\033[0m";
53}
54
55function red($str) {
56    return "\033[0;31m$str\033[0m";
57}
58
59?>