def stringMatching2(stringInput): connectionObj=Connection.Config() cursor=connectionObj.cursor db=connectionObj.db flag = 0 c=0 pasString='' savestate = 0 start = 1 cursor.execute("select count(*) from commands;") table_row=cursor.fetchone() strInput=stringInput.split() while(start <= table_row[0]): cursor.execute("select command from commands where id='"+str(start)+"'") query_row=cursor.fetchone() selectedString=query_row[0] str1=selectedString.split() a=0 while(a<len(str1)): b=0 while(b<len(strInput)): if flag == 1: if strInput[b] == str1[c]: pasString+=strInput[b]+' ' c+=1 if pasString.rstrip()==selectedString: sql2 = "select cmdvalue from commands where id='" + str(start) + "'" cursor.execute(sql2) query_row = cursor.fetchone() returnValue=query_row[0] str2 = "insert into user_commands(command,cmdvalue) values('" + stringInput + "'," + str(returnValue) + ");" try: cursor.execute(str2) db.commit() except: db.rollback() return query_row[0] else: b = savestate flag = 0 c=0 break else: if(str1[a] == strInput[b]): savestate = b pasString='' b-=1 flag = 1 b+=1 a+=1 start+=1
def stringMatching(stringInput): connectionObj=Connection.Config() cursor=connectionObj.cursor str1=stringInput flag=0 if flag==0: index=1 cursor.execute("select count(*) from user_commands;") table_row=cursor.fetchone() while index<=table_row[0]: sql2="select command,cmdvalue from user_commands where id='"+str(index)+"'" cursor.execute(sql2) query_row=cursor.fetchone() str2=query_row[0] if (str1==str2): return query_row[1] else: flag=1 index+=1 if flag==1: b= stringMatching2(str1) return b