Issue Type
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
Issue Type
Current Behavior
It does not exist.
Expected Behavior
Create a formatter which would export a table and its content.
Something like:
Caseshould be the primary key.UPSERTinstead ofINSERT