Re: [Sqlalchemy-users] DateTime as primary key failure

Thu, 04 May 2006 13:31:39 -0700

column types were not being bound in the "WHERE" clause of the UPDATE/DELETE generated by mapper, fixed in rev 1389.

On May 4, 2006, at 2:25 PM, Dimi Shahbaz wrote:

import mx.DateTime as mxDateTime

from sqlalchemy import *


e = create_engine("postgres://database=test", echo=True)


test = Table("test", e,

  Column("id", String, primary_key=True),

  Column("date", DateTime, primary_key=True),

  Column("something", String),

)

class Test(object):

  pass

Test.mapper = mapper(Test, test)


try:

  test.drop()

except:

  pass

test.create()


date = mxDateTime.now()


t = Test()

t.id = '1'

t.date = date

t.something = 'hello'


objectstore.flush()

del t


t = Test.mapper.get_by(id='1', date=date)

t.something = 'hi'

objectstore.flush() # fails


Reply via email to