executemany存万得数据到数据库

• 参考

插入的表名为参数，插入数据为大量数据

from psycopg2.extensions import AsIs
data = []
data.append(
    (AsIs(tablename),val1,val2),
    (AsIs(tablename),val3,val4)
)
cur.executemany('''insert into \"%s\" values (%s,%s,%s) on conflict do nothing''',data) #如果表存在，则不做处理，退出

• 存入万得示例

from WindPy import w
import psycopg2

w.start()

wdata = w.wsd(...)
data_size = len(wdata.Data[0]) 
data = []
for i in range(data_size):
    data.append(
        wdata.Data[0][i],
        wdata.Data[1][i],
        ...
    )
conn = psycopg2.connect('user=user dbname=dbname')
cur = conn.cursor()
cur.executemany('''insert into table values(%s,%s,...)''',data)
conn.commit()

conn.close()
w.close()