



# SQLServer
  
Connect to SQLServer and manage all your databases, execute custom queries, import and export data, create and execute stored procedures.  

*Read this in other languages: [English](README.md), [Português](README.pr.md), [Español](README.es.md)*

## How to install this module
  
To install the module in Rocketbot Studio, it can be done in two ways:
1. Manual: __Download__ the .zip file and unzip it in the modules folder. The folder name must be the same as the module and inside it must have the following files and folders: \__init__.py, package.json, docs, example and libs. If you have the application open, refresh your browser to be able to use the new module.
2. Automatic: When entering Rocketbot Studio on the right margin you will find the **Addons** section, select **Install Mods**, search for the desired module and press install.  


## Overview


1. SQLServer Connection  
Connect to SQLServer database

2. Query SQLServer  
Make a query to a SQLServer database

3. Insert SQLServer  
Insert data in a SQLServer database

4. Export data  
Export data from a SQLServer database

5. Import data  
Import data to a SQLServer database

6. Download File  
Download File from a SQL Server Database

7. Create a SP with variables  
Create the Store Procedure with variables

8. Get SPs  
Get the available Store Procedures

9. SP to execute  
To see the SPs you must connect to the DB and do not close the conection until you selected the Store Procedure

10. Delete a SP  
Delete the indicated Store Procedure

11. Close connection  
Close the connection to SQLServer  




----
### OS

- windows
- docker

### Dependencies
- [**sqlalchemy**](https://pypi.org/project/sqlalchemy/)- [**pyodbc**](https://pypi.org/project/pyodbc/)
### License
  
![MIT](https://camo.githubusercontent.com/107590fac8cbd65071396bb4d04040f76cde5bde/687474703a2f2f696d672e736869656c64732e696f2f3a6c6963656e73652d6d69742d626c75652e7376673f7374796c653d666c61742d737175617265)  
[MIT](http://opensource.org/licenses/mit-license.ph)