Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Lorenzo Rutayisire
    @loryruta
    I would firstly like to understand why my solution isn't working before trying workarounds...
    Jonathan Vanasco
    @jvanasco
    call session.flush() at the end of the loop
    Lorenzo Rutayisire
    @loryruta
    session.flush(objects=[op]) soon after op.processed_at = ... right?
    Jonathan Vanasco
    @jvanasco
    In your example, you're modifying the objects in Python but not updating the database
    Lorenzo Rutayisire
    @loryruta
    I've already tried adding flush after setting processed_at and I was still getting the same result...
    Jonathan Vanasco
    @jvanasco
    session.flush() should work
    at the same indent leve as the for loop, right after it
    level
    Lorenzo Rutayisire
    @loryruta
    I found the actual issue...
    yeah, flush is required however it continued giving me wrong results
    the issue was the filter clause. It should have looked like this:
                            .filter(and_(
                                SavedOp.id_user == user.id,
                                SavedOp.processed_at.is_(None)
                            )) \
    Alex Grönholm
    @agronholm
    that would not be required if you used a single chunking query methinks
    Jonathan Vanasco
    @jvanasco
    I didn't catch that. You can also do SavedOp.processed_at.op("is")(None)
    but is_(None) is the correct form
    Lorenzo Rutayisire
    @loryruta
    nope, I can't chunk
    Saltymakov Timofey
    @Actticus
    Hi. How can I do async bulk update by one statement? Can't find any information about it in docs
    await session.execute(
                    sqlalchemy.update(
                        some_table
                    ).where(
                        some_table.id.in_(ids)
                    ).values(
                        [{'a':.., ...}, {'a':.., ...},...]
                    ),
                )
    2 replies
    I'm tried something like that but catch UPDATE construct does not support multiple parameter sets.
    Alex Grönholm
    @agronholm
    is that from sqlalchemy itself or the rdbms?
    Alex Grönholm
    @agronholm
    why am I getting TypeError: dict is not a sequence when running engine.execute(...)? I'm not even passing it any parameters, just a literal SQL UPDATE statement
    it's crashing at cursor.execute(statement, parameters) where cursor is a psycopg2 cursor
    and parameters is an empty dict
    Federico Caselli
    @CaselIT
    strange, if cursor is a psycopg2 object sqlalchemy has no say in it
    btw I've just tried the same and I get no error: cur.execute('select 1', {}) where type(cur) is psycopg2.extensions.cursor
    Alex Grönholm
    @agronholm
    maybe it has to do with the contents of the query text
    GauravPandey-NECI
    @Gauravp-NEC
    Hi, How I can list the process of sqlalchemy?
    Federico Caselli
    @CaselIT
    what do you mean? sqlalchemy by its own does not have any process
    Alex Grönholm
    @agronholm
    perhaps that is a reference to PostgreSQL where client connections are shown as "processes" connecting to the server
    GauravPandey-NECI
    @Gauravp-NEC
    Hi, How we can check the "os.fork" have implemented in SQLalchemy source code?
    How we can check the "os.fork" functionality is used in SQLalchemy??
    Alex Grönholm
    @agronholm
    @Gauravp-NEC are you trying to ask if os.fork() is used in sqlalchemy, or what
    4 replies
    Varsha Ramesh
    @varsharmsh

    Hi,
    We are trying to use SQLAlchemy compile to generate queries in different dialects. It is somehow not working for complex queries.
    QUERY
    SELECT partsupp.ps_supplycost, region.r_regionkey FROM region JOIN partsupp ON
    (partsupp.ps_partkey 698) < region.r_regionkey

    SELECT OBJECT

    <class 'sqlalchemy.sql.selectable.Select'>
    SELECT partsupp.ps_supplycost, region.r_regionkey
    FROM region JOIN partsupp ON
    (partsupp.ps_partkey + %(ps_partkey_1)s) < region.r_regionkey

    USAGE

    Federico Caselli
    @CaselIT
    I'm not sure what is the issue @varsharmsh
    2 replies
    Cyril Margorin
    @comargo
    Hello there.
    I've got a noob question.
    https://gist.github.com/comargo/0ca997e45ce2d59ca456f556c6d5a07d
    How can I make relationship(..., backref="...") populate parent class before using it?
    but you should probably use back_populates
    Cyril Margorin
    @comargo
    @CaselIT Thanks!!! the configure_mappers() was exactly what I looked for, but why back_populates is better then backref? It requires me to write the same thing twice....
    Federico Caselli
    @CaselIT
    you write the other side of the relationshinp
    in the 99% or the cases it's better since it's explicit and it better to reason about once you have to re-read old code and you don't remember who defined that backref
    Cyril Margorin
    @comargo
    Well... ok, probably you right. Thank you for you help!
    Luis Roel
    @luisroel91
    Hello all! Anyone have any examples on how to use Automap with asyncpg? Even when running Base.prepare in run_sync call, still get (NoInspectionAvailable) exception
    Hunter Kiely
    @hkiely
    Has anything replaced SQLAlchemy-ImageAttach for SQLAlchemy 1.4?
    Hunter Kiely
    @hkiely
    If sqlalchemy.ext.declarative is built in version 1.4, can anyone link to a tutorial?
    Alex Grönholm
    @agronholm
    @hkiely it's no longer an extension; can you really not find the tutorial in the documentation?
    Nicolai Mogensen
    @NicolaiMogensen
    Can anyone explain why a call to __table__.columns on the base class of a model, also gives me all the columns of all classes that inherit the baseclass? How do i figure out what columns a specific class has, base or not
    Alex Grönholm
    @agronholm
    can you not determine that from the column objects themselves?
    Nicolai Mogensen
    @NicolaiMogensen
    Do they have a property that tells you what type of model they belong to?
    Alex Grönholm
    @agronholm
    I can't remember off hand, but dir(column) should give you a list a properties to check out
    Nicolai Mogensen
    @NicolaiMogensen
    I'll try it out, thanks for the pointer. But is the idea of having different table models, based on what the database might have implemented wrong? I see that i can't point them to the same table and schema. I might need to do something different. My idea was to have different classes based on what the client expects, but maybe i'm better off creating views in the actual database?
    Nicolai Mogensen
    @NicolaiMogensen
    Guess i'm trying to achieve https://docs.sqlalchemy.org/en/14/orm/inheritance.html#single-table-inheritance single table inheritance, i will dig around
    Hunter Kiely
    @hkiely
    @agronholm this is what I hav found dahlia/sqlalchemy-imageattach#47 .