def get_wbtips(self, store):
ret = []
for tip in store.find(models.WhistleblowerTip):
x = wbtip.serialize_wbtip(store, tip, 'en')
x['receivers_ids'] = [rtip.receiver_id for rtip in tip.internaltip.receivertips]
ret.append(x)
return ret
def get_wbtips(self, store):
ret = []
for tip in store.find(models.WhistleblowerTip):
x = wbtip.serialize_wbtip(store, tip, 'en')
x['receivers_ids'] = [rcvr.id for rcvr in tip.internaltip.receivers]
ret.append(x)
return ret
def get_wbtips(self, session):
ret = []
for i in session.query(models.InternalTip) \
.filter(models.InternalTip.tid == 1):
x = wbtip.serialize_wbtip(session, i, 'en')
x['receivers_ids'] = list(zip(*session.query(models.ReceiverTip.receiver_id) \
.filter(models.ReceiverTip.internaltip_id == i.id,
models.InternalTip.id == i.id,
models.InternalTip.tid == 1)))[0]
ret.append(x)
return ret
def get_wbtips(self, store):
ret = []
for w, i in store.find((models.WhistleblowerTip, models.InternalTip),
models.WhistleblowerTip.id == models.InternalTip.id):
x = wbtip.serialize_wbtip(store, w, i, 'en')
r_ids = store.find(models.ReceiverTip.receiver_id,
models.ReceiverTip.internaltip_id == w.id)
x['receivers_ids'] = [r_id for r_id in r_ids]
ret.append(x)
return ret
def get_wbtips(self, session):
ret = []
for w, i in session.query(models.WhistleblowerTip, models.InternalTip) \
.filter(models.WhistleblowerTip.id == models.InternalTip.id,
models.InternalTip.tid == 1):
x = wbtip.serialize_wbtip(session, w, i, 'en')
x['receivers_ids'] = list(zip(*session.query(models.ReceiverTip.receiver_id)
.filter(models.ReceiverTip.internaltip_id == i.id,
models.InternalTip.id == i.id,
models.InternalTip.tid == 1)))[0]
ret.append(x)
return ret
