python 链接数据库

MySQL
1.最原始的方法

import pymysql
CONN = pymysql.connect(host='127.0.0.1',
                       port=3306,
                       user='root',
                       password='root',
                       database='ss',
                       charset='utf8')

cursor = CONN.cursor()
cursor.execute('select * from test')
result = cursor.fetchall()
cursor.close()
print(result)

import pymysql
import pandas as pd
conn = pymysql.connect(
	user="user",
	password="password",
	host="127.0.0.1",
	database="test"
)
sql = 'select * from test'
df=pd.read_sql(sql,conn)

from sqlalchemy import create_engine
import pandas as pd

engine = create_engine(
        "mysql+pymysql://user:password@127.0.0.1/test",
    )
sql = 'select * from test'
# 读数据
with engine.connect() as conn:
    df = pd.read_sql(sql, conn)

MSSQL

import pymssql
import pandas as pd
conn = pymssql.connect(
	user="user",
	password="password",
	host="127.0.0.1",
	database="test"
)
sql = 'select * from test'
df=pd.read_sql(sql,conn)

from sqlalchemy import create_engine
import pandas as pd

engine = create_engine(
        "mssql+pymssql://user:password@127.0.0.1/test",
    )
sql = 'select * from test'
# 读数据
with engine.connect() as conn:
    df = pd.read_sql(sql, conn)

PostgreSQL

import pg8000
import pandas as pd
conn = pg8000.connect(
    user="user",
    password="user",
    host='127.0.0.1',
    database='test',
)
sql = 'select * from test'
df = pd.read_sql_query(sql, conn)

from sqlalchemy import create_engine
import pandas as pd

engine = create_engine(
        "postgresql+pg8000://user:password@127.0.0.1/test",
    )
sql = 'select * from test'
# 读数据
with engine.connect() as conn:
    df = pd.read_sql_query(sql, conn)

neo4j

from py2neo import Graph
graph = Graph(
    "http://localhost:7474",
    username="neo4j",
    password="rooter"
)