redshift mysql_使用Python迁移redshift mysql

嗨，我正在使用以下脚本将数据从mysql迁移到redshift。在mysql_table_name = 'clabDevelopment.KPI_kpireport'

mysql_cur = mysql_conn.cursor()

mysql_cur.execute('select * from %s where Date = "2018-01-01";' % mysql_table_name )

description = mysql_cur.description

rows = mysql_cur.fetchall()

# Insert data into Redshift

redshift_table_name = 'kpi_kpireport'

redshift_cur = redshift_conn.cursor()

insert_template = 'insert into %s (%s) values %s;'

column_names = ', '.join([x[0] for x in description])

values = ', '.join(['(' + ','.join(map(str, x)) + ')' for x in rows])

redshift_cur.execute(insert_template % (redshift_table_name, column_names, values))

我遇到的邮件问题是当值为空时：

^{pr2}$

就像None和CHG之间有“，，”，它会导致程序失败。在

错误如下：Traceback (most recent call last):

File "C:\Users\trackstarz\migration.py", line 20, in

redshift_cur.execute(insert_template % (redshift_table_name, column_names, values))

psycopg2.ProgrammingError: syntax error at or near ","

LINE 1: ...re_Costs, FBA_Fee) values (241325,2018-01-01,None,,CHG,USA,N...

^

[Finished in 2.0s]