gf/table_with_prefix.sql at fix/gconv_array - gf - Gitea: Git with a cup of tea

bingyi/gf

mirror of https://gitee.com/johng/gf synced 2026-06-06 16:21:40 +08:00

Files

Jack Ling 030cd84836 test(contrib/drivers/mariadb): add softtime, with, scanlist, union and do tests (#4721 )

## Summary

- Port 48 soft-time tests: soft create/update/delete with
timestamp/datetime/date types, SoftTime switches
(SoftTimeTypeOff/Delete/Timestamp), Unscoped, ForceDelete, joined
queries with soft-delete
- Port 19 With/ScanList tests: With/WithAll for eager loading of
hasOne/hasMany/belongsTo relations, ScanList for manual relation
mapping, nested With
- Port 12 union tests: Union/UnionAll with various parameter forms
(string/Model/subquery), combined with OrderBy, Limit, Where conditions
- Port 12 gdb.Do tests: DoSelect/DoInsert/DoUpdate/DoDelete raw
operation hooks, batch insert, InsertIgnore/InsertGetId/Replace via
DoInsert option

Includes testdata SQL files for With relation table schemas (with_tpl).
Soft-time tests create tables inline via SQL, no separate testdata files
needed.

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

2026-03-12 11:15:42 +08:00

7 lines

211 B

SQL

Raw Permalink Blame History

 CREATE TABLE `instance`  (
     `f_id` int(11) NOT NULL AUTO_INCREMENT,
     `name` varchar(255) NULL DEFAULT '',
     PRIMARY KEY (`f_id`) USING BTREE
 ) ENGINE = InnoDB;
 INSERT INTO `instance` VALUES (1, 'john');