def get_request_object(real_id, actor_id):
"""
Retrieve real and actor rows from database
:param real_id:
:param actor_id:
:return: RequestAuth instance or None
"""
accounts = list(db.query("SELECT * FROM account WHERE id IN (:real_id, :actor_id) AND status='active'", real_id=real_id, actor_id=actor_id).fetchall())
if not accounts:
return None
if len(accounts) < 2:
if accounts[0]['id'] != real_id:
return None
return RequestAuth(accounts[0], accounts[0])
if accounts[0]['id'] == real_id:
return RequestAuth(accounts[0], accounts[1])
else:
return RequestAuth(accounts[1], accounts[0])
def get(id):
return db.query('select * from news where id=:id',id=id)
def add(title, content):
return db.query('insert into news (dated, title, content) values (:dated, :title, :content) returning id', dated=datetime.now(), title=title, content=content).scalar()
