database_wrapper_mssql
Part of the database_wrapper package.
This python package is a database wrapper for Mssql database.
Installation
pip install database_wrapper[mssql]
Prerequisites
- pymssql
- pyodbc - currently this is used for introspection and only installed in development environment
Usage
from database_wrapper_mssql import Mssql, DBWrapperMssql
db = Mssql({
"hostname": "localhost",
"port": "1433",
"username": "sa",
"password": "your_password",
"database": "master"
})
db.open()
dbWrapper = DBWrapperMssql(dbCursor=db.cursor)
# Simple query
aModel = MyModel()
res = await dbWrapper.getByKey(
aModel,
"id",
3005,
)
if res:
print(f"getByKey: {res.toDict()}")
else:
print("No results")
# Raw query
res = await dbWrapper.getAll(
aModel,
customQuery="""
SELECT t1.*, t2.name AS other_name
FROM my_table AS t1
LEFT JOIN other_table AS t2 ON t1.other_id = t2.id
"""
)
async for record in res:
print(f"getAll: {record.toDict()}")
else:
print("No results")
db.close()
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file database_wrapper_mssql-0.3.146.tar.gz.
File metadata
- Download URL: database_wrapper_mssql-0.3.146.tar.gz
- Upload date:
- Size: 9.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
96224dcb73b94e6e4f1a2b95eebabd60fb2797b6a7112f0f96a2d538dde801c7
|
|
| MD5 |
d9b4fabc8408f2e6a1d4211aa4802aa2
|
|
| BLAKE2b-256 |
2789d7b0a5a3937670d5e49cd960b19cbf6766640587624817a26bdfd4ec847a
|
Provenance
The following attestation bundles were made for database_wrapper_mssql-0.3.146.tar.gz:
Publisher:
master.yml on 4Apps/py_database_wrapper
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
database_wrapper_mssql-0.3.146.tar.gz -
Subject digest:
96224dcb73b94e6e4f1a2b95eebabd60fb2797b6a7112f0f96a2d538dde801c7 - Sigstore transparency entry: 2370779745
- Sigstore integration time:
-
Permalink:
4Apps/py_database_wrapper@70f4b183e3587e9bf25a8626acb8b19cd7ee0937 -
Branch / Tag:
refs/tags/v0.3.146 - Owner: https://github.com/4Apps
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
master.yml@70f4b183e3587e9bf25a8626acb8b19cd7ee0937 -
Trigger Event:
release
-
Statement type:
File details
Details for the file database_wrapper_mssql-0.3.146-py3-none-any.whl.
File metadata
- Download URL: database_wrapper_mssql-0.3.146-py3-none-any.whl
- Upload date:
- Size: 9.7 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
791af35d5d8beff59346d081402d9f4de303c763a6be0a6fe0d23c895862ac19
|
|
| MD5 |
399a784375b100dbb7bf177aa5242248
|
|
| BLAKE2b-256 |
1056a2977056f5deb9d76e18fa9e249b4a82da9d0ad18780a0e3d95e0dc13909
|
Provenance
The following attestation bundles were made for database_wrapper_mssql-0.3.146-py3-none-any.whl:
Publisher:
master.yml on 4Apps/py_database_wrapper
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
database_wrapper_mssql-0.3.146-py3-none-any.whl -
Subject digest:
791af35d5d8beff59346d081402d9f4de303c763a6be0a6fe0d23c895862ac19 - Sigstore transparency entry: 2370780099
- Sigstore integration time:
-
Permalink:
4Apps/py_database_wrapper@70f4b183e3587e9bf25a8626acb8b19cd7ee0937 -
Branch / Tag:
refs/tags/v0.3.146 - Owner: https://github.com/4Apps
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
master.yml@70f4b183e3587e9bf25a8626acb8b19cd7ee0937 -
Trigger Event:
release
-
Statement type:
