Fixed "db has gone away"

[erebus.git] / erebus.py

#!/usr/bin/python

# Erebus IRC bot - Author: John Runyon
# main startup code

#TODO: tons

import os, sys, select, MySQLdb, MySQLdb.cursors
import bot, config, ctlmod

class Erebus(object):
	bots = {}
	fds = {}
	mods = {}
	numhandlers = {}
	msghandlers = {}
	users = {}
	chans = {}

	class User(object):
		def __init__(self, nick, auth=None):
			self.nick = nick
			self.auth = auth
			self.checklevel()

			self.chans = []

		def isauthed(self):
			return self.auth is not None

		def authed(self, auth):
			if auth == '0': self.auth = None
			else: self.auth = auth.lower()
			self.checklevel()

		def checklevel(self):
			if self.auth is None:
				self.glevel = -1
			else:
				c = main.db.cursor()
				c.execute("SELECT level FROM users WHERE auth = %s", (self.auth,))
				row = c.fetchone()
				if row is not None:
					self.glevel = row['level']
				else:
					self.glevel = 0
			return self.glevel

		def join(self, chan):
			self.chans.append(chan)
		def part(self, chan):
			self.chans.remove(chan)

		def __str__(self): return self.nick
		def __repr__(self): return "<User %r (%d)>" % (self.nick,self.glevel)

	class Channel(object):
		def __init__(self, name, bot):
			self.name = name
			self.bot = bot
			self.levels = {}

			self.users = []
			self.voices = []
			self.ops = []

			c = main.db.cursor()
			c.execute("SELECT user, level FROM chusers WHERE chan = %s", (self.name,))
			row = c.fetchone()
			while row is not None:
				self.levels[row['user']] = row['level']
				row = c.fetchone()


		def levelof(self, auth):
			auth = auth.lower()
			if auth in self.levels:
				return self.levels[auth]
			else:
				return 0

		def setlevel(self, auth, level, savetodb=True):
			auth = auth.lower()
			if savetodb:
				c = main.db.cursor()
				c.execute("REPLACE INTO chusers (chan, user, level) VALUES (%s, %s, %s)", (self.name, auth, level))
			self.levels[auth] = level

		def userjoin(self, user, level=None):
			if user not in self.users: self.users.append(user)
			if level == 'op' and user not in self.ops: self.ops.append(user)
			if level == 'voice' and user not in self.voices: self.voices.append(user)
		def userpart(self, user):
			if user in self.ops: self.ops.remove(user)
			if user in self.voices: self.voices.remove(user)
			if user in self.users: self.users.remove(user)

		def userop(self, user):
			if user in self.users and user not in self.ops: self.ops.append(user)
		def uservoice(self, user):
			if user in self.users and user not in self.voices: self.voices.append(user)
		def userdeop(self, user):
			if user in self.ops: self.ops.remove(user)
		def userdevoice(self, user):
			if user in self.voices: self.voices.remove(user)

		def __str__(self): return self.name
		def __repr__(self): return "<Channel %r>" % (self.name)

	def __init__(self, trigger):
		self.trigger = trigger
		if os.name == "posix":
			self.potype = "poll"
			self.po = select.poll()
		else: # f.e. os.name == "nt" (Windows)
			self.potype = "select"
			self.fdlist = []

	def newbot(self, nick, user, bind, server, port, realname):
		if bind is None: bind = ''
		obj = bot.Bot(self, nick, user, bind, server, port, realname)
		self.bots[nick.lower()] = obj

	def newfd(self, obj, fileno):
		self.fds[fileno] = obj
		if self.potype == "poll":
			self.po.register(fileno, select.POLLIN)
		elif self.potype == "select":
			self.fdlist.append(fileno)

	def bot(self, name): #get Bot() by name (nick)
		return self.bots[name.lower()]
	def fd(self, fileno): #get Bot() by fd/fileno
		return self.fds[fileno]
	def randbot(self): #get Bot() randomly
		for b in self.bots.itervalues(): return b #TODO

	def user(self, nick, justjoined=False):
		nick = nick.lower()
		if nick in self.users:
			return self.users[nick]
		else:
			user = self.User(nick)
			self.users[nick] = user

			if justjoined:
				self.randbot().conn.send("WHO %s %%ant,2" % (nick))

			return user
	def channel(self, name): #get Channel() by name
		if name.lower() in self.chans:
			return self.chans[name.lower()]
		else:
			return None

	def newchannel(self, bot, name):
		chan = self.Channel(name.lower(), bot)
		self.chans[name.lower()] = chan
		return chan

	def poll(self):
		if self.potype == "poll":
			return [fd for (fd, ev) in self.po.poll()]
		elif self.potype == "select":
			return select.select(self.fdlist, [], [])[0]

	def connectall(self):
		for bot in self.bots.itervalues():
			if bot.conn.state == 0:
				bot.connect()

	#bind functions
	def hook(self, word, handler):
		try:
			self.msghandlers[word].append(handler)
		except:
			self.msghandlers[word] = [handler]
	def unhook(self, word, handler):
		if word in self.msghandlers and handler in self.msghandlers[word]:
			self.msghandlers[word].remove(handler)
	def hashook(self, word):
		return word in self.msghandlers and len(self.msghandlers[word]) != 0
	def gethook(self, word):
		return self.msghandlers[word]

	def hooknum(self, word, handler):
		try:
			self.numhandlers[word].append(handler)
		except:
			self.numhandlers[word] = [handler]
	def unhooknum(self, word, handler):
		if word in self.numhandlers and handler in self.numhandlers[word]:
			self.numhandlers[word].remove(handler)
	def hasnumhook(self, word):
		return word in self.numhandlers and len(self.numhandlers[word]) != 0
	def getnumhook(self, word):
		return self.numhandlers[word]



class MyCursor(MySQLdb.cursors.DictCursor):
	def execute(self, *args, **kwargs):
		print "[SQL] [#] MyCursor.execute(self, %s, %s)" % (', '.join([repr(i) for i in args]), ', '.join([str(key)+"="+repr(kwargs[key]) for key in kwargs]))
		try:
			super(self.__class__, self).execute(*args, **kwargs)
		except MySQLdb.MySQLError as e:
			print "[SQL] [!] MySQL error! %r" % (e)
			try:
				dbsetup()
				super(self.__class__, self).execute(*args, **kwargs)
			except MySQLdb.MySQLError as e:
				print "[SQL] [!!!] DOUBLE MySQL error! %r" % (e)
				print "* [!!!] Giving up."
				sys.exit()


def dbsetup():
	main.db = MySQLdb.connect(host=cfg.dbhost, user=cfg.dbuser, passwd=cfg.dbpass, db=cfg.dbname, cursorclass=MyCursor)

def setup():
	global cfg, main

	cfg = config.Config('bot.config')
	main = Erebus(cfg.trigger)

	autoloads = [mod for mod, yes in cfg.items('autoloads') if int(yes) == 1]
	for mod in autoloads:
		print "Loading %s" % (mod)
		ctlmod.load(main, mod)

	dbsetup()
	c = main.db.cursor()
	c.execute("SELECT nick, user, bind FROM bots WHERE active = 1")
	rows = c.fetchall()
	c.close()
	for row in rows:
		main.newbot(row['nick'], row['user'], row['bind'], cfg.host, cfg.port, cfg.realname)
	main.connectall()

def loop():
	poready = main.poll()
	for fileno in poready:
		for line in main.fd(fileno).getdata():
			main.fd(fileno).parse(line)

if __name__ == '__main__':
	setup()
	while True: loop()