7pqgXTN1

1<?php
2
3require 'vendor/autoload.php';
4
5$config = [
6    'driver' => 'Pdo_Sqlite',
7    'database' => 'test.db'
8];
9
10
11$config = [
12    'driver'   => 'Pdo_Mysql',
13    'database' => 'test_ephy',
14    'username' => 'root',
15    'password' => '1234',
16    'hostname' => 'localhost',
17    'charset'  => 'utf8',
18    'attributes' => [\PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION]
19];
20
21$config = [
22    'driver'   => 'Pdo_Pgsql',
23    'database' => 'imatec',
24    'username' => 'reginaldo',
25    'password' => '1234',
26    'hostname' => 'localhost',
27    'attributes' => [\PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION]
28];
29
30$adapter = new EphyDB\Adapter\Adapter($config);
31$db = new EphyDB\EphyDB($adapter);
32
33$db->query("
34CREATE TABLE IF NOT EXISTS messages (
35	id	serial,
36	title	TEXT,
37	message	TEXT,
38	time	INTEGER,
39	PRIMARY KEY(id)
40)
41");
42
43/*
44$arrayList = [1,2];
45
46$q = rtrim(str_repeat('?,', count($arrayList)), ',');
47$paramType = array_fill(0, count($arrayList), \PDO::PARAM_INT);
48
49$select = $db->select()
50    ->setColumns(['TOTAL' => 'COUNT(*)'])
51    ->setFrom('messages');
52
53
54$result = $db->execute($select);
55$res = $result->fetchAll(\PDO::FETCH_ASSOC);
56var_dump($res);
57var_dump(count($res));
58*/
59/*
60$data = [
61    'title' => 'Hello',
62    'message' => 'message here...'
63];
64
65$insert = $db->insert('messages', $data);
66$exec = $db->execute($insert);
67var_dump($insert->lastInsertID());
68
69echo $insert->__toString() . "\n";*/
70/*
71$delete = $db->delete('messages')->where('id = ?', 1, \PDO::PARAM_INT);
72$exec = $db->execute($delete);
73
74var_dump($exec);
75var_dump($exec->rowCount());
76
77echo $delete->__toString() . "\n";*/
78
79try {
80
81
82    $select = $db->select()
83        ->from('messages')
84        ->where('message like ?', '%reg%');
85
86    $exec = $db->execute($select);
87    $res = $exec->fetchAll(\PDO::FETCH_ASSOC);
88
89
90    var_dump($res);
91    echo $select->__toString();
92
93   /* $faker = Faker\Factory::create();
94
95    for ($i = 0; $i <= 10000000; $i++) {
96        $data = [
97            'title' => 'Hello',
98            'message' => 'message '.$faker->name.' here...'
99        ];
100
101        $insert = $db->insert('messages', $data);
102        $exec = $db->execute($insert);
103        echo $insert->lastInsertID() ." { $faker->name }\n";
104    }*/
105
106}catch (Exception $e) {
107    echo $e->getMessage();
108}