piccolo
piccolo copied to clipboard
piccolo-orm
A fast, user friendly ORM and query builder which supports asyncio.
Issue Description: I've encountered an intermittent issue in the get_sql_value function where a TypeError occurs. The error message indicates that the problem is related to the isinstance() function, specifically at...
Hello! I've using piccolo with fastapi and pydantic. I need to `select()` db records as dicts and throw them to pydantic, but it fails on ForeignKey because piccolo returns nested...
Resolves https://github.com/piccolo-orm/piccolo/issues/757
When creating a new migration, I think this bug(error) only occurs with ForeignKeys, details below: ``` my_app/tables.py ``` ```python class Order(Table, tablename="orders"): user = ForeignKey( LazyTableReference( table_class_name="Users", module_path="users.tables" ) )...
Resolves https://github.com/piccolo-orm/piccolo/issues/785
With code like this: ``` async with DB.transaction(): await Band.insert(Band(name="test1")) assert False await Band.insert(Band(name="test2")) ``` Band "test1" is still inserted. Is there a way to make the transaction "really atomic"?...
The Piccolo migrations look something like this: ```python from piccolo.apps.migrations.auto.migration_manager import MigrationManager ID = "2022-02-26T17:38:44:758593" VERSION = "0.69.2" # The version of Piccolo used to create it DESCRIPTION = "Optional...
I have this table: ``` class Profile(Table): class Role(str, Enum): STAFF = 'staff' SUPERVISOR = 'supervisor' ADMIN = 'admin' user = ForeignKey(references=BaseUser) user = ForeignKey(references=Company) ``` and created the Pydantic...
Hi, sometimes I get the above exception. Once it happens, all following DB Queries are raising this exception, so I have to restart the entire web app. The Trace-Back looks...
Metadata
Owner
Metadata
A fast, user friendly ORM and query builder which supports asyncio.