Return to wikisqldumpToSQL.py CVS log

Up to [Repository] / MPIWGWeb

Annotation of MPIWGWeb/wikisqldumpToSQL.py, revision 1.1.2.1

1.1.2.1 ! dwinter     1: import psycopg
        !             2: 
        !             3: o = psycopg.connect('dbname=authorities user=dwinter password=3333',serialize=0) 
        !             4: c = o.cursor() 
        !             5: 
        !             6: import re
        !             7: 
        !             8: def quote(str):
        !             9:     str=str.replace("'","\\\'")
        !            10:     str=str.replace("@","\\\'")
        !            11:     return str#.encode('utf-8')
        !            12: 
        !            13: filename="/Users/dwinter/Desktop/dewiki-20060908-categorylinks.sql"
        !            14: txt=file(filename).read()
        !            15: datas=re.findall("(VALUES.*)",txt)
        !            16: for data in datas:
        !            17:     print data
        !            18:     txt=data.replace("VALUES","")
        !            19:     data=re.findall("\((.*?)\)",txt)
        !            20:     print len(data)
        !            21:     for result in data:
        !            22:         result=result.replace("\\\'","@")
        !            23:         
        !            24:         new=re.findall("\'(.*?)\'",result)
        !            25:         if len(new)>1:
        !            26:             if (len(new)>0) and ((new[0]=='Mann') or (new[0]=="Frau")):
        !            27:                 try:
        !            28:                     firstname=new[1].split(",")[1].lstrip()
        !            29:                 except:
        !            30:                     firstname=""
        !            31:                 lastname=new[1].split(",")[0].lstrip()
        !            32:                 
        !            33:                 print "INSERT into persons (firstname,lastname) VALUES ('%s','%s')"% (quote(firstname),quote(lastname))
        !            34:                 c.execute("INSERT into persons (firstname,lastname) VALUES ('%s','%s')"% (quote(firstname),quote(lastname)))
        !            35:                 c.commit()