PyMSSQL/show.py

#coding=utf-8

from Diff import *



if __name__ == '__main__':

    #table
    tables,cols=FindNotIn()
    print("\n2016缺少的表:")
    print("-"*10)
    for t in tables:
        print("- "+t)
    print("\n2016缺少的字段:")
    print("-"*10)
    for c in cols.items():
        print("- %s:%s" %(c[0],c[1]))

    #tri
    tri,trisame=FindNotIn_TR_P_FN("TR")
    print("\n2016缺少的触发器:")
    print("-"*10)
    for t in tri:
        print("- "+t)
    print("\n与2016不一样的触发器:")
    print("-"*10)
    for t in trisame:
        print("- "+t)

    #proc
    proc,procsame=FindNotIn_TR_P_FN("P")
    print("\n2016缺少的存储过程:")
    print("-"*10)
    for p in proc:
        print("- "+p)
    print("\n与2016不一样的存储过程:")
    print("-"*10)
    for p in procsame:
        print("- "+p)

    #FN
    fn,fnsame=FindNotIn_TR_P_FN("FN")
    print("\n2016缺少的函数:")
    print("-"*10)
    for f in fn:
        print("- "+f)
    print("\n与2016不一样的函数:")
    print("-"*10)
    for f in fnsame:
        print("- "+f)