itwmw/engine-validate-mysql-rules

新版微擎验证器Mysql验证规则集

v5.0.0 2023-09-11 03:23 UTC

Requires

• php: ^8.1
• ext-json: *
• w7/engine-validate: ^4.0|^5.0

Requires (Dev)

• friendsofphp/php-cs-fixer: ^3

Apache-2.0

• 虞灪

README

包含Mysql除空间类型以外的全部字段类型的验证规则

安装

itwmw/engine-validate-mysql-rules

使用

在项目中，将自定义规则路径注册到验证器中

\W7\Validate\Support\Storage\ValidateConfig::instance()->setRulesPath('Itwmw\\Validate\\Mysql\\Rules\\');

规则

字段类型	规则名	参数
bigint	mysqlBigint	unsigned
binary	mysqlBinary	length
bit	mysqlBit	length
blob	mysqlBlob	length
char	mysqlChar	length
date	mysqlDate	-
datetime	mysqlDatetime	-
decimal	mysqlDecimal	unsigned,length,precision
double	mysqlDouble	unsigned,length,precision
enum	mysqlEnum	table,field
float	mysqlFloat	unsigned,length,precision
int	mysqlInt	unsigned
json	mysqlJson	-
longblob	mysqlLongblob	length
longtext	mysqlLongtext	length
mediumblob	mysqlMediumblob	length
mediumint	mysqlMediumint	unsigned
mediumtext	mysqlMediumtext	length
set	mysqlSet	table,field
smallint	mysqlSmallint	unsigned
mysqlText	mysqlText	length
time	mysqlTime	-
timestamp	mysqlTimestamp	-
tinyblob	mysqlTinyblob	length
tinyint	mysqlTinyint	unsigned
tinytext	mysqlTinytext	length
varbinary	mysqlVarbinary	length
varchar	mysqlVarchar	length
mysqlYear	mysqlYear	-

参数说明:

• table 表名
• field 字段名
• unsigned 无符号,值为true或false
• length 字段长度
• precision 小数精度