metakot

init-db said "Inited models already" even if error has occured before

3

So if I forgot to add "aerich.models" to models config or the importing of the app's models failed because of something, and then run `aerich init-db`, it failes with error...

aerich doesn't respect default in TextField

2

Add the text field ```python text = fields.TextField(default='') ``` run `aerich migrate` the result is ```json { "upgrade": [ "ALTER TABLE \"company\" ADD \"text\" TEXT NOT NULL" ], "downgrade": [...

pydantic error none.not_allowed on select().output(nested=True)

12

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...

Support for other primary key names than `id`?

3

So I'm creating a new table with varchar primary key which has another name than `id`. ```python import piccolo.columns as cl from piccolo.table import Table class Currency(Table): code = cl.Varchar(primary_key=True)...

DatatypeMismatchError when migrating new field references to `self` with UUID PK field.

1

So I have this table in postgres ```python import piccolo.columns as cl from piccolo.table import Table class SelfTable(Table): id = cl.UUID(primary_key=True) ``` Creating migration for it and running it as...

Value is not a valid <type> when having column with null=True, default=None, required=False

11

piccolo==0.107.0 piccolo-admin==0.44.0 piccolo-api==0.51.0 So I have this simple table ```python import piccolo.columns as cl from piccolo.table import Table class TestTable(Table): number = cl.Integer( null=True, default=None, required=False, ) ``` When I...

piccolo==1.5.0 piccolo_admin==1.3.2 piccolo_api==1.4.0 So I have a table in Postgres: ```python class Example(Table): number = Serial() ``` Saving it ```python example = Example() await example.save() print(example.number) ``` it just prints...

piccolo==1.5.0 piccolo_admin==1.3.2 piccolo_api==1.4.0 So I have a table in SQLite: ```python class Example(Table): number = Serial() ``` When trying to save it ```python example = Example() await example.save() ``` the...

Work without relay.Node interfaces

3

Can this package work without relay.Node interfaces? Checking for permissions happens in _get_node_ func, but if used without relay, this func never gets called.

Auto-created index name have a big chance to clash with the table name or name of some structure in the database.

1

So I have this two tables in postgres: ```python from piccolo.columns import * from piccolo.table import Table class EmployeeRole(Table): name = Varchar() class Employee(Table): name = Varchar() role = ForeignKey(EmployeeRole,...