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.14.tar.gz
(2.8 kB
view hashes)
Built Distribution
Close
Hashes for sqlserver-0.0.14-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f17178bc3cbe19e2d62d38315f99efd62f43512ddc2ac62ee040b9ebd08e90cf |
|
MD5 | 83348f8b500355a9c7d5c045d0a15e19 |
|
BLAKE2b-256 | f8f5ca24b50e30461ff8174d8725d0c6c11905d7da931e3f9abe18f2302b09da |