def upgrade():
teller = 0
oldfile = datadir + os.sep + 'old'
dbdir = datadir + os.sep + 'db' + os.sep + 'karma.db'
if os.path.exists(dbdir):
try:
from gozerbot.database.db import Db
db = Db(dbtype='sqlite')
db.connect('db/karma.db')
result = db.execute(""" SELECT * FROM karma """)
if result:
for i in result:
try:
karma.add(i[0], i[1])
except sa.exc.IntegrityError:
pass
teller += 1
result = db.execute(""" SELECT * FROM whokarma """)
if result:
for i in result:
if i[2] == 'up':
karma.setwhoup(i[0], i[1])
else:
karma.setwhodown(i[0], i[1])
result = db.execute(""" SELECT * FROM whykarma """)
if result:
for i in result:
karma.addwhy(*i)
except Exception, ex:
handle_exception()
return teller
def upgrade():
teller = 0
oldfile = datadir + os.sep + 'old'
dbdir = datadir + os.sep + 'db' + os.sep + 'karma.db'
if os.path.exists(dbdir):
try:
from gozerbot.database.db import Db
db = Db(dbtype='sqlite')
db.connect('db/karma.db')
result = db.execute(""" SELECT * FROM karma """)
if result:
for i in result:
try:
karma.add(i[0], i[1])
except sa.exc.IntegrityError:
pass
teller += 1
result = db.execute(""" SELECT * FROM whokarma """)
if result:
for i in result:
if i[2] == 'up':
karma.setwhoup(i[0], i[1])
else:
karma.setwhodown(i[0], i[1])
result = db.execute(""" SELECT * FROM whykarma """)
if result:
for i in result:
karma.addwhy(*i)
except Exception, ex:
handle_exception()
return teller
def upgrade():
rlog(10, 'infoitem', 'upgrading')
teller = 0
dbdir = datadir + os.sep + 'db' + os.sep + 'infoitem.db'
if os.path.exists(dbdir):
try:
from gozerbot.database.db import Db
db = Db(dbtype='sqlite')
db.connect('db/infoitem.db')
result = db.execute(""" SELECT * FROM infoitems """)
if result:
for i in result:
info.add(*i[1:])
teller += 1
except Exception, ex:
handle_exception()
def upgrade():
rlog(10, 'quote', 'upgrading')
teller = 0
oldfile = datadir + os.sep + 'old' + os.sep + 'todo'
dbdir = datadir + os.sep + 'db' + os.sep + 'todo.db'
if os.path.exists(dbdir):
try:
from gozerbot.database.db import Db
db = Db(dbtype='sqlite')
db.connect('db/todo.db')
result = db.execute(""" SELECT * FROM todo """)
if result:
for i in result:
todo.add(i[1], i[5],*i[2:4])
teller += 1
except Exception, ex:
handle_exception()
return teller
def upgrade():
rlog(10, 'quote', 'upgrading')
teller = 0
oldfile = datadir + os.sep + 'old' + os.sep + 'todo'
dbdir = datadir + os.sep + 'db' + os.sep + 'todo.db'
if os.path.exists(dbdir):
try:
from gozerbot.database.db import Db
db = Db(dbtype='sqlite')
db.connect('db/todo.db')
result = db.execute(""" SELECT * FROM todo """)
if result:
for i in result:
todo.add(i[1], i[5], *i[2:4])
teller += 1
except Exception, ex:
handle_exception()
return teller
