Fake2DB

Create fake data and bulk insert it into the database

Dependency

For generating fake data using below package https://github.com/brianvoe/gofakeit

Notes for running the app

In case the number of workers is more than chunk like below some errors maybe accused depends on mysql configuration

worker =100 
chunk_size = 1
rows = 100000

supposed errors

[mysql] packets.go:37: unexpected EOF
bad connection
error in executing the query Error 1213: Deadlock found when trying to get lock; try restarting transaction

but if chunk size is big enough it is possible to have 100 workers in the same time for instance like below

worker =100
chunk_size = 3000

CREATE TABLE students (
    id BIGINT UNSIGNED AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    gender ENUM('male', 'female', 'other'),
    code INT,
    dob DATE,
    address TEXT,
    created_at DATETIME,
    PRIMARY KEY (id)
);