home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
linuxmafia.com 2016
/
linuxmafia.com.tar
/
linuxmafia.com
/
bale
/
baleit.py
< prev
next >
Wrap
Text File
|
2005-02-10
|
2KB
|
68 lines
import os
import string
import MySQLdb
def opendb():
host = 'localhost'
db = 'events'
user = 'bale'
passwd = 'cabalista'
rdb = MySQLdb.connect(db=db, host=host, user=user, passwd=passwd)
cursor = rdb.cursor()
return rdb, cursor
def getfilelist():
pwd = "%s/groups/" % (os.getcwd())
fl = os.listdir(pwd)
return pwd, fl
def parsefile(fname):
f = open(fname, 'r')
g = f.readlines()
f.close()
return g
def fudgeQuotes(str):
g = str.strip()
g = string.replace(g, "'", "''")
return g
def getfiles(cursor):
pwd, fl = getfilelist()
for i in fl:
lines = parsefile("%s%s" % (pwd, i))
q1 = "select count(*) from groups where gcode = '%s'" % (i,)
q3 = "delete from groups where gcode = '%s'" % (i,)
q2 = "insert into groups (gcode, gname, gcity, gcounty, "
q2 = q2 + "active, outofarea, description) values "
q2 = q2 + "('%s', '%s', '%s', '%s', %s, %s, '%s')"
cursor.execute(q1)
gcode = i
gname = fudgeQuotes(lines[0])
gcity = fudgeQuotes(lines[1])
gcounty = fudgeQuotes(lines[2])
gactive = fudgeQuotes(lines[3])
goutofarea = fudgeQuotes(lines[4])
description = fudgeQuotes(string.join(lines[5:], ''))
resultSet = cursor.fetchall()
if resultSet[0][0] != 0:
cursor.execute(q3)
stmt = q2 % (gcode, gname, gcity, gcounty, gactive, goutofarea, description)
cursor.execute(stmt)
print "group %s added successfully" % (i,)
if __name__ == "__main__":
db, cursor = opendb()
getfiles(cursor)