Python DAO.select_by方法代码示例

本文整理汇总了Python中models.DAO.DAO.select_by方法的典型用法代码示例。如果您正苦于以下问题：Python DAO.select_by方法的具体用法？Python DAO.select_by怎么用？Python DAO.select_by使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类models.DAO.DAO的用法示例。

在下文中一共展示了DAO.select_by方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。

示例1: select_tales_other_creator

# 需要导入模块: from models.DAO import DAO [as 别名]
# 或者: from models.DAO.DAO import select_by [as 别名]
	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
			)
		)

开发者ID:tayllan，项目名称:anaddventure，代码行数:36，代码来源:Tale.py

示例2: select_viewable_by_creator_id_and_viewer_id

# 需要导入模块: from models.DAO import DAO [as 别名]
# 或者: from models.DAO.DAO import select_by [as 别名]
	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
			)
		)

开发者ID:tayllan，项目名称:anaddventure，代码行数:30，代码来源:Tale.py

示例3: select_top_ten_order_by_star_count

# 需要导入模块: from models.DAO import DAO [as 别名]
# 或者: from models.DAO.DAO import select_by [as 别名]
	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",
				()
			)
		)

开发者ID:tayllan，项目名称:anaddventure，代码行数:9，代码来源:Tale.py