Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/python
- # -*- coding: utf-8 -*-
- import psycopg2
- import sys
- try:
- offset = 0
- while offset < 9000000:
- #print "Current OFFSET : " + str(offset)
- con = psycopg2.connect(database='postgres', user='postgres', password='postgres')
- cur = con.cursor()
- sql='SELECT name,content FROM my_db LIMIT 200 OFFSET {0}'.format(offset)
- cur.execute(sql)
- dataset = cur.fetchall()
- for row in dataset:
- nazov=row[0].upper().decode('utf8')
- obsah=row[1].lower().decode('utf8')
- nazov=nazov.encode('utf8').replace("í","Í").replace("š","Š").replace("č","Č").replace("ľ","Ľ") \
- .replace("ž","Ž").replace("ý","Ý").replace("é","É").replace("á","Á") \
- .replace("ť","Ť").replace("ú","Ú").replace("ň","Ň").replace("ó","Ó") \
- .replace("ô","Ô").replace("ä","Ä").replace("ě","Ě").replace("ü","Ü") \
- .replace("ö","Ö").replace("ů","Ů").replace("ř","Ř") # Quick&Dirty :) #
- print "\n" + "-----" + "\n" + nazov + "\n"
- print obsah
- offset = offset +200
- except psycopg2.DatabaseError, e:
- print 'Error %s' % e
- sys.exit(1)
- finally:
- if con:
- con.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement