Re: [sqlalchemy] Doesnt execute any thing at new pc

exists. Your "username" may have changed. -- Richard Damon -- 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

Re: [sqlalchemy] Many-to-many cascade delete

0458f55e4n%40googlegroups.com <https://groups.google.com/d/msgid/sqlalchemy/b5e4faee-5cd6-4b9b-936b-0d80458f55e4n%40googlegroups.com?utm_medium=email_source=footer>. -- Richard Damon -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post exam

Re: [sqlalchemy] Changing Type of an ORM record

On 5/2/21 6:34 PM, Mike Bayer wrote: > > > On Sun, May 2, 2021, at 4:44 PM, Richard Damon wrote: >> I asked this a bit ago, but never got an answer, so trying again wording >> a bit different to see if I can get help. > > sorry if this got missed. > >> >>

[sqlalchemy] Changing Type of an ORM record

the value of the type field in the Employee table with an UPDATE. The question is, is there a more "ORM' way to do this? -- Richard Damon -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Mi

[sqlalchemy] Upgrading an ORM object from a base class to a derived class.

to actually do some of the work? I don't think I can just create a new derived object with the original primary key, as that will get rejected as a duplicate key, not replace the object. -- Richard Damon -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http

Re: [sqlalchemy] How to refer to columns whose names begin with a number when autoloading?

dents", metadata, autoload=True, > autoload_with=engine) > > @property > def first_period(self): > return self.1st_period Have you tried using getattr? That might work (if SQLAlchemy isn't doing something to quote the name to make a valid version. getattr(self, '1st_period')

Re: [sqlalchemy] Using Abstract Base Classes with ORM Table Classes

eclarative/api.html?highlight=instrument_declarative#sqlalchemy.ext.declarative.instrument_declarative> > > > which can be turned into an equivalent decorator. > > that said I have not yet experimented with mapping classes that are > also extending ABCMeta so I'm not sure if there are other issues. > > >

[sqlalchemy] Using Abstract Base Classes with ORM Table Classes

to work, or am I missing some other trick? Side question, when doing this sort of mix-in, does the order of the mix-in and declarative_base matter, or is there a real preference? -- Richard Damon -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org

Re: [sqlalchemy] ORM and objects with properties that need conversion to write to database

Thank you, that looks like what I was looking for but didn't know what it was called. On 10/8/20 4:55 AM, Simon King wrote: > On Thu, Oct 8, 2020 at 3:38 AM Richard Damon wrote: >> I am working on a app using SQLAlchemy's ORM layer to interface to the >> database, but I am runnin

[sqlalchemy] ORM and objects with properties that need conversion to write to database

representation, and I see an option to add a 'reconstructor' to convert a value read from the database into an object. Is there a similar way that when writing the object, to indicate how to convert the object into a format that can be put into the database? -- Richard Damon -- SQLAlchemy

Re: [sqlalchemy] ORM AmbiguousForeignKeysErro

r and caused a more complicated one) > I think you need to post the basics of the code. See the link below about making it a MCVE There is obviously something you aren't describing, or we need to see to point to you what you are missing. -- Richard Damon -- SQLAlchemy - The Python SQL Too

Re: [sqlalchemy] ORM AmbiguousForeignKeysErro

I just have a foreign key to that table? It's a simple many to one > > > @Richard: you can use @declared_attr.cascading to cascade the > mapper_args to your child classes. > On Friday, August 28, 2020 at 2:56:02 PM UTC-4 Richard Damon wrote: > > Thank you, so that go into

Re: [sqlalchemy] ORM 3 level hieracrchy

ok. On 9/3/20 10:25 AM, Mike Bayer wrote: > yup that was the idea > > > On Thu, Sep 3, 2020, at 10:24 AM, Richard Damon wrote: >> I have a large number (around a dozen or more, and likely to grow) of >> derived classes, so I was hoping to cut down repetition with the >>

Re: [sqlalchemy] ORM 3 level hieracrchy

class but this depends on what > you're doing. > > > > On Thu, Sep 3, 2020, at 7:24 AM, Richard Damon wrote: >> I've tried taking my code and changing the ForeignKey to be to Node, and >> that doesn't change the Warning. >> Is the problem trying to DRY with the @declare

Re: [sqlalchemy] ORM 3 level hieracrchy

ode_id = Column(Integer, ForeignKey("Property.node_id"), > primary_key=True) > >     __mapper_args__ = { >     "polymorphic_identity": "Name", >     "inherit_condition": node_id == Property.node_id, >     } > > > > On Wed, Sep 2, 2020,

Re: [sqlalchemy] ORM 3 level hieracrchy

://docs.sqlalchemy.org/en/13/faq/ormconfiguration.html#i-m-getting-a-warning-or-error-about-implicitly-combining-column-x-under-attribute-y > > for joined table inheritance, where Name(Node) -> node_id are FK -> > PK, the warning isn't emitted.  so please share the mapping if it is

[sqlalchemy] ORM 3 level hieracrchy

, it is just where it hits the 3rd level that it seems to want something explicit. -- Richard Damon -- 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

Re: [sqlalchemy] ORM AmbiguousForeignKeysErro

gt; > class Foo(...): >    __mapper_args__ = { >   "inherit_condition": node_id == Node.node_id >    } > -- Richard Damon -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Compl

[sqlalchemy] ORM AmbiguousForeignKeysErro

s to Node to push this into the subclasses? Would I use a @declared_attr, which would need to check if the type was Node since it is different? (Background, long time programmer, but somewhat new to python, looking to learn how with reasons, not just rote recipes to follow) -- Richard Damon

Re: [sqlalchemy] Re: ArgumentError: Only one Column may be marked autoincrement=True, found both id and id.` when I run the following insert

into the table_args for the table (but that loses the column object) -- Richard Damon -- 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

Re: [sqlalchemy] Re: ArgumentError: Only one Column may be marked autoincrement=True, found both id and id.` when I run the following insert

, as that would cause issues, but in an explicit scope like a class it works. -- Richard Damon -- 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://st

Re: [sqlalchemy] Attaching a second database to a connection

/20 12:46 AM, Mike Bayer wrote: > > > On Mon, Jul 6, 2020, at 11:19 PM, Richard Damon wrote: >> SQLite allows a program to attach multiple databases to a single >> connection, and you are able to reference tables in these additional >> databases with things like schema.t

[sqlalchemy] Attaching a second database to a connection

me do a lot of the work down in the database engine. I also have found being able to bind different sets of tables into different engines, but in my case the database will have the same set of tables, so this doesn't look to work. -- Richard Damon -- SQLAlchemy - The Python SQL Toolkit and

Re: [sqlalchemy] Getting SQLite INTEGER PRIMARY KEY for a column

't an alias shows it following the inserted data, so I guess it is becoming the named alias for the ROWID. I think I came across a different section wording that restriction that wasn't as clear about it, or it was long enough ago that they have updated that wording to be clearer. -- Richard Damo

[sqlalchemy] Getting SQLite INTEGER PRIMARY KEY for a column

for the ROWID. I can't seem to find anything documented to do to make this happen. I would think this would be a commonly wanted optimization. Is there something I can do to get this? I would like to be able to use the ORM. -- Richard Damon -- SQLAlchemy - The Python SQL Toolkit and Object Relat

Re: [sqlalchemy] Handling multiple very similar tables

be more or less current: > > https://github.com/sqlalchemy/sqlalchemy/wiki/EntityName > > note the second example that shows declarative with a mixin, and shows > how you can use the type() function to generate new classes > dynamically.   Creating new classes in Python is quite o

[sqlalchemy] Handling multiple very similar tables

, or the decorator could just duck type the needed hooks into the class. -- Richard Damon -- 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

Re: [sqlalchemy] SQLAlchemy Access to Native Bulk Loaders

ementation more DB independent. > > Anyhow, thanks again for your note and your work on SQLAlchemy. I > appreciate it. > > Ben I will admit that wasn't a command I was familiar with, but being DB Specific it would be something I tend to try to minimize the use of. -- Richard D

Re: [sqlalchemy] SQLAlchemy Access to Native Bulk Loaders

ture, but that is NOT part of the base SQL language. -- Richard Damon -- 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

Re: [sqlalchemy] Bidirectional many-to-many without foreign key

be a violation of the normal form, and makes operations for creating these relationships very complicated. -- Richard Damon THis -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete