Delete Table Method in molgenis-emx2-py Client

[Fernananas]

Issue

I would like to request a method to delete a specific table from a schema in the molgenis-emx2-py client. Currently, this action is possible in the schema editor UI but not via the Python client. Adding this functionality would improve automation and flexibility in managing schemas, particularly when rebuilding tables across multiple schemas.

Current Situation:

• The schema editor allows deleting individual tables.
• The Python client (molgenis-emx2-py) provides a method to delete an entire schema using:
  async def delete_schema(self, name: str = None):
• However, there is no equivalent method to delete a single table from a schema programmatically.

Use Case:
I have multiple schemas where I need to delete and rebuild specific tables programmatically. Deleting an entire schema and recreating it is not always feasible, so a method to remove individual tables would be highly beneficial.

Solution

Add a new method to delete a table within a schema, similar to delete_schema. The function signature could be:

async def delete_table(self, schema_name: str, table_name: str):

Expected Behavior:

• The method should remove the specified table from the given schema.
• If the table does not exist, an appropriate exception or error message should be returned.
• Optional confirmation logging or response to indicate successful deletion.

Alternatives

No response

Additional context

No response