feel free to hang here, note that some of the "chat" happens on libera.chat #sqlalchemy
(about 10 people working in this repo... I'm asking around for any info as nobody covers the whole code)
oh, to anyone interested in sqlalchemy_utils.register_composites() + async
Hello, is it possible to add some option during Sequence creation so upon deletion 'drop sequence CASCADE' would be issued instead of 'drop sequence' in ddl.compile. dialect is psql.
I'm getting error
I'm getting error
cannot drop sequence sequence_ticket_number because other objects depend on it
ticket_number = db.Column(
db.Integer, sequence_ticket_number, server_default=sequence_ticket_number.next_value(), autoincrement=True, nullable=False)
can you find such a thing in the documentation? https://www.postgresql.org/docs/current/sql-createsequence.html
so as far as I can see it's python objects being compiled into sql
first link answers that
I know very well what these parameters do
https://docs.sqlalchemy.org/en/14/core/defaults.html#sqlalchemy.schema.Sequence <- as you can see from the example, just having the sequence there is enough
the code is legacy, trying to launch tests and droppping whole db is blocked because of problems during sequence deletion
thanks, gonna try to remove
if removing this
sequence_ticket_number.next_value() part resolves
Hi all.
Using ORM.
I have a O2M relationship that I set to lazy="raise" (addresses in User table).
Now I want to use the relationship User.addresses in a query:result = await async_session.execute(User.addresses.statement)
But it complains saying AttributeError: 'InstrumentedList' object has no attribute 'statement'
I don't want to change the lazy so that I don't accidentally call it.
Don't know that that api is. Please see this for details on relationship loading https://docs.sqlalchemy.org/en/14/orm/loading_relationships.html?highlight=relationship+loading
Turns out I must be using
https://docs.sqlalchemy.org/en/14/orm/extensions/asyncio.html#preventing-implicit-io-when-using-asyncsession
(Last point)
lzay="dynamic"https://docs.sqlalchemy.org/en/14/orm/extensions/asyncio.html#preventing-implicit-io-when-using-asyncsession
(Last point)
Another question: How to joinedload and selectinload on the same table?
Example:
User - O2M - Addresses
User - M2O (FK) - Group
This doesn't work:select(User).options(joinedload(User.group).selectinload(User.addresses))
chaining them indicates that you somehow want to load the "addresses" relationship in the related
Group
select(User).options(joinedload(User.group).selectinload(User.addresses))
you should not chain them since aggresses is not part of Group. they should be separated by comma, since are both "top level" (of user) select(User).options(joinedload(User.group), selectinload(User.addresses))
Hi guys, I have a problem that I'm not sure how to approach.
I have 3 classes that all share some attributes - (id, entry time, owner, category) and I would like to be able to query them all at once.
So say I need to search for class where entry time < datetime I could easily retrieve all classes where that would be the case. Not knowing much about sqlalchemy I figured the easiest solution would be an abstract class that would then be used for querying but it seems that is not supported?
I have 3 classes that all share some attributes - (id, entry time, owner, category) and I would like to be able to query them all at once.
So say I need to search for class where entry time < datetime I could easily retrieve all classes where that would be the case. Not knowing much about sqlalchemy I figured the easiest solution would be an abstract class that would then be used for querying but it seems that is not supported?
Right now I'm stuck because the only querying that seems to be supported is through one class at a time - session.query(class).filter() but I need to be able to query through multiple classes by their shared attributes.
see the docs about it https://docs.sqlalchemy.org/en/14/orm/inheritance.html
Hello! Using async SQLAlchemy, let's assume I have all my relationships defined with
lazy="raise", which would raise an exception each time I try to access the respective attribute. Is there a way to load such an "unloaded" relationship after I have already obtained the object from the ORM? According to the documentation, Session.refresh()doesn't automatically refresh unloaded relationships. How do I load the relationship, then? I'm aware of joinedload() & friends, but in case of a large object graph I would like to avoid eagerly loading the whole database with every single query.
it's also in the "tip" box in the refresh documenation
Good afternoon. Share your experience with those who are familiar with the situation: only the first line from the csv file is added..
async with aiofiles.open(
directory, mode="r", encoding="utf-8", newline=""
) as afp:
async for new in AsyncDictReader(afp):
query = ScheduleService(
**{
"id": new["id"],
"name": new["name"],
"type": new["type"],
"title": new["title"],
"description": new["description"],
"date": datetime.strptime(
new["date"], settings.DATE
).date(),
"there_is": datetime.strptime(
new["there_is"], settings.DATETIME_FORMAT
),
"created_at": datetime.now(),
"sch_s_owner": new["sch_s_owner"],
"sch_s_service_id": new["sch_s_service_id"],
}
)
# ..
session.add_all(query)
session.refresh([query])
await session.commit()
Hi all, I'm trying to follow the tutorial on caching (sqlalchemy version 1.3): https://docs.sqlalchemy.org/en/13/_modules/examples/dogpile_caching/caching_query.html but whenever I execute the code line:
self.mergte_result(..., load=False) I get: AttributeError: '<MyModel>' object has no attribute '_sa_instance_state' does anyone know if this is me making a mistake/wrong-assumption or is the tutorial that is missing something?
