def addOfficielle(mbrecasconfirme, mbregueris, mbremort, mbresoustraitement): conn = sqlite3.connect(path.getPath()) c = conn.cursor() c.execute( 'SELECT mbrecasconfirme, mbregueris, mbremort,mbresoustraitement,rowid from officielle ORDER BY rowid asc' ) res = c.fetchone() if (res == None): print("Insertion de donnée ..........") c.execute( "INSERT INTO officielle (mbrecasconfirme,mbregueris,mbresoustraitement,mbremort) \ VALUES (" + str(mbrecasconfirme) + "," + str(mbregueris) + "," + str(mbresoustraitement) + "," + str(mbremort) + ")") else: if ((int(mbrecasconfirme) == int(res[0])) and (int(mbresoustraitement) == int(res[3])) and (int(mbregueris) == int(res[1])) and (int(mbremort) == int(res[2]))): # print(res) print("pas d'évolution des statistiques ") else: print("Insertion de donnée ..........") c.execute( "INSERT INTO officielle (mbrecasconfirme,mbregueris,mbresoustraitement,mbremort) \ VALUES (" + str(mbrecasconfirme) + "," + str(mbregueris) + "," + str(mbresoustraitement) + "," + str(mbremort) + ")") conn.commit()
def getRes(): conn = sqlite3.connect( path.getPath()) c = conn.cursor() c.execute('SELECT mbrecasconfirme, mbregueris, mbremort,mbresoustraitement,rowid from officielle ORDER BY rowid desc') res = c.fetchone() return res
def addActualite2(actualite, id_date, taille): conn = sqlite3.connect(path.getPath()) c = conn.cursor() c.execute('SELECT count(actualite) FROM tableactualite') res = c.fetchone() res = int(res[0]) # print(taille) if (int(res) == 0): i = 0 while (i < int(taille)): print("Insertion de donnée ..........") # print("Insertion de donnée ..........") c.execute("INSERT INTO tableactualite (actualite,id_date) \ VALUES ('" + str(actualite) + "' ,'" + str(id_date) + "')") i = i + 1 else: if (int(res) == int(taille)): print("pas d'évolution des statistiques") if ((int(res) < int(taille))): taille = taille - res while (taille > 0): print("Insertion de donnée ..........") c.execute("INSERT INTO tableactualite (actualite,id_date) \ VALUES ('" + str(actualite) + "' ,'" + str(id_date) + "')") taille = taille - 1 conn.commit()
def addMapdb(longitude, latitude, mapdate, numeroTel): conn = sqlite3.connect(path.getPath()) c = conn.cursor() c.execute("INSERT INTO mapDb (longitude,latitude,mapdate,numeroTel) \ VALUES ('" + str(longitude) + "' ,'" + str(latitude) + "','" + str(mapdate) + "','" + str(numeroTel) + "')") conn.commit()
def createTablesActualite(): conn = sqlite3.connect(path.getPath()) c = conn.cursor() # Create officielle c.execute('''CREATE TABLE tableactualite (actualite TEXT, id_date TEXT)''')
def getCountActualite(): conn = sqlite3.connect(path.getPath()) c = conn.cursor() c.execute('SELECT count(actualite) FROM tableactualite') res = c.fetchone() res = int(res[0]) return res
def createTablesOfficielle(): conn = sqlite3.connect(path.getPath()) c = conn.cursor() # Create officielle c.execute('''CREATE TABLE officielle ( mbrecasconfirme INT, mbregueris INT, mbresoustraitement INT, mbremort INT)''')
def createTableMapDb(): conn = sqlite3.connect(path.getPath()) c = conn.cursor() # Create mapDb c.execute('''CREATE TABLE mapDb ( longitude TEXT, latitude TEXT, mapdate TEXT, numeroTel TEXT)''')
def scrapperIntox(): conn = sqlite3.connect( path.getPath()) c = conn.cursor() URL = 'https://www.who.int/fr/emergencies/diseases/novel-coronavirus-2019/advice-for-public/myth-busters' page = requests.get(URL) soup = BeautifulSoup(page.content, 'html.parser') # html = open("https://unric.org/fr/covid-19-info-ou-intox/").read() # soup = BeautifulSoup(html) # filtered = soup.find_all(attrs={"span": "color: #ff0000"}) # results = soup.find_all("span") resultsTitre = soup.find_all('h2') resultsContenu = soup.find_all('p') contenu = [] titre = [] for result in resultsTitre: if None in (result): continue titre.append(result.text.strip()) print(len(titre)) for result in resultsContenu: if None in (result): continue contenu.append(result.text.strip()) print(len(titre)) i = 0 while (i<len(titre)): print("Insertion de donnée ..........") c.execute("INSERT INTO intoxDb (intoxTitre,intoxContenu) \ VALUES ('" + str(echapper(titre[i])) + "' ,'" + str(echapper(contenu[i]))+"')") i = i +1 conn.commit()
def addActualite(actualite, id_date): conn = sqlite3.connect(path.getPath()) c = conn.cursor() c.execute("INSERT INTO tableactualite (actualite,id_date) \ VALUES ('" + str(actualite) + "' ,'" + str(id_date) + "')") conn.commit()
def createConnexion(): conn = sqlite3.connect(path.getPath()) c = conn.cursor() return c
def getAllMapdb(): conn = sqlite3.connect(path.getPath()) c = conn.cursor() c.execute('SELECT longitude,latitude,mapdate,numeroTel, rowid from mapDb') result = c.fetchall() return result
def getAllActualite(): conn = sqlite3.connect(path.getPath()) c = conn.cursor() c.execute('SELECT actualite, id_date, rowid from tableactualite') result = c.fetchall() return result