python - PostgreSQL（新部署）

Question

需要更改服务器上的表，Sources 表的名称（DateRegister 列 - 日期格式），从本地服务器上传部署并使用正确的日期格式。它不适用于查询 SQL 的力量。谁能回答执行？.py 上的代码可以正常工作，但我们需要 postgreSQL。

my.py

import sqlalchemy
from sqlalchemy import create_engine
from sqlalchemy import text
import pandas as pd
import  datetime

engine = create_engine('postgresql://postgres:user@localhost')
connection = engine.connect()

query = ''' 
SELECT id ,"DateRegister"
  FROM "Sources"
  ORDER BY id
'''

result = connection.execute(query)
df = pd.DataFrame(result.fetchall())
df.columns = result.keys()
date = []
id = list(df['id'])

for i in df['DateRegister']:
    i = pd.to_datetime(i)
    date.append(i.date())


count = 0
for i in date:
    query = ''' 
    UPDATE "Sources" 
    SET "DateRegister1" = '{}'
    WHERE id = {}
    '''.format(i, id[count])
    connection.execute(query)
    count +=1

https://github.com/Luks77/all/blob/0eb995fc2c95b89572c50c2614c4f45b8dd7c7aa/my.py

标签： pythonpostgresql