sqlalchemy连接数据库的方法.pdf

zayki

346

3页

1次

2021-08-10

免费下载

Pandas + Sqlalchemy

Oracle

1.sid

engine = create_engine('oracle://scott:tiger@127.0.0.1:1521/sidname')

1> engine = create_engine("oracle://scott:tiger@localhost:1521/?

service_name=mydbpdb", encoding='utf-8')

df.to_sql('credentials', con=engine, if_exists='replace', index=False)

2> engine = create_engine('oracle+cx_oracle://scott:tiger@tnsname') #tns

excel

import pandas as pd

from sqlalchemy import create_engine

file = r'./testcases.xlsx'

df = pd.read_excel(file)

try:

engine = create_engine("mysql+pymysql://zyjsuper:123456@192.

168.128.129:3306/mydb", encoding='utf-8')

df.to_sql('testcases', con=engine, if_exists='replace', index=False)

except:

print("")

excel

import pandas as pd

from sqlalchemy import create_engine

if __name__ == "__main__":

engine = create_engine('mysql+pymysql://zyjsuper:123456@192.

168.128.129:3306/mydb')

#sql

sql = 'SELECT * FROM testcases'

#dataframe

df = pd.read_sql_query(sql,engine)

df.to_excel("testcases.xls",index=False)

excel

import pandas as pd

from sqlalchemy import create_engine

import os

dataPath = "C:\\Users\\Zayki\\Desktop\\Eureka"

os.chdir(dataPath)

i = 1

for file in os.listdir(dataPath):

df = pd.read_excel(file)

if file.startswith('eureka'):

try:

engine = create_engine("mysql+pymysql://zyjsuper:123456@192.

168.128.129:3306/mydb", encoding='utf-8')

df.to_sql('eureka' + str(i), con=engine, if_exists='replace',

index=False)

print('eureka' + str(i) + "")

except:

print("")

i+=1

else:

try:

engine = create_engine("mysql+pymysql://zyjsuper:123456@192.

168.128.129:3306/mydb", encoding='utf-8')

df.to_sql('summary' + str(i), con=engine, if_exists='replace',

index=False)

print('summary' + str(i) + "")

except:

print("")

i+=1

of 3

免费下载

关注

评论