Metadata-Version: 2.1
Name: truncate-and-write-to-sql
Version: 0.1.1
Summary: Truncate existing table and write to the table with new entries
Home-page: https://github.com/MPettersen/truncate_and_write_to_sql
Author: Markus Pettersen
Author-email: mp.markus94@gmail.com
License: UNKNOWN
Platform: UNKNOWN
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.8
Description-Content-Type: text/markdown

# A small package for truncating a table before writing to it

## Install

```powershell
pip install truncate-and-write-to-sql
```

## Example usage

```python
import pandas as pd
from sqlalchemy import create_engine

from truncat_and_write_to_sql.methods import truncate_and_write_sql

# Establish a connection to a SQL database
connection_string = 'a connection string to a database'
engine = create_engine(connection_string)

# Create a dataframe to write to the database
data = {'First Column Name':  ['First value', 'Second value'],
        'Second Column Name': ['First value', 'Second value']}
df = pd.DataFrame(data)

# Truncate existing values and write in new ones
truncate_and_write_sql(
    con=engine,
    df=df,
    table='name of database table',
    schema='database schema e.g. stg',
    if_exists='append',
    mulit=True
)
```

