pycharm连接python,Python Pycharm和SQL Server连接

I would like to use data from SQL server in Pycharm using python. I have my database connection set up in Pycharm, but not sure how to access this data within my python code. I would like to query the data within the python code (similar to what I would do in R using the RODBC package).

Any suggestions on what to do or where to look would be much appreciated.

解决方案

There is a concept called OR(Object Relational) Mapping in python, which can be used for database connections. One of the modules that you need to import for the purpose is SQLAlchemy.

First, you will need to install sqlalchemy by:

pip install sqlalchemy

Now, for database connection, we have an Engine class in the sqlalchemy, which is responsible for the database connectivity. We create an object of the Engine class for establishing connection.

from sqlalchemy import create_engine,MetaData,select

engine=create_engine("mysql://user:pwd@localhost/dbname", echo=True)

connection=engine.connect()

The process of reading the database and creating metadata is called Reflection.

metadata=MetaData()

query=select([Student]) #Assuming that my database already has a table named Student

result=connection.execute(query)

row=result.fetchall() #This works similar to the select* query

In this way, you can manipulate data through other queries too, using sqlalchemy!