前段时间用python写了一个小脚本,来获取指定目录输的详细信息,并存进Oracle中,第一次写博客和大家分享一下,目前还有一些不足之处,希望大家多多交流指正,直接贴上代码
# coding=gbk
# encoding:utf-8
# -*- coding:gb2312 -*-
import sys
import os
import os.path
import pandas as pd
import cx_Oracle
from sqlalchemy import create_engine
from datetime import datetime, date, timedelta
import time
import numba as nb
Dirlist=[]
DirSizelist=[]
Pathlist=[]
FileNumlist = []
Timekeylist = []
Processoperationnamelist = []
homedir = r'S:\。。。' # 需要访问的文件夹地址
def formatSize(bytes):
"""文件字节大小统一处理为数据容量,单位:M"""
try:
byt = float(bytes)
MB = round(byt / 1024 / 1024, 3)
return MB
except:
print("传入的字节格式不对")
return "Error"
def get_size(filedir):
tree = os.walk(filedir, topdown=False)
dirsize = 0
f