createDatabase.py

import mysql.connector

mydb = mysql.connector.connect(
    host="localhost",
    user='root',
    passwd='9840382936',
    database="chatdata"
)




my_cursor = mydb.cursor()

# my_cursor.execute("CREATE TABLE Ncell (questionID INTEGER AUTO_INCREMENT PRIMARY KEY, questions TEXT, answers TEXT)")
# mydb.commit()
records =[]
check=0
tupleList=[]
with open('DataSetNew.txt','r') as f:
    for line in f:
        if check%2==0:
            line = line.replace("\n","")
            line = line.replace("?","")
            line = line.replace(".","")
            line = line.replace(",","")
            tupleList.append(str(line))
            check+=1
        else:
            line = line.replace("\n","")
            line = line.replace(".","")
            tupleList.append(str(line))
            t = tuple(tupleList)
            records.append(t)
            tupleList.clear()
            check+=1



sqlStuff = "INSERT INTO Ncell (questions, answers) VALUES (%s, %s)"

my_cursor.executemany(sqlStuff, records)
mydb.commit()
            

# # a = input("Your Questions: ")
# # finalText = removeWords(a)
# # print(finalText)
# # my_cursor.execute("SELECT answers FROM talkative WHERE mainKey=%s",(finalText,))
# # result = my_cursor.fetchall()
# # print(result)
# check =0
# with open('DataSetNew.txt','r') as f:
#     for line in f:
#         if check%2==0:
#             line = line.replace("?","")
#             line = line.replace(".","")
#             line= line.replace(",","")
#             with open('questionQnly.txt','a+') as writer:
#                 writer.write(line)
#             check+=1
#         else:
#             check+=1


# from SimilarSentences import SimilarSentences
# # Make sure the extension is .txt
# model = SimilarSentences('questionQnly.txt',"train")
# model.train()

# from SimilarSentences import SimilarSentences


# text = 'who is andy chong'
# model = SimilarSentences('model.zip',"predict")
# simple = model.predict(text, 1, "simple")
# simple = simple.replace("[","")
# simple = simple.replace("]","")
# simple = simple.replace('"',"")
# print(simple)