Skip to content

F
fund_report
Switch branch/tag
Find file
Normal viewHistoryPermalink
tamp_course_order.log 10.6 KB
Newer Older
pengxiong@wealthgrow.cn's avatar
项目初始化
39fdda12
 
pengxiong@wealthgrow.cn committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 
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