def get_response_by_text(self,text,phrase_id):
session.execute("SELECT * FROM response WHERE response=? AND phrase_id=?",[text,phrase_id])
return self.zip_response(session.fetchone())
def get_phrase_by_text(self,text):
session.execute("SELECT * FROM phrase WHERE phrase=?",[text])
return self.zip_phrase(session.fetchone())
def get_response(self,response_id):
session.execute("SELECT * FROM response WHERE response_id=?",[response_id])
return self.zip_response(session.fetchone())
def get_phrase(self,phrase_id):
session.execute("SELECT * FROM phrase WHERE id=?",[phrase_id])
return self.zip_phrase(session.fetchone())
