def AddTestcases(self):
db = dbconfig()
db.cursor.execute(
"insert into testcase_details(input_sentence,source_language_id,created_date,test_case_id,test_status) value('%s','%d','%s','%d','%d')"
% (self.input_sentence, self.language, self.created_date,
self.source_id, self.test_status))
db.db.commit()
def GetLanguageById(self,id):
db=dbconfig()
Language1=Languages()
db.cursor.execute("select * from languages where id='%d'"%id)
result=db.cursor.fetchone()
Language1.id=result[0]
Language1.name=result[1]
return Language1
def GetTranslators(self):
db = dbconfig()
translator_list = []
db.cursor.execute("select * from translator")
result = db.cursor.fetchall()
for row in result:
translator1 = self.DBObjecttMapper(row)
translator_list.append(translator1)
return translator_list
def AddTranslator(self):
db = dbconfig()
db.cursor.execute(
"insert into translator(name,api_key,input_element,output_element,submit_element,source_language_element,"
+
"target_language_element,url) value('%s','%s','%s','%s','%s','%s','%s','%s')"
%
(self.name, self.api_key, self.input_element, self.output_element,
self.submit_element, self.source_language_element,
self.target_language_element, self.url))
db.db.commit()
def GetLanguages(self):
language_list=[]
db=dbconfig()
db.cursor.execute("select * from languages")
result=db.cursor.fetchall()
for row in result:
Language=Languages()
Language.id=row[0]
Language.name=row[1]
language_list.append(Language)
return language_list
def GetSearchResults(self,By,param):
search_list=[]
sql="select * from result_url"
sql={
'id':self.QueryBuilder("id",param),
'result':self.QueryBuilder("result_id",param)
}[By]
db=dbconfig()
db.cursor.execute(sql)
result=db.cursor.fetchall()
for row in result:
result=self.DBObjectMapper(row)
search_list.append(result)
return search_list
def GetTestCases(self, By, param):
testcase_list = []
sql = "select * from testcase_details"
sql = {
'id': self.QueryBuilder("id", param),
'language': self.QueryBuilder("source_language_id", param),
'source': self.QueryBuilder("test_case_id", param),
'status': self.QueryBuilder("test_status", param)
}[By]
db = dbconfig()
db.cursor.execute(sql)
result = db.cursor.fetchall()
for row in result:
result = self.DBObjectMapper(row)
testcase_list.append(result)
return testcase_list
def GetTestResults(self,By,param):
result_list=[]
sql="select * from result"
sql={
'id':self.QueryBuilder("id",param),
'testcase':self.QueryBuilder("test_case_detail_id",param),
'language':self.QueryBuilder("target_language_id",param),
'translator':self.QueryBuilder("translator_id",param)
}[By]
db=dbconfig()
db.cursor.execute(sql)
result=db.cursor.fetchall()
for row in result:
result=self.DBObjectMapper(row)
result_list.append(result)
return result_list
def GetTranslatorById(self, id):
db = dbconfig()
db.cursor.execute("select * from translator where id='%d'" % id)
row = db.cursor.fetchone()
translator1 = self.DBObjecttMapper(row)
return translator1
def AddSearchResults(self):
db=dbconfig()
db.cursor.execute("insert into result_url(result_id,result_text,url_no,created_date"+") value('%d','%s','%d','%s')"
%(self.result_id, self.result_url, self.url_no, self.created_date))
db.db.commit()
def AddTestcaseSource(self, source):
db = dbconfig()
db.cursor.execute("insert into testcases(source) value('%s')" % source)
db.db.commit()
def AddTestCases(self):
db=dbconfig()
db.cursor.execute("insert into result(test_case_detail_id,translator_id,target_language_id,forward_translation,result,created_date,reverse_translation"+
") value('%d','%d','%d','%s','%f','%s','%s')"
%(self.testcase_id, self.translator_id, self.target_language_id, self.forward_translation, self.result, self.created_date, self.reverse_translation))
db.db.commit()
def AddLanguages(self):
db=dbconfig()
db.cursor.execute("insert into languages(name) value('%s')"%self.name)
db.db.commit()
