piccolo

piccolo copied to clipboard

945 Using `db_column_name` when adding columns to existing tables using auto migrations

1

Resolves https://github.com/piccolo-orm/piccolo/issues/945

dantownsend

The way we store arrays in SQLite is by converting the values to JSON strings, and then storing them in a text field. We have this function which converts list...

dantownsend

LazyTableReference circular import

3

I'm facing circular import when I use LazyTableReference with app_name, please check the attached video below: https://github.com/piccolo-orm/piccolo/assets/19409912/d445e3c3-f24c-45ba-8578-ccf084e8b010

Abdelhadi92

Pessimistic locking: select for update

2

I need to lock an object in the database in order to prevent other transactions from modifying the same record. Within the Postgres such a lock should be done using...

Abdelhadi92

support in the future for surrealdb?

3

Hi Guys: I am a new fan of piccolo.. Thanks for the hard work.. I wonder if there is any plan to support "surrealdb"?

abcnow

Reverse relations fetching

11

FEATURE REQUEST: Is it a problem to add reverse relation fetching (conceptual or technical)? It would be nice to see something like that: ```python class Student(Table, tablename="students"): name = Varchar(length=64)...

Forceres

cockroachDB extremely long query due to Array(UUID())

8

hello all, Assume we have a simple `Post` table: ```python from piccolo.columns import * class Post(Table): uuid = UUID(primary_key=True) user = ForeignKey(User, null=False) description = Text() users_mentioned = Array(UUID()) ```...

Jacky56

Is there a way to truncate the table?

3

devsarvesh92

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

3

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

metakot

Schema generation assumes incorrect default values for UUID columns

1

## Summary Database: PostgreSQL 16 Version: 1.17.0 UUID columns generated by running `piccolo schema generate` have incorrect default values. This appears to be because `piccolo.columns.column_types.UUID` assumes that UUID columns with...

Keating950