def add_url(self, url, title, hostmask_id, channel=None): with self.dbcon.scoped_db_session() as session: url_qr = session.query(URL).filter(URL.url==url).all() # One? if len(url_qr) == 0: url_obj = URL() #self.connection.privmsg("jabr", type(url_obj.hostmask_id)) url_obj.url = url url_obj.title = title url_obj.channel = channel url_obj.hostmask_id = hostmask_id session.add(url_obj) msg = "URL %s added by %d" % (url, hostmask_id) self.connection.privmsg("jabr", msg) elif len(url_qr) == 1: msg = "URL %s already exist" % url self.connection.privmsg("jabr", msg) else: msg = "ERROR: %d instances of URL (%s) in DB" % (len(url_qr), url) self.connection.privmsg("jabr", msg)
def add_url(self, url, title, hostmask_id, channel=None): with self.dbcon.scoped_db_session() as session: url_qr = session.query(URL).filter(URL.url == url).all() # One? if len(url_qr) == 0: url_obj = URL() #self.connection.privmsg("jabr", type(url_obj.hostmask_id)) url_obj.url = url url_obj.title = title url_obj.channel = channel url_obj.hostmask_id = hostmask_id session.add(url_obj) msg = "URL %s added by %d" % (url, hostmask_id) self.connection.privmsg("jabr", msg) elif len(url_qr) == 1: msg = "URL %s already exist" % url self.connection.privmsg("jabr", msg) else: msg = "ERROR: %d instances of URL (%s) in DB" % (len(url_qr), url) self.connection.privmsg("jabr", msg)