The dawdle package

[Tags:library, mit, program]

Generates DDL suggestions based on a CSV file


[Skip to Readme]

Properties

Versions 0.1.0.0, 0.1.0.1, 0.1.0.2
Dependencies base (==4.8.*), 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 repository head: git clone https://github.com/arnons1/dawdle.git
Uploaded Sat Dec 5 22:58:40 UTC 2015 by arnon
Distributions NixOS:0.1.0.2
Downloads 242 total (19 in the last 30 days)
Votes
0 []
Status Docs available [build log]
Last success reported on 2015-12-05 [all 1 reports]
Hackage Matrix CI

Modules

[Index]

Downloads

Maintainer's Corner

For package maintainers and hackage trustees

Readme for dawdle

Readme for dawdle-0.1.0.2

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