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()