Has anyone successfully saved a `SQLTableDataset` ...
# questionsr
Richard Purvis
10/27/2023, 2:40 AMHas anyone successfully saved a
SQLTableDatasetj
Juan Luis
10/27/2023, 8:36 AMWould this require a custom resolver to pass the types through the catalog?yes! here's an example for Polars:
r
Richard Purvis
10/27/2023, 4:27 PMThanks. What would be a good way to add arguments for these? For instance,
sqlalchemy.types.String(32)j
Juan Luis
10/27/2023, 4:29 PMmaybe
"${sqlalchemy:String:32}"Juan Luis
10/27/2023, 4:29 PMand you split the value by
:r
Richard Purvis
10/27/2023, 4:30 PM Copy code
CONFIG_LOADER_ARGS = {
"custom_resolvers": {
"sql_types": lambda x: getattr(sqlalchemy.types, x),
}
}Richard Purvis
10/27/2023, 4:31 PMI'm not sure how the nested keys would work with that, though
Richard Purvis
10/27/2023, 4:32 PMAlternately,
Copy code
CONFIG_LOADER_ARGS = {
"custom_resolvers": {
"sql_string": lambda x: sqlalchemy.types.String(x),
}
}j
Juan Luis
10/30/2023, 9:17 AMI was thinking
Copy code
CONFIG_LOADER_ARGS = {
"custom_resolvers": {
"sql_types": lambda value: getattr(sqlalchemy.types, value.split(":")[0])(value.split(":")[1]),
}
} Copy code
def get_sql_type(value):
type_cls_name, arg = value.split(":")
type_cls = getattr(sqlalchemy.types, type_cls_name)
return type_cls_name(arg)r
Richard Purvis
10/30/2023, 1:44 PMYes, thanks.
👍🏼 1