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