pytsql allows to run mssql scripts, typically run from GUIs, from Python.
This, in turn, eases concurrent, scheduled and chained execution of scripts in a workflow. Put differently, it enables automated execution of Microsoft sql server scripts.
Moreover, pytsql supports parametrization of scripts, akin to templating.
Please have a look at our documentation if you're curious about more details.
To install, execute:
pip install pytsql
or in a conda environment
mamba install pytsql
Be aware that depending on your platform, you'will need specific drivers (Windows, Linux, macOS).
pytsql is tailored to run with MSSQL. Other sql dialects are not supported.
The main function of interest is execute. It requires a sqlalchemy Engine
object as well as the path to the sql script of interest. A typical use case might look as follows:
import pytsql
from sqlalchemy import sa
db_connection_string = "connection_to_my_database"
engine = sa.get_engine(db_connection_string)
pytsql.execute("my_sql_script.sql", engine)
Please also have a look at our documentation sections on usage and development.
Grammar is based on antlr4/grammars-v4.
FAQs
`Pytsql` allows to run mssql sripts, typically run via GUIs, via CLI.
We found that pytsql demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 2 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
PyPI confirms no security flaws were exploited in the Ultralytics supply chain attack and highlights improvements for safer package publishing.
Security News
Research
The Socket Research Team breaks down a malicious wrapper package that uses obfuscation to harvest credentials and exfiltrate sensitive data.
Research
Security News
Attackers used a malicious npm package typosquatting a popular ESLint plugin to steal sensitive data, execute commands, and exploit developer systems.