take the following code with sqlite 3.4 on cygwin, and i get strftime
error on insert, any ideas?

Python 2.5.1 (r251:54863, May 18 2007, 16:56:43)
[GCC 3.4.4 (cygming special, gdc 0.12, using dmd 0.125)] on cygwin
Type "help", "copyright", "credits" or "license" for more information.

from elixir import *
from sqlalchemy.types import *
from sqlalchemy import func, DynamicMetaData

metadata.connect('sqlite:///mytest.db')

class TestC(Entity):
    with_fields(
        name    = Field(Unicode(50), nullable=False),
        created = Field(TIMESTAMP(timezone=True),
default=func.datetime('now', 'localtime'))
    )

create_all()

z = TestC(name="mytestname")

objectstore.flush()

== error ==

Traceback (most recent call last):
  File "mytest.py", line 17, in <module>
    objectstore.flush()
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/orm/session.py", line
302, in flush
    self.uow.flush(self, objects)
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/orm/unitofwork.py", line
210, in flush
    flush_context.execute()
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/orm/unitofwork.py", line
400, in execute
    UOWExecutor().execute(self, head)
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/orm/unitofwork.py", line
1018, in execute
    self.execute_save_steps(trans, task)
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/orm/unitofwork.py", line
1032, in execute_save_steps
    self.save_objects(trans, task)
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/orm/unitofwork.py", line
1023, in save_objects
    task.mapper.save_obj(task.polymorphic_tosave_objects, trans)
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/orm/mapper.py", line
1189, in save_obj
    c = connection.execute(statement, params)
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/engine/base.py", line
520, in execute
    return Connection.executors[c](self, object, *multiparams,
**params)
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/engine/base.py", line
560, in execute_clauseelement
    return self.execute_compiled(elem.compile(dialect=self.dialect,
parameters=p                        aram), *multiparams, **params)
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/engine/base.py", line
570, in execute_compiled
    context.pre_exec()
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/engine/default.py", line
201, in pre_exec
    self.parameters =
self._encode_param_keys(self.dialect.convert_compiled_para
ms(self.compiled_parameters))
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/engine/default.py", line
120, in convert_compiled_params
    parameters = parameters.get_raw_list()
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/sql.py", line 858, in
get_raw_list
    return [self.get_processed(key) for key in self.positional]
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/sql.py", line 839, in
get_processed
    return bind.typeprocess(value, self.dialect)
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/sql.py", line 1841, in
typeprocess
    return self.type.dialect_impl(dialect).convert_bind_param(value,
dialect)
  File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.3.9dev_r2844-
py2.5.egg/sql                        alchemy/databases/sqlite.py",
line 38, in convert_bind_param
    return value.strftime(self.__format__)
AttributeError: 'unicode' object has no attribute 'strftime'


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to