[sqlalchemy] Re: Shared ORM objects between threads

Thanks Jonathan, that should help me move forward. On Tuesday, July 5, 2022 at 12:51:52 PM UTC-4 Jonathan Vanasco wrote: > > > I'm guessing we shouldn't be passing ORM objects to threads, but rather > just passing IDs and then querying the full object in the thread function > > Correct. > >

[sqlalchemy] Shared ORM objects between threads

Hi, I'm troubleshooting some code that uses thread_pool_executor to run a function, passing an ORM entity as an argument. Within the executed function, we are sometimes receiving a "Value Error: generator already executing" when accessing a related entity via a relationship property. I'm

[sqlalchemy] Re: sqlalchemy messes up names with "_1" suffix

Not sure if this will help but are you using FlaskWTF? If you have repeating fields on a form, some of its data structures will append a _1, _2... to each instance in your response to keep them unique. So, just a guess, but perhaps your problem is related to Flask / WTForms? On Friday, July

Re: [sqlalchemy] SQLAlchemy Access to Native Bulk Loaders

that the world would want to rely on my code :) In any case, thank you so much for taking the time to reply. Ben On Sunday, April 19, 2020 at 1:23:06 PM UTC-4, James Fennell wrote: > > Hi Ben, > > Have you checked out bulk operations? > https://docs.sqlalchem

[sqlalchemy] SQLAlchemy Access to Native Bulk Loaders

the right place for this. Thanks! Ben -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You

[sqlalchemy] Re: Attributes missing documentation?

of the Python world that I've used in the past few years, and I haven't pushed them very far the way that a public project with a lot of users might. On Monday, September 3, 2018 at 8:46:34 PM UTC-7, Ben Creasy wrote: > > Thank you for the amazing tool! I've been messing around with SQLA

Re: [sqlalchemy] How to reflect a table when I only have SELECT permission for some columns?

se tables be reflected, instead > you'd have to code the columns you care about in the application. > > > On Dec 25, 2016 3:55 AM, "Ben Mishkanian" <shami...@gmail.com > > wrote: > >> Hello, >> >> I am having an issue similar to the one descr

[sqlalchemy] How to reflect a table when I only have SELECT permission for some columns?

Hello, I am having an issue similar to the one described in this unanswered StackOverflow question. My issue is that I need to load the data from a table where the SELECT permission is denied

[sqlalchemy] Re: Dialect Python package name convension

In the case of the just-released dialect for CockroachDB, I called the package "cockroachdb". My plan (at least for now) is to include dialects for multiple ORMs in one python package instead of a separate package for each one. I have a slight personal preference for "-sqlalchemy", but

Re: [sqlalchemy] Using CockroachDB with SQLAlchemy

we're still working hard on stability and performance. You can use it in development but it's not to the point that we'd recommend trusting it with production data. The SQLAlchemy dialect itself is in pretty good shape because it builds on the existing PostgreSQL support, although it has so f

[sqlalchemy] Using CockroachDB with SQLAlchemy

. -Ben -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@google

Re: How to handle changing formerly-unnamed constraints (and retrying after errors in migration scripts)

ion_method_pkey" with op.batch_alter_table("user_authentication_method") as batch_op: batch_op.drop_constraint(probable_name, type_='unique') No guarantees that the above is /correct/ but it catches the exception and seems to work so far. Thanks again. -- Ben On Wednesday, 20 A

How to handle changing formerly-unnamed constraints (and retrying after errors in migration scripts)

irst error and try subsequent constraint names? Thanks, Ben -- You received this message because you are subscribed to the Google Groups "sqlalchemy-alembic" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy-alembic+unsubscr...@googleg

[sqlalchemy] Expressions generated by select(...) changes when submitted in session.query

Hi, I am using sqlalchemy in flask, essentially through flask-sqlalchemy, and my goal is to generate and execute queries on the fly. I am pretty new to sqlalchemy ( a great challenge and a great work) I am using a model generated by automap. The entities are automap classes I managed to

[sqlalchemy] SQLite objects getting closed in wrong thread, if session not explicitly closed

the clean-up logic to the callback on a weakref is the wrong thing to do? Not that I'm sure what the alternative would be... Thanks, Ben -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving e

[sqlalchemy] Getting different error messages trying to connect to DB server.

][ODBC SQL Server Driver][SQL Server]Login failed for user 'ben n'. (18456)) None None On the database server, if I look in the Event Viewer, I find a message that says: MSSQLSERVER / Event ID: 18456 Login failed for user '*myusername*'. Reason: Could not find a login matching the name provided

Re: [sqlalchemy] HSTORE intermittent bug

tracking system that has anything to do with this purported issue. Thank you, Ben Boule On Wednesday, February 19, 2014 1:54:10 PM UTC-5, Michael Bayer wrote: On Feb 19, 2014, at 1:28 PM, al...@bitcredits.io javascript: wrote: Hi there, I've been hitting an intermittent bug with SQLAlchemy

[sqlalchemy] inheritied table with related field as discriminator?

: select([Reference.reference_name].join(Parent) Thanks Ben -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post

Re: [sqlalchemy] Pool_recycle in Oracle (aka Oracle has gone away)

experience is that pool_recycle is not doing anything with Oracle... hopefully have a test (or ideally a never mind) follow up in a few days. Am I correct in assuming that SQLA connection pool is wholly independent of Oracle's connection pooling (which we have disabled)? Ben -- You

[sqlalchemy] Pool_recycle in Oracle (aka Oracle has gone away)

the problem is. Thanks for you time, and interested to hear thoughts. Ben -- Ben Hitz Senior Scientific Programmer ** Saccharomyces Genome Database ** GO Consortium Stanford University ** h...@stanford.edu -- You received this message because you are subscribed to the Google Groups sqlalchemy

[sqlalchemy] GROUP BY ... WITH ROLLUP

Is it possible to use the 'WITH ROLLUP' clause in SQLAlchemy? I'm having problems locating any examples on how to do so. Here's a link to MySQL (dialect I'm using) docs on the statement - http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html -- You received this message because you

Re: [sqlalchemy] GROUP BY ... WITH ROLLUP

(Foo.data)).statement.compile(dialect=mysql.dialect()) print s.query(Foo).group_by(rollup(Foo.__table__.c.data)).statement.compile(dialect=mysql.dialect()) On May 1, 2012, at 11:23 AM, Ben Hayden wrote: Is it possible to use the 'WITH ROLLUP' clause in SQLAlchemy? I'm having problems

Re: [sqlalchemy] GROUP BY ... WITH ROLLUP

sqlalchemy.dialects import mysql print s.query(Foo).group_by(rollup(Foo.data)).statement.compile(dialect=mysql.dialect()) print s.query(Foo).group_by(rollup(Foo.__table__.c.data)).statement.compile(dialect=mysql.dialect()) On May 1, 2012, at 11:23 AM, Ben Hayden wrote: Is it possible to use

[sqlalchemy] How to stop SQLAlchemy from adding an ON UPDATE clause to a TIMESTAMP column by default

Say I have a model (running on MySQL): *class Foo(DeclarativeBase):* *__tablename__ = 'foo'* * * *#column definitions* *id = Column(u'id', CHAR(length=36), default=uuid, primary_key=True, nullable=False)* *date_added = Column(u'dateAdded', TIMESTAMP(), nullable=False)* *

[sqlalchemy] Re: How to stop SQLAlchemy from adding an ON UPDATE clause to a TIMESTAMP column by default

Hmm... well this is a weird problem then. I ran the provided code, and got the same result you did, with the DEFAULT ON UPDATE missing. However, I added a couple lines: *from sqlalchemy.ext.declarative import declarative_base* *from sqlalchemy import Table, CHAR, TIMESTAMP, TEXT, schema,

[sqlalchemy] Re: How to stop SQLAlchemy from adding an ON UPDATE clause to a TIMESTAMP column by default

Well - I don't know what's going on, but I did find a workaround (for me at least, your mileage may vary), I set server_default to this: *date_added = Column(u'dateAdded', TIMESTAMP(), server_default=text('CURRENT_TIMESTAMP'), nullable=False)* * * Which gives me: *CREATE TABLE foo (* * id

Re: [sqlalchemy] Re: object_session returns None, but state still has session_id

should also have mentioned that the original session would have been from a query_property rather than an explicitly created Session(). Is there any particular reason that you added the check where you did in the patch as opposed to the except KeyError clause in _state_session? Cheers, Ben -- You

[sqlalchemy] object_session returns None, but state still has session_id

could be set to None - or any other action taken that would make the state look like it didn't have a Session. As for a fix, I guess the best thing to do would be to make_transient(obj) or is there a better way? Thanks, Ben -- You received this message because you are subscribed to the Google

[sqlalchemy] Re: object_session returns None, but state still has session_id

is to do: state = attributes.instance_state(obj) state.detach() Would that work do you think? BTW would this be considered a bug, should I raise a bug report on this? Cheers, Ben -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion

[sqlalchemy] Caveats with sqlite in-memory databases + transactions?

Hi all, I've been writing some tests for an application that makes use of transactions and came across a strange issue: the Transactions in my tests seemed to be committed before commit() was called. After some head scratching I reduced the problem to a minimal test case and found that everything

[sqlalchemy] Re: Caveats with sqlite in-memory databases + transactions?

://www.sqlalchemy.org/trac/wiki/FAQ#Iamusingmultipleconnectionswi... On Sep 1, 2011, at 8:26 AM, Ben Hearsum wrote: Hi all, I've been writing some tests for an application that makes use of transactions and came across a strange issue: the Transactions in my tests seemed

[sqlalchemy] Unexpected IntegrityError when trying to add new related element

' into the Child() constructor, it still attempts to set parent_id to None with this UPDATE. What am I doing wrong? -- Ben Sizer -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from

[sqlalchemy] Re: Unexpected IntegrityError when trying to add new related element

list. It looks like the cascade=all,delete-orphan is the right thing to do for all ownership relations. -- Ben Sizer -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from

Re: [sqlalchemy] Problem with eagerload and lazy='joined'

On Jul 8, 2011, at 8:24 PM, Michael Bayer wrote: On Jul 8, 2011, at 6:17 PM, Ben Chess wrote: Hmm, bummer. We're pretty dependent on detached mode. We eagerload a bunch of things for the purposes of storing them in memcache, and things don't go well when they're not fully traversable

Re: [sqlalchemy] Problem with eagerload and lazy='joined'

On Jul 9, 2011, at 3:51 PM, Michael Bayer wrote: On Jul 9, 2011, at 5:07 PM, Ben Chess wrote: On Jul 8, 2011, at 8:24 PM, Michael Bayer wrote: OK so you're caching.Actually when I worked with caching a lot I found that I was looking for the objects to exist without their related

Re: [sqlalchemy] Problem with eagerload and lazy='joined'

, Michael Bayer mike...@zzzcomputing.com wrote: On Jul 7, 2011, at 7:04 PM, Ben Chess wrote: I've hit a problem where eagerload() fails to load in a relation of a relation when lazy='joined' is involved.  It's easiest just to show the test.  It fails in 0.7.1, and an equivalent test also fails

[sqlalchemy] type safety using sqlite

be coerced to an integer, but this doesn't fit that constraint. So, 2 questions: a) Is this expected behaviour? b) How can I catch this, ideally at the SQLAlchemy level, so that I can't accidentally store a string as an integer? -- Ben Sizer -- You received this message because you are subscribed

[sqlalchemy] Re: type safety using sqlite

Thanks very much Michael, that should be more than enough information for me to find a solution. -- Ben Sizer -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from

[sqlalchemy] Re: type safety using sqlite

Ok, this seems to do the trick for my use case, but I'd be curious to see if there's a better way or if there are things that should be fixed here. from types import IntType, LongType from sqlalchemy.exc import ArgumentError from sqlalchemy import event from sqlalchemy.orm import mapper def

[sqlalchemy] Problem with eagerload and lazy='joined'

I've hit a problem where eagerload() fails to load in a relation of a relation when lazy='joined' is involved. It's easiest just to show the test. It fails in 0.7.1, and an equivalent test also fails in 0.6.8. http://pastebin.com/ruq6SM1z Basically, A has relations to B, C, and D. C's

[sqlalchemy] Re: Slightly confusing error when session set up incorrectly

On Jun 29, 7:30 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Jun 29, 2011, at 12:24 PM, Ben Sizer wrote: OK, this happens a lot with me, if anyone can please recommend what university I should go to in order to learn to speak english correctlyHere's the sentence: It's

[sqlalchemy] Re: Slightly confusing error when session set up incorrectly

On Jun 29, 6:46 am, Michael Bayer mike...@zzzcomputing.com wrote: On Jun 28, 2011, at 9:34 PM, Ben Sizer wrote: What does the None None signify? Would it be possible to change this exception to be a bit more descriptive and a little less cryptic? eg. Include the URI that failed

[sqlalchemy] Slightly confusing error when session set up incorrectly

? or to Session.configure? or to Session's constructor? - and it's not clear why they all have to exist.) -- Ben Sizer -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from

Re: [sqlalchemy] SQLAlchemy best practise

I think the session about sessions do that explanation: http://www.sqlalchemy.org/docs/orm/session.html 2011/6/6 Liju lij...@gmail.com I'm new to SQLAlchemy and loving it. But reading all documentation online makes me wonder if there are any best practice documentation for sqlalchemy out

[sqlalchemy] Dynamic relationship

sqlalchemy manage the relationship and caching? Also, I'd like to be able to sometimes eagerly load this relationship. Obviously I can't do in with a JOIN of the original query, but is there some way to define the relationship, perhaps using a column_property, to be able to undefer()? Thanks, Ben

Re: [sqlalchemy] Dynamic relationship

- lazy=immediate or immediateload() as an option - but that won't save you on SELECT statements. On Jun 2, 2011, at 6:15 PM, Ben Chess wrote: Hi, I want to establish a relationship with an object whose key is defined inside a JSON BLOB column in the child.  Naively, I know I can do

Re: [sqlalchemy] Dynamic relationship

On Thu, Jun 2, 2011 at 5:18 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Jun 2, 2011, at 8:11 PM, Ben Chess wrote: I'm not intending for the contents of the BLOB to be readable to MySQL.  It would only be cracked open and read from within Python. Meaning Python only knows what

Re: [sqlalchemy] Dynamic relationship

Sounds far more complicated than something I'd want to take on. Thanks for your thoughts and the detailed response. Ben On Thu, Jun 2, 2011 at 6:28 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Jun 2, 2011, at 8:25 PM, Ben Chess wrote: On Thu, Jun 2, 2011 at 5:18 PM, Michael Bayer

[sqlalchemy] Why we don't have a contains_eager_all?

Hi, Just a easy question, why we don't have a contains_eager_all like we do with joinedload? By the way, I don't exactly understand why we shouldn't use the _all version always. Example (from http://www.sqlalchemy.org/docs/orm/loading.html?highlight=contains_eager#contains-eager ):

Re: [sqlalchemy] Why we don't have a contains_eager_all?

Hmm, nice, I'm still with the 0.6.7, so that's why I missed it. Thanks again for the superfast-effective answer. 2011/5/26 Michael Bayer mike...@zzzcomputing.com On May 26, 2011, at 11:02 AM, Israel Ben Guilherme Fonseca wrote: Hi, Just a easy question, why we don't have

[sqlalchemy] Subselect that references the outer select

Hi, I'm trying to construct a query that have a subquery, and that subquery references the outer query attribute. It's almost working actually: Intended select: select * from curso c join matricula m on c.id_curso = m.id_curso where m.id_aluno = 1

[sqlalchemy] Re: Subselect that references the outer select

() It stills give-me two matricula in the from clause. The == Matricula.id_curso, is still enforcing the another matricula in the query. 2011/5/26 Israel Ben Guilherme Fonseca israel@gmail.com Hi, I'm trying to construct a query that have a subquery, and that subquery references the outer query

Re: [sqlalchemy] Re: Subselect that references the outer select

clause, it acts like a table. Use the .c. attribute. On May 26, 2011, at 3:34 PM, Israel Ben Guilherme Fonseca wrote: I did a bit more of digging in the docs and found the 'select_from' method. I thought that it would force the FROM statement to use ONLY what I pass as argument. But it didn't

Re: [sqlalchemy] Re: Subselect that references the outer select

Sweet, it's working. :) Now let's wait for the 0.8. 2011/5/26 Michael Bayer mike...@zzzcomputing.com On May 26, 2011, at 5:03 PM, Israel Ben Guilherme Fonseca wrote: I saw that, but I'm not using a subquery in the from clause. Maybe I wasn't clear enough. Example: outeruser = aliased

[sqlalchemy] Declarative: Joined Inheritance + Two Tables To One Object

I have the following: class Person(Base): __tablename__ = 'pessoa' id = Column(id_person), Integer, primary_key = True) name = Column(String) class Teacher(Person): __tablename__ = 'teacher' id = Column(id_teacher, Integer, ForeignKey(Person.id), primary_key=True) info =

[sqlalchemy] Re: Declarative: Joined Inheritance + Two Tables To One Object

is it being prohibited? Issued with advanced cases, or just to avoid hard-to-debug errors? 2011/5/23 Israel Ben Guilherme Fonseca israel@gmail.com I have the following: class Person(Base): __tablename__ = 'pessoa' id = Column(id_person), Integer, primary_key = True) name = Column

Re: [sqlalchemy] SQLAlchemy 0.7.0 Released

May the force be with SQLAlchemy. :) 2011/5/20 Michael Bayer mike...@zzzcomputing.com The SQLAlchemy project is pleased to announce version 0.7.0 of SQLAlchemy, the first production release within the 0.7.0 series. 0.7 represents the past year's worth of development, streamlining APIs,

[sqlalchemy] Queries issued with 'passive_deletes'

I didn't get why issuing selects for the children objects when passive_deletes=False. Wouldn't be better just issue direct deletes, and maybe using subselects in the where clause of these deletes (for nested associations) when approriate? It would solve the overhead problem of the selecting large

Re: [sqlalchemy] Queries issued with 'passive_deletes'

Well, now it does make sense. :) Thanks for the explanation. 2011/5/9 Michael Bayer mike...@zzzcomputing.com On May 9, 2011, at 7:57 AM, Israel Ben Guilherme Fonseca wrote: I didn't get why issuing selects for the children objects when passive_deletes=False. Wouldn't be better just issue

[sqlalchemy] Two Objects, One Table and the inverse

Hi, Is it possible to break a table in two Python objects? Ex: Python objects: class Person: name = Column(String) class Address: street = Column(String) city = Column(String) Table: table Person name varchar city varchar street varchar How can i make the

Re: [sqlalchemy] Two Objects, One Table and the inverse

Michael Bayer mike...@zzzcomputing.com On Apr 5, 2011, at 9:06 AM, Israel Ben Guilherme Fonseca wrote: Hi, Is it possible to break a table in two Python objects? Ex: Python objects: class Person: name = Column(String) class Address: street = Column(String

Re: [sqlalchemy] Session: close(), remove(), expire_all() and expunge_all()

Thank you very much for the answers. No doubts for now. 2011/3/18 Michael Bayer mike...@zzzcomputing.com On Mar 18, 2011, at 2:55 PM, Israel Ben Guilherme Fonseca wrote: Hi everybody, I'm new with SQLAlchemy and I'm trying to understand better the Session object. First of all, why

[sqlalchemy] Session: close(), remove(), expire_all() and expunge_all()

Hi everybody, I'm new with SQLAlchemy and I'm trying to understand better the Session object. First of all, why the expire_all() exists? Shouldn't it be always better to expunge_all() instead? If it is expired, at the use of the instance another query would be issued to reattach it anyway, so

Re: [sqlalchemy] another problem with complex join

Ok, thanks. I have never seen this pattern in use. If the import is done inside a function, usually there are no problems with circular module import. Its a performance gain as the second time you hit that function you don't have to import it again. -- You received this message because

[sqlalchemy] Re: Error due to MySQL-Python at 1.2.3?

Thanks a lot~ I should have added it earlier. Ben -- Ben Cheng | Software Architect | Oursky Ltd. | M +852 9381-6083 | www.bencheng.net On Sun, Mar 8, 2009 at 1:25 AM, Michael Bayer mike...@zzzcomputing.com wrote: nevermind i added it myself https://sourceforge.net/tracker/index.php?func

[sqlalchemy] Error due to MySQL-Python at 1.2.3?

sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1146, Table 'voters.forms' doesn't exist) 'DESCRIBE `forms`' () But when I roll-back to MySQL-Python 1.2.1, the error gones. Any thought? Best, Ben --~--~-~--~~~---~--~~ You received this message because you

[sqlalchemy] Filtering by an attribute of a related class (abusing generative filters...)

(there are two, 'rFooPrecedes' and 'rFooFollows', which are Foo-Foo links via the FooPrecedence mapped class; here I'd want to filter based on the titles of the attached Foos, not on the titles of the FooPrecedence entries that link them). Cheers, -- Ben

[sqlalchemy] Re: Filtering by an attribute of a related class (abusing generative filters...)

class. But I'm fairly sure any sequence of calls that involve methods from someone else's code which begin with an underscore counts as bad form ;) is there a more direct way of getting this? Cheers, -- Ben --~--~-~--~~~---~--~~ You received this message because

[sqlalchemy] Re: Too many database connections.

options, but I never needed to do this before when using Postgres. - Ben --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com

[sqlalchemy] Re: Too many database connections.

() as a workaround for now. if problems persist, let me know; theres some other things we can look at. SA trunk works great, less real postgres connections used, and no overflow/connection problems so far! - Ben --~--~-~--~~~---~--~~ You received this message because

[sqlalchemy] probably unsupported type for date field

. I'm running Python 2.5 on Windows with SQLAlchemy 0.3.7. Any ideas what the problem might be? Thanks Ben - Traceback (most recent call last): File C:\cygwin\home\barwork\test.py, line 20, in module session.flush() File build\bdist.win32\egg\sqlalchemy\orm