search

AllenCellModeling / datasetdatabase

Modeling DB Schema, Creation, and IO
Other
1 stars 0 forks source link

Can't upload dictionaries #19

Closed cdw closed 6 years ago

cdw commented 6 years ago 
ds = {"a":1, "b":2, "c":3}
dsdbds = dsdb.Dataset(ds)
dsdbdb = dsdb.DatasetDatabase(config='/Users/cdavew/.dsdb_prod.json')
dsdbds.upload_to(dsdbdb)

returns

QueryException: operator does not exist: bytea = integer
LINE 1: SELECT * FROM "Iota" WHERE "Key" = 'a' AND "Value" = 1
                                                           ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
 (SQL: SELECT * FROM "Iota" WHERE "Key" = %s AND "Value" = %s (['a', 1]))
evamaxfield commented 6 years ago

Update to v1.0.3, this has been resolved, the issue was on the Dictionary introspector and not casting values to bytearrays before ingestion.