Create Data Tables with Code

[ianb]

I just looked into this, and if you write yaml to directly create a db schema there is nothing in the yaml that can check this box in your app:

You can try it yourself, If you:

1. Create a blank app with only a datatable
2. Check the box in the picture above,( even change something to make sure all changes are saved)
3. Export the yaml file
4. Delete the app and re-import the same yaml from file.

Then the checkbox to auto-create missing columns will be unchecked on import.

This means you can’t even programmatically add a (nearly) blank DB schema and then have it auto-create the columns for you without using the anvil editor.
The reason I was looking into this was because of this question:

Self-hosted Anvil, managing data tables

@ianbuywise, thank you very much, this will solve my problem partially, I hope. Do you have a suggestion for data transfer as well? I’m getting errors using Pandas dataframe (read_csv) even for simple tables. Am I making a mistake or do I need to deal with datatypes of each column or “NaN” values? I’m not experienced in Python tbh… I can share my code if needed. @stefano.menci, it doesn’t help, because if I need to write SQL queries for simplest operations, there is no point to use data table…

Here, @polat Is using the self hosted version, and is trying to load data without using the editor, but it seems like there are a few roadblocks to using the self hosting without having moderate database and data typing skills. (Even If you already have some data-science skills)

Maybe this could at least be possible to toggle on with the schema in the yaml ?
Since I think the code exists in the self-hosted version to auto-add columns? I’m not sure how someone would turn it on.

At this point I’m not even sure if I am asking for a feature or asking a question, I have thoroughly confused myself.