Open kemistep opened 4 years ago
操作示例
if __name__ == "__main__":
port = mysql_ss_config.get('port')
ip = mysql_ss_config.get('ip')
user = mysql_ss_config.get('user')
password = mysql_ss_config.get('password')
db_name ='stock'
table_name='dim_stock_xueqiu'
sql_drop_table = """ DROP TABLE IF EXISTS dim_stock_xueqiu; """;
execute_sql(sql= sql_drop_table)
sql_create_table = """
CREATE TABLE `dim_stock_xueqiu` (
`stock_code` VARCHAR (32) NOT NULL COMMENT 'name',
`stock_name` VARCHAR (255) CHARACTER SET utf8mb4 DEFAULT NULL ,
`create_time` datetime DEFAULT CURRENT_TIMESTAMP ,
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
PRIMARY KEY (`stock_code`)
) ENGINE = INNODB DEFAULT CHARSET = utf8;
""".format(table_name=table_name)
#sql_create_table = sql_create_table.replace('\n','')
#sql_create_table = sql_create_table.replace('\n', '\r\n')
sql_create_table = ' '.join([line.strip() for line in sql_create_table.splitlines()]).strip()
execute_sql(sql= sql_create_table)