inception必须有对数据库的访问权限
[root@mhamaster ~]# ./pymysql.py
*************************** 1 .row ***************************
ID : 1
stage : CHECKED
errlevel : 0
stagestatus : Audit completed
errormessage : None
SQL : use test
Affected_rows : 0
sequence : '0_0_0'
backup_dbname : None
execute_time : 0
sqlsha1 :
*************************** 2 .row ***************************
ID : 2
stage : CHECKED
errlevel : 2
stagestatus : Audit completed
errormessage : Set charset to one of 'utf8mb4' for table 'send_fans_gift_history_info'.
Set comments for table 'send_fans_gift_history_info'.
Column 'send_id' in table 'send_fans_gift_history_info' have no comments.
Set unsigned attribute on auto increment column in table 'send_fans_gift_history_info'.
Column 'request_type' in table 'send_fans_gift_history_info' have no comments.
Column 'request_type' in table 'send_fans_gift_history_info' is not allowed to been nullable.
Auto increment column 'send_id' is meaningful? it's dangerous!
Index 'IX_createdate' in table 'send_fans_gift_history_info' need 'idx_' prefix.
Index 'IX_roomid' in table 'send_fans_gift_history_info' need 'idx_' prefix.
Key column 'create_date' doesn't exist in table.
Incorrect index name '(null)' in table 'send_fans_gift_history_info'.
Key column 'room_id' doesn't exist in table.
Incorrect index name '(null)' in table 'send_fans_gift_history_info'.
SQL : CREATE TABLE `send_fans_gift_history_info` ( `send_id` INT(11) NOT NULL AUTO_INCREMENT, `request_type` INT(11) DEFAULT NULL, PRIMARY KEY (`send_id`), KEY `IX_createdate` (`create_date`), KEY `IX_roomid` (`room_id`)) ENGINE=INNODB CHARSET=utf8
Affected_rows : 0
sequence : '0_0_1'
backup_dbname : 127_0_0_1_3306_test
execute_time : 0
sqlsha1 :
mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| t_copy_schema |
+----------------+
1 row in set (0.00 sec)
出现error,在线数据库不会执行该sql
[root@mhamaster ~]# ./pymysql.py
File "./pymysql.py", line 7
`send_id` INT(11) NOT NULL AUTO_INCREMENT,\\
^
SyntaxError: EOL while scanning string literal
[root@mhamaster ~]# ./pymysql.py
File "./pymysql.py", line 8
SyntaxError: Non-ASCII character '\xe9' in file ./pymysql.py on line 9, but no encoding declared; see for details