本文整理汇总了Python中models.DAO.DAO类的典型用法代码示例。如果您正苦于以下问题：Python DAO类的具体用法？Python DAO怎么用？Python DAO使用的例子？那么, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了DAO类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: update_contribution_request_count
def update_contribution_request_count(tale_id, value):
DAO.update(
'''
UPDATE anaddventure.tale
SET tale_contribution_request_count = tale_contribution_request_count + (%s)
WHERE tale_id = (%s)
''',
(value, tale_id)
)示例2: update_follow_count
def update_follow_count(tale_id, value):
DAO.update(
'''
UPDATE anaddventure.tale
SET tale_follow_count = tale_follow_count + (%s)
WHERE tale_id = (%s)
''',
(value, tale_id)
)示例3: update_all
def update_all(tale_id, title, description, category, license_id):
DAO.update(
'''
UPDATE anaddventure.tale
SET tale_title = (%s),
tale_description = (%s),
tale_category = (%s),
tale_license = (%s)
WHERE tale_id = (%s)
''',
(title, description, category, license_id, tale_id)
)示例4: select_viewable_by_creator_id_and_viewer_id
def select_viewable_by_creator_id_and_viewer_id(
creator_id, viewer_id, rows = None
):
return Tale._construct_tale_objects(
DAO.select_by(
'''
SELECT DISTINCT
tale_id, tale_title, tale_description,
tale_category, tale_creator, tale_license,
tale_star_count, tale_follow_count,
tale_contribution_request_count, tale_creation_datetime
FROM anaddventure.tale INNER JOIN anaddventure.invitation ON
tale_creator = (%s) AND
(
tale_category = 1 OR
(
invitation_creator = tale_creator AND
invitation_invited = (%s) AND
invitation_tale_id = tale_id
) OR
tale_creator = (%s)
)
ORDER BY tale_star_count DESC
''',
(creator_id, viewer_id, viewer_id),
rows
)
)示例5: select_tales_other_creator
def select_tales_other_creator(user_id, viewer_id, rows = None):
return Tale._construct_tale_objects(
DAO.select_by(
'''
SELECT DISTINCT
tale_id, tale_title, tale_description,
tale_category, tale_creator, tale_license,
tale_star_count, tale_follow_count,
tale_contribution_request_count, tale_creation_datetime
FROM anaddventure.tale INNER JOIN anaddventure.contribution_request ON
contribution_request_system_user_id = (%s) AND
tale_creator != contribution_request_system_user_id AND
tale_id = contribution_request_tale_id AND
(
tale_category = 1 OR
(
(
SELECT COUNT(*) FROM anaddventure.invitation WHERE
invitation_creator = tale_creator AND
invitation_invited = contribution_request_system_user_id
) > 0 AND
(
SELECT COUNT(*) FROM anaddventure.invitation WHERE
invitation_creator = tale_creator AND
invitation_invited = (%s)
) > 0
)
)
ORDER BY tale_star_count DESC
''',
(user_id, viewer_id),
rows
)
)示例6: select_top_ten_order_by_star_count
def select_top_ten_order_by_star_count():
return Tale._construct_tale_objects(
DAO.select_by(
"SELECT * FROM anaddventure.tale WHERE tale_category = 1 ORDER BY tale_star_count DESC LIMIT 5",
()
)
)示例7: select_all
def select_all(rows = None):
return Tale._construct_tale_objects(
DAO.select_by(
"SELECT * FROM anaddventure.tale",
(),
rows
)
)示例8: select_by_creator_id_and_full_title
def select_by_creator_id_and_full_title(creator_id, title, rows = None):
return Tale._construct_tale_objects(
DAO.select_by(
"SELECT * FROM anaddventure.tale WHERE tale_creator = (%s) AND tale_title ILIKE (%s)",
(creator_id, title),
rows
)
)示例9: select_by_license_id
def select_by_license_id(license_id, rows = None):
return Tale._construct_tale_objects(
DAO.select_by(
"SELECT * FROM anaddventure.tale WHERE tale_license = (%s)",
(license_id, ),
rows
)
)示例10: select_by_creator_id
def select_by_creator_id(creator_id, rows = None):
return Tale._construct_tale_objects(
DAO.select_by(
"SELECT * FROM anaddventure.tale WHERE tale_creator = (%s)",
(creator_id, ),
rows
)
)示例11: select_by_category
def select_by_category(category = '', rows = None):
return Tale._construct_tale_objects(
DAO.select_by(
"SELECT * FROM anaddventure.tale WHERE tale_category = (%s)",
(category, ),
rows
)
)示例12: select_count_by_title
def select_count_by_title(title = '', rows = None):
return Tale._construct_tale_objects(
DAO.select_by(
"SELECT COUNT(tale_id) FROM anaddventure.tale WHERE tale_title ILIKE (%s)",
('%' + title + '%', ),
rows
)
)示例13: select_by_full_title
def select_by_full_title(title = '', rows = None):
return Tale._construct_tale_objects(
DAO.select_by(
"SELECT * FROM anaddventure.tale WHERE tale_title ILIKE (%s)",
(title, ),
rows
)
)示例14: select_all
def select_all(rows = None):
return License._construct_license_objects(
DAO.select_by(
"SELECT * FROM anaddventure.license",
(),
rows
)
)示例15: select_by_name
def select_by_name(name, rows = None):
return License._construct_license_objects(
DAO.select_by(
"SELECT * FROM anaddventure.license WHERE license_name ILIKE (%s)",
('%' + name + '%', ),
rows
)
)