def ajout_data(series):
conn = connection_bd()
cursor = conn.cursor()
for i in range(len(series)):
query = "SELECT idusers FROM users WHERE user_pseudo ='"
query += " " + series.loc[i, 'author'] + "';"
print(query)
cursor.execute(query)
res = cursor.fetchall()
print(res)
if len(res) != 1:
add_utilisateur = "INSERT INTO users (user_pseudo) VALUES ('" + series.loc[
i, 'author'] + "');"
print(add_utilisateur)
cursor.execute(add_utilisateur)
user_no = cursor.lastrowid
else:
user_no = cursor
#format_date = dt.datetime.strptime(str(series.loc[i,'date']), '%d/%m/%Y').strftime('%y-%m-%d')
add_commentaire = 'INSERT INTO users_comments (contenu, user_id, comment_date) VALUES( "' + series.loc[
i, 'content'] + '", ' + str(user_no) + ', "' + str(
series.loc[i, 'dates']) + '");'
#add_commentaire = 'INSERT INTO users_comments (contenu, user_id, comment_date) VALUES ( "'+str(series.loc[i,'content'])+'", '+str(user_no)+', "'+str(format_date)+'");'
print(add_commentaire)
cursor.execute(add_commentaire)
conn.commit()
# Make sure data is committed to the database
cursor.close()
conn.close()
def modif_lbel(lab,idC):
cnx = connection_bd()
cursor = cnx.cursor()
update_query = 'UPDATE users_comments SET comment_label = %s where comment_id = %s;'
cursor.execute(update_query, (idC, lab))
cnx.commit()
cursor.close()
cnx.close()
def reqcommentaires():
cnx = connection_bd()
cursor = cnx.cursor()
query_string = "SELECT comment_id, contenu FROM users_comments where comment_label is NULL;"
cursor.execute(query_string)
data = cursor.fetchall()
cnx.commit()
cursor.close()
cnx.close()
return data
def data_lab():
cnx = connection_bd()
cursor = cnx.cursor()
query = "SELECT comment_id,contenu, comment_label FROM users_comments where comment_label is NOT NULL;"
cursor.execute(query)
data = cursor.fetchall()
cnx.commit()
print(data)
cursor.close()
cnx.close()
return data
def recente_date():
cnx = connection_bd()
cursor = cnx.cursor()
date_query = 'SELECT max(comment_date) FROM users_comments;'
cursor.execute(date_query)
data = cursor.fetchall()
tab_comment = pd.DataFrame({
'author': authors,
'content': comments,
'date': dates
})
tab_comment['dates'] = pd.to_datetime(tab_comment['date']).dt.date
# =============================================================================
# print('unicode',tab_comment['content'].iloc[2])
# =============================================================================
#tab_comment
#%%
from cnxdb import connection_bd
#import mysql.connector
#conn = mysql.connector.connect(host="localhost",user="******",password="******", database="my_app")
conn = connection_bd()
#
#%%
def ajout_data(series):
conn = connection_bd()
cursor = conn.cursor()
for i in range(len(series)):
query = "SELECT idusers FROM users WHERE user_pseudo ='"
query += " " + series.loc[i, 'author'] + "';"
print(query)
cursor.execute(query)
res = cursor.fetchall()
print(res)