a module that makes queries easier to SQL Server than PYODBC
Project description
SQLSERVER PYODBC Module
Installation for linux guys
%%sh
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get -q -y install msodbcsql17
pip install sqlserver
Installation for windows guys
pip install sqlserver
Example of ConnectionString linux guys
DRIVER={ODBC Driver 17 for SQL Server};SERVER=SERVERNAME,PORT;DATABASE=DB;UID=USERNAME;PWD=PASSWORD
Usage
import sqlserver
db = sqlserver.adgsqlserver('yourconnectionstring')
db.(whateverfunctions in the modules)
returns data
Copyright ADGSTUDIOS 2022
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqlserver-0.0.13.tar.gz
(2.9 kB
view hashes)
Built Distribution
Close
Hashes for sqlserver-0.0.13-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 589dfa8fc3c0b8203d285ce7792f262684f22c236c83eecce6f7e691e22f98e2 |
|
MD5 | 3063f1f1d3ee3e6bd67eca6b5931f2e5 |
|
BLAKE2b-256 | a1674aa7bd840832a6a375cc21b5fb581bf037b9d949fdde6f76bbf8becd0506 |