[sqlalchemy] Re: PostgreSQL's TIME WITH TIME ZONE issue

2014-11-13 Thread Hyunjun Kim
Hi. It seems the problem was caused from psycopg2 implementation. - https://github.com/psycopg/psycopg2/blob/master/psycopg/adapter_datetime.c#L63-L76 Thank you. 2014년 11월 13일 목요일 오후 4시 53분 22초 UTC+9, Hyunjun Kim 님의 말: Greetings, I'm trying to use PostgreSQL's TIME WITH TIME ZONE type

[sqlalchemy] PostgreSQL's TIME WITH TIME ZONE issue

2014-11-12 Thread Hyunjun Kim
Greetings, I'm trying to use PostgreSQL's TIME WITH TIME ZONE type. I've used SQLAlchemy's generic type Time(timezone=True) and it was successful that the schema was reflected to TIME WITH TIME ZONE(timetz) when I use alembic or metadata.create_all(). The problem is, it seems that the

Re: [sqlalchemy] AttributeError: 'ColumnProperty' object has no attribute 'strategy'

2013-10-05 Thread Hyunjun Kim
other stuffs. how can i fix this? 김현준 드림 -- Hyunjun Kim StyleShare Inc. | Software Engineer +82 10-8597-5340 Sent with Sparrow (http://www.sparrowmailapp.com/?sig) On 2013년 10월 4일 Friday at 오후 10:59, Michael Bayer wrote: this is definitely not related to any issue from 2007. See what

Re: [sqlalchemy] AttributeError: 'ColumnProperty' object has no attribute 'strategy'

2013-10-05 Thread Hyunjun Kim
table via module m, and it twisted all when sqlalchemy configured all classes. thank you for help!! On 2013년 10월 6일 Sunday at 오후 1:22, Hyunjun Kim wrote: oh sorry. I thought the subject duplication shouldn't be in the mailing list. I called configure_mappers() right before every query

[sqlalchemy] AttributeError: 'ColumnProperty' object has no attribute 'strategy'

2013-10-04 Thread kim
T_T Hi, I am using SQLAlchemy 0.8.2 with PostgreSQL and having exactly same problem. I have a lot of table classes inherited declarative base and only some of classes raise errors. (https://gist.github.com/yoloseem/d1c9b0f8d3cef6c196e4 ) Actually, even for same buggy classes, errors are

[sqlalchemy] What is declarative_base() exactly?

2013-09-23 Thread Edward Kim
Hi all, I have a really short experience of python so it can be really stupid question. I tried to understanding about declarative_base(). Example below: Base = declarative_base() class Bus(Base): __tablename__ = 'bus' In my understanding, That python code look like function

Re: [sqlalchemy] What is declarative_base() exactly?

2013-09-23 Thread Edward Kim
Oh, I see! It is return class literally. Thanks for your code. On Monday, 23 September 2013 23:28:11 UTC+10, Klauss wrote: On Mon, Sep 23, 2013 at 10:22 AM, Edward Kim onward...@gmail.comjavascript: wrote: Base = declarative_base() Base class 'sqlalchemy.ext.declarative.api.Base

Re: [sqlalchemy] How can I tell SA that a mutable attribute has changed?

2012-02-24 Thread Tate Kim
Hi, Chris. Have you checked http://docs.sqlalchemy.org/en/latest/orm/extensions/mutable.html ? Regards, Tate -Original Message- From: Chris Withers ch...@simplistix.co.uk Sender: sqlalchemy@googlegroups.com Date: Fri, 24 Feb 2012 10:49:46 To: sqlalchemy@googlegroups.com Reply-To:

Re: [sqlalchemy] on delete cascade

2012-02-24 Thread Tate Kim
Hi, jo. At first, try with cascade option 'all, delete' (note that dropped 'delete-orphan'). Second, I've ever been your situation before, maybe -Original Message- From: jo jose.soa...@sferacarta.com Sender: sqlalchemy@googlegroups.com Date: Fri, 24 Feb 2012 11:41:48 To:

Re: [sqlalchemy] on delete cascade

2012-02-24 Thread Tate Kim
: Tate Kim insight...@gmail.com Date: Fri, 24 Feb 2012 17:56:44 To: sqlalchemy@googlegroups.com Reply-To: insight...@gmail.com Subject: Re: [sqlalchemy] on delete cascade Hi, jo. At first, try with cascade option 'all, delete' (note that dropped 'delete-orphan'). Second, I've ever been your situation

Re: Bug in old-style mutable type? (was Re: [sqlalchemy] How can I tell SA that a mutable attribute has changed?)

2012-02-24 Thread Tate Kim
Opps I didn't know that subject has been changed. FYI, in 0.6.x, I used to play with class JSONType(MutableType, TypeDecorator) pretty well. But 0.7.x, I'm not sure it works as well as 0.6.x... Regards, Tate -Original Message- From: Chris Withers ch...@simplistix.co.uk Sender:

Re: [sqlalchemy] Overload Query Object

2012-01-31 Thread Tate Kim
Hi, Have you checked the __iter__ method ? -Original Message- From: Christian Démolis christiandemo...@gmail.com Sender: sqlalchemy@googlegroups.com Date: Tue, 31 Jan 2012 17:39:54 To: sqlalchemysqlalchemy@googlegroups.com Reply-To: sqlalchemy@googlegroups.com Subject: [sqlalchemy]

Re: [sqlalchemy] Passing additional arguments to event listeners ?

2011-12-01 Thread Tate Kim
How about functools.partial ? As far as I know, functools.partial will simply do this. Usually, I import this when I need to make an argument-less function equip extra arguments. Best regards, Tate -Original Message- From: Michael Bayer mike...@zzzcomputing.com Sender:

Re: [sqlalchemy] Passing additional arguments to event listeners ?

2011-12-01 Thread Tate Kim
] On Behalf Of Tate Kim Sent: Friday, 2 December 2011 12:33 PM To: sqlalchemy@googlegroups.com Subject: Re: [sqlalchemy] Passing additional arguments to event listeners ? How about functools.partial ? As far as I know, functools.partial will simply do this. Usually, I import this when I need to make

Re: [sqlalchemy] implementation of periodic task or time triggered update

2011-11-30 Thread Tate Kim
] implementation of periodic task or time triggered update On Nov 29, 2011, at 3:51 AM, Tate Kim wrote: Hello everyone, I think this question may be for the database side, but i 'd like to post here if you don't mind. I have a certain periodic task that bult updates a couple

[sqlalchemy] implementation of periodic task or time triggered update

2011-11-29 Thread Tate Kim
Hello everyone, I think this question may be for the database side, but i 'd like to post here if you don't mind. I have a certain periodic task that bult updates a couple of columns has expired in License table. ( It doesn't matter what it is. ) In this situation, time accuracy was really

[sqlalchemy] how can i detect fields that cause an exception ?

2011-11-01 Thread Tate Kim
hi, I'm using sqlalchemy 0.7.3 and postgresql 9 with psycopg2 and python 2.7. When I put wrong type of data(ex: 'some string' into Integer field), I get DataError exception in commit phase. This is so expected result, but i think it would be great to get more specific data which can tell

Re: [sqlalchemy] how can i detect fields that cause an exception ?

2011-11-01 Thread Tate Kim
but that exception would also occur in a context where the column name is not present - as types can be used in any arbitrary expression. On Nov 1, 2011, at 2:42 AM, Tate Kim wrote: hi, I'm using sqlalchemy 0.7.3 and postgresql 9 with psycopg2 and python 2.7. When I put wrong type of data(ex: 'some