[API] Create table fails if whitelisted schema not exist

[jh-RLI]

Description of the issue

This is bug is problematic mostly for developers who want to create a table in an empty database. The whitelisted schemas do not exist in this database. If one wants to create a table using the wizard there is an error "Internal Server error" the user cant understand what is going on. Looking at the django terminal, this error is raised:

sqlalchemy.exc.programmingerror: (psycopg2.errors.InvalidSchemaName) schema "model_draft" does not exist

LINE 2: CREATE TABLE model_[draft.tetet](https://draft.tetet/) (

^

[SQL:

CREATE TABLE model_[draft.tetet](https://draft.tetet/) (

id BIGSERIAL NOT NULL,

name CHAR(5),

PRIMARY KEY (id)

)

]

(Background on this error at: http://sqlalche.me/e/13/f405)

[08/May/2023 09:25:05] "PUT /api/v0/schema/model_draft/tables/tetet/ HTTP/1.1" 500 200062

[08/May/2023 09:25:35] "GET /dataedit/wizard/ HTTP/1.1" 200 23052

ERROR:root:READING

Steps to Reproduce

1. Create empty database
2. Start oeplatform django application
3. User wizzard or api to create a table

Ideas of solution

As the schemas will not be part of the oep there should we should keep in mind to remove this code.

• [ ] Update the api create_table method and implement code before the table is created
• [ ] Check if schema name in whitelisted and create the schema if it is

alternative solution:

• [ ] Create schemas when database is created

Context and Environment

• Version used: develop
• Operating system: Windows 10
• Environment setup and (python) version: py3.10

Workflow checklist

• [x] I am aware of the workflow in CONTRIBUTING.md

[wingechr]

mh.. did you run python manage.py alembic upgrade head

this should create the schemata in the oedb (oedb_datamodels/versions/5c098aa81e2c_create_schemas.py)

NOTE

this is NOT the django migration, but the oedb alembic migration

[jh-RLI]

Ahhh i knew i forgot something!

I try again.

[jh-RLI]

Thanks again for refreshing my memory. This solves this issue.