Python-сообщество

def insert_csvfile():
    import calendar, csv, codecs
    import psycopg2
    db=psycopg2.connect("host='localhost' dbname='tvprogram' user='postgres' password='abcd'") # коннеект с БД
    cu=db.cursor()
    '''
    with codecs.open('tv.csv','rb', encoding='windows-1251') as input_file: # перекодировка "на лету"
        for line in input_file:
            print type(line), line
    '''
    
    with codecs.open('tv.csv','rb', encoding='windows-1251') as input_file:
        rdr=csv.DictReader(input_file,fieldnames=['begt','channel','prname','prgenre','endt'])
        for rec in rdr:
            bd, bt=rec['begt'].split()
            bdd, bdm, bdy=map(int, bd.split('.'))
            bth, btm=map(int,bt.split('.'))
            eth, etm=map(int, rec['endt'].split('.'))
            rec['wd']=calendar.weekday(bdy, bdm, bdd)
            rec['begd']=db.Date(bdy, bdm, bdd)
            rec['begt']=db.Time(bth,bdm,0)
            rec['endt']=db.Time(eth,etm,0)
            
            cu.execute(''' INSERT INTO tv (tvdate, tvweekday, tvchannel, 
                            tvtime1, tvtime2, prname, prgenre
                            VALUES (%(begd)s, %(wd)s, %(channel)s, %(begt)s, %(endt)s,
                                    %(prname)s, %(prgenre)s); ''', rec)
                                    
    db.commit()                                         
    db.close()