abluecrate / SQLServerHandler Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

Small class that handles connections to Microsoft SQL Server

0 stars 0 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 11 Commits
README.md		README.md
populationMetricsTool.py		populationMetricsTool.py
sqlsrvrHandler.py		sqlsrvrHandler.py

Repository files navigation

SQLServerHandler

Small class that handles connections to Microsoft SQL Server
Reads SQL Queries into Pandas DataFrames

Format:

myDatabase = SQLServer('SERVER', 'DATABASE')

myQuery = 'select top (50) Names from DATABASE.myTable'

data = myDatabase.queryToDF(myQuery)

Utilizes: pandas, pyodbc

About

Small class that handles connections to Microsoft SQL Server

python data sql sql-server database pandas-dataframe pandas microsoft-sql-server sqlserver

Report repository

Releases

No releases published

Packages

No packages published

Languages

Python 100.0%