dawdle

Generates DDL suggestions based on a CSV file https://github.com/arnons1/dawdle

Latest on Hackage:0.1.0.2

This package is not currently in any snapshots. If you're interested in using it, we recommend adding it to Stackage Nightly. Doing so will make builds more reliable, and allow stackage.org to host generated Haddocks.

MIT licensed by Arnon Shimoni

Dawdle - the DDL suggestor tool

Meant as a tool for analyzing CSVs and suggesting a DDL. Generates an executable called dawdle once installed.

Usage examples

$ dawdle --input="example_with_comma.csv" --with-header -s "," This means analyze the file example_with_comma.csv, assume the first line is the header and use a comma as a separator. The example output is

create table example_with_comma (id int not null,
                                 name varchar(65) not null,
                                 created_at datetime not null,
                                 updated_at datetime not null)

To see all command line flags, run $ dawdle --help.

Types

Currently, the syntax is basic(-ish) SQL. Supported types are: tinyint smallint int bigint real float date datetime (==timestamp) * varchar

Used by 1 package:
comments powered byDisqus