leading zeroes / --shape args

[jsfenfen]

Hi @simonw I'm having a hard time applying the shape function. I can use the native .import function, but that brings in everything as text, but I'd love to specify that the ZCTA columns have leading zeroes while other int columns don't. Edited to say this is easy to work around by just making the sqlite file by "normal" means.

That said, this and #42 both have leading zero issues. I was running version 0.9.2

Running csvs-to-sqlite --shape "ZCTA5:ZCTA5(TEXT)" zctas.csv zctas.db on a csv like the following results in the output having the leading zeroes removed although using the shape arg does result in the type being string (without specifying type it is imported as an integer, which also removes the leading zeroes).

ZCTA5
00601
00601
00602
00603
00606
00606
00610
00612
00616
00617
00622
00623
00624
00624
00627
00631
00631
00637
00637
00638