Type | Line | Description |
---|---|---|
14 | SQL dialect for a certain database | |
15 | The query built | |
16 | Prefix to attach to all table names | |
18 | Columns to select | |
19 | From part | |
20 | Join part | |
21 | Where part | |
22 | Group by part | |
23 | Order by part | |
24 | Limit by part | |
25 | Offset by part | |
118 | stackoverflow.com/questions/173400/php-arrays-a-good-way-to-check-if-an-array-is-associative-or-sequential/4254008#4254008 | |
213 | If $values is null, then use $columns to build it up | |
218 | Incoming is associative array, split it up in two | |
224 | Create an array of '?' to match number of columns | |
301 | If $values is string, then move that to $where |
Type | Line | Description |
---|---|---|
3 | ||
4 | Set the error reporting. | |
5 | ||
6 | Report all type of errors | |
7 | Do not buffer outputs, write directly | |
10 | ||
11 | Get required files | |
12 | ||
19 | ||
20 | Read config file | |
21 | ||
26 | ||
27 | Carry out som tests | |
28 |
Type | Line | Description |
---|---|---|
19 | Options used when creating the PDO object | |
20 | The PDO object | |
21 | The latest statement used to execute a query | |
22 | Count all queries made | |
23 | Save all queries for debugging purpose | |
24 | Save all parameters for debugging purpose | |
101 | For debug purpose, shows all connection details | |
104 | Hide connection details. |
Type | Line | Description |
---|---|---|
4 | Set up details on how to connect to the database | |
11 | Display details on what happens | |
14 | Throw a more verbose exception when failing to connect | |
15 | 'debug_connect' => 'true', |
Type | Line | Description |
---|---|---|
3 | ||
4 | Set the error reporting. | |
5 | ||
6 | Report all type of errors | |
7 | Display all errors | |
10 | ||
11 | Get required files | |
12 | ||
19 | ||
20 | Precondition | |
21 | ||
22 | if (!is_writable(__DIR__)) { | |
23 | die("This directory must be writable to create the SQLite database file."); | |
24 | } | |
27 | ||
28 | Read config file | |
29 | ||
34 | ||
35 | Carry out som tests | |
36 |
Type | Line | Description |
---|---|---|
2 | ||
3 | Carry out som tests, db must exist | |
4 | ||
7 | $db->connect('debug'); | |
10 | ||
11 | Drop a table if it exists | |
12 | ||
17 | ||
18 | Create a table | |
19 | ||
33 | ||
34 | Rows to test with | |
35 | ||
42 | ||
43 | Insert a single row into table using key => value | |
44 | ||
59 | ||
60 | Insert a single row into table using two arrays | |
61 | ||
74 | ||
75 | Insert a single row into table using single array | |
76 | ||
90 | ||
91 | Select from database | |
92 | ||
107 | ||
108 | Update a single row using key => value | |
109 | ||
123 | ||
124 | Select from database | |
125 | ||
134 | ||
135 | Update a single row using one arrays | |
136 | ||
147 | ||
148 | Select from database | |
149 | ||
158 | ||
159 | Select from database | |
160 | ||
179 | ||
180 | Select from database | |
181 | ||
192 | ||
193 | Select and group by | |
194 | ||
206 | ||
207 | Select, limit and offset | |
208 | ||
238 | ||
239 | Select and join from database | |
240 | ||
271 | www.sqlite.org/omitted.html"; | |
287 | ||
288 | Delete a single row | |
289 | ||
299 | ||
300 | Select from database | |
301 | ||
308 | ||
309 | Delete all row | |
310 | ||
317 | ||
318 | Select from database | |
319 | ||
325 | ||
326 | Drop a table | |
327 |
Type | Line | Description |
---|---|---|
10 | ||
11 | Create a table | |
12 | ||
29 | ||
30 | Insert a single row into table using key => value | |
31 | ||
45 | ||
46 | Insert a single row into table using two arrays | |
47 | ||
58 | ||
59 | Insert a single row into table using one array (rest will be sent as parameters) | |
60 | ||
70 | ||
71 | Update a single row using key => value | |
72 | ||
87 | ||
88 | Update a single row using two arrays | |
89 | ||
101 | ||
102 | Update a single row into table using one array (rest will be sent as parameters) | |
103 | ||
114 | ||
115 | Select from database | |
116 | ||
137 | ||
138 | Select and join from database | |
139 | ||
171 | ||
172 | Select, limit and offset | |
173 | ||
197 | ||
198 | Delete a single row | |
199 | ||
209 | ||
210 | Delete all row | |
211 | ||
220 | ||
221 | Drop a table | |
222 |
Type | Line | Description |
---|---|---|
3 | ||
4 | Set the error reporting. | |
5 | ||
6 | Report all type of errors | |
7 | Do not buffer outputs, write directly | |
10 | ||
11 | Get required files | |
12 | ||
19 | ||
20 | Read config file | |
21 | ||
26 | ||
27 | Carry out som tests, db must exist | |
28 | ||
35 | ||
36 | Drop a table if it exists | |
37 | ||
43 | ||
44 | Create a table | |
45 | ||
58 | ||
59 | Add some users to test with | |
60 | ||
72 | ||
73 | Add some users, two steps since must use salt as created before. | |
74 | ||
89 | ||
90 | Check whats in the db | |
91 | ||
101 | ||
102 | Check password for each user | |
103 | ||
114 | ||
115 | Check password for each user | |
116 | ||
128 | ||
129 | Check (wrong) password for user | |
130 |