py-scripto

This is to run SQL script or file script in an instance of sql server

Installation:

python -m pip install py_scripto

Version used

SQL Server 2019
Python 3.7.5

DEPENDENCIES

DbExec stored procedure

Download from https://github.com/datnguye/SQL-Server/blob/master/maintenance/DbExec.sql
Compile it to master database

xp_cmdshell need enabling on SQL instance

EXEC sp_configure 'show advanced option', 1
RECONFIGURE
GO
EXEC sp_configure 'xp_cmdshell', 1
RECONFIGURE
GO

USAGE

from py_scripto import sqlserver
sqlserver.run_file_script(server="DAVID\DAVID", uid="py-scripto", pwd="py-scripto", connect_to_db="IMPORT", script_path="D:\\Downloads\\test.sql")
sqlserver.run_script(server="DAVID\DAVID", uid="py-scripto", pwd="py-scripto", connect_to_db="IMPORT", sql="SELECT * FROM Test WITH (NOLOCK)")

Metadata

Release files for py-scripto 0.1.4

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for py-scripto 0.1.4
File	Size	Uploaded	Provenance
py_scripto-0.1.4.tar.gz	2.0 kB	May 11, 2020	Without provenance	Details

Built distribution (wheel)

Table of built distributions (wheels) for py-scripto 0.1.4
File	Interpreter	ABI	Platform	Reset
py_scripto-0.1.4-py3-none-any.whl 3.3 kB May 11, 2020 Without provenance	Python 3	none	any	Details

Total release size: 5.3 kB

Release files / py_scripto-0.1.4.tar.gz

Download URL	py_scripto-0.1.4.tar.gz
Size	2.0 kB
Tags	Source
SHA-256 checksum How to use checksums	`fe13b3671930fd1f39ddaede466ac3ee1fb6ac4d334e09a5fbb1f1147267633a`
BLAKE2b-256 checksum How to use checksums	`c8cc8189aed5774834c4d9b6ae2c3b6be2884a38cb7de8d9b96dce636a2f5957`
Upload date	May 11, 2020
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/3.1.1 pkginfo/1.5.0.1 requests/2.22.0 setuptools/46.2.0 requests-toolbelt/0.9.1 tqdm/4.40.2 CPython/3.7.5`

Release files / py_scripto-0.1.4-py3-none-any.whl

Download URL	py_scripto-0.1.4-py3-none-any.whl
Size	3.3 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`630172f518ceae153e969ad68298d58fb351e2e8b632369defe650ca98f7fcc4`
BLAKE2b-256 checksum How to use checksums	`ef7c8a0c9b8210ada7b23a23de4a20d21665eaab6fc7eec64165f11ed62664a9`
Upload date	May 11, 2020
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/3.1.1 pkginfo/1.5.0.1 requests/2.22.0 setuptools/46.2.0 requests-toolbelt/0.9.1 tqdm/4.40.2 CPython/3.7.5`

Security for py-scripto 0.1.4

Report project as malware

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.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Release history Release notifications | RSS feed

This release

0.1.4 This release

May 11, 2020 2 release files No provenance

0.1.0