Client could not read SqlAlchemy object which contains TIMESTAMP column.

[一首诗]

Will get an exception:

    datetime.datetime' object has no attribute '_sa_instance_state'

Remove the TIMESTAMP column below in the SA object definition, will eliminate the problem.

   last_activity_time = Column(TIMESTAMP, nullable=False, server_default="2001-01-01 01:01:01")

Flex client doesn't have this problem.

I found this on version 0.4.2

--
look to the things around you,the immediate world around you, if you are alive,it will mean something to you ——Paul Strand

_______________________________________________
PyAMF users mailing list - users@...
http://lists.pyamf.org/mailman/listinfo/users

[lists-144]

Hi,

I guess you mean something like:

last_activity_time = Column('last_activity_time', TIMESTAMP, nullable=False, server_default="2001-01-01 01:01:01")

I opened a ticket [1] to add a timestamp column in the sqlalchemy adapter example, and tested it with the patch for the sample and everything worked fine with 0.4.2 here. Can you open a ticket with a sample that reproduces the error? Or are you saying its a Python AMF client issue cause I haven't tested that.

[1] http://pyamf.org/ticket/630

Cheers,

Thijs

On 24 Jul 2009, at 03:42, Peter Cai wrote:

Will get an exception:

    datetime.datetime' object has no attribute '_sa_instance_state'

Remove the TIMESTAMP column below in the SA object definition, will eliminate the problem.

   last_activity_time = Column(TIMESTAMP, nullable=False, server_default="2001-01-01 01:01:01")

Flex client doesn't have this problem.

I found this on version 0.4.2

--
look to the things around you,the immediate world around you, if you are alive,it will mean something to you ——Paul Strand

_______________________________________________
PyAMF users mailing list - users@...
http://lists.pyamf.org/mailman/listinfo/users

_______________________________________________
PyAMF users mailing list - users@...
http://lists.pyamf.org/mailman/listinfo/users

[一首诗]

Yeah, I am saying that this is a Python AMF client problem.  I will write a little test code and attach it to the ticket.

On Sun, Jul 26, 2009 at 4:02 PM, Thijs Triemstra | Collab <lists@...> wrote:

Hi,

I guess you mean something like:

last_activity_time = Column('last_activity_time', TIMESTAMP, nullable=False, server_default="2001-01-01 01:01:01")

I opened a ticket [1] to add a timestamp column in the sqlalchemy adapter example, and tested it with the patch for the sample and everything worked fine with 0.4.2 here. Can you open a ticket with a sample that reproduces the error? Or are you saying its a Python AMF client issue cause I haven't tested that.

[1] http://pyamf.org/ticket/630

Cheers,

Thijs

On 24 Jul 2009, at 03:42, Peter Cai wrote:

Will get an exception:

    datetime.datetime' object has no attribute '_sa_instance_state'

Remove the TIMESTAMP column below in the SA object definition, will eliminate the problem.

   last_activity_time = Column(TIMESTAMP, nullable=False, server_default="2001-01-01 01:01:01")

Flex client doesn't have this problem.

I found this on version 0.4.2

--
look to the things around you,the immediate world around you, if you are alive,it will mean something to you ——Paul Strand

_______________________________________________
PyAMF users mailing list - users@...
http://lists.pyamf.org/mailman/listinfo/users

_______________________________________________
PyAMF users mailing list - users@...
http://lists.pyamf.org/mailman/listinfo/users

--
look to the things around you,the immediate world around you, if you are alive,it will mean something to you ——Paul Strand

_______________________________________________
PyAMF users mailing list - users@...
http://lists.pyamf.org/mailman/listinfo/users

[Nick Joyce]

Did this ever happen? It would be good to get this in for the pending 0.5 release.

Thanks!

Nick

On 26 Jul 2009, at 20:54, Peter Cai wrote:

Yeah, I am saying that this is a Python AMF client problem.  I will write a little test code and attach it to the ticket.

On Sun, Jul 26, 2009 at 4:02 PM, Thijs Triemstra | Collab <lists@...> wrote:

Hi,

I guess you mean something like:

last_activity_time = Column('last_activity_time', TIMESTAMP, nullable=False, server_default="2001-01-01 01:01:01")

I opened a ticket [1] to add a timestamp column in the sqlalchemy adapter example, and tested it with the patch for the sample and everything worked fine with 0.4.2 here. Can you open a ticket with a sample that reproduces the error? Or are you saying its a Python AMF client issue cause I haven't tested that.

[1] http://pyamf.org/ticket/630

Cheers,

Thijs

On 24 Jul 2009, at 03:42, Peter Cai wrote:

Will get an exception:

    datetime.datetime' object has no attribute '_sa_instance_state'

Remove the TIMESTAMP column below in the SA object definition, will eliminate the problem.

   last_activity_time = Column(TIMESTAMP, nullable=False, server_default="2001-01-01 01:01:01")

Flex client doesn't have this problem.

I found this on version 0.4.2

--
look to the things around you,the immediate world around you, if you are alive,it will mean something to you ——Paul Strand

_______________________________________________
PyAMF users mailing list - users@...
http://lists.pyamf.org/mailman/listinfo/users

_______________________________________________
PyAMF users mailing list - users@...
http://lists.pyamf.org/mailman/listinfo/users

--
look to the things around you,the immediate world around you, if you are alive,it will mean something to you ——Paul Strand

_______________________________________________
PyAMF users mailing list - users@...
http://lists.pyamf.org/mailman/listinfo/users

_______________________________________________
PyAMF users mailing list - users@...
http://lists.pyamf.org/mailman/listinfo/users