Important

🚫 Ethical Restrictions

My works cannot be used in:

• Military applications or systems
• Surveillance technologies
• Any activity violating human rights

🚀 Features

⚡ Quick Start

Installation

# Clone repository
git clone https://github.com/SSobol77/csv-db-sdk.git
cd csv-db-sdk
# Basic Installation (Core Functionality)
pip install csv-db-sdk
# Development Setup (Testing + Coverage)
pip install "csv-db-sdk[testing]"
# Full Installation (All Features)
pip install "csv-db-sdk[full]"

Semantic Versioning Policy

Dependency Management

Version Guarantees

Compatibility Matrix

Upgrade Recommendations

# Safe Upgrade Path
pip install --upgrade-strategy eager "csv-db-sdk>=1.2,<2.0"
# Version Pinning Example
echo "csv-db-sdk==1.2.3" >> production-requirements.txt

Basic Usage

from csv_db_sdk import PostgresConnector
# Initialize connector
config = {
 "host": "localhost",
 "user": "admin",
 "password": "secret",
 "database": "mydb"
}
pg = PostgresConnector(config)
# Import CSV to table
pg.import_csv("data/users.csv", "users_table")
# Export table to CSV
pg.export_csv("analytics/results.csv", "sales_data")

🏗 Architecture

csv-db-sdk/
├── 📂 core/ # SDK Core Components
│ ├── connectors.py # Base DB connector logic
│ └── utilities.py # CSV parsing/validation
├── 📂 db_adapters/ # Database-specific implementations
│ ├── postgres.py # PostgreSQL adapter
│ ├── mongodb.py # MongoDB adapter
│ └── ... # Other databases
├── 📂 examples/ # Ready-to-run scenarios
│ ├── basic_import.py # CSV → DB example
│ └── advanced_export.py # DB → CSV with filtering
└── 📂 tests/ # Comprehensive test suite
 ├── unit/ # Isolated component tests
 └── integration/ # End-to-end workflow tests

🔧 Database Configuration

Connection Templates

# PostgreSQL Example
postgres:
 host: "db-server.prod"
 port: 5432
 database: "analytics"
 user: "${DB_USER}"
 password: "${DB_PASS}"
 sslmode: "require"
# MongoDB Example
mongodb:
 uri: "mongodb+srv://cluster.prod.mongodb.net"
 authSource: "admin"
 tls: true

🧪 Testing Strategy

# Run all tests
pytest tests/ -v
# Test specific database
pytest tests/postgres -v --cov=db_adapters.postgres
# Generate coverage report
pytest --cov-report html --cov=.

🤝 Contributing

📜 License

📬 Contact