Python库sqlite2mysql_Python 数据库连接(sqlite, mysql, oracle, postgresql, sql server)

Python 数据库连接(sqlite, mysql, oracle, postgresql, sql server)

Python连接数据主要用SQLAlchemy。

SQLAlchemy是最有名的ORM框架。

首先通过pip或easy_install 安装 SQLAlchemy

pip install sqlalchemy

数据库连接

from sqlalchemy import create_engine

# 连接 sqlite内存数据库

engine = create_engine('sqlite:///:memory:')

# 连接 sqlite文件数据库

# where is relative:

engine = create_engine('sqlite:///foo.db')

# or absolute, starting with a slash:

engine = create_engine('sqlite:absolute/path/to/foo.db')

# 连接 mysql

engine = create_engine('mysql+mysqldb://scott:tiger@localhost/foo')

#连接 oracle

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

#连接SQL Server

engine = create_engine('mssql+pyodbc://mydsn')

#or

engine &#