Sorry because i'm a bit late ( work deadlines are struggling my
time! :) ).
I've made some different configurations and schema definitions... and
i've noticed that it never updates a row if i set the datetime field
as PK ( never! even if i set it as the only PK .. ). If i set
composite PKs excluding any datetime column everything works fine ( it
also works if i set a datetime as PK at the database side and
excluding it at the schema on sqlalchemy side.. ). Sorry about the
mess with the PKs between the former examples but i was only trying to
say that changing the schema results that everything works fine...
Here's a little piece of code just as an example to start playing...
( it works for me.., but if i include start as PK it "crashes")
import sqlalchemy as sa
import datetime, time
from sqlalchemy.orm import sessionmaker
sa_engine=sa.create_engine("mssql://sa:[EMAIL PROTECTED]/siaDB_BR",
echo=True)
metadata = sa.MetaData(sa_engine)
Session = sessionmaker(bind=sa_engine, autoflush=True,
transactional=True)
sa_session = Session()
jobs = sa.Table('jobs', metadata,
sa.Column('identifier', sa.Numeric(18),
primary_key=True),
sa.Column('section', sa.VARCHAR(20)),
sa.Column("start",sa.DateTime),
sa.Column("stop",sa.DateTime),
sa.Column("station", sa.VARCHAR(20),
primary_key=True),
autoload=False)#ok
class Job(object):
def __init__(self, identifier, start, station="TCHUKI"):
self.identifier, self.start, self.station=identifier, start,
station
sa.orm.mapper(Job, jobs)
j = Job(22, datetime.datetime.now())
sa_session.save(j)
sa_session.commit()
sa_session.clear()
time.sleep(1)
j1=sa_session.query(Job).all()[0]
j1.stop=datetime.datetime.now()
sa_session.save_or_update(j1)
sa_session.commit()
On 12 Dic, 17:54, "Rick Morrison" <[EMAIL PROTECTED]> wrote:
> Hey Fabio, would you please post a full non-working copy with the new schema
> and all the PKs that you want set up? There are a few too many variants in
> this thread to see what's going on now. Your earlier versions didn't include
> 'station' as a PK, but did include 'start', while this one's the opposite.
--~--~---------~--~----~------------~-------~--~----~
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 this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
