How I can compile statement with this 2 objects:
st = """ SELECT "user".id AS user_id, "user".username AS
user_username, "user".email AS user_email, "user".password AS
user_password, "user".bd AS user_bd, "user".first_name AS
user_first_name, "user".last_name AS user_last_name,
"user".middle_name AS user_middle_name, "user".is_active_flag AS
user_is_active_flag, "user".time_create AS user_time_create,
"user".time_last_activity AS user_time_last_activity,
"user".subscribe_news AS user_subscribe_news, "user".is_deleted AS
user_is_deleted, "user".is_banned AS user_is_banned
FROM "user"
WHERE "user".id != "user".id AND "user".time_last_activity > %
(time_last_activity_1)s ORDER BY "user".time_last_activity DESC
LIMIT %(param_1)s """
params = {'time_last_activity_1': datetime.datetime(2011, 10, 21, 17,
36, 21, 577026), 'param_1': 3}
If I do
result = st % params
then I get not valid sql:
' SELECT "user".id AS user_id, "user".username AS user_username,
"user".email AS user_email, "user".password AS user_password,
"user".bd AS user_bd, "user".first_name AS user_first_name,
"user".last_name AS user_last_name, "user".middle_name AS
user_middle_name, "user".is_active_flag AS user_is_active_flag,
"user".time_create AS user_time_create, "user".time_last_activity AS
user_time_last_activity, "user".subscribe_news AS user_subscribe_news,
"user".is_deleted AS user_is_deleted, "user".is_banned AS
user_is_banned\nFROM "user"\nWHERE "user".id != "user".id AND
"user".time_last_activity > 2011-10-21 17:36:21.577026 ORDER BY
"user".time_last_activity DESC\n LIMIT 3 '
because datetime must be '2011-10-21 17:36:21.577026'
Thanks.
--
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.
