Mssql Facade
Instalación
pip3 install mssqldbfacade
Manual de uso
- Variables de Entorno
| Variable | Tipo de dato |
|---|---|
| MSSQL_STRING_CONNECTION | string |
-
Funciones:
get_data(query): Este método permite ejecutar una consulta SQL y obtener los resultados como un DataFrame de pandas.update_data(name, data): Este método ejecuta un procedimiento almacenado en la base de datos, enviando un DataFrame como parámetro.modify_data(query, data): Este método utiliza el paquete pandasql para aplicar una consulta SQL a un DataFrame local.
-
Ejemplos de Uso
from mssql_database_facade import DatabaseFacade
import pandas as pd
# Crear instancia de la fachada
db_facade = DatabaseFacade()
# Consultar datos
query = "SELECT * FROM mi_tabla"
data = db_facade.get_data(query)
print(data)
# Modificar datos utilizando pandasql
modify_query = "SELECT * FROM data WHERE columna > 10"
modified_data = db_facade.modify_data(modify_query, data)
print(modified_data)
# Actualizar datos con un procedimiento almacenado
update_data = pd.DataFrame([{"columna1": "valor1", "columna2": "valor2"}])
db_facade.update_data("mi_procedimiento", update_data)
By: Alan Medina ⚙️
1 maintainer
Metadata
1 maintainer
Release files for mssqldbfacade 1.0.12
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| mssqldbfacade-1.0.12.tar.gz | 4.4 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| mssqldbfacade-1.0.12-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 10.0 kB
Release files / mssqldbfacade-1.0.12.tar.gz
| Download URL | mssqldbfacade-1.0.12.tar.gz |
|---|---|
| Size | 4.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
e7e288ff2ee276cd9e037086262631d9dedafcc470d12f508fd12d866ad10883
|
|
BLAKE2b-256 checksum How to use checksums |
3d92cef9a8f54d875604e285a5e9f0025cd82cbf13cc5347b28464eb89d83fc9
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.0.1 CPython/3.8.10
|
Release files / mssqldbfacade-1.0.12-py3-none-any.whl
| Download URL | mssqldbfacade-1.0.12-py3-none-any.whl |
|---|---|
| Size | 5.6 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
e13648bdaba849c9bda8780773c2ceb5ffae368ddcaaca5ac351f0fa37178787
|
|
BLAKE2b-256 checksum How to use checksums |
240da1c15b32e7820a51dc379d58b69a80b48cd8a7abbc5b04f8892f4742f8cf
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.0.1 CPython/3.8.10
|
Security for mssqldbfacade 1.0.12
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
