KaneAI - World’s First E2E Software Testing Agent.Book a Demo 
How to use del_break method in avocado
Best Python code snippet using avocado_python
data_collection.py
Source:data_collection.py 
1import streamlit as st2import math3import re4#import sqlite35import mysql.connector as mysql6#import pandas as pd7import csv8from tkinter import *9from tkinter import ttk10from tkinter import messagebox11#from calculations import *12#import matplotlib13#matplotlib.use('Agg')14status=""1516#------------------------------------------------ reading input file -----------------------------------------------------------1718#read date, write into date_break192021#cnx = mysql.connector.connect(user='PBTK', password='akstr!admin2',22# host='131.220.66.200',23# database='coffee_list')24#cnx.close()2526#--------------------------- main function to call from different script27def write_break(coffee_break,breaklen):28 id_ext=""29 db = mysql.connect(user='PBTK', password='akstr!admin2', #connecting to mysql30 host='127.0.0.1',31 database='coffee_list')32 cursor=db.cursor(buffered=True)33 34 cursor.execute("use coffee_list")3536 cursor.execute("create table if not exists breaks (id int auto_increment, id_ext char(10), day int, month int, year int, primary key(id), unique key(id_ext))") #creatingbreaks table37 cursor.execute("create table if not exists drinkers (id int auto_increment, id_ext char(10), persons varchar(30), coffees varchar(30), primary key(id), CONSTRAINT fk_drinkers_break_ID_ext FOREIGN KEY(id_ext) REFERENCES breaks(id_ext) ON DELETE CASCADE)") #creating drinkers table38 cursor.execute("create table if not exists members (id int auto_increment, name varchar(3), password varchar(20), primary key(id))")39 cursor.execute("create table if not exists update_status (id int auto_increment, object varchar(5), id_ext int, content varchar(1000), primary key(id))")40 41 #---------------------- creating the extended id -----------------------42 id_ext=""43 date_break=coffee_break[0]44 day_break=str(date_break[0])45 month_break=str(date_break[1])46 if(len(month_break)==1): #adding "0" if month has 1 digit47 month_break="0"+str(date_break[1])48 if(len(day_break)==1): #adding "0" if day has 1 digit49 day_break="0"+str(date_break[0])50 id_ext=str(date_break[2])+month_break+day_break51 52 total=053 cursor.execute("SELECT id_ext FROM breaks WHERE id_ext like '"+id_ext+"%'") #searching for breaks of the same day as enterd break54 ids=cursor.fetchall()55 ids=list(ids)56 for i in range(len(ids)):57 ids[i]=int(ids[i][0])58 if len(ids)==0:59 id_ext=id_ext+"01"60 else:61 id_ext=str(max(ids)+1)6263 temp1="" #converting coffee_break into a list of strings for instertion into database64 temp2=""65 coffee_break_str=[]66 coffee_break_str.append(date_break)6768 for i in range(len(coffee_break[1])):69 temp1=temp1+str(coffee_break[1][i])70 temp2=temp2+str(coffee_break[2][i])71 if i<(len(coffee_break[1])-1):72 temp1=temp1+"-"73 temp2=temp2+"-"74 coffee_break_str.append(temp1)75 coffee_break_str.append(temp2)76 77 cursor.execute("INSERT INTO breaks (id_ext, day, month, year) VALUES ("+id_ext+","+str(date_break[0])+","+str(date_break[1])+","+str(date_break[2])+")")78 cursor.execute("INSERT INTO drinkers (id_ext, persons, coffees) VALUES ("+id_ext+",'"+str(coffee_break_str[1])+"','"+str(coffee_break_str[2])+"')")79 #cursor.execute("select * from drinkers")80 #temp=cursor.fetchall()81 #for row in temp:82 # print(row)83 print("Coffee break saved!")84 print(id_ext+", "+str(coffee_break_str[1])+", "+str(coffee_break_str[2]))8586 #--------------------- writing into each person's list -------------------87 persons=coffee_break[1]88 coffees=coffee_break[2]8990 for i in range(len(persons)):91 cursor.execute("create table if not exists mbr_"+persons[i]+" (id_ext char(10), n_coffees int, primary key(id_ext), CONSTRAINT fk_member_"+persons[i]+"_break_ID_ext FOREIGN KEY(id_ext) REFERENCES breaks(id_ext) ON DELETE CASCADE)") #creating a table for each individual person92 cursor.execute("insert into mbr_"+persons[i]+" (id_ext, n_coffees) values (%s, %s)", (id_ext, coffees[i])) #writes break id and coffees into personal table93 cursor.execute("select count(*) from members where name='"+persons[i]+"'") #checks if person is already written in members table94 temp=cursor.fetchone()95 temp=int(temp[0])96 if temp==0:97 cursor.execute("insert into members (name) values ('"+str(persons[i])+"')") #writes person into members table98 99100 #---------------------- writing break length table ------------------------101 cursor.execute("create table if not exists break_lengths (id int auto_increment, id_ext char(10), length time(6), primary key(id), CONSTRAINT fk_breaklen_break_ID_ext FOREIGN KEY(id_ext) REFERENCES breaks(id_ext) ON DELETE CASCADE)")102 cursor.execute("insert into break_lengths (id_ext, length) values (%s, %s)",(id_ext,breaklen))103104 #writing update_status table105 cursor.execute("select max(id_ext) from breaks")106 tmp = cursor.fetchall()107 cursor.execute("update update_status set id_ext = "+str(tmp[0][0])+" where object = 'database'")108 109 110 db.commit()111 #cursor.execute("select * from drinkers")112 #databases=cursor.fetchall()113 #for row in databases:114 # print(row)115 #print("--------------------")116 db.close()117118119 #---------------------- checking for user and password --------------------120121def safety_check(command):122 status=command123 sfycheck_fld = Tk()124 sfycheck_fld.geometry("400x100")125 sfycheck_fld.title("Safety Check")126 frame_sfycheck = LabelFrame(sfycheck_fld, width= 400, height=200, bd = 0)127 frame_sfycheck.place (x=0, y= 10)128 header_sfycheck=Label(frame_sfycheck, text="Please enter your user name and password:", fg="red", font=("Helvetica", 14))129 header_sfycheck.place(x=20, y = 0)130 user_inp=ttk.Entry(frame_sfycheck, text="", width=4)131 user_inp.place(x=120, y = 30)132 pw_inp=ttk.Entry(frame_sfycheck, show="*", text="", width=8)133 pw_inp.place(x=161, y = 30)134 conf_sfycheck=ttk.Button(frame_sfycheck, text="Delete this break", command=lambda: user_pw_database_search(sfycheck_fld,user_inp,pw_inp,status) )135 conf_sfycheck.place(x=119, y= 60)136 sfycheck_fld.bind('<Return>', (lambda event: user_pw_database_search(sfycheck_fld,user_inp,pw_inp,status)))137138def user_pw_database_search(sfycheck_fld,user_inp,pw_inp,status):139 user_inp=str(user_inp.get()).upper()140 pw_inp=str(pw_inp.get())141 142 #print(user_inp, pw_inp)143144 db = mysql.connect(user='PBTK', password='akstr!admin2', #connecting to mysql145 host='127.0.0.1',146 database='coffee_list')147 cursor=db.cursor(buffered=True)148 149 cursor.execute("use coffee_list")150 cursor.execute("SELECT * FROM members WHERE name='"+user_inp+"'")151 user_data=""152 user_data=cursor.fetchall()153 #print(user_data)154 if user_data==[]:155 sfycheck_fld.destroy()156 messagebox.showinfo("Log-In status", "No such User!")157 158 else:159 user_data_check=list(user_data[0])160 161 #print(user_data)162 #print(pw_inp) 163 164 if user_data_check[2]==pw_inp:165 sfycheck_fld.destroy()166167 if status=="delete_one": # to delete one break168 clear_ONE_break()169 elif status=="delete_db": # to clear the whole database170 if user_data_check[3]==1:171 answer = messagebox.askokcancel("Confirmation", "Are you REALLY sure to clear the database?",icon="warning")172 if answer:173 answer = messagebox.askokcancel("Confirmation", "Final warning!",icon="warning")174 if answer:175 #clear_database()176 messagebox.showinfo("Deletion status", "The database has successfully been cleared.")177 else:178 messagebox.showerror("Access denied", "You do not have admin rights. Please contact your system administrator.")179 else:180 sfycheck_fld.destroy()181 messagebox.showinfo("Log-In status", "Wrong Password!")182183 return184 185 #---------------------- deleting a break by knowing id_ext ----------------186def clear_ONE_break():187 input_fld = Tk()188 input_fld.geometry("600x100")189 input_fld.title("Deleting a break from the databank")190 frame_ifld = LabelFrame(input_fld, width= 600, height=100, bd = 0)191 frame_ifld.place (x=0, y= 30)192 header_ifld=Label(input_fld, text="Please enter the coffee break ID you want to delete:", fg="red", font=("Helvetica", 14))193 header_ifld.place(x=70, y = 10)194 id_inp=ttk.Entry(frame_ifld, text="", width=20)195 id_inp.place(x=220, y = 30)196 conf_delete_break=ttk.Button(frame_ifld, text="Delete this break", command=lambda: conf_break_delete(input_fld,id_inp) )197 conf_delete_break.place(x=350, y=28)198 input_fld.bind('<Return>', (lambda event: conf_break_delete(input_fld,id_inp)))199 200def conf_break_delete(input_fld,id_inp):201 #print(str(id_inp.get()).upper())202 del_ID=[]203 del_ID.append(str(id_inp.get()).upper())204 del_ID=str(del_ID[0])205 print("Coffee break deleted: "+del_ID)206207 db = mysql.connect(user='PBTK', password='akstr!admin2', #connecting to mysql208 host='127.0.0.1',209 database='coffee_list')210 cursor=db.cursor(buffered=True)211 212 cursor.execute("use coffee_list")213 cursor.execute("SELECT * FROM breaks WHERE id_ext='"+del_ID+"'")214 del_break=""215 del_break=cursor.fetchall()216 #print(del_break)217 218 if del_break != []:219 cursor.execute("DELETE FROM breaks WHERE id_ext='"+del_ID+"'")220221 #writing update_status table222 cursor.execute("select max(id_ext) from breaks")223 tmp = cursor.fetchall()224 cursor.execute("update update_status set id_ext = "+str(tmp[0][0])+" where object = 'database'")225226 input_fld.destroy()227 messagebox.showinfo("Deletion status", "This break has successfully been deleted.")228 229 else:230 input_fld.destroy()231 messagebox.showinfo("Deletion status", "This break does not exist, therefore nothing was deleted.")232233 234 235 236 db.commit()237 db.close 238239 #------------------- deleting the whole database --------------------------------------240def clear_database():241 db = mysql.connect(user='PBTK', password='akstr!admin2',242 host='127.0.0.1',243 database='coffee_list')244 cursor=db.cursor()245246 cursor.execute("use coffee_list")247 cursor.execute("SHOW tables")248 databases=cursor.fetchall()249 #print(databases)250 #print("yes")251 cursor.execute("select name from members")252 mbrs=cursor.fetchall()253 mbrs=list(mbrs)254 for i in range(len(mbrs)):255 cursor.execute("drop table if exists mbr_"+mbrs[i][0])256 257 cursor.execute("drop table if exists break_ID,breaks, drinkers, members, total_coffees, break_lengths")258 cursor.execute("SHOW tables")259 databases=cursor.fetchall()260 #print(databases)261 db.commit()262 db.close()263264 265 #------------------------- reading breaks from 2021 into database ---------------------266def breaks_2021():267 db = mysql.connect(user='PBTK', password='akstr!admin2',268 host='127.0.0.1',269 database='coffee_list')270 cursor=db.cursor()271272 cursor.execute("use coffee_list")273274 inp = []275 file = open("breaks_2021.txt","r")276 lines = file.readlines()277 file.close()278 persons=['TK','PB','NV','DB','FLG','SHK','TB']279 for line in lines:280 #print(line)281 #inp.append(list(map(int,line.split())))282 inp=list(map(int,line.split())) #getting lines from input file283 284 cursor.execute("SELECT * FROM breaks WHERE id_ext='"+str(inp[0])+"'") #check if break is already in database285 exists=""286 exists=cursor.fetchall()287 if exists==[]:288 #print(str(inp[0])+","+str(inp[0])[0:4]+","+str(inp[0])[4:6]+","+str(inp[0])[6:8])289 290 temp1=""291 temp2=""292 temp3=0293 temp4=0294 for j in range(7): #checking how many persons took part in break295 if inp[j+1]!=0:296 temp3+=1297298 cursor.execute("insert into breaks (id_ext, year, month, day) VALUES ("+str(inp[0])+","+str(inp[0])[0:4]+","+str(inp[0])[4:6]+","+str(inp[0])[6:8]+")")299 300 for j in range(7): #creating string for input into drinkers table301 if inp[j+1]!=0:302 temp1+=persons[j]303 temp2+=str(inp[j+1])304 temp4+=1305 if temp4 < temp3:306 temp1+="-"307 temp2+="-"308 print(inp)309 cursor.execute("create table if not exists mbr_"+persons[j]+" (id_ext char(10), n_coffees int, primary key(id_ext), CONSTRAINT fk_member_"+persons[j]+"_break_ID_ext FOREIGN KEY(id_ext) REFERENCES breaks(id_ext) ON DELETE CASCADE)")310 cursor.execute("insert into mbr_"+persons[j]+" (id_ext, n_coffees) values (%s, %s)", (inp[0], inp[j+1]))311 312 cursor.execute("INSERT INTO drinkers (id_ext, persons, coffees) VALUES ("+str(inp[0])+",'"+temp1+"','"+temp2+"')")313314 db.commit()
...
preprocessing.py
Source:preprocessing.py
...20# Ne pas oublier de dl toutes les libs21#nltk.download()22path = "./tmp/"23##### PREPROCESSING ######24def del_break(file):25 '''26 Remove breaks from a text27 '''28 f = open(file, encoding = "utf8")29 raw = f.read()30 raw = raw.replace('\n','')31 f.close()32 #output= open(path + file, "w", encoding="utf8")33 #print(raw, file=output)34 #output.close()35def sentence_tokenize(file, language):36 '''37 Separate texte into indexed sentences.38 '''39 # ATTENTION AU FORMAT DES FICHIERS sinon erreurs possibles -> pour twitter uft840 # Il faudra adapter le path pour les fichiers des CGUs41 if isinstance(file, str) and file.endswith(".txt"):42 del_break(file)43 f = open(file, encoding="utf8")44 raw = f.read()45 raw = raw.replace('\n\n', '. ').replace('\n', ' ')46 f.close()47 48 elif isinstance(file, str): 49 raw = file.replace("\n\n", '. ').replace('\n', " ")50 else :51 return " ERROR TYPE"52 # l'objet JSON53 data_stopwords = {}54 data = {}55 # segmentation par phrase56 stop_words = set(stopwords.words(language))...
03_❌_Delete_coffee_or_break.py
Source:03_❌_Delete_coffee_or_break.py
1import streamlit as st2from common_functions import *3import pandas as pd4st.set_page_config(page_title="Coffee list",page_icon="coffee",layout="wide")5 #---------------------- deleting a break by knowing id_ext ----------------6def clear_one_break(del_id, test):7 db = init_connection()8 cursor = db.cursor(buffered=True)9 10 if del_id == "":11 st.warning("Please enter a break ID")12 else:13 cursor.execute("SELECT * FROM breaks WHERE id_ext='"+del_id+"'")14 del_break=cursor.fetchall()15 if del_break != []:16 cursor.execute("DELETE FROM breaks WHERE id_ext='"+del_id+"'")17 cursor.execute("delete from break_sizes where id_ext ='"+del_id+"'")18 cursor.execute("update update_status set last_break = timestamp(subdate(current_date, 1))")19 st.success("Break "+del_id+" has successfully been deleted.")20 else:21 st.error("Break "+del_id+" does not exist, therefore nothing was deleted.")22 23 db.commit()24 db.close()25 26#----------------------- check whether break ID was entered or not --------------------------27def delete_one_coffee_check(del_id,del_person):28 if del_id=="":29 del_id = last_breaks[len(last_breaks)-1][0]30 delete_one_coffee(del_id,del_person)31 32 33 #---------------------- deleting a coffee from a break ----------------34def delete_one_coffee(id_ext, name):35 db = init_connection()36 cursor = db.cursor(buffered=True)37 38 cursor.execute("select persons, coffees from drinkers where id_ext = '"+id_ext+"'")39 tmp=cursor.fetchall()40 persons = tmp[0][0].split("-")41 coffees = tmp[0][1].split("-")42 for i in range(len(persons)):43 if persons[i] == name.upper():44 coffees[i] = int(coffees[i]) - 145 cursor.execute("update mbr_"+name.upper()+" set n_coffees = "+str(coffees[i])+" where id_ext = '"+id_ext+"'")46 if coffees[i] == 0:47 cursor.execute("delete from mbr_"+name.upper()+" where id_ext = '"+id_ext+"'")48 49 cursor.execute("select size from break_sizes where id_ext = '"+id_ext+"'")50 tmp1 = cursor.fetchall()51 cursor.execute("update break_sizes set size = "+str(int(tmp1[0][0])-1)+" where id_ext = '"+id_ext+"'")52 persons_new = ""53 coffees_new = ""54 for i in range(len(persons)):55 if coffees[i] == 0:56 pass57 else:58 if persons_new == "":59 persons_new += persons[i]60 coffees_new += str(coffees[i])61 else:62 persons_new = persons_new + "-" + persons[i]63 coffees_new = coffees_new + "-" + str(coffees[i])64 if persons_new == "":65 cursor.execute("DELETE FROM breaks WHERE id_ext='"+id_ext+"'")66 cursor.execute("delete from break_sizes where id_ext = '"+id_ext+"'")67 else:68 cursor.execute("update drinkers set persons = '"+persons_new+"' where id_ext = '"+id_ext+"'")69 cursor.execute("update drinkers set coffees = '"+coffees_new+"' where id_ext = '"+id_ext+"'")70 db.commit()71 db.close()72 73 74 75 76 77########################################################################################################################################################################78##################################################### MAIN #######################################################################################################79########################################################################################################################################################################80st.subheader("**:x:** Delete a coffee break")81if 'logged_in' not in st.session_state or 'user_name' not in st.session_state or 'admin' not in st.session_state or 'attempt' not in st.session_state:82 st.warning("Warning! Your session was terminated due to inactivity. Please return to home to restart it and regain access to all features.")83else:84 85 if st.session_state.admin != "1":86 st.warning("You do not have the permission to delete a coffee or break. Please contact a system administrator for further information.")87 elif st.session_state.admin == "1":88 st.markdown("Please enter the extended ID of the break you want to delete.")89 last_breaks=get_last_breaks(10)90 col1,col2,col3 = st.columns([1,0.5,3])91 del_id = col1.text_input("Extended ID of break", placeholder=last_breaks[len(last_breaks)-1][0])92 df=pd.DataFrame(last_breaks,columns=['Extended ID','Date','Drinkers','Coffees'])93 col3.markdown("Last 10 breaks")94 col3.dataframe(df, width=600, height=400)95 delete = col1.button("Delete break", on_click=clear_one_break, args=(del_id,""))96 col1.write("-" * 34)97 del_person = col1.text_input("Delete for person", placeholder="Username")98 col1.button("Delete coffee from break", on_click=delete_one_coffee_check, args=(del_id,del_person))99#------- footer ----------------100footer="""<style>101.footer {102position: fixed;103left: 0;104bottom: 0;105width: 100%;106background-color: white;107color: grey;108text-align: center;109}110</style>111<div class="footer">112<p>Developed by P. C. Brehm and T. Kalisch. Web design by T. Kalisch <a style='display: block; text-align: center</a></p>113</div>114"""...
Automation Testing Tutorials
Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.
LambdaTest Learning Hubs:
- JUnit Tutorial
- TestNG Tutorial
- Webdriver Tutorial
- WebDriverIO Tutorial
- Protractor Tutorial
- Selenium 4 Tutorial
- Jenkins Tutorial
- NUnit Tutorial
- Jest Tutorial
- Playwright Tutorial
- Cypress Tutorial
- PyTest Tutorial
YouTube
You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.
Run avocado automation tests on LambdaTest cloud grid
Perform automation testing on 3000+ real desktop and mobile devices online.
Try LambdaTest Now !!
Get 100 minutes of automation test minutes FREE!!
Was this article helpful?
