ponyorm / editor Goto Github PK

Reproduce by setting up a str attribute

switching it to UUID without removing max_length

Results in:
Required(UUID, 255, unique=True, default=uuid4). causing TypeError: Unexpected positional argument for attribute Model.some_id: 255

Fixable by moving back to str and removing offending field, or editing manually.

Currently it is only possible to build a structure from scratch, but it would be better to be able to import python definitions.

Especially for source control it would be great if we could just throw the database definition form December 2018 into the editor, and get a visual representation of that.

Hi,

I just use your editor in order to generate SQL schemas and got the error when clicking on postgreSQL tabs (note: it's the same if I click on Oracle, Mysql, SQLite):
Something went wrong: invalid syntax (, line 343)

How can I debug this ?

I can't seem to find an option to set composite keys/indices in the editor.
If I can't find it but it's there, can you tell me where it is?
If it is not there, it would be awesome if it could be added.

In your documentation, you recommend using mixins to not lose customization when copying the models from the editor. It's good advice, but currently, you would still have to re-establish all the multi-inheritance of each class when updating. It would be super useful to have a field to declare the additional mixins for a given entity and have them reflected in the "Models" code.

Editing the Intermediate Table value for a given entity field does not result in the table argument being passed to the Set initialization on generated Models code.

I can not see any zoom in/out function on canvas. I can use ctrl+scroll but it shrinks/enlarges the whole page which causes readability issues with menus.

It is nice to have that zoom in and out function for just the canvas part.

The sidebar and menu bar remove some visibility to the designer tab, especially when working with split screen, it would be nice to be able to hide these sections to have more space on the designer tab.

Some attributes, like collections, are "virtual" and does not have associate column in the table. It should be more clear to display such attributes in a way that makes them visually distinguishing from "normal" attributes

Steps to reproduce:

1. Log into Pony ORM editor
2. Open an existing diagram
3. Generate Models

Result:

• UI displays Something went wrong
• Browser developer tools shows call to /get-code failed with error 500

Notes:

• Issue also occurs with all the other code generators: SQLite, MySQL, PostgreSQL, Oracle

Currently public diagrams can be edited by everyone with an account. This means that a possibly malicious user is able (as all public diagrams are visible on a single page) to destroy all diagrams.

This makes it difficult to rely on to make small projects, if at any given time, a malicious user can come in and destroy everything.

A possible improvement would be to restrict write access to diagrams. If someone wants to edit a diagram, he can make a copy of it and edit his own copy.

The Python code for Sqlite database created with the online editor always ends with the following two lines:

db.bind("sqlite", ":memory:", create_db=True)
db.generate_mapping(create_tables=True)

I don't remember ever manually changing them. I think they came out with the correct database name, as set in the settings page. Also the two checkboxes in the mapping settings are ignored: "Create database" and "Create tables".

Is it a regression?

Getting errors with even the simplest of diagrams, any idea why?

Hi,

Just wanted to ask whether the source for online editor is available ?