@fantix @wwwjfy Do we have sqlalchemy type events in place? (like after_create, after_update, etc.) Or is there any decent way to achieve this?
Solution provided here looks a bit hacky and I'm not very convinced if I should implement something like this (If any of you approves, I can go and implement a similar setup). Thanks :)
Solution provided here looks a bit hacky and I'm not very convinced if I should implement something like this (If any of you approves, I can go and implement a similar setup). Thanks :)
then call
create_user() instead of User.create()
or alternatively override
User.create method
Just my first reaction to this question, would require more use cases though
such hooks could be added
but the
create() and create_all() functions are a bit less elegant - they're copied from SQLAlchemy and manipulated to be async, so I'm overall not a big fan
the
create_async or GinoSchemaVisitor.create might be the places to override
Hi guys, does anybody knows how to wrap all pytest (pytest-asyncio) + sanic/aiohttp test cases in transactions? Seems like there is multiple different event loops, and asyncpg can't work in this conditions (similar issue like I have: python-gino/gino#713)
1 reply
As alternative solution I'm already do TRUNCATE at end of each test case, but it is too slow, nearly 1 second for each test case. Transactions can improve mine test run time significally, I think.
As final solution I want have something like django test cases, where transaction starts at setup_method and rollbacks at teardown_method.
Thanks in advance.
Hi. May be anybody knows why sqlalchemy query execute faster then Gino query. I have this type pf code with Gino
async with db.with_bind(connecting_str) as engine:
instructions = await Instruction.query.where(Instruction.id==int(instruction_id)
).where(Instruction.trigger_id==int(instruction['trigger_id'])).gino.first()
await instructions.update(blocks=instruction['blocks']).apply(). And my SQLAlchemy code:
with AlchemySession() as db:
db.session.query(Trigger).filter(Trigger.id == trigger_id).update({'instructions_id': request['instructions_id']})
db.session.commit()
How can we use update query in sqlalchemy
db.session.query(Trigger).filter(Trigger.id == trigger_id).update({'instructions_id': request['instructions_id']})style for one-to-many relations?
Shall we do it without getting foreign key and then find child table with this key and after that update this row?
2 replies
@fantix hey man, first of all good job on creating Gino! I was wondering if it is possible to filter a table using someting like
filter_by from sqlalchemy where you could just filter arguments without having to pass table columns? Keep up the good work, thanks in advance!
2 replies
Is there some person to message about this
?
I'm writing a guide that takes advantage of gino and quart and would like to use this package in this guide -> migrating the package with changes I already have for my projects working
The changes will be up and tested in a few days
@Chaostheorie oh if the tag name matches the pattern, the pre-defined GitHub Action will do the release: https://github.com/python-gino/gino-quart/blob/a2f7415340c979f777dc8500f43ea3f6305e7c52/.github/workflows/test.yml#L7-L8
pls feel free to either bump the version, or change the pattern
and FYI there's already 0.1.0 out on PyPI: https://pypi.org/project/gino-quart/#history
we may want to call the next version 0.2.0b0 or something
I will delete the tag and create a new one called 0.2.0b0 for this. A