2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO SHOW VARIABLES LIKE 'sql_mode'
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO SELECT DATABASE()
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO show collation where `Charset` = 'utf8' and `Collation` = 'utf8_bin'
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8) COLLATE utf8_bin AS anon_1
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO DESCRIBE `users`
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO ROLLBACK
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO 
CREATE TABLE users (
	id INTEGER NOT NULL AUTO_INCREMENT, 
	name VARCHAR(20) DEFAULT 'zhangsan' COMMENT '姓名', 
	password VARCHAR(32), 
	address VARCHAR(20), 
	PRIMARY KEY (id), 
	UNIQUE (name)
)


2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  14:57:25 Wed sqlalchemy.engine.base.Engine INFO COMMIT
2020-11-18  14:58:14 Wed sqlalchemy.engine.base.Engine INFO SHOW VARIABLES LIKE 'sql_mode'
2020-11-18  14:58:14 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  14:58:14 Wed sqlalchemy.engine.base.Engine INFO SELECT DATABASE()
2020-11-18  14:58:14 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  14:58:14 Wed sqlalchemy.engine.base.Engine INFO show collation where `Charset` = 'utf8' and `Collation` = 'utf8_bin'
2020-11-18  14:58:14 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  14:58:14 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1
2020-11-18  14:58:14 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  14:58:14 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1
2020-11-18  14:58:14 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  14:58:14 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8) COLLATE utf8_bin AS anon_1
2020-11-18  14:58:14 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:12 Wed sqlalchemy.engine.base.Engine INFO SHOW VARIABLES LIKE 'sql_mode'
2020-11-18  15:08:12 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:12 Wed sqlalchemy.engine.base.Engine INFO SELECT DATABASE()
2020-11-18  15:08:12 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:12 Wed sqlalchemy.engine.base.Engine INFO show collation where `Charset` = 'utf8' and `Collation` = 'utf8_bin'
2020-11-18  15:08:12 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:12 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1
2020-11-18  15:08:12 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:12 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1
2020-11-18  15:08:12 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:13 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8) COLLATE utf8_bin AS anon_1
2020-11-18  15:08:13 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:13 Wed sqlalchemy.engine.base.Engine INFO DESCRIBE `users`
2020-11-18  15:08:13 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:13 Wed sqlalchemy.engine.base.Engine INFO ROLLBACK
2020-11-18  15:08:13 Wed sqlalchemy.engine.base.Engine INFO 
CREATE TABLE users (
	id INTEGER NOT NULL AUTO_INCREMENT, 
	name VARCHAR(20) DEFAULT 'zhangsan' COMMENT '姓名', 
	password VARCHAR(32), 
	address VARCHAR(20), 
	PRIMARY KEY (id), 
	UNIQUE (name)
)


2020-11-18  15:08:13 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:13 Wed sqlalchemy.engine.base.Engine INFO COMMIT
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO SHOW VARIABLES LIKE 'sql_mode'
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO SELECT DATABASE()
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO show collation where `Charset` = 'utf8' and `Collation` = 'utf8_bin'
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8) COLLATE utf8_bin AS anon_1
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO DESCRIBE `users`
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO BEGIN (implicit)
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO INSERT INTO users (name, password, address) VALUES (%(name)s, %(password)s, %(address)s)
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO {'name': 'peng', 'password': '123', 'address': 'shanghai'}
2020-11-18  15:08:34 Wed sqlalchemy.engine.base.Engine INFO COMMIT
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO SHOW VARIABLES LIKE 'sql_mode'
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO SELECT DATABASE()
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO show collation where `Charset` = 'utf8' and `Collation` = 'utf8_bin'
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8) COLLATE utf8_bin AS anon_1
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO DESCRIBE `order_info`
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO ROLLBACK
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO 
CREATE TABLE order_info (
	id INTEGER NOT NULL AUTO_INCREMENT, 
	order_no VARCHAR(50) COMMENT '订单号', 
	transaction_serial_no VARCHAR(50) DEFAULT '' COMMENT '交易流水号', 
	prod_name VARCHAR(200) COMMENT '商品名称', 
	prod_type VARCHAR(200) COMMENT '商品类型', 
	prod_id VARCHAR(200) COMMENT '商品ID', 
	prod_quantity INTEGER DEFAULT 1 COMMENT '数量', 
	amount FLOAT COMMENT '订单总额', 
	user_id VARCHAR(100) COMMENT '用户ID', 
	user_apple_id VARCHAR(100) COMMENT '用户苹果ID', 
	order_status INTEGER DEFAULT 0 COMMENT '订单状态：0:未支付，1:已支付，2:已退款', 
	pay_method INTEGER DEFAULT 1 COMMENT '支付方式：1:苹果支付，2:微信支付，3:支付宝支付', 
	create_time DATETIME DEFAULT now() COMMENT '下单时间', 
	pay_time DATETIME DEFAULT now() COMMENT '支付时间', 
	del_flag INTEGER DEFAULT 0 COMMENT '是否删除,0:未删除,1:已删除', 
	PRIMARY KEY (id)
)


2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:27:08 Wed sqlalchemy.engine.base.Engine INFO COMMIT
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO SHOW VARIABLES LIKE 'sql_mode'
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO SELECT DATABASE()
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO show collation where `Charset` = 'utf8' and `Collation` = 'utf8_bin'
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8) COLLATE utf8_bin AS anon_1
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO DESCRIBE `order_info`
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO ROLLBACK
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO 
CREATE TABLE order_info (
	id BIGINT NOT NULL AUTO_INCREMENT, 
	order_no VARCHAR(50) COMMENT '订单号', 
	transaction_serial_no VARCHAR(50) DEFAULT '' COMMENT '交易流水号', 
	prod_name VARCHAR(200) COMMENT '商品名称', 
	prod_type VARCHAR(200) COMMENT '商品类型', 
	prod_id VARCHAR(200) COMMENT '商品ID', 
	prod_quantity INTEGER DEFAULT 1 COMMENT '数量', 
	amount FLOAT COMMENT '订单总额', 
	user_id VARCHAR(100) COMMENT '用户ID', 
	user_apple_id VARCHAR(100) COMMENT '用户苹果ID', 
	order_status INTEGER DEFAULT 0 COMMENT '订单状态：0:未支付，1:已支付，2:已退款', 
	pay_method INTEGER DEFAULT 1 COMMENT '支付方式：1:苹果支付，2:微信支付，3:支付宝支付', 
	create_time DATETIME DEFAULT now() COMMENT '下单时间', 
	pay_time DATETIME DEFAULT now() COMMENT '支付时间', 
	del_flag INTEGER DEFAULT 0 COMMENT '是否删除,0:未删除,1:已删除', 
	PRIMARY KEY (id)
)


2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO {}
2020-11-18  16:29:19 Wed sqlalchemy.engine.base.Engine INFO COMMIT