首页 > 代码库 > 第二周作业__增删改查

第二周作业__增删改查

<style type="text/css">html,body,div,span,applet,object,iframe,h1,h2,h3,h4,h5,h6,p,blockquote,pre,a,abbr,acronym,address,big,cite,code,del,dfn,em,img,ins,kbd,q,s,samp,small,strike,strong,sub,sup,tt,var,b,u,i,center,dl,dt,dd,ol,ul,li,fieldset,form,label,legend,table,caption,tbody,tfoot,thead,tr,th,td,article,aside,canvas,details,embed,figure,figcaption,footer,header,hgroup,menu,nav,output,ruby,section,summary,time,mark,audio,video { margin: 0; padding: 0; border: 0 } body { font-family: Helvetica, arial, freesans, clean, sans-serif; font-size: 14px; line-height: 1.6; color: #333; background-color: #fff; padding: 20px; max-width: 960px; margin: 0 auto } body>*:first-child { margin-top: 0 !important } body>*:last-child { margin-bottom: 0 !important } p,blockquote,ul,ol,dl,table,pre { margin: 15px 0 } h1,h2,h3,h4,h5,h6 { margin: 20px 0 10px; padding: 0; font-weight: bold } h1 tt,h1 code,h2 tt,h2 code,h3 tt,h3 code,h4 tt,h4 code,h5 tt,h5 code,h6 tt,h6 code { font-size: inherit } h1 { font-size: 28px; color: #000 } h2 { font-size: 24px; border-bottom: 1px solid #ccc; color: #000 } h3 { font-size: 18px } h4 { font-size: 16px } h5 { font-size: 14px } h6 { color: #777; font-size: 14px } body>h2:first-child,body>h1:first-child,body>h1:first-child+h2,body>h3:first-child,body>h4:first-child,body>h5:first-child,body>h6:first-child { margin-top: 0; padding-top: 0 } a:first-child h1,a:first-child h2,a:first-child h3,a:first-child h4,a:first-child h5,a:first-child h6 { margin-top: 0; padding-top: 0 } h1+p,h2+p,h3+p,h4+p,h5+p,h6+p { margin-top: 10px } a { color: #4183C4; text-decoration: none } a:hover { text-decoration: underline } ul,ol { padding-left: 30px } ul li>:first-child,ol li>:first-child,ul li ul:first-of-type,ol li ol:first-of-type,ul li ol:first-of-type,ol li ul:first-of-type { margin-top: 0px } ul ul,ul ol,ol ol,ol ul { margin-bottom: 0 } dl { padding: 0 } dl dt { font-size: 14px; font-weight: bold; font-style: italic; padding: 0; margin: 15px 0 5px } dl dt:first-child { padding: 0 } dl dt>:first-child { margin-top: 0px } dl dt>:last-child { margin-bottom: 0px } dl dd { margin: 0 0 15px; padding: 0 15px } dl dd>:first-child { margin-top: 0px } dl dd>:last-child { margin-bottom: 0px } pre,code,tt { font-size: 12px; font-family: Consolas, "Liberation Mono", Courier, monospace } code,tt { margin: 0 0px; padding: 0px 0px; white-space: nowrap; border: 1px solid #eaeaea; background-color: #f8f8f8 } pre>code { margin: 0; padding: 0; white-space: pre; border: none; background: transparent } pre { background-color: #f8f8f8; border: 1px solid #ccc; font-size: 13px; line-height: 19px; overflow: auto; padding: 6px 10px } pre code,pre tt { background-color: transparent; border: none } kbd { background-color: #DDDDDD; background-image: linear-gradient(#F1F1F1, #DDDDDD); background-repeat: repeat-x; border-color: #DDDDDD #CCCCCC #CCCCCC #DDDDDD; border-style: solid; border-width: 1px; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; line-height: 10px; padding: 1px 4px } blockquote { border-left: 4px solid #DDD; padding: 0 15px; color: #777 } blockquote>:first-child { margin-top: 0px } blockquote>:last-child { margin-bottom: 0px } hr { clear: both; margin: 15px 0; height: 0px; overflow: hidden; border: none; background: transparent; border-bottom: 4px solid #ddd; padding: 0 } table th { font-weight: bold } table th,table td { border: 1px solid #ccc; padding: 6px 13px } table tr { border-top: 1px solid #ccc; background-color: #fff } table tr:nth-child(2n) { background-color: #f8f8f8 } img { max-width: 100% }</style>

增删改查

def add ():
    d = query()
    add = input("please input proxy your add:")
    count = 0
    f_first.seek(0)
    for line in f_first:
        if count == d[max(d)] :
            f_second.write("\t\t"+add+"\n")
        f_second.write(line)
        count +=1
def change ():
    d = query()
    old = input("please input proxy your choice:")
    new = input("please input new proxy;")
    count = 0
    f_first.seek(0)
    for line in f_first:
        count +=1
        if count == d[old] :
            f_second.write("\t\t" + new + "\n")
            continue
        f_second.write(line)
def delete():
    d = query()
    delete = input("please input proxy your want delete:")
    count = 0
    f_first.seek(0)
    for line in f_first:
        count += 1
        if count == d[delete]:
            continue
        f_second.write(line)
def query ():
    d = {}
    flag = False
    url = input("please input url:")
    count = 0
    for line in f_first:
        count += 1
        if line.startswith("backend") and url in line:
            flag = True
            continue
        if line.startswith("backend") and flag:
            flag = False
        if flag:
            d[line.strip()] = count
    for i in d:
        print(i)
    return d
def main ():
    menu = {1: "add", 2: "delete", 3: "change", 4: "query",5:"quit"}
    for i in range(1,6):
        print (i,menu[i])
    action = int(input("choice:"))
    if action ==5:quit()
    list_url = []
    with  open("haproxy.conf", encoding="utf8") as f_first:
        for line in f_first:
            if line.startswith("backend"):
                list_url.append(line.strip())
    for i in list_url:
        print (i.split(" ")[1])
    return action
import os
with  open("haproxy.conf", encoding="utf8") as f_first, open("haproxy1.conf", mode="w+",
                                                             encoding="utf8") as f_second:
    choice = main ()
    if choice == 1 : add()
    if choice == 2 : delete()
    if choice == 3 : change()
    if choice == 4 : query ()

os.rename("haproxy.conf","haproxy_bak.conf")
os.rename("haproxy1.conf","haproxy.conf")

第二周作业__增删改查