mshanu / idli

Generate create statement for your RDBMS looking through sample data set

idli

You get data with many columns as file, mostly csv. Now you would like to import the data to a database. Creating a table going through all the columns understanding the type is a pain. Idli helps you to generate create statement based on the data (sampling) for a database of your choice.

Support

Currently it takes only csv file with first line as header and generates the script for the following dbs

• Oracle
• Mysql
• Postgres

Instructions to Run

git clone

./gradlew run --args "file=<path_to_file> db=mysql"

db values can be oracle, mysql or pg

idli's Issues

Support for Postgres

Add support to generate the create statement for postgres db.

Support for more data types

Currently idli does not recognise dates and timestamps. This is an issue to track the feature.

While splitting not respecting quotes

Values having quotes for eg:
first value,"secon column, with comma separated values",third column, forth column
is split as five values than three values.
Values with single quotes and double quotes should be treated as one value

Support for configurable delimiter.

Currently the default delimiter used is comma. Make the tool also take in a delimiter value.