def find_by_cursor(last_id, size):
if last_id:
feeds = Feed.query \
.filter(Feed.id < last_id) \
.order_by(db.desc(Feed.id)).offset(0).limit(size).all()
else:
feeds = Feed.query \
.order_by(db.desc(Feed.id)).offset(0).limit(size).all()
return feeds
def find_by_cursor(from_uid, last_update_date, size):
if last_update_date:
contacts = Contact.query \
.filter((Contact.uidA == from_uid) | (Contact.uidB == from_uid),
Contact.status == ContactStatus.Connected,
Contact.updated_at < last_update_date) \
.order_by(db.desc(Contact.updated_at)).offset(0).limit(size).all()
else:
contacts = Contact.query \
.filter((Contact.uidA == from_uid) | (Contact.uidB == from_uid),
Contact.status == ContactStatus.Connected) \
.order_by(db.desc(Contact.updated_at)).offset(0).limit(size).all()
return contacts
def find_by_cursor(uid, latest_id, size):
if latest_id:
return EndorseComment.query \
.filter(EndorseComment.uid == uid,
EndorseComment.status == EndorseStatus.Supported,
EndorseComment.id > latest_id) \
.order_by(db.desc(EndorseComment.id)) \
.offset(0).limit(size).all()
else:
return EndorseComment.query \
.filter(EndorseComment.uid == uid,
EndorseComment.status == EndorseStatus.Supported) \
.order_by(db.desc(EndorseComment.id)) \
.offset(0).limit(size).all()
def find_by_cursor(uid, type, latest_id, size):
if latest_id:
return UserEndorse.query \
.filter(UserEndorse.uid == uid,
UserEndorse.type == type,
UserEndorse.status == EndorseStatus.Supported,
UserEndorse.id > latest_id) \
.order_by(db.desc(UserEndorse.id)) \
.offset(0).limit(size).all()
else:
return UserEndorse.query \
.filter(UserEndorse.uid == uid,
UserEndorse.type == type,
UserEndorse.status == EndorseStatus.Supported) \
.order_by(db.desc(UserEndorse.id)) \
.offset(0).limit(size).all()
def find_by_cursor(uid, last_id, size=20):
if last_id:
requests = ContactRequest.query \
.filter(ContactRequest.uidB == uid) \
.filter((ContactRequest.status == ContactRequestStatus.Accepted) | (
ContactRequestStatus == ContactRequestStatus.Pending)) \
.filter(ContactRequest.id < last_id) \
.order_by(db.desc(ContactRequest.id)) \
.offset(0) \
.limit(size).all()
else:
requests = ContactRequest.query \
.filter(ContactRequest.uidB == uid) \
.filter((ContactRequest.status == ContactRequestStatus.Accepted) | (
ContactRequest.status == ContactRequestStatus.Pending)) \
.order_by(db.desc(ContactRequest.id)) \
.offset(0) \
.limit(size).all()
return requests
def find_latest_by_uid(uid):
return EndorseComment.query \
.filter(EndorseComment.uid == uid,
EndorseComment.status == EndorseStatus.Supported) \
.order_by(db.desc(EndorseComment.id)) \
.first()