dawdle: Generates DDL suggestions based on a CSV file

[ database, library, mit, program ] [ Propose Tags ]

Generates DDL suggestions based on a CSV file


[Skip to Readme]

Downloads

Maintainer's Corner

Package maintainers

For package maintainers and hackage trustees

Candidates

  • No Candidates
Versions [RSS] 0.1.0.0, 0.1.0.1, 0.1.0.2
Dependencies base (>=4.8 && <4.9), dawdle (==0.1.0.2), filepath (>=1.4.0.0), parsec (>=3.1.8 && <3.2), pretty (>=1.0 && <1.2), text (>=0.11.1.13 && <1.3), time (>=1.4 && <1.6) [details]
License MIT
Author Arnon Shimoni
Maintainer arnon.shimoni@gmail.com
Category Database
Home page https://github.com/arnons1/dawdle
Source repo head: git clone https://github.com/arnons1/dawdle.git
Uploaded by arnon at 2015-12-05T22:58:40Z
Distributions
Executables dawdle
Downloads 2088 total (1 in the last 30 days)
Rating (no votes yet) [estimated by Bayesian average]
Your Rating
  • λ
  • λ
  • λ
Status Docs available [build log]
Last success reported on 2015-12-05 [all 1 reports]

Readme for dawdle-0.1.0.2

[back to package description]

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