Hi Michael,
I'm using a manual workaround, so this is only out of curiosity now.
Cf yr point 1:
1. Merging MoviesAndDirectorsAndGenres, with no primary key identifiers set,
sets it as pending in the Session. This now indicates that an INSERT into
all three tables will take place during
On Jul 22, 2010, at 9:02 AM, Harry Percival wrote:
Hi Michael,
I'm using a manual workaround, so this is only out of curiosity now.
Cf yr point 1:
1. Merging MoviesAndDirectorsAndGenres, with no primary key identifiers set,
sets it as pending in the Session. This now indicates that an
I'm clear on that. I'm only using session.add to do an insert when I
know i definitely want to. But you'll see I used session.merge on the
composite object, yet it still attempts to do an insert for rows that
already exist in its constituent tables...
On Mon, Jul 19, 2010 at 5:19 PM, Michael
On Jul 20, 2010, at 6:05 AM, Harry Percival wrote:
I'm clear on that. I'm only using session.add to do an insert when I
know i definitely want to. But you'll see I used session.merge on the
composite object, yet it still attempts to do an insert for rows that
already exist in its
On Jul 20, 2010, at 11:51 AM, Harry Percival wrote:
attached. feel free to ignore the 'sqlite' folder, which is only
needed for ironpython. the error definitely occurs in cpython 2.6.3.
1. Merging MoviesAndDirectorsAndGenres, with no primary key identifiers set,
sets it as pending in the
On Jul 19, 2010, at 10:24 AM, Harry Percival wrote:
OK, so I will treat any classes mapped to a join of multiple tables as
being a read-only API, and manually manage the write-API using
relationship().
It doesn't look like I can define a relationship from the composite
mapped class to
Michael, thanks, as ever, for your help.
So, I think I've managed to specify the relationships:
j = join(movies_table,md_table).join(directors_table).join(genres_table)
js = j.select(use_labels=True).alias('mdg')
r0 = relationship(Movies,
On Jul 19, 2010, at 12:04 PM, Harry Percival wrote:
Michael, thanks, as ever, for your help.
So, I think I've managed to specify the relationships:
j = join(movies_table,md_table).join(directors_table).join(genres_table)
js = j.select(use_labels=True).alias('mdg')
r0 =
On Jul 15, 2010, at 5:11 PM, Harry Percival wrote:
thanks Michael. I really appreciate your help.
How should use .merge()? I've tried both:
another_new = MoviesAndDirectorsAndGenres() #init another_new as blank row
another_new = session.merge(new) #attempt to merge with my 'new'
object
A new problem, which seems to occur in both IronPython and normal Python:
I have a database with tables for movies, directors, genres (and a
bridging table movie_directors)
I have a class mapped to a join of all three of the above
j =
On Jul 15, 2010, at 2:52 PM, Harry Percival wrote:
A new problem, which seems to occur in both IronPython and normal Python:
I have a database with tables for movies, directors, genres (and a
bridging table movie_directors)
I have a class mapped to a join of all three of the above
j =
thanks Michael. I really appreciate your help.
How should use .merge()? I've tried both:
another_new = MoviesAndDirectorsAndGenres() #init another_new as blank row
another_new = session.merge(new) #attempt to merge with my 'new'
object that has desired attributes
and
new =
12 matches
Mail list logo