KaneAI - World’s First E2E Software Testing Agent.Book a Demo Join TestMu Conference

How to use import_table method in localstack

Best Python code snippet using localstack_python

K1830_opt.py

Source:K1830_opt.py

1import csv2from math import sqrt3import os4import random5from re import S67import shutil8import tkinter as tk9from tkinter import *10from tkinter import ttk, messagebox11from tkinter import Label12from tkinter import filedialog13from tkinter.filedialog import askopenfile14from turtle import left, width15import sys16import keyboard1718from numpy import column_stack1920import tkinter as tk2122class CreateToolTip(object):23    """24    create a tooltip for a given widget25    """26    def __init__(self, widget, text='widget info'):27        self.waittime = 500     #miliseconds28        self.wraplength = 180   #pixels29        self.widget = widget30        self.text = text31        self.widget.bind("<Enter>", self.enter)32        self.widget.bind("<Leave>", self.leave)33        self.widget.bind("<ButtonPress>", self.leave)34        self.id = None35        self.tw = None3637    def enter(self, event=None):38        self.schedule()3940    def leave(self, event=None):41        self.unschedule()42        self.hidetip()4344    def schedule(self):45        self.unschedule()46        self.id = self.widget.after(self.waittime, self.showtip)4748    def unschedule(self):49        id = self.id50        self.id = None51        if id:52            self.widget.after_cancel(id)5354    def showtip(self, event=None):55        x = y = 056        x, y, cx, cy = self.widget.bbox("insert")57        x += self.widget.winfo_rootx() + 2558        y += self.widget.winfo_rooty() + 2059        # creates a toplevel window60        self.tw = tk.Toplevel(self.widget)61        # Leaves only the label and removes the app window62        self.tw.wm_overrideredirect(True)63        self.tw.wm_geometry("+%d+%d" % (x, y))64        label = tk.Label(self.tw, text=self.text, justify='left',65                       background="#ffffff", relief='solid', borderwidth=1,66                       wraplength = self.wraplength)67        label.pack(ipadx=1)6869    def hidetip(self):70        tw = self.tw71        self.tw= None72        if tw:73            tw.destroy()7475""" tk_ToolTip_class101.py76gives a Tkinter widget a tooltip as the mouse is above the widget77tested with Python27 and Python34  by  vegaseat  09sep201478www.daniweb.com/programming/software-development/code/484591/a-tooltip-class-for-tkinter7980Modified to include a delay time by Victor Zaccardo, 25mar1681"""8283class Redirect():84    85    def __init__(self, widget):86        self.widget = widget87    88    def write(self, text):89        self.widget.insert('end', text)90        self.widget.see('end') # autoscroll91   9293def print_t(string):94    old_stdout = sys.stdout    95    sys.stdout = Redirect(text)96    print(string)97    sys.stdout = old_stdout9899##############################################################################################################################################100# MAIN101##############################################################################################################################################102103RUNS = 10000104file_location = os.getcwd()105Footprint_Library = file_location + "/Data/Footprint_Library.csv"106Compdata = file_location + "/Data/Compdata.csv"107Feeder = file_location + "/Data/Feeder.csv"108Mark = file_location + "/Data/Mark.csv"109Nozzle = file_location + "/Data/Nozzle.csv"110Panel = file_location + "/Data/Panel.csv"111PCBdata = file_location + "/Data/PCB.csv"112113import_table = []114Footprint_Library_table = list(csv.reader(open(Footprint_Library)))115Compdata_table = list(csv.reader(open(Compdata)))116F_table = list(csv.reader(open(Feeder)))117M_table = list(csv.reader(open(Mark)))118N_table = list(csv.reader(open(Nozzle)))119P_table = list(csv.reader(open(Panel)))120PCB_table = list(csv.reader(open(PCBdata)))121122#######################################################################123# Recommends Nozzles to use. Does not change the current nozzles 124# unless a specific nozzle type is missing. 125#######################################################################126def Nozzle_Suggest(import_table,Footprint_Library_table,N_table):127    nozzle_array = ["CN030","CN040","CN065","CN100","CN140","CN220","CN400","CN750"]128129    nozzle_CN030 = 0130    nozzle_CN040 = 0131    nozzle_CN065 = 0132    nozzle_CN100 = 0133    nozzle_CN140 = 0134    nozzle_CN220 = 0135    nozzle_CN400 = 0136    nozzle_CN750 = 0137138    F_col = []139140    for i in range(len(Footprint_Library_table)):141        F_col.append(Footprint_Library_table[i][0])142143    for i in range(1,len(import_table)):144        if(import_table[i][1] not in F_col):145            print_t(import_table[i][1] + " is not in Footprint_Library.csv")146            return False147        index = F_col.index(import_table[i][1])148        if Footprint_Library_table[index][4] == "CN030":149            nozzle_CN030 += 1150        elif Footprint_Library_table[index][4] == "CN040":151            nozzle_CN040 += 1152        elif Footprint_Library_table[index][4] == "CN065":153            nozzle_CN065 += 1154        elif Footprint_Library_table[index][4] == "CN100":155            nozzle_CN100 += 1156        elif Footprint_Library_table[index][4] == "CN140":157            nozzle_CN140 += 1158        elif Footprint_Library_table[index][4] == "CN220":159            nozzle_CN220 += 1160        elif Footprint_Library_table[index][4] == "CN400":161            nozzle_CN400 += 1162        elif Footprint_Library_table[index][4] == "CN750":163            nozzle_CN750 += 1164165    nozzle_CN030round = 0166    nozzle_CN040round = 0167    nozzle_CN065round = 0168    nozzle_CN100round = 0169    nozzle_CN140round = 0170    nozzle_CN220round = 0171    nozzle_CN400round = 0172    nozzle_CN750round = 0173    total = 0174175    total_nozzles = nozzle_CN030 + nozzle_CN040 + nozzle_CN065 + nozzle_CN100 + nozzle_CN140 + nozzle_CN220 + nozzle_CN400 + nozzle_CN750176177    if (nozzle_CN030 > 0):178        nozzle_CN030round = round((nozzle_CN030 / total_nozzles) * 8)179        # If round is 0180        total += nozzle_CN030round181        if nozzle_CN030round == 0:182            nozzle_CN030round += 1183            total += nozzle_CN030round184185    if (nozzle_CN040 > 0):186        nozzle_CN040round = (round((nozzle_CN040 / total_nozzles) * 8))187        total += nozzle_CN040round188        # If round is 0189        if nozzle_CN040round == 0:190            nozzle_CN040round += 1191            total += nozzle_CN040round192193    if (nozzle_CN065 > 0):194        nozzle_CN065round = round((nozzle_CN065 / total_nozzles) * 8)195        total += nozzle_CN065round196        # If round is 0197        if nozzle_CN065round == 0:198            nozzle_CN065round += 1199            total += nozzle_CN065round200201    if (nozzle_CN100 > 0):202        nozzle_CN100round = round((nozzle_CN100 / total_nozzles) * 8)203        total += nozzle_CN100round204        #If round is 0205        if nozzle_CN100round == 0:206            nozzle_CN100round += 1207            total += nozzle_CN100round208209    if (nozzle_CN140 > 0):210        nozzle_CN140round = round((nozzle_CN140 / total_nozzles) * 8)211        # If round is 0212        total += nozzle_CN140round213        if nozzle_CN140round == 0:214            nozzle_CN140round += 1215            total += nozzle_CN140round216217    if (nozzle_CN220 > 0):218        nozzle_CN220round = round((nozzle_CN220 / total_nozzles) * 8)219        total += nozzle_CN220round220        # If round is 0221        if nozzle_CN220round == 0:222            nozzle_CN220round += 1223            total += nozzle_CN220round224225    if (nozzle_CN400 > 0):226        nozzle_CN400round = round((nozzle_CN400 / total_nozzles) * 8)227        total += nozzle_CN400round228        # If round is 0229        if nozzle_CN400round == 0 :230            nozzle_CN400round += 1231            total += nozzle_CN400round232233    if (nozzle_CN750 > 0):234        nozzle_CN750round = round((nozzle_CN750 / total_nozzles) * 8)235        total += nozzle_CN750round236        # If round is 0237        if nozzle_CN750round == 0 :238            nozzle_CN750round += 1239            total += nozzle_CN750round240241    nozzle_total_array = [nozzle_CN030round,nozzle_CN040round,nozzle_CN065round,nozzle_CN100round,nozzle_CN140round,nozzle_CN220round,nozzle_CN400round,nozzle_CN750round]242243    while total > 8:244        index_max = max(range(len(nozzle_total_array)), key=nozzle_total_array.__getitem__)245        nozzle_total_array[index_max] -= 1246        total -= 1247        nozzle_array[index_max]248    while total < 8:249        index_max = max(range(len(nozzle_total_array)), key=nozzle_total_array.__getitem__)250251    nozzle_counter_array = []252    for i in range(len(nozzle_total_array)):253        to_append = []254        to_append.append(nozzle_array[i])255        to_append.append(nozzle_total_array[i])256        nozzle_counter_array.append(to_append)257    nozzle_counter_array.sort(key=lambda x:x[1],reverse=True)258259    nozzle_suggest_array = []260    for i in range(len(nozzle_counter_array)):261        while(nozzle_counter_array[i][1] > 0):262            nozzle_suggest_array.append(nozzle_counter_array[i][0])263            nozzle_counter_array[i][1] -= 1264265    print_t("Recommended Nozzles: " + nozzle_suggest_array[0] + ", " + nozzle_suggest_array[1] + ", " + nozzle_suggest_array[2] + ", " + nozzle_suggest_array[3] + ", " + nozzle_suggest_array[4] + ", " + nozzle_suggest_array[5] + ", " + nozzle_suggest_array[6] + ", " + nozzle_suggest_array[7])266    print_t("Current Nozzles: " + N_table[1][2] + ", " + N_table[2][2] + ", " + N_table[3][2] + ", " + N_table[4][2] + ", " + N_table[5][2] + ", " + N_table[6][2] + ", " + N_table[7][2] + ", " + N_table[8][2])267    window.update()268    window.after(20)269    N_table_array = [N_table[1][2],N_table[2][2],N_table[3][2],N_table[4][2],N_table[5][2],N_table[6][2],N_table[7][2],N_table[8][2]]270    for i in range(len(nozzle_suggest_array)):271        if nozzle_suggest_array[i] not in N_table_array:272            print_t("Using Recommended Nozzles.")273            window.update()274            window.after(20)275            N_table[1][2] = nozzle_suggest_array[0]276            N_table[2][2] = nozzle_suggest_array[1]277            N_table[3][2] = nozzle_suggest_array[2]278            N_table[4][2] = nozzle_suggest_array[3]279            N_table[5][2] = nozzle_suggest_array[4]280            N_table[6][2] = nozzle_suggest_array[5]281            N_table[7][2] = nozzle_suggest_array[6]282            N_table[8][2] = nozzle_suggest_array[7]283            return N_table284    print_t("Using Current Nozzles.")285    window.update()286    window.after(20)            287    return N_table288289#######################################################################290# Checks if footprints and comments are persent in Compdata.csv291# discards component otherwise.292#######################################################################293def Check_footprints_comments(table_check,Compdata_table):294    Compdata_fp_cmnt = []295    table_check_fp_cmnt = []296    discard = []297    check = 0298    for i in range(len(Compdata_table)):299        to_append = []300        to_append.append(Compdata_table[i][0])301        to_append.append(Compdata_table[i][1])302        Compdata_fp_cmnt.append(to_append)303    for i in range(len(table_check)):304        to_append = []305        to_append.append(table_check[i][1])306        to_append.append(table_check[i][10])307        table_check_fp_cmnt.append(to_append) 308        if table_check_fp_cmnt[i] in Compdata_fp_cmnt:309            continue310        else:311            check += 1312            discard.append(i)313            print_t("Discarded "+ table_check[i][1])314            print_t("Add Component '" + table_check_fp_cmnt[i][0] + "' - '" + table_check_fp_cmnt[i][1] + "' to Data/Compdata.csv" )315            window.update()316        window.after(50)    317    for i in range(len(discard)):    318        table_check.remove(table_check[discard[i]])319    320    return table_check321322#######################################################################323# If the Import file is pre-made and only needs the nozzle/feeder324# order to be modified, then this function replaces all the Panel, 325# Mark, PCB, Nozzle data with that the datafile.326#######################################################################327def Existing_Table(table_check,Compdata_table,M_table,N_table,P_table,PCB_table):328    col1 =[]329    import_table = []330    import_table_temp = []331    Compdata_table_temp = []332    for i in range(len(table_check)):333        col1.append(table_check[i][0])334    Compdata_index = col1.index('#Feeder')335    PCB_index = col1.index('#PCB')336    P_index = col1.index('#Panel')337    N_index = col1.index('#Nozzle')338    M_index = col1.index('#Mark')339    Foot_index = col1.index('#Comp')340    Compdata_end = PCB_index - 1341    PCB_end = P_index - 1342    P_end = N_index - 1343    N_end = M_index - 1344    M_end = Foot_index - 1345    Foot_end = len(col1)346347    for i in range(Compdata_index,Compdata_end):348        Compdata_table_temp.append(table_check[i])349    for i in range(PCB_index,PCB_end):350        PCB_table.append(table_check[i])351    for i in range(P_index,P_end):352        P_table.append(table_check[i])353    for i in range(N_index,N_end):354        N_table.append(table_check[i])355    for i in range(M_index,M_end):356        M_table.append(table_check[i])357    for i in range(Foot_index,Foot_end):358        import_table_temp.append(table_check[i])359360    for i in range(len(Compdata_table_temp)):361        to_append = []362        for j in range(6,len(Compdata_table_temp[i])):363            if j != 8:364                to_append.append(Compdata_table_temp[i][j])365        Compdata_table.append(to_append)366367    import_table.append(["Designator","Footprint","Center-X(mm)","Center-Y(mm)","Ref-X(mm)","Ref-Y(mm)","Pad-X(mm)","Pad-Y(mm)","Layer","Rotation","Comment"])368    for i in range(1,len(import_table_temp)):369        to_append = []370        to_append.append(import_table_temp[i][4])371        to_append.append(import_table_temp[i][3])372        to_append.append(import_table_temp[i][6])373        to_append.append(import_table_temp[i][7])374        to_append.append(import_table_temp[i][6])375        to_append.append(import_table_temp[i][7])376        to_append.append(import_table_temp[i][6])377        to_append.append(import_table_temp[i][7])378        to_append.append("Toplayer")379        to_append.append(import_table_temp[i][8])380        to_append.append(import_table_temp[i][2])381        import_table.append(to_append)382    return import_table,Compdata_table,M_table,N_table,P_table,PCB_table383384sourcefile = ''385# Store directory folder in file_location variable386file_location = os.getcwd()387388import_folder = "/Import"389import_file_location = file_location + import_folder390391# Name of the folder where output is stored392new_folder = "/Output"393new_files = file_location + new_folder394395# Check whether the specified path exists or not396isExist = os.path.exists(new_files)397398if not isExist:399  # Create a new directory because it does not exist 400  os.makedirs(new_files)401  print("The new directory is created!")402403Footprint_Nozzle = []404to_fappend = []405for i in range(len(Footprint_Library_table)):406    to_fappend.append(Footprint_Library_table[i][0])407Footprint_Nozzle.append(to_fappend)408to_fappend = []409for i in range(len(Footprint_Library_table)):410    to_fappend.append(Footprint_Library_table[i][4])411Footprint_Nozzle.append(to_fappend)412413#######################################################################414# Measures the distance between each feeder or a feeder and the center415# start is the starting feeder and end is the ending feeder416# if start is set to 0, it is considered to be the center.417#######################################################################418def distance_calc(start,end):419    dist = 0420    t = 0421422    if start == end:423        dist = 0.1424        dist = dist*20.9425        dist = round(dist,2)426        return float(str(round(dist,2)))427428    if start == 0:429        if (end <= 17):430            t = abs(17-end)+2.5431            dist = sqrt(144+(t*t))432            dist = round(dist,2)433        elif (end <= 33):434            t = abs(33-end)+2.5435            dist = sqrt(144+(t*t))436            dist = round(dist,2)437        elif (end <= 50):438            t = abs(50-end)+2.5439            dist = sqrt(144+(t*t))440            dist = round(dist,2)441        elif (end <= 66):442            t = abs(66-end)+2.5443            dist = sqrt(144+(t*t))444            dist = round(dist,2)445        dist = dist*20.9446447        dist = round(dist,2)448        return float(str(round(dist,2)))449450    if (start <= 17):451        if (end <= 17):452            dist = abs(end - start)453        elif (end <= 33):454            dist = abs((end-start))+5455        elif (end <= 50):456            t = abs(end-(start+33))457            dist = sqrt(576+(t*t))458            dist = round(dist,2)459        elif (end <= 66):460            t = abs((end-(start+33)))+5461            dist = sqrt(576+(t*t))462            dist = round(dist,2)463    elif (start <= 33):464        if (end <= 17):465            dist = abs((end - start))+5466        elif (end <= 33):467            dist = abs(end-start)468        elif (end <= 50):469            t = abs((end-(start+33)))+5470            dist = sqrt(576+(t*t))471            dist = round(dist,2)472        elif (end <= 66):473            t = abs(end-(start+33))474            dist = sqrt(576+(t*t))475            dist = round(dist,2)476    elif (start <= 50):477        if (end <= 17):478            t = abs(end-(start-33))479            dist = sqrt(576+(t*t))  480            dist = round(dist,2)        481        elif (end <= 33):482            t = abs((end-(start-33)))+5483            dist = sqrt(576+(t*t)) 484            dist = round(dist,2) 485        elif (end <= 50):486            dist = abs(end - start)487        elif (end <= 66):488            dist = abs((end-start))+5489    elif (start <= 66):490        if (end <= 17):491            t = abs((end-(start-33)))+5492            dist = sqrt(576+(t*t))    493            dist = round(dist,2)      494        elif (end <= 33):495            t = abs(end-(start-33))496            dist = sqrt(576+(t*t))497            dist = round(dist,2)  498        elif (end <= 50):499            dist = abs((end-start))+5500        elif (end <= 66):501            dist = abs(end - start)502    dist = dist*20.9503    dist = round(dist,2)504    return float(str(round(dist,2)))505506def csv_to_lists(r,data):507    list = []508    for i in range(r[0],r[1]):509        a = data[i]510        list.append(a)511    return list512513#######################################################################514# Discards BGA components515#######################################################################516def discard_comp(import_table,Compdata_table):517    discard = []518    footprints = []519    for i in range(1,len(Compdata_table)):520        footprints.append(Compdata_table[i][0])521        522    for i in range(1,len(import_table)):523        if import_table[i][1] == "BGA484C80P22X22_1900X1900X190" or import_table[i][1] == "BGA96C80P16X9_1400X900X120":524            print_t("Discarded "+ import_table[i][1])525            discard.append(i)526527    for i in range(len(discard)):    528        import_table.remove(import_table[discard[i]])529    return import_table530531#######################################################################532# Creates a list (comp_freq) of unique components and how many of each533# there are in the import file.534#######################################################################535def component_frequency(import_table):536    comp_freq = []537    done = []538    temp = [0,0]539    for j in range(1,len(import_table)):540        if j not in done:541            temp[0] = import_table[j][1]542            temp[1] = import_table[j][10]543            count = 0544            to_append = []545            to_append.append(count)546            to_append.append(0)547            for i in range(j,len(import_table)):548                if ((temp[0] == import_table[i][1]) & (temp[1] == import_table[i][10])):549                    count = count + 1550                    to_append.append(i)551                    done.append(i)552            to_append[0] = count553            comp_freq.append(to_append)554    comp_freq.sort(key=lambda x:x[0],reverse=True)555    return comp_freq556557#######################################################################558# Checks if the current nozzle is the correct nozzle to pick up the559# components by comparing it to data from Footprint_Library.csv.560#######################################################################561def nozzle_match(N_table,Footprint_Nozzle,nozzle,designator,import_table):562563    N_type = N_table[nozzle][2]564    footprint_current = import_table[designator][1] # footprint of the input component565    col = Footprint_Nozzle[0].index(footprint_current)566    nozzle_current = Footprint_Nozzle[1][col] # list of all compatible parts with the chosen nozzle567    if nozzle_current == N_type:568        return True569    return False570571#######################################################################572# Returns total number of components.573#######################################################################574def total_components(comp_freq):575    comp_total = 0576    for i in range(len(comp_freq)):577        comp_total = comp_total + comp_freq[i][0]578    return comp_total579580#######################################################################581# Checks is the current nozzle can reach the current feeder582#######################################################################583def nozzle_reach(f,n):584    if ((n == 1) and (((f > 26) and (f < 34)) or (f > 59))):585        return False586    elif ((n == 2) and (((f > 27) and (f < 34)) or (f > 60) or (f < 2) or ((f > 33) and (f < 35)))):587        return False588    elif ((n == 3) and (((f > 28) and (f < 34)) or (f > 61) or (f < 3) or ((f > 33) and (f < 36)))):589        return False590    elif ((n == 4) and (((f > 29) and (f < 34)) or (f > 62) or (f < 4) or ((f > 33) and (f < 37)))):591        return False592    elif ((n == 5) and (((f > 30) and (f < 34)) or (f > 63) or (f < 5) or ((f > 33) and (f < 38)))):593        return False594    elif ((n == 6) and (((f > 31) and (f < 34)) or (f > 64) or (f < 6) or ((f > 33) and (f < 39)))):595        return False596    elif ((n == 7) and (((f > 32) and (f < 34)) or (f > 65) or (f < 7) or ((f > 33) and (f < 40)))):597        return False598    elif ((n == 8) and ((f < 8) or ((f > 33) and (f < 41)))):599        return False600    else:601        return True602603#######################################################################604# Assigns each unique component to each feeder.605# checks if there is not feeder and nozzle mismatch and moves them606# checks for any microSD components and moves them to an empty feeder607# with no adjacent used feeders.608#######################################################################609def comp_feeder_learner(comp_freq_original,import_table,N_table,comp_total,Footprint_Nozzle):610    comp_freq = comp_freq_original611612    mapping_start = [16,15,14,17,13,12,11]613    mapping_original = [18,19,20,21,22,23,24,25,50,51,49,52,48,53,47,54,46,55,45,56,44,57,43,58,10,614    9,26,8,27,7,28,6,29,5,30,4,31,3,32,2,33,1,42,59,41,60,40,61,39,62,38,63,37,64,36,65,35,66,34]615616    mapping = []617    for i in range(len(comp_freq)):618        mapping.append(mapping_original[i])619620    feeder_used = []621    current_feeder = 10622    current_comp = 0623    current_comp_feeder = 0624    current_comp_footprint = 0625    current_comp_nozzle = 0626    counter = 0627    checker = 0628    checker2 = 0629    N_types = []630    microsd = []631    micro = 0632    CN750 = []633    bool = 1634    loop = 0635    j = 0636637    for i in range(len(mapping_start)):638        map = mapping_start[i]       # pick random feeder from list639        f_index = comp_freq[i][2]640        footprint = import_table[f_index][1]641642        if(footprint != "MicroSD_-_DM3C-SF"):643            comp_freq[i][1] = map644            micro = 1645        if(comp_freq[i][1] != 0):646            feeder_used.append(comp_freq[i][1])647648    for i in range(len(mapping_start),len(comp_freq)):649650        map = random.choice(mapping)        # pick random feeder from list651        mapping.remove(map)                 # remove picked feeder to avoid duplicates652        f_index = comp_freq[i][2]653        footprint = import_table[f_index][1]654655        if(footprint != "MicroSD_-_DM3C-SF"):656            comp_freq[i][1] = map657            micro = 1658        if(comp_freq[i][1] != 0):659            feeder_used.append(comp_freq[i][1])660661    for i in range(len(comp_freq)):662        N_types = []663        counter = 0664        checker = 0665        if comp_freq[i][1] != 0:666            current_comp = comp_freq[i][2]667            current_comp_feeder = comp_freq[i][1]668            current_comp_footprint = import_table[current_comp][1]669            index = Footprint_Nozzle[0].index(current_comp_footprint)670            current_comp_nozzle = Footprint_Nozzle[1][index]671            for j in range(len(N_table)):672                if N_table[j][2] == current_comp_nozzle:673                    N_types.append(N_table[j][1])674            for j in range(len(N_types)):675                if (nozzle_reach(current_comp_feeder,int(N_types[j])) is True):676                    checker = 1677                    break          678            while ((checker == 0) and (checker2 == 0)):679                current_comp_feeder = (current_comp_feeder % 66) + 1680                counter += 1681                if (current_comp_feeder not in feeder_used):682                    for l in range(len(N_types)):683                        if (nozzle_reach(current_feeder,int(N_types[l])) is True): 684                            comp_freq[i][1] = current_comp_feeder685                            checker2 = 1686                if(counter > 67):687                    print_t("Too many components. Results may be Inaccurate.")688                    break689690    if micro == 1:691        for i in range(len(N_table)):692            if N_table[i][2] == "CN750":693                CN750.append(N_table[i][1])694        for i in range(len(comp_freq)):695            while comp_freq[i][1] == 0:696                loop += 1697                if (current_feeder not in feeder_used) and ((current_feeder-1) not in feeder_used) and ((current_feeder+1) not in feeder_used):698                    for j in range(len(CN750)):699                        if (nozzle_reach(current_feeder,int(CN750[j])) is not True):700                            current_feeder += 1701                            bool = 0702                    if bool == 1:703                        comp_freq[i][1] = current_feeder704                        current_feeder = 1705                    bool = 1706                else:707                    if(current_feeder >= 66):708                        current_feeder = 1709                    elif(current_feeder < 66):710                        current_feeder += 1711712                    if loop == 1000:713                        comp_freq.remove(comp_freq[i])714                        print_t("Discarded MicroSD_-_DM3C-SF")715                        comp_total = comp_total - 1716                        return comp_freq,comp_total717                             718    return comp_freq,comp_total719720# def comp_feeder_designation(comp_freq_original,import_table,N_table):721#     comp_freq = comp_freq_original722#     mapping = [17,18,16,19,15,20,14,21,13,22,12,23,11,24,10,25,50,51,49,52,48,53,47,54,46,55,45,56,44,57,43,58,723#     9,26,8,27,7,28,6,29,5,30,4,31,3,32,2,33,1,42,59,41,60,40,61,39,62,38,63,37,64,36,65,35,66,34]724#     feeder_used = []725#     current_feeder = 9726#     microsd = []727#     micro = 0728#     CN750 = []729#     bool = 1730#     j = 0731732#     for i in range(len(comp_freq)):733734#         map = mapping[i]735#         f_index = comp_freq[i][2]736#         footprint = import_table[f_index][1]737#         if(footprint != "MicroSD_-_DM3C-SF"):738#             comp_freq[i][1] = map739#             micro = 1740#         if(comp_freq[i][1] != 0):741#             feeder_used.append(comp_freq[i][1])742743#     if micro == 1:744#         for i in range(len(N_table)):745#             if N_table[i][2] == "CN750":746#                 CN750.append(N_table[i][1])747#         for i in range(len(comp_freq)):748#             while comp_freq[i][1] == 0:749#                 if (current_feeder not in feeder_used) and ((current_feeder-1) not in feeder_used) and ((current_feeder+1) not in feeder_used):750#                     for j in range(len(CN750)):751#                         if (nozzle_reach(current_feeder,int(CN750[j])) is not True):752#                             current_feeder += 1753#                             bool = 0754#                     if bool == 1:755#                         comp_freq[i][1] = current_feeder756#                         current_feeder = 1757#                     bool = 1758                    759#                 else:760#                     if(current_feeder >= 66):761#                         current_feeder += 1762#                     else:763#                         exit("Nozzle and Feeder Mismatch!")764                             765#     return comp_freq    766767#######################################################################768# Assigns the picking order of nozzles for each feeder769#######################################################################770def comp_nozzle_designation(comp_total,new_comp,import_table):771    nozzle_amount = 8772    current_nozzle = 1773    left_bottom = 17774    right_bottom = 18775    left_top = 50776    right_top = 51777    comp_total_temp = comp_total778    prev_feeder = 0779    current_feeder = (left_bottom - nozzle_amount) + 1780    new_feeders = []781    nozzle_designation = []782    feeder_loop = 0783    stuck_loop = 0784785    for i in range(len(new_comp)):786        new_feeders.append(new_comp[i][1])787    788    while comp_total > 0:789        790        temp_list = []791        if current_feeder in new_feeders:792            index = new_feeders.index(current_feeder)793                        794            if int(new_comp[index][0]) > 0:795                designator = int(new_comp[index][2])796                if ((nozzle_reach(current_feeder,current_nozzle) is not True) or (nozzle_match(N_table,Footprint_Nozzle,current_nozzle,designator,import_table) is not True)):797                    pass798                else:799                    stuck_loop = 0800                    feeder_loop = 0801                    new_comp[index][0] = int(new_comp[index][0]) - 1802                    temp_list = [new_comp[index][1],new_comp[index][2],current_nozzle]803804                    if len(new_comp[index]) > 2:805                        del new_comp[index][2]806807                    nozzle_designation.append(temp_list)808809                    comp_total = comp_total - 1 810811                    prev_feeder = current_feeder812                    if current_nozzle < nozzle_amount:813                        current_nozzle = current_nozzle + 1814                    elif current_nozzle == nozzle_amount:815                        current_nozzle = 1816                        current_feeder = 10817                        continue818            819        if current_feeder == 9:820            current_feeder = 34821        elif current_feeder == 25:822            current_feeder = 43823        elif current_feeder == 58:824            current_feeder = 1825        elif current_feeder == 42:826            current_feeder = 26827        elif current_feeder == 33:828            current_feeder = 59829        elif current_feeder == 66:830            current_feeder = 10831        else:832            current_feeder = current_feeder + 1833        if feeder_loop > 66:834            if current_nozzle < nozzle_amount:835                current_nozzle = current_nozzle + 1836            elif current_nozzle == nozzle_amount:837                current_nozzle = 1838            feeder_loop = 0839        feeder_loop = feeder_loop + 1840        stuck_loop = stuck_loop + 1841842        if stuck_loop > 5000:843            # print("s")844            return nozzle_designation845    846    return nozzle_designation847848#######################################################################849# update the starting feeder for measuring distance850#######################################################################851def update_distance_starting_position(nid,fid_prev,nid_prev):852    if fid_prev > 0:853        if nid > nid_prev:854            fid_prev = fid_prev + (abs(nid-nid_prev))855        elif nid < nid_prev:856            fid_prev = fid_prev - (abs(nid-nid_prev))857        elif nid == nid_prev:858            pass859    return fid_prev860861#######################################################################862# Runs distance calculations across all the assigned feeders and nozzles863#######################################################################864def total_distance_calc(nozzle_designation):865    filled_nozzle = []866    distance = 0867    fid_prev = 0868    nid_prev = 0869    for i in range(len(nozzle_designation)):870        nid = nozzle_designation[i][2]871        filled_nozzle.append(nid)872        cid = nozzle_designation[i][1]873        fid = nozzle_designation[i][0]874        # Check if we need to move back to the center875        if i > 0:876            if nid < nid_prev:877                fid_prev = 0878                distance = distance + distance_calc(fid_prev,fid)879880        # Moving to next feeder881        fid_prev = update_distance_starting_position(nid,fid_prev,nid_prev)882        distance = distance + distance_calc(fid_prev,fid)883        nid_prev = nid884        fid_prev = fid885886    # last loop to move nozzles back to the center887    distance = distance + distance_calc(fid_prev,fid)888    return distance889890#######################################################################891# Returns feeder data in the required format892#######################################################################893def feeder_output(comp_freq,F_table,Compdata_table,import_table):894    feeder_store = []895    896    for i in range(len(comp_freq)):897        f_index = comp_freq[i][1]898        c = comp_freq[i][2]899        for j in range(1,len(Compdata_table)):900            if ((Compdata_table[j][0] == import_table[c][1]) and (Compdata_table[j][1] == import_table[c][10])):901                c_index = j902        to_append = []903        for j in range(6):904            to_append.append(F_table[f_index][j])905        to_append.append(Compdata_table[c_index][0])906        to_append.append(Compdata_table[c_index][1])907        to_append.append(F_table[f_index][6])908        for j in range(2,len(Compdata_table[c_index])):909            to_append.append(Compdata_table[c_index][j])910        feeder_store.append(to_append)911912    feeder_store.sort(key=lambda x:x[1],reverse=False)913    914    return feeder_store915916#######################################################################917# Returns component data in the required format918#######################################################################919def comp_output(import_table,nozzle_designation):920    header = ['#Comp','Feeder ID','Comment','Footprint','Designatior','NozzleNumber','Pos X','Pos Y','Angle','Skip','Position']921    comp_header = []922    comp_header.append(header)923    for i in range(0,len(nozzle_designation)):924        n = nozzle_designation[i]925        append_list = []926        append_list.append('Comp')927        append_list.append(n[0])928        append_list.append(import_table[n[1]][10])929        append_list.append(import_table[n[1]][1])930        append_list.append(import_table[n[1]][0])931        append_list.append(n[2])932        append_list.append(import_table[n[1]][2])933        append_list.append(import_table[n[1]][3])934        append_list.append(import_table[n[1]][9])935        append_list.append('No')936        append_list.append('Align')   937        comp_header.append(append_list)938    return comp_header939940#######################################################################941# Creates the output csv file942#######################################################################943def full_output(feeder_store,PCB_table,P_table,N_table,M_table,comp_store,sourcefile,sourcefile_import):944    header = ['#Feeder','Feeder ID','Skip','Pos X','Pos Y','Angle','Footprint','Comment','Nozzle','Pick Height','Pick Delay','Move Speed','Place Height','Place Delay','Place Speed','Accuracy',945              'Width','Length','Thickness','Size Analyze','Tray X','Tray Y','Columns','Rows','Right Top X','Right Top Y','Vision Model','Brightness','Vision Error','Vision Flash','Feeder Type','NoisyPoint']946    pre, ext = os.path.splitext(sourcefile_import)947    output = new_files +"/" + pre + "_out" + ext948    outp = pre + "_out" + ext949    with open(output, 'w') as f:950        converted_list = [str(element) for element in header]951        joined_list = ",".join(converted_list)952        f.write(joined_list)953        f.write('\n')          954        for line in feeder_store:955            converted_list = [str(element) for element in line]956            joined_list = ",".join(converted_list)957            f.write(joined_list)958            f.write('\n')   959        f.write('\n')  960        for line in PCB_table:961            converted_list = [str(element) for element in line]962            joined_list = ",".join(converted_list)963            f.write(joined_list)964            f.write('\n')   965        f.write('\n')  966        for line in P_table:967            converted_list = [str(element) for element in line]968            joined_list = ",".join(converted_list)969            f.write(joined_list)970            f.write('\n')  971        f.write('\n')   972        for line in N_table:973            converted_list = [str(element) for element in line]974            joined_list = ",".join(converted_list)975            f.write(joined_list)976            f.write('\n')   977        f.write('\n')  978        for line in M_table:979            converted_list = [str(element) for element in line]980            joined_list = ",".join(converted_list)981            f.write(joined_list)982            f.write('\n')  983        f.write('\n')           984        for line in comp_store:985            converted_list = [str(element) for element in line]986            joined_list = ",".join(converted_list)987            f.write(joined_list)988            f.write('\n')        989    return outp  990991#######################################################################992# Runs the above functions 10000 times and picks the output with993# the shortest distance traveled.994#######################################################################995def shortest_distance(import_table,sourcefile,sourcefile_import,Compdata_table,M_table,N_table,P_table,PCB_table):996    sort_comparison_list = []997    new_comp_store = []998    total_distance = 100000999    prev_total_distance = total_distance1000    loops = 01001    i = 01002    while i < RUNS:1003        import_table = discard_comp(import_table,Compdata_table)1004        comp_freq = component_frequency(import_table)1005        new_comp_store.append(comp_freq)1006        comp_total = total_components(comp_freq)1007        new_comp,comp_total = comp_feeder_learner(comp_freq,import_table,N_table,comp_total,Footprint_Nozzle)10081009        temp_comp = new_comp1010        feeder_store = feeder_output(new_comp,F_table,Compdata_table,import_table)10111012        nozzle_designation = comp_nozzle_designation(comp_total,new_comp,import_table)1013        1014        total_distance = total_distance_calc(nozzle_designation)1015        if int(total_distance) < int(prev_total_distance):1016            prev_total_distance = total_distance10171018            sort_comp = []1019            sort_comp.append(temp_comp)1020            sort_comp.append(total_distance)1021            sort_comp.append(nozzle_designation)1022            sort_comparison_list.append(sort_comp)1023        i = i+11024        1025        loops = loops+110261027    sort_comparison_list.sort(key=lambda x:x[1],reverse=False)10281029    comp_store = comp_output(import_table,sort_comparison_list[0][2])1030    output = full_output(feeder_store,PCB_table,P_table,N_table,M_table,comp_store,sourcefile,sourcefile_import)1031    1032    return sort_comparison_list[0][2],output10331034#######################################################################1035# Same as shortest_distance() but modified for pre-made import files1036#######################################################################1037def shortest_distance_pre(import_table,sourcefile,sourcefile_import,Compdata_table,M_table,N_table,P_table,PCB_table):1038    sort_comparison_list = []1039    new_comp_store = []1040    total_distance = 1000001041    prev_total_distance = total_distance1042    loops = 01043    i = 01044    while i < RUNS:1045        import_table = discard_comp(import_table,Compdata_table)1046        comp_freq = component_frequency(import_table)1047        new_comp_store.append(comp_freq)1048        comp_total = total_components(comp_freq)1049        new_comp,comp_total = comp_feeder_learner(comp_freq,import_table,N_table,comp_total,Footprint_Nozzle)10501051        temp_comp = new_comp1052        feeder_store = feeder_output(new_comp,F_table,Compdata_table,import_table)10531054        nozzle_designation = comp_nozzle_designation(comp_total,new_comp,import_table)1055        1056        total_distance = total_distance_calc(nozzle_designation)1057        if int(total_distance) < int(prev_total_distance):1058            prev_total_distance = total_distance10591060            sort_comp = []1061            sort_comp.append(temp_comp)1062            sort_comp.append(total_distance)1063            sort_comp.append(nozzle_designation)1064            sort_comparison_list.append(sort_comp)1065        i = i+11066        1067        loops = loops+110681069    sort_comparison_list.sort(key=lambda x:x[1],reverse=False)10701071    comp_store = comp_output(import_table,sort_comparison_list[0][2])1072    output = full_output(feeder_store,PCB_table,P_table,N_table,M_table,comp_store,sourcefile,sourcefile_import)1073    1074    return sort_comparison_list[0][2],output107510761077##############################################################################################################################################1078# SIMULATION1079##############################################################################################################################################1080outline = "#000"1081fill = "#ffe"10821083#######################################################################1084# Update the feeder nozzle and component counters. components 1085# uses the footprint from import_table1086#######################################################################1087def update_counters(import_table,canvas,fid,nid,cid,canvas_counters,reset):1088    if reset:1089        canvas.itemconfig(canvas_counters[1], text="0")1090        canvas.itemconfig(canvas_counters[2], text="0")1091        canvas.itemconfig(canvas_counters[3], text="none") 1092        return1093    cid_footprint = import_table[cid][1]1094    canvas.itemconfig(canvas_counters[1], text=str(fid))1095    canvas.itemconfig(canvas_counters[2], text=str(nid))1096    canvas.itemconfig(canvas_counters[3], text=str(cid_footprint))10971098def update_distance(canvas,distance,canvas_counters):1099    d = distance1100    d = round(d,2)1101    canvas.itemconfig(canvas_counters[0], text=str(d)+" mm")11021103def update_remaining_feeders(canvas,fid,remaining_feeders,feeder_canvas):1104    if int(fid) in remaining_feeders:1105        canvas.itemconfig(feeder_canvas[fid], fill='yellow')1106    elif int(fid) not in remaining_feeders:1107        canvas.itemconfig(feeder_canvas[fid], fill=fill)11081109def update_distance_starting_position(nid,fid_prev,nid_prev):1110    if fid_prev > 0:1111        if nid > nid_prev:1112            fid_prev = fid_prev + (abs(nid-nid_prev))1113        elif nid < nid_prev:1114            fid_prev = fid_prev - (abs(nid-nid_prev))1115        elif nid == nid_prev:1116            pass1117    return fid_prev1118    11191120#######################################################################1121# Moves all 8 nozzles to (x_move,y_move). id is the number of nozzle1122# picking up.1123#######################################################################1124def animate_moveto(canvas,nozzle_canvas,id,n_c,x_move, y_move):1125    x = x_move1126    y = y_move1127    for i in range(id,len(n_c)):1128        canvas.moveto(n_c[i],x,y)1129        x = x + 231130    x = x_move1131    for i in range(id-1,0,-1):1132        x = x - 231133        canvas.moveto(nozzle_canvas[i],x,y)113411351136#######################################################################1137# Module to animate the nozzles picking up up the components for the1138# feeders based on their nozzle_designation1139#######################################################################1140def nozzle_animation(nozzle_designation,import_table):11411142    # Creating tkinter canvas and drawing all objects (feeder, nozzle, pcb, counters)1143    ws = tk.Tk()1144    ws.title('K1830 Simulation')1145    ws.geometry('1000x600')1146    ws.config(bg='#345')11471148    canvas = Canvas(1149        ws,1150        height=600,1151        width=1000,1152        bg="#ddd"1153        )11541155    canvas.pack()11561157    feeder_canvas = [0]1158    nozzle_canvas = [0]1159    x0 = 501160    x1 = x0 + 181161    y0 = 5001162    y1 = y0 - 6011631164    def draw_nozzles(start,end,x0, y0, x1, y1, nozzle_canvas):1165        for i in range(start,end):1166            n = canvas.create_oval(x0, y0, x1, y1, outline=outline, fill=fill)1167            data = [n,x0,y0,x1,y1]1168            nozzle_canvas.append(n)1169            x0 = x0 + 231170            x1 = x0 + 181171        return nozzle_canvas11721173    def draw_feeders(start,end,x0, y0, x1, y1, feeder_canvas):1174        st_x0 = x01175        st_x1 = x11176        for i in range(start,end):1177            f  = canvas.create_rectangle(x0, y0, x1, y1, outline=outline, fill=fill)1178            data = [f,x0,y0,x1,y1]1179            feeder_canvas.append(f)1180            x0 = x0 + 231181            x1 = x0 + 181182        return x0, y0, x1, y1, feeder_canvas11831184    def draw_feeders_label(start,end,x0, y0, x1, y1):1185        for i in range(start,end):1186            if i >= 34:1187                canvas.create_text((x0+9, y0-10), text=str(i))1188            else:1189                canvas.create_text((x0+9, y0-50), text=str(i))1190            x0 = x0 + 231191            x1 = x0 + 181192        return x0, y0, x1, y111931194    def pause_sim(pause_keyboard,RUN_or_PAUSE):1195        canvas.itemconfig(RUN_or_PAUSE, text="Press 'r' to RUN")1196        canvas.update()1197        canvas.after(50)1198        while pause_keyboard == True:1199            if keyboard.is_pressed('r'):1200                pause_keyboard = False1201        canvas.itemconfig(RUN_or_PAUSE, text="Press 'p' to PAUSE") 1202        return pause_keyboard12031204    x0, y0, x1, y1, feeder_canvas = draw_feeders(1,18,x0, y0, x1, y1, feeder_canvas)12051206    x0 = x0 + 1501207    x1 = x0 + 181208    x0, y0, x1, y1, feeder_canvas = draw_feeders(18,34,x0, y0, x1, y1, feeder_canvas)12091210    x0 = 501211    x1 = x0 + 181212    y0 = 1501213    y1 = y0 - 601214    x0, y0, x1, y1, feeder_canvas = draw_feeders(34,51,x0, y0, x1, y1, feeder_canvas)12151216    x0 = x0 + 1501217    x1 = x0 + 181218    x0, y0, x1, y1, feeder_canvas = draw_feeders(51,67,x0, y0, x1, y1, feeder_canvas)12191220    x0 = 501221    x1 = x0 + 181222    y0 = 5001223    y1 = y0 - 601224    x0, y0, x1, y1 = draw_feeders_label(1,18,x0, y0, x1, y1)12251226    x0 = x0 + 1501227    x1 = x0 + 181228    x0, y0, x1, y1 = draw_feeders_label(18,34,x0, y0, x1, y1)12291230    x0 = 501231    x1 = x0 + 181232    y0 = 1501233    y1 = y0 - 601234    x0, y0, x1, y1 = draw_feeders_label(34,51,x0, y0, x1, y1)12351236    x0 = x0 + 1501237    x1 = x0 + 181238    x0, y0, x1, y1 = draw_feeders_label(51,67,x0, y0, x1, y1)12391240    x0 = 4251241    x1 = x0 + 181242    y0 = 2801243    y1 = y0 + 181244    nozzle_canvas = draw_nozzles(1,9,x0, y0, x1, y1, nozzle_canvas)12451246    x0 = 1801247    y0_text = 5501248    canvas.create_text(x0,y0_text,fill="black",font="Arial 12 bold",1249                            text="Total Distance:")1250    counter_d = canvas.create_text(x0+65,y0_text,fill="black",font="Arial 12 bold",anchor="w",1251                            text="0.00 mm")12521253    x0 = x0 + 3401254    canvas.create_text(x0,y0_text,fill="black",font="Arial 12 bold",1255                            text="Feeder: ")1256    counter_f = canvas.create_text(x0+35,y0_text,fill="black",font="Arial 12 bold",anchor="w",1257                            text="0")12581259    x0 = x0 + 1201260    canvas.create_text(x0,y0_text,fill="black",font="Arial 12 bold",1261                            text="Nozzle: ")1262    counter_n = canvas.create_text(x0+35,y0_text,fill="black",font="Arial 12 bold",anchor="w",1263                            text="0")12641265    x0 = x0 + 1201266    canvas.create_text(x0,y0_text,fill="black",font="Arial 12 bold",1267                            text="Comp: ")1268    counter_c = canvas.create_text(x0+35,y0_text,fill="black",font="Arial 12 bold",anchor="w",1269                            text="none")12701271    canvas_counters = [counter_d,counter_f,counter_n,counter_c]12721273    RUN_or_PAUSE = canvas.create_text(835,30,fill="black",font="Arial 12 bold",text="Press 'p' to PAUSE")12741275    remaining_feeders = []1276    for i in range(len(nozzle_designation)):1277        remaining_feeders.append(nozzle_designation[i][0])1278        canvas.itemconfig(feeder_canvas[nozzle_designation[i][0]], fill='yellow')1279    filled_nozzle = []1280    distance = 01281    fid_prev = 01282    nid_prev = 01283    pause_keyboard = False1284    canvas.update()1285    canvas.after(2000)1286    for i in range(len(nozzle_designation)):1287        if keyboard.is_pressed('p'):1288            pause_keyboard = True 1289            canvas.update()1290            canvas.after(30)1291        nid = nozzle_designation[i][2]1292        filled_nozzle.append(nid)1293        cid = nozzle_designation[i][1]1294        fid = nozzle_designation[i][0]1295        # Check if we need to move back to the center1296        if i > 0:1297            if nid < nid_prev:1298                fid_prev = 01299                if keyboard.is_pressed('p'):1300                    pause_keyboard = True 1301                    canvas.update()1302                    canvas.after(30)              1303                distance = distance + distance_calc(fid_prev,fid)1304                update_distance(canvas,distance,canvas_counters)1305                for j in range(len(filled_nozzle)):1306                    fnid = filled_nozzle[j]1307                    canvas.itemconfig(nozzle_canvas[fnid], fill='green')1308                x0,y0 = 425,2801309                animate_moveto(canvas,nozzle_canvas,1,nozzle_canvas,x0, y0)1310                canvas.update()1311                canvas.after(300) 1312                for j in range(len(filled_nozzle)-1):1313                    fnid = filled_nozzle[j]1314                    canvas.itemconfig(nozzle_canvas[fnid], fill=fill)1315                filled_nozzle = [nid]13161317        # Moving to next feeder1318        x0,y0,x1,y1 = canvas.coords(feeder_canvas[fid])1319        if fid >= 34:1320            y0 = y1 + 51321        else:1322            y0 = y0 - 251323        fid_prev = update_distance_starting_position(nid,fid_prev,nid_prev)1324        update_counters(import_table,canvas,fid,nid,cid,canvas_counters,0)1325        distance = distance + distance_calc(fid_prev,fid)1326        update_distance(canvas,distance,canvas_counters)1327        canvas.itemconfig(nozzle_canvas[nid], fill='green')1328        canvas.itemconfig(feeder_canvas[fid], fill='green')1329        animate_moveto(canvas,nozzle_canvas,nid,nozzle_canvas,x0, y0)1330        if pause_keyboard == True:1331            pause_keyboard = pause_sim(pause_keyboard,RUN_or_PAUSE)1332        canvas.update()1333        canvas.after(300)1334        canvas.itemconfig(nozzle_canvas[nid], fill=fill)1335        remaining_feeders.pop(0)1336        update_remaining_feeders(canvas,fid,remaining_feeders,feeder_canvas)13371338        # canvas.itemconfig(feeder_canvas[fid], fill=fill)1339        nid_prev = nid1340        fid_prev = fid134113421343    # last loop to move nozzles back to the center1344    for j in range(len(filled_nozzle)):1345        fnid = filled_nozzle[j]1346        canvas.itemconfig(nozzle_canvas[fnid], fill='green')1347    x0,y0 = 425,2801348    animate_moveto(canvas,nozzle_canvas,1,nozzle_canvas,x0, y0)1349    canvas.update()1350    canvas.after(700)   1351    for j in range(len(filled_nozzle)):1352        fnid = filled_nozzle[j]1353        canvas.itemconfig(nozzle_canvas[fnid], fill=fill)1354    filled_nozzle = []    1355    update_counters(import_table,canvas,fid,nid,cid,canvas_counters,1)1356    distance = distance + distance_calc(fid_prev,fid)1357    update_distance(canvas,distance,canvas_counters)1358    print_t("Simulation Complete")1359    ws.mainloop()136013611362##############################################################################################################################################1363# USER INTERFACE1364##############################################################################################################################################1365window = tk.Tk()13661367text = tk.Text(window)1368text.pack()1369text.place(x=30,y=325,height=210,width=615)13701371# Basic setup of window1372window.title("K1830 Pick and Place")1373window.geometry("680x550")1374window.resizable(False, False)13751376# Text in the window1377label1 = Label(window,1378               text="Choose a File",1379               font=("Arial bold", 22),1380               )1381label1.place(x=30,y=30)13821383# Showing files in the folder1384file_view = tk.Listbox(window,width=42,height= 9,font=(11))1385file_view.place(x=30,y=80)13861387for items in os.listdir(import_file_location):1388    if items.endswith(".csv"):      # Only shows csv files1389        file_view.insert(0, items)13901391# Function to run the optimization from pre-existing import file1392def run_program_pre(sourcefile,sourcefile_import,import_table,Compdata_table,M_table,N_table,P_table,PCB_table):1393    nozzle_designation,output = shortest_distance_pre(import_table,sourcefile,sourcefile_import,Compdata_table,M_table,N_table,P_table,PCB_table)1394    return nozzle_designation, import_table, output13951396# Function to run the optimization from import file1397def run_program(sourcefile,sourcefile_import,import_table,Compdata_table,M_table,N_table,P_table,PCB_table):1398    import_table = list(csv.reader(open(sourcefile)))1399    import_table = Check_footprints_comments(import_table,Compdata_table)1400    nozzle_designation,output = shortest_distance(import_table,sourcefile,sourcefile_import,Compdata_table,M_table,N_table,P_table,PCB_table)1401    return nozzle_designation, import_table, output14021403# Function for storing the selected listbox value and then runs run_program1404def selected_item(Compdata_table,M_table,N_table,P_table,PCB_table):1405    sourcefile = ''1406    for i in file_view.curselection():1407        sourcefile = "Import/" + file_view.get(i)1408        sourcefile_import = file_view.get(i)1409    if sourcefile == '':1410        print_t("Please Select a CSV file.")1411        return1412    table_check = list(csv.reader(open(sourcefile)))1413    if table_check[0][0] == "#Feeder":1414        Compdata_table,M_table,N_table,P_table,PCB_table = [],[],[],[],[]1415        import_table,Compdata_table,M_table,N_table,P_table,PCB_table = Existing_Table(table_check,Compdata_table,M_table,N_table,P_table,PCB_table)1416        print_t("Running optimization on '" + sourcefile_import + "'")1417        window.update()1418        window.after(20) 1419        x,y,output = run_program_pre(sourcefile,sourcefile_import,import_table,Compdata_table,M_table,N_table,P_table,PCB_table)1420        print_t("Done. Result '" + output + "' stored in Output folder")14211422    elif table_check[0][0] != "Designator":1423        print_t(sourcefile_import + " is not in the correct format.")1424        return1425    else:1426        print_t("Running optimization on '" + sourcefile_import + "'")1427        window.update()1428        window.after(20) 1429        N_table = Nozzle_Suggest(table_check,Footprint_Library_table,N_table)1430        x,y,output = run_program(sourcefile,sourcefile_import,table_check,Compdata_table,M_table,N_table,P_table,PCB_table)1431        print_t("Done. Result '" + output + "' stored in Output folder")14321433# Function for storing the selected listbox value and then runs run_simulation1434def selected_item_sim(Compdata_table,M_table,N_table,P_table,PCB_table):1435    sourcefile = ''1436    for i in file_view.curselection():1437        sourcefile = "Import/" + file_view.get(i)1438        sourcefile_import = file_view.get(i)1439    if sourcefile == '':1440        print_t("Please Select a CSV file.")1441        return1442    table_check = list(csv.reader(open(sourcefile)))1443    if table_check[0][0] == "#Feeder":1444        Compdata_table,M_table,N_table,P_table,PCB_table = [],[],[],[],[]1445        import_table,Compdata_table,M_table,N_table,P_table,PCB_table = Existing_Table(table_check,Compdata_table,M_table,N_table,P_table,PCB_table)1446        print_t("Running Simulation on '" + sourcefile_import + "'")1447        window.update()1448        window.after(20) 1449        nozzle_designation,import_table,x = run_program_pre(sourcefile,sourcefile_import,import_table,Compdata_table,M_table,N_table,P_table,PCB_table)1450    elif table_check[0][0] != "Designator":1451        print_t(sourcefile_import + " is not in the correct format.")1452        return1453    else:1454        print_t("Running Simulation on '" + sourcefile_import + "'")1455        window.update()1456        window.after(20) 1457        N_table = Nozzle_Suggest(table_check,Footprint_Library_table,N_table)1458        nozzle_designation,import_table,x = run_program(sourcefile,sourcefile_import,table_check,Compdata_table,M_table,N_table,P_table,PCB_table)14591460    nozzle_animation(nozzle_designation,import_table)1461    14621463# Exits the program1464def Exit():1465    sys.exit("Done")14661467img_run = PhotoImage(file = file_location + '/Images/Run.png')1468img_run = img_run.zoom(10)1469img_run = img_run.subsample(64)1470button1 = tk.Button(window, text='Run Program',image = img_run,command=lambda: selected_item(Compdata_table,M_table,N_table,P_table,PCB_table))1471button1.place(x=542,y=20)1472button1_ttp = CreateToolTip(button1, \1473    "Run Optimization")147414751476img_sim = PhotoImage(file = file_location + '/Images/Sim.png')1477img_sim = img_sim.zoom(10)1478img_sim = img_sim.subsample(64)1479button2 = tk.Button(window, text='Run Simulation',image = img_sim,command=lambda: selected_item_sim(Compdata_table,M_table,N_table,P_table,PCB_table))1480button2.place(x=542,y=135)1481button2_ttp = CreateToolTip(button2, \1482    "Run Simulation")14831484img_exit = PhotoImage(file = file_location + '/images/Exit.png')1485img_exit = img_exit.zoom(6)1486img_exit = img_exit.subsample(64)1487button3 = tk.Button(window, text='Exit',image = img_exit,command=lambda: Exit(),anchor=E)1488button3.grid(row = 2, column = 6,sticky="ne",rowspan=4)1489button3.place(x=580,y=250)1490button3_ttp = CreateToolTip(button3, \1491    "Exit")14921493# Defining infinite loop
...

cartodb.py

Source:cartodb.py

...35                     sql_url,36                     CDB_USER,37                     CDB_KEY))38@task39def import_table(relpath, tablename):40    '''import a table to cartodb'''41    with lcd(cwd):42        execute(run_query, drop_sql(tablename))43        with hide('running'):44            local('%s/import_csv_cartodb.sh %s/%s/%s.csv %s %s'45                  % (scripts_path,46                     data_path,47                     relpath,48                     tablename,49                     CDB_USER,50                     CDB_KEY))51@task52@runs_once53def import_common():...

import.py

Source:import.py

...65    #                             '9ace7c8c-55b4-4c5d-9aa8-e573a5dde9ad')66    #67    # time3 = datetime.now()68    # print(str(time3 - time2))69    # importer.import_table('enum_area_type_values')70    # importer.import_table('area')71    # importer.import_table('enum_artist_alias_type_values')72    # importer.import_table('enum_artist_type_values')73    # importer.import_table('enum_release_group_type_values')74    # importer.import_table('enum_release_status_values')75    # importer.import_table('enum_language_values')76    # importer.import_table('enum_gender_values')77    # importer.import_table('enum_medium_format_values')78    # importer.import_table('enum_work_type_values')79    # importer.import_table('enum_place_type_values')80    # importer.import_table('enum_series_type_values')81    # importer.import_table('enum_label_type_values')82    # importer.import_table('artist', artists)83    # importer.import_table('artist')84    # importer.import_table('artist_credit')85    # importer.import_table('release_group')86    # importer.import_table('release')87    # importer.import_table('medium')88    # importer.import_table('recording')89    # importer.import_table('track')90    # importer.import_table('work')91def main():92    main_parser = argparse.ArgumentParser(93        description='Import data from MusicBrainz DB dumps',94        formatter_class=argparse.RawTextHelpFormatter)95    sps = main_parser.add_subparsers(96        dest='command', metavar='command',97        help='''The following commands are available: update-dump, import''')98    parser = sps.add_parser('update-dump',99                            description='Download the latest '100                            'MusicBrainz DB dump')101    parser.add_argument('--verbose', dest='verbose', action='store_true',102                        help='Be verbose')103    parser = sps.add_parser('import',104                            description='Import data from the MB DB dump')...

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.