Metadata-Version: 2.4
Name: bizflow-db-helper
Version: 1.0.0
Summary: A database helper utility for Oracle, SQL Server, and PostgreSQL databases
Home-page: https://github.com/littlekeixi/dbhelper
Author: littlekeixi
Project-URL: Bug Tracker, https://github.com/littlekeixi/dbhelper/issues
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.6
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: oracledb
Requires-Dist: pandas
Requires-Dist: bcpy
Requires-Dist: sqlalchemy
Requires-Dist: numpy
Dynamic: author
Dynamic: classifier
Dynamic: description
Dynamic: description-content-type
Dynamic: home-page
Dynamic: license-file
Dynamic: project-url
Dynamic: requires-dist
Dynamic: requires-python
Dynamic: summary

# bizflow-db-helper

A Python database helper utility that simplifies database operations for Oracle, SQL Server, and PostgreSQL databases. This package provides a unified interface for working with different database types and includes features for efficient data transfer and type handling.

## Features

- Support for Oracle, SQL Server, and PostgreSQL databases
- Unified interface for all supported databases
- Automatic data type handling and conversion
- Efficient bulk data loading
- Pandas DataFrame integration

## Installation

```bash
pip install bizflow-db-helper
```

## Usage

```python
from bizflow_db_helper import DBHelper

# Initialize the database helper
db = DBHelper(
    user="your_username",
    password="your_password",
    host="your_host",
    port="your_port",
    db_name="your_database",
    schema="your_schema",
    db_type="oracle"  # or "sql_server" or "postgresql"
)

# Write DataFrame to database
import pandas as pd
df = pd.DataFrame(...)
db.to_sql(df, "table_name", if_exists="append")
```

## License

This project is licensed under the MIT License - see the LICENSE file for details.
