radosz / filldb

Command line tool to fill an arbitrary mariadb schema with test data

A tool for filling a Relational database

I looked around and couldn't find a decent database filling tool. So I wrote one.

This tool only works with MariaDB. Extending it to support other databases should not be hard, but I have no need at the moment. Anyone that would like to implement it can help.

Meant to be used from the command line.

Status

Only one real problem left: Dealing with primary keys that span multiple columns (may or may not fail with the current code)

There is a command line switch that allows you to ignore errors so that the insert won't fail completely.

Current features

• Schema agnostic, point it to a DB and it will figure things out from there
• Supports text, varchar, bigint, int and bit columns
• Can generate test data of various field types: street, city, state, country, email, name, first/middle/last name, hex, phone number, timestamp,
• Can download various lorum ipsums from generators online
• Can download various cartoons from webcomics

Future features

There are some listed in src/docs/ideas.md. More ideas are welcome. As are bugs, comments and anything else really.

Installation

1. Check out the code git clone https://github.com/codemonstur/filldb.git
2. Run make install
3. You can now run the code with java -jar target/filldb.jar
4. [Optional] Copy the code to /usr/local/bin
5. [Optional] Create an alias alias filldb='java -jar /usr/local/bin/filldb.jar'

The code requires Java 11.