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)