5
from gozerbot.datadir import datadir
6
from gozerbot.db import db
11
from gozerbot.users import Users
12
u = Users(datadir + os.sep + 'users')
17
db.execute(""" INSERT INTO userhosts(userhost, name) \
18
VALUES(%s, %s) """, (j, i.name))
24
db.execute(""" INSERT INTO perms(name, perm) \
25
VALUES(%s, %s) """, (i.name, j))
31
db.execute(""" INSERT INTO email(name, email) \
32
VALUES(%s, %s) """, (i.name, i.email))
38
db.execute(""" INSERT INTO permits(name, permit) \
39
VALUES(%s, %s) """, (i.name, j))
45
db.execute(""" INSERT INTO statuses(name, status) \
46
VALUES(%s, %s) """, (i.name, j))
50
print i.name, i.passwd
52
db.execute(""" INSERT INTO passwords(name, passwd) \
53
VALUES(%s, %s) """, (i.name, i.passwd))
57
from gozerplugs.plugs.infoitem import Infoitems
58
info = Infoitems(datadir + os.sep + 'infoitems')
60
print "ADDING INFOITEMS"
64
for i,j in info.data.iteritems():
68
db.execute(""" INSERT INTO infoitems(item, description, \
69
userhost, time) VALUES(%s, %s, %s, %s) """, (i, z, '', 0))
75
from gozerplugs.plugs.karma import Karma
80
for i,j in k.karma.iteritems():
83
db.execute(""" INSERT INTO karma(item, value) VALUES(%s, %s) """, \
88
for i,j in k.reasonup.iteritems():
92
db.execute(""" INSERT INTO whykarma(item, updown, why) \
93
VALUES(%s, %s, %s) """, (i, 'up', z))
97
for i,j in k.reasondown.iteritems():
101
db.execute(""" INSERT INTO whykarma(item, updown, why) \
102
VALUES(%s, %s, %s) """, (i, 'down', z))
103
except Exception, ex:
106
for i,j in k.whodown.iteritems():
110
db.execute(""" INSERT INTO whokarma(item, nick, updown) \
111
VALUES(%s, %s, %s) """, (i, z, 'down'))
112
except Exception, ex:
115
for i,j in k.whoup.iteritems():
119
db.execute(""" INSERT INTO whokarma(item, nick, updown) \
120
VALUES(%s, %s, %s) """, (i, z, 'up'))
121
except Exception, ex:
124
print "ADDING QUOTES"
126
from gozerplugs.plugs.quote import Quotes
127
q = Quotes(datadir + os.sep + 'quotes')
130
print i.txt, i.nick, i.userhost, i.time
132
db.execute(""" INSERT INTO quotes(quote, userhost, createtime, \
133
nick) VALUES (%s, %s, %s, %s) """, (i.txt, i.userhost, i.time, i.nick))
134
except Exception, ex:
139
from gozerplugs.plugs.todo import Todo
140
todo = Todo(datadir + os.sep + 'todo')
144
for i, j in todo.data.iteritems():
148
db.execute(""" INSERT INTO todo(name, time, duration, \
149
warnsec, descr, priority) VALUES(%s, %s, %s, %s, %s, %s) """, \
150
(z.name, z.time, z.duration, z.warnsec, z.descr, z.priority))
151
except Exception, ex:
156
from gozerbot.persist import Persist
157
mylists = Persist(datadir + os.sep + 'mylists')
161
for i, j in mylists.data.iteritems():
162
for z, zz in j.iteritems():
166
db.execute(""" INSERT INTO list(username, listname, item) \
167
VALUES(%s, %s, %s) """, (i, z, x))
168
except Exception, ex:
172
from gozerbot.pdol import Pdol
173
lists = Pdol(datadir + os.sep + 'lists')
177
for i, j in lists.data.iteritems():
181
db.execute(""" INSERT INTO list(username, listname, item) \
182
VALUES(%s, %s, %s) """, ('all', i, z))
183
except Exception, ex: