fake-data-to-database 1.1

A Python library to generate fake data and insert it into databases.

Fake Data To Database

Fake Data To Database is a Python library designed to generate fake data and insert it into databases.

Features

• Generate realistic fake data using Faker
• Insert data into:
  • PostgreSQL
• Easy-to-use interface for bulk data insertion

Installation

You can install the library using pip:

pip install fake-data-to-database

Exemple of use

You can use the lib as the exemple:

import fake_data_to_database as fdg

db_config_postgres = {
    "db": "postgres",
    "host": "localhost",
    "port": 5432,
    "database": "db",
    "user": "user",
    "password": "password",
}

fields = {
    "name": {"type": "varchar", "nullable": False},
    "age": {"type": "int", "nullable": False},
    "email": {"type": "varchar", "nullable": True},
    "cidade": {"type": "varchar", "nullable": False},
}

fdg = fdg.FakeDataGenerator(
    db_config=db_config_postgres,
    schema="public",
    table="teste",
    fields_config=fields
)

fdg.generate_and_insert_data(num_records=10)