{"repo":"Quantco/pytsql","free":true,"listed":false,"github":"https://github.com/Quantco/pytsql","clone":"git clone https://github.com/Quantco/pytsql.git","description":"Run mssql scripts from Python.","language":"C++","stars":15,"topics":["database","mssql","sql","tsql"],"license":"BSD-3-Clause","category":"databases-storage","readme_excerpt":"pytsql 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. Installation To install, execute: or in a conda environment Be aware that depending on your platform, you'will need specific drivers (Windows, Linux, macOS). Usage 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 ][engine] object as well as the path to the sql script of interest. A typical use case might look as follows: Please also have a look at our documentation sections on usage and development. [engine]: https://docs.sqlalchemy.org/en/14/core/engines.html Credits Grammar is based on antlr4/grammars-v4.","default_branch":null,"files":null,"tree":[],"storefront":"/r/Quantco","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Quantco/pytsql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}