Skip to content
This repository was archived by the owner on Feb 2, 2022. It is now read-only.
This repository was archived by the owner on Feb 2, 2022. It is now read-only.

Add formatter to generate SQL Inserts #53

@rgreinho

Description

@rgreinho

Issue Type

  • Feature request

Current Behavior

It does not exist.

Expected Behavior

Create a formatter which would export a table and its content.

Something like:

CREATE TABLE IF NOT EXISTS data (
age INT NULL,
arrested VARCHAR(56) NULL,
case VARCHAR(10) NULL,
dob VARCHAR(11) NULL,
date VARCHAR(27) NULL,
ethnicity VARCHAR(8) NULL,
fatalcrashesthisyear INT NULL,
first_name VARCHAR(17) NULL,
gender VARCHAR(6) NULL,
last_name VARCHAR(15) NULL,
link VARCHAR(49) NULL,
location VARCHAR(59) NULL,
notes VARCHAR(267) NULL,
time VARCHAR(19) NULL
);

INSERT INTO data VALUES
(33,NULL,"17-3550122","6-18-84)","Thursday\, December 21\, 2017","White",71,"Carson","male","Goldstein","http://austintexas.gov/news/traffic-fatality-71-0","2100 block of Burton Drive",NULL,"1:38 p.m."),
(62,NULL,"17-3460912","1-22-55)","Tuesday\, December 12\, 2017","White",70,"Lance","male","Trewitt","http://austintexas.gov/news/traffic-fatality-70-0","8400 block of Research Blvd. Southbound",NULL,"2:13 p.m.");
  • Case should be the primary key.
  • The dates should be normalized and converted to UTC.
  • The duplicated entries would need to be handled.
  • Add an option for UPSERT instead of INSERT

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions