Adding Data Source Tables containing wildcards '*' breaks schema about polypheny-db HOT 5 OPEN

Hey, i wanna fix this. Can I get some direction to do this?

from polypheny-db.

hi, I'm not sure about the progress of this project, but I'm very interested in it. My proposal is to first validate user input when adding a data source and prevent users from using reserved characters (such as ) as table names.
To address this concern, a validation rule supposed to be added to the addAdapter method of Crud.java. Specifically, before proceeding with the adapter addition process, the method checks if the unique name of the adapter is "".
AdapterModel a = gson.fromJson(body, AdapterModel.class); if (a.uniqueName.equals("*")) { ctx.json(new Result("Invalid adapter name: '*' is not allowed").setSuccess(false)); return; }
If it is, the method returns a Result object containing an appropriate error message indicating that creating an adapter with the name "" is not allowed. This validation rule ensures that no new entity named "" is created in the public schema.Hope my comment can receive further guidance and feedback for ongoing improvement;)

from polypheny-db.

@hennlo So what is the objective now, not allowing * (asterix) or implement the logic to select all the available db in the schema
If possible assign this issue to me I would be happy to contribute

from polypheny-db.

The issue is as pointed out by @dengjuan0721 that an * or other reserved keywords like already existing tables_names in that schema may break the entire schema. Therefore the input should be validated.

from polypheny-db.

My basic solution is provided in #479
Please review the proposed solution at your convenience so I can get some instruction in detail

from polypheny-db.