recipe-576534.py 文件源码

def add_ver_info(separate_files, connect_string, username):
    """add version information"""
    f = None
    if separate_files:
        ver_file = os.path.join(SCHEMA_DIR, 'version.txt')
        f = open_file_write(ver_file)
    title = 'info'
    print_start_info(title)
    output_line('date: %s' % (time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())), f)
    output_line('connect string: %s' % (connect_string), f)
    output_line('user: %s' % (username), f)
    script_ver = __version__[5:-2]
    output_line('created by: %s' % (script_ver), f)
    print_stop_info(title)
    show_qry('DB version', DB_VERSION_SQL, fout=f)
    show_qry('DB name', 'SELECT ora_database_name FROM dual', fout=f)
    sel_info_option = '--ver-info-sql'
    for s in sys.argv[1:]:
        if s.startswith(sel_info_option):
            sel = s[len(sel_info_option):].strip('=')
            try:
                show_qry(sel, sel, fout=f)
            except:
                ex_info = traceback.format_exc()
                serr = '\nSQL: %s\nException: %s\n' % (sel, ex_info)
                print_err(serr)
            break
    show_qry('DB features used', FEATURE_USAGE_SQL, fout=f)
    if f:
        f.close()