本文整理汇总了Python中trove.instance.models.DBInstance.query方法的典型用法代码示例。如果您正苦于以下问题:Python DBInstance.query方法的具体用法?Python DBInstance.query怎么用?Python DBInstance.query使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类trove.instance.models.DBInstance
的用法示例。
在下文中一共展示了DBInstance.query方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: _run_query
# 需要导入模块: from trove.instance.models import DBInstance [as 别名]
# 或者: from trove.instance.models.DBInstance import query [as 别名]
def _run_query(start_date, end_date):
created_filters = [DBInstance.created < end_date,
DBInstance.deleted == 0]
created_columns = [DBInstance.created.label('timestamp'),
literal_column("0").label('deleted'),
DBDatastoreVersion.id.label('dsvid')]
deleted_filters = [DBInstance.created < end_date,
DBInstance.deleted_at >= start_date,
DBInstance.deleted == 1]
deleted_columns = [DBInstance.deleted_at.label('timestamp'),
literal_column("1").label('deleted'),
DBDatastoreVersion.id.label('dsvid')]
query1 = DBInstance.query().\
join(DBDatastoreVersion).\
add_columns(*created_columns)
query1 = query1.filter(*created_filters)
query2 = DBInstance.query().\
join(DBDatastoreVersion).\
add_columns(*created_columns)
query2 = query2.filter(*deleted_filters)
query3 = DBInstance.query().\
join(DBDatastoreVersion).\
add_columns(*deleted_columns)
query3 = query3.filter(*deleted_filters)
union_query = query1.union(query2, query3).\
order_by(text('anon_1.timestamp'))
return union_query.all()