SQL Server2008 數據庫誤刪除數據的恢復辦法分享

SQL Server2008 數據庫誤刪除數據的恢復辦法分享。本站提示廣大學習愛好者：（SQL Server2008 數據庫誤刪除數據的恢復辦法分享）文章只能為提供參考，不一定能成為您想要的結果。以下是SQL Server2008 數據庫誤刪除數據的恢復辦法分享正文

本文實例講述了python刪除過時文件的辦法。分享給年夜家供年夜家參考。詳細完成辦法以下：

# remove all jpeg image files of an expired modification date = mtime
# you could also use creation date (ctime) or last access date (atime)
# os.stat(filename) returns (mode, ino, dev, nlink, uid, gid, size, atime, mtime, ctime)
# tested with Python24  vegaseat 6/7/2005
import os, glob, time
root = 'D:\\Vacation\\Poland2003\\' # one specific folder
#root = 'D:\\Vacation\\*'     # or all the subfolders too
# expiration date in the format YYYY-MM-DD
xDate = '2003-12-31'
print '-'*50
for folder in glob.glob(root):
  print folder
  # here .jpg image files, but could be .txt files or whatever
  for image in glob.glob(folder + '/*.jpg'):
    # retrieves the stats for the current jpeg image file
    # the tuple element at index 8 is the last-modified-date
    stats = os.stat(image)
    # put the two dates into matching format  
    lastmodDate = time.localtime(stats[8])
    expDate = time.strptime(xDate, '%Y-%m-%d')
    print image, time.strftime("%m/%d/%y", lastmodDate)
    # check if image-last-modified-date is outdated
    if expDate > lastmodDate:
      try:
        print 'Removing', image, time.strftime("(older than %m/%d/%y)", expDate)
        #os.remove(image) # commented out for testing
      except OSError:
        print 'Could not remove', image

願望本文所述對年夜家的Python法式設計有所贊助。