Schema generation and visualisation, + video

[dantownsend]

We recently added the schema app to Piccolo. It lets users auto generate their Piccolo Table classes from an existing database, using piccolo schema generate.

It also auto generates an Entity Relationship Diagram from your schema using piccolo schema graph, which can be great for documentation.

Here's a video about it:

https://www.youtube.com/watch?v=Y9vaS4nnQGE

[James-Firth]

I tried using piccolo schema generate today while seeing if piccolo would work as a nice query builder for one of our teams.

But we have a table called user that referenced a lot so I got a big list of ValueErrors with the exception user is a protected name, please give your table a different name.

Is there a way for me to tell the generator to ignore that error or use a different alias internally?

I know Piccolo does a lot, but I'm really just looking for something to do models and query building right now so I don't think the user restriction should matter to me.

Thanks in advance and let me know if I should put this in a separate issue or discussion :)

[dantownsend]

I'll create an issue.

[dantownsend]

#849

[dantownsend]

@James-Firth Try piccolo==0.116.0 - it now just emits a warning instead of an exception. I might remove this warning in the future, but at least it should work now.

[James-Firth]

Thanks! Just gave that a shot and it looks like it works, thanks!

[dantownsend]

Nice!