def insertVisited():
local = int(input("ID local (site): "))
data = input("Data: ")
con = Conexao()
sql = "INSERT INTO Visited (site_id, `date`) VALUES(%s,%s);"
con.insertQuery(sql, (local,data))
def insertPerson():
nome = input("Nome: ")
sobrenome = input("Sobrenome: ")
con = Conexao()
sql = "INSERT INTO Person (personal,family) VALUES(%s,%s);"
con.insertQuery(sql, (nome, sobrenome))
def insertSite():
nome = input("Nome: ")
lat = float(input("Latitude: "))
longi = float(input("Longitude: "))
con = Conexao()
sql = "INSERT INTO Site (name,lat,`long`) VALUES(%s,%s,%s);"
con.insertQuery(sql, (nome, lat, longi))
def insertSurvey():
visita = int(input("ID visita: "))
pessoa = int(input("ID pessoa: "))
quant = input("Medida: ")
read = float(input("Valor: "))
con = Conexao()
sql = "INSERT INTO Survey (visited_id, person_id, quant, reading) VALUES (%s, %s, %s, %s);"
con.insertQuery(sql, (visita,pessoa,quant,read))
def insertRandom():
con = Conexao()
sqlperson = "INSERT INTO Person (personal,family) VALUES(%s,%s);"
sqlsite = "INSERT INTO Site (name,lat,`long`) VALUES(%s,%s,%s);"
sqlvisited = "INSERT INTO Visited (site_id, `date`) VALUES(%s,%s);"
sqlsurvey = "INSERT INTO Survey (visited_id, person_id, quant, reading) VALUES (%s, %s, %s, %s);"
con.insertQuery(sqlperson, (randomName(6),randomName(12)))
con.insertQuery(sqlsite, (randomName(8), randomFloat(), randomFloat()))
con.insertQuery(sqlvisited, (randomIDFromTab("Site"), randomWord(["1930-11-12","1929-01-08","1928-12-08","1927-05-29"])))
con.insertQuery(sqlsurvey, (randomIDFromTab('Visited'),randomIDFromTab('Person'), randomWord(["rad","sal","temp"]), randomFloat() ))