Piccolo Admin not adding row in the table for complex schema.

[sumitsharansatsangi]

For complex schema, piccolo admin not adding rows.
It is fetching the rows from the database perfectly, but the problem occurs while adding the row.
Pressing the create button is not adding the data to the database.

[sinisaos]

@sumitsharansatsangi Are there any errors or? Can you share the code for your database tables that we can try and see where the problem is?

[sinisaos]

@sumitsharansatsangi I just managed to try your scheme. @dantownsend and you are right that the column name causes problem. Camelcase variable name is not common in Python and I think this line caused the problem because it cannot split the column name properly (accountNumber became Accountnumber in Piccolo Admin schema title name and it can't be splitted).

[sumitsharansatsangi]

@sinisaos , it's true that Camelcase variable name is not common in python. I had just because of copying the schema from another language and just changing it to be compatible with piccolo, I was unware that using camelCase with an issue. I had similar experience earlier too,but that time I was using Django, django raise some error while doing migrations of the table (or somewhere else, I don't remember exactly ), if similar can also be done for the piccolo, it will be helpful for other developers. @dantownsend , till raising exception is not added to the piccolo, please add in the schema section of the piccolo documentation to use snake_case as variable name.

Thank you both for the help.

[dantownsend]

Cool, I'm glad we know what caused the problem.

We assume that that column names are snake case. I think this can be fixed though in Piccolo Admin.

[sumitsharansatsangi]

If it can be fixed, please fix it.

[dantownsend]

This should be fixed now in piccolo_admin==0.32.0.