new version posted does type guessing and generate models with
formats:
$ python csvstudio.py -a -m 0 <input.csv
### Columns
columns = ['a', 'b', 'c']
### Column "a"
type(value) = "date %m/%d/%Y"
len(values) = 1
values = ['12/21/1981']
### Column "b"
type(value) = "double"
len(values) = 1
values = ['34.4']
### Column "c"
type(value) = "integer"
len(values) = 1
values = [23]
$ python csvstudio.py -w mytable -m 0 <input.csv
db.define_table("mytable",
Field("a","date",requires=IS_DATE(format="%m/%d/%Y"))
Field("b","double")
Field("c","integer")
)
On Dec 19, 6:22 am, "Martin.Mulone" <[email protected]> wrote:
> +1
