# Project: Package to Convert Dataframes to SQL Server Script
## Project Author: Francisco Fadio
[(click here to see my profile on the platform)](https://github.com/franciscofabio)
#### Technology: Python | SQL
#### Date: 22/01/2023
-----------------------------------------
### Description
The "df_to_sql" package is used for:
- "Convert" module:
- has the function converter_df_in_sql that with os.mkdir('SCRIPTS')
- the function receives 3 variables as a parameter:
- df -> dataframe name.
- tb_name -> name of the sql database table.
- name_script -> file name
- creates the output folder for sql scripts
- Through for adds '' in columns of type object 'categories'
---------------------------------------------
### Here the goal is to provide a simple code package but it solved a real problem for me and I believe it can solve problems with other dataframes. If you need, you can collect the data in csv, treat them and after that, to insert the records in a sql server database, just use the df_to_sqlserver package to generate the scripts and then run these scripts in your DBMS or batch.
----------------------------------------------------
## How to install the package
```bash
pip install df_to_sqlserver
```
-------------------------------------------------
## How to use in any project
```python
from df_to_sqlserver.df_to_sqlserver import converter_df_in_sql
converter_df_in_sql(df,"Tablename","name_Script_SQL")
```
## Author:
Francisco Fabio de Almeida Ferreira <br>
Systems Analyst and Data Science Specialist
Raw data
{
"_id": null,
"home_page": "https://github.com/franciscofabio/df_to_sqlserver",
"name": "df-to-sqlserver",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.8",
"maintainer_email": "",
"keywords": "df to sql",
"author": "Francisco Fabio de Almeida Ferreira",
"author_email": "franciscofabio18@hotmail.com",
"download_url": "https://files.pythonhosted.org/packages/44/bd/8e1c277ce4fcf389a9b6cb13015f513a1ba31249e6884586d0e51660a29f/df_to_sqlserver-1.0.8.tar.gz",
"platform": null,
"description": "# Project: Package to Convert Dataframes to SQL Server Script\n## Project Author: Francisco Fadio\n[(click here to see my profile on the platform)](https://github.com/franciscofabio)\n#### Technology: Python | SQL\n#### Date: 22/01/2023\n-----------------------------------------\n### Description\nThe \"df_to_sql\" package is used for:\n\n- \"Convert\" module:\n - has the function converter_df_in_sql that with os.mkdir('SCRIPTS')\n - the function receives 3 variables as a parameter:\n - df -> dataframe name.\n - tb_name -> name of the sql database table.\n - name_script -> file name\n - creates the output folder for sql scripts\n - Through for adds '' in columns of type object 'categories'\n\n---------------------------------------------\n\n### Here the goal is to provide a simple code package but it solved a real problem for me and I believe it can solve problems with other dataframes. If you need, you can collect the data in csv, treat them and after that, to insert the records in a sql server database, just use the df_to_sqlserver package to generate the scripts and then run these scripts in your DBMS or batch.\n----------------------------------------------------\n## How to install the package\n```bash\npip install df_to_sqlserver\n```\n-------------------------------------------------\n## How to use in any project\n\n```python\nfrom df_to_sqlserver.df_to_sqlserver import converter_df_in_sql\nconverter_df_in_sql(df,\"Tablename\",\"name_Script_SQL\")\n```\n\n\n## Author:\nFrancisco Fabio de Almeida Ferreira <br>\nSystems Analyst and Data Science Specialist",
"bugtrack_url": null,
"license": "MIT License",
"summary": "Test version - Dataframe to Script SQL. This project created to Francisco Fabio de A. Ferreira, Systems Analyst, Data Scientist. This package. E-mail:franciscofabio18@hotmail.com.",
"version": "1.0.8",
"split_keywords": [
"df",
"to",
"sql"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "44bd8e1c277ce4fcf389a9b6cb13015f513a1ba31249e6884586d0e51660a29f",
"md5": "3421e39df21f9088d1455ff1072e7f6b",
"sha256": "ed907dd1e26440dc405dcc8aa14fbb7b2c4cbd781d57c65899643eaea2b13b5a"
},
"downloads": -1,
"filename": "df_to_sqlserver-1.0.8.tar.gz",
"has_sig": false,
"md5_digest": "3421e39df21f9088d1455ff1072e7f6b",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 2774,
"upload_time": "2023-01-23T13:51:42",
"upload_time_iso_8601": "2023-01-23T13:51:42.557409Z",
"url": "https://files.pythonhosted.org/packages/44/bd/8e1c277ce4fcf389a9b6cb13015f513a1ba31249e6884586d0e51660a29f/df_to_sqlserver-1.0.8.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-01-23 13:51:42",
"github": true,
"gitlab": false,
"bitbucket": false,
"github_user": "franciscofabio",
"github_project": "df_to_sqlserver",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "df-to-sqlserver"
}
JSON
