mirror of
https://gitee.com/johng/gf
synced 2026-07-04 21:03:13 +08:00
68b02218d7
## Summary - Add full test infrastructure (`mariadb_unit_init_test.go`) with MariaDB-specific helpers (createTable, createInitTable, dropTable) matching the MySQL test baseline - Port 4 basic tests from MySQL: `Test_New`, `Test_DB_Ping`, `Test_DB_Query`, `Test_DB_Exec` - Port 47 core tests covering CRUD operations, raw SQL, schema switching, and DB/TX method parity - Port 55 model tests covering Model API: Fields, Where, Scan, Save, Replace, InsertIgnore, InsertGetId, OmitEmpty, Distinct, Count/Min/Max/Avg/Sum, HasField, chained operations, testdata SQL-based scenarios and more - Add 5 testdata SQL files required by model tests (copied from MySQL baseline) All tests are structurally identical to the MySQL driver baseline. SQL syntax is standard and shared. Package and import references are adapted for MariaDB. ref #4689 --------- Co-authored-by: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
20 lines
753 B
SQL
20 lines
753 B
SQL
CREATE TABLE %s (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`key` varchar(45) DEFAULT NULL,
|
|
`category_id` int(10) unsigned NOT NULL,
|
|
`user_id` int(10) unsigned NOT NULL,
|
|
`title` varchar(255) NOT NULL,
|
|
`content` mediumtext NOT NULL,
|
|
`sort` int(10) unsigned DEFAULT '0',
|
|
`brief` varchar(255) DEFAULT NULL,
|
|
`thumb` varchar(255) DEFAULT NULL,
|
|
`tags` varchar(900) DEFAULT NULL,
|
|
`referer` varchar(255) DEFAULT NULL,
|
|
`status` smallint(5) unsigned DEFAULT '0',
|
|
`view_count` int(10) unsigned DEFAULT '0',
|
|
`zan_count` int(10) unsigned DEFAULT NULL,
|
|
`cai_count` int(10) unsigned DEFAULT NULL,
|
|
`created_at` datetime DEFAULT NULL,
|
|
`updated_at` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |