import os, time
import datetime
import re
from difflib import ndiff
import ftplib
import cx_Oracle

direct = 'C:/Users/Documents/new'
files = []
listing = []
delta = []
 
#ftp = ftplib.FTP('127.0.0.1')
#ftp.login(user='user', passwd='pwd')
#ftp.cwd("dir")
#entries = ftp.nlst()
#for entry in entries:
#    size = ftp.size(entry)
#    sizename = str(size) + ' ' + entry
#    listing.append(sizename)
#ftp.quit()

#fileone = open(r'C:/Users/Documents/new/otchtwo.txt', 'w')
#for i in listing:
#    if 'ABC' in i:
#        fileone.write(i + '\n')
#fileone.close()


full = os.listdir(direct)
for filenames in full:
    fullname = os.path.join(direct, filenames)
    Filesize = os.path.getsize(fullname)
    Full = str(Filesize) + ' ' + filenames
    if filenames.startswith('ABC'):
        files.append(Full)
fout = open('C:/Users/Documents/new/otch.txt', 'w') 
for line in files:
    fout.write(line + '\n')
fout.close()

t1 = open('C:/Users/Documents/new/otch.txt')
t2 = open('C:/Users/Documents/new/otchtwo.txt')
diff = ndiff(t1.readlines(), t2.readlines())
for x in diff:
    if x.startswith('- '):
        xnew = x.replace('- ', '(')
        delta.append(xnew.replace ('\n', ')'))
print delta
filetwo = open('C:/Users/Documents/new/otchthree.txt', 'w')
filetwo.writelines(delta)
filetwo.close()
t2.close()
t1.close()

con = cx_Oracle.connect('user/123456@127.0.0.1/mybase')
cur = con.cursor()
cur.executemany("insert into table (ID_FILE, NAME_FILE, DATE) values (diff_seq.nextval, :1, sysdate)", delta)
con.commit()
cur.close()
con.close()