Skip to content

This is a Python Script that connects to a remote linux server and Execute Sql queries

License

Notifications You must be signed in to change notification settings

haroonkhan02/Python-script-for-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 

Repository files navigation

Python-script-for-SQL

This is a Python Script that connects to a remote linux server to execute SQL Queries and then create a Word or PDF report based on the template provided currently.

This is what the script performs in steps:

  1. Connects to linux Host
  2. Reads an Sql file that contains Sql queries
  3. prints the queries
  4. Executes the Sql queries in the Database
  5. checks the current Date (to be later used for report)
  6. Create a Word Document
  7. reads and replace the table contents of each table with the query results
  8. Saves the file
  9. Closes the connection

About

This is a Python Script that connects to a remote linux server and Execute Sql queries

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages