Commit graph

81 commits

Author SHA1 Message Date
Visman
70620c155f Add more database information for MySQL 2023-09-10 22:52:26 +07:00
Visman
ebef5d5dad Add some order 2023-07-14 20:45:32 +07:00
Visman
8b1f40e34c Fix DB\AbstractStatement 2023-04-29 18:05:01 +07:00
Visman
e2cf3896b6 Up min PHP version from 7.3 to 8.0 - 4 2023-04-28 13:34:43 +07:00
Visman
7c7e1a097f Up min PHP version from 7.3 to 8.0 - 3 2023-04-28 10:58:24 +07:00
Visman
5528d0480b Up min PHP version from 7.3 to 8.0 2023-04-27 19:36:15 +07:00
Visman
c2b5758465 Fix truncateTable() method for SQLite 2023-03-31 09:43:16 +07:00
Visman
65941831e5 Update DB\Pgsql for COLLATE 2022-02-07 14:14:45 +07:00
Visman
cdea5ce590 Update DB drivers 2022-01-25 13:23:14 +07:00
Visman
c6253ef6fe Update DB\Sqlite 2022-01-24 23:19:16 +07:00
Visman
efaf3112d8 Revert "Small changes that break everything"
This reverts commit e61bd6c3c0.
2022-01-17 18:06:49 +07:00
Visman
e61bd6c3c0 Small changes that break everything 2022-01-17 18:06:33 +07:00
Visman
18710f1a2f Update DB\Sqlite\alterField() method 2021-12-29 19:04:41 +07:00
Visman
8f838ce769 Update DB\Sqlite\dropIndex() method
Fix for PRIMARY KEY.
2021-12-29 18:03:01 +07:00
Visman
9902e302a5 Update DB\Mysql 2021-12-29 17:46:24 +07:00
Visman
bfecbd573c Update DB\Sqlite 2021-12-29 17:14:32 +07:00
Visman
768074c78e Update DB\Sqlite\addIndex() method
Fix for PRIMARY KEY.
2021-12-29 16:37:36 +07:00
Visman
777010f049 Update DB\Sqlite\indexExists() method
Fix for PRIMARY KEY.
2021-12-29 15:41:01 +07:00
Visman
acffa1cdfc Update DB\Sqlite\dropField() method 2021-12-29 13:56:54 +07:00
Visman
66b0273725 Fix DB\Pgsql 2021-12-29 13:55:38 +07:00
Visman
91f192e52d Fix DB\Sqlite 2021-12-28 21:25:16 +07:00
Visman
7e04d6acc2 Update DB drivers 2021-12-28 18:50:13 +07:00
Visman
2cb9f34dcd Update DB drivers
Pass the prefix of the database tables by their name. Similar to sql queries.
2021-12-28 17:47:38 +07:00
Visman
2d71c280ca Minor change 2021-12-23 13:22:23 +07:00
Visman
e893a5d4e5 Update DB\SqliteStatement 2021-12-23 13:21:59 +07:00
Visman
cb04b8657c Update DB\AbstractStatement 2021-12-23 13:21:21 +07:00
Visman
99243e23e1 Update DBStatement 2021-12-22 23:28:11 +07:00
Visman
cd975a3855 Fix DB\Mysql
Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
2021-12-20 20:08:55 +07:00
Visman
5b5fedde23 Update DB drivers
Remove the checks that are not needed after the previous commit.
2021-12-20 19:44:57 +07:00
Visman
1d28b4f8c8 Update DB drivers
Add a separate method for creating a query string for a column.
2021-12-20 19:34:02 +07:00
Visman
27f624ee9d Update DB\Pgsql #7
Fix addIndex() and dropIndex() for primary key.
2021-12-19 21:46:45 +07:00
Visman
e0d30948d0 Minor fixes 2021-12-19 17:19:49 +07:00
Visman
49c00d420b Update DB\Sqlite #10
A crutch in the dropField() method for SQLite prior to version 3.36.0.
2021-12-18 19:02:02 +07:00
Visman
56c0b67525 Update DB\Sqlite
#10
2021-12-18 01:04:01 +07:00
Visman
f6dfd6fdcd Update DB\Sqlite
More data for server statistics.
2021-12-17 14:29:50 +07:00
Visman
274ea421de Update DB\SqliteStatement #9
Fix for PHP 8.0 - 8.0.6.
2021-12-16 23:13:24 +07:00
Visman
8c1f4a9503 Update DB\AbstractStatement #9
Add fetchAll() method.
2021-12-16 19:00:35 +07:00
Visman
9c813d46cb Update DB\AbstractStatement 2021-12-16 16:51:23 +07:00
Visman
0b5e9b77f0 Add setFetchMode() to DB\AbstractStatement #9 2021-12-16 15:43:31 +07:00
Visman
2073aceed7 Update DB\AbstractStatement #9
In the case of -> fetch (PDO :: FETCH_COLUMN), the method should return the value from the first column of the row, not an array with the data of all columns of the row.
2021-12-16 13:09:23 +07:00
Visman
0d443ff683 Update DBStatement for SQLite #9
I had to split DBStatement for SQLite into two branches: for PHP 7 and for PHP 8, otherwise it does not allow inheriting the PDOStatement class.
2021-12-16 11:03:43 +07:00
Visman
481489f505 Remove debug output 2021-12-15 23:22:07 +07:00
Visman
3bd0a4aa3b Fix DB\SqliteStatement for #9
For tables with no integer/boolean fields.
2021-12-15 19:31:11 +07:00
Visman
b12b96ccd5 Fix DB\AbstractStatement
#9
2021-12-15 18:05:53 +07:00
Visman
1077d2c6b6 Type conversion for #9
Added BOOLEAN to SQLite types.
Expanded DBStatement (started).
The fecth() method for INTEGER and BOOLEAN fields returns integer/float(?) and bool data.
2021-12-15 17:16:54 +07:00
Visman
1800381095 A little loop optimization 2021-12-15 09:48:01 +07:00
Visman
474dd4d439 Fix DB\Sqlite 2021-12-13 23:14:52 +07:00
Visman
04f5906281 Update DB\Mysql 2021-12-13 20:09:20 +07:00
Visman
2839c21416 Update DB\Pgsql 2021-12-13 20:09:02 +07:00
Visman
456751fa61 Add DB\Sqlite 2021-12-13 20:07:20 +07:00