def setup(self): self.logger_db = db_path(self, 'logger') self.logger_conn = sqlite3.connect(self.logger_db) self.greeting_db = db_path(self, 'greeting') self.greeting_conn = sqlite3.connect(self.greeting_db) self.greeting_count = {} c = self.greeting_conn.cursor() c.execute('''create table if not exists special_nicks ( message varchar(255), nick varchar(255), channel varchar(255), unique (channel, nick) on conflict replace );''') c.close()
def setup(self): self.pester_db = db_path(self, 'pester') self.pester_conn = sqlite3.connect(self.pester_db) c = self.pester_conn.cursor() c.execute( '''CREATE TABLE IF NOT EXISTS to_pester (pesteree TEXT, pesterer TEXT, reason TEXT, dismissed TEXT, last_pestered TEXT, created TEXT);''' )
def setup(self): self.whois_db = db_path(self, 'whois') connection = sqlite3.connect(self.whois_db) cursor = connection.cursor() make_table(cursor) cursor.close() connection.close()
def setup(self): global global_revisions, global_filename global_filename = db_path(self, 'repos') if not os.path.exists(global_filename): try: f = open(global_filename, 'w') except OSError: pass else: f.write('') f.close() global_revisions = loadRevisions(global_filename) # @@ tell
def countGuest(phenny, nick): global_filename = db_path(phenny, 'guests') if not os.path.exists(global_filename): try: f = open(global_filename, 'w') except OSError: pass f.write('') f.close() guests = {} with open(global_filename, 'r') as dbFile: guests = set(dbFile.read().strip().split(',')) guests.add(nick) with open(global_filename, 'w') as dbFile: dbFile.write(','.join(guests))
def getGuests(phenny, input): if input.admin: global_filename = db_path(phenny, 'guests') if not os.path.exists(global_filename): try: f = open(global_filename, 'r') except OSError: pass f.close() guests = {} with open(global_filename, 'r') as dbFile: guests = set(dbFile.read().strip().split(',')) phenny.say(str(guests)) else: phenny.reply("That is an admin-only command.")
def setup(self): self.logger_db = db_path(self, 'logger') self.logger_conn = sqlite3.connect(self.logger_db) c = self.logger_conn.cursor() c.execute('''create table if not exists lines_by_nick ( channel varchar(255), nick varchar(255), lines unsigned big int not null default 0, characters unsigned big int not null default 0, last_time timestamp default CURRENT_TIMESTAMP, quote text, unique (channel, nick) on conflict replace );''')
def setup(self): self.more_db = db_path(self, 'more') connection = sqlite3.connect(self.more_db) cursor = connection.cursor() cursor.execute('''CREATE TABLE IF NOT EXISTS more ( id INTEGER PRIMARY KEY AUTOINCREMENT, target VARCHAR(255), message VARCHAR({max_msg_len}), tag VARCHAR(255) );'''.format(max_msg_len=max_message_length)) cursor.close() connection.close()
def setup(self): global config_filename config_filename = db_path(self, 'lastfm') if not os.path.exists(config_filename): try: f = open(config_filename, 'w') except OSError: pass else: f.write('') f.close() config_file = config.read(config_filename) if not config.has_section("Nick2User"): config.add_section("Nick2User") if not config.has_section("User2Nick"): config.add_section("User2Nick") if not config.has_section("Nick2Verb"): config.add_section("Nick2Verb")
def setup(self): self.greeting_count = {} self.greeting_db = db_path(self, 'greeting') connection = sqlite3.connect(self.greeting_db) cursor = connection.cursor() cursor.execute('''create table if not exists special_nicks ( message varchar(255), nick varchar(255), channel varchar(255), unique (channel, nick) on conflict replace );''') cursor.close() connection.close()
def setup(self): self.logger_db = db_path(self, 'logger') connection = sqlite3.connect(self.logger_db) cursor = connection.cursor() cursor.execute('''create table if not exists lines_by_nick ( channel varchar(255), nick varchar(255), lines unsigned big int not null default 0, characters unsigned big int not null default 0, last_time timestamp default CURRENT_TIMESTAMP, quote text, unique (channel, nick) on conflict replace );''') cursor.close() connection.close()
def setup(self): self.greeting_count = {} self.greeting_db = db_path(self, 'greeting') connection = sqlite3.connect(self.greeting_db) cursor = connection.cursor() cursor.execute('''create table if not exists special_nicks ( message varchar(255), nick varchar(255), channel varchar(255), unique (channel, nick) on conflict replace );''') cursor.execute('''create table if not exists opted_out ( nick varchar(255) );''') cursor.close() connection.close()
def setup(self): # volatile data: nick -> last_time # entries exist for as long as nick is active self.gci_data = {} # persistent data: nick -> mentor_nick, code, all_time self.gci_db = db_path(self, 'gci_data') connection = sqlite3.connect(self.gci_db) cursor = connection.cursor() cursor.execute('''CREATE TABLE IF NOT EXISTS gci_data ( nick varchar(255), mentor_nick varchar(255), code varchar(255), all_time unsigned big int not null default 0, UNIQUE (nick, code) ON CONFLICT REPLACE );''') cursor.close() connection.close()
def setup(self): self.pester_db = db_path(self, 'pester') self.pester_conn = sqlite3.connect(self.pester_db) c = self.pester_conn.cursor() c.execute('''CREATE TABLE IF NOT EXISTS to_pester (pesteree TEXT, pesterer TEXT, reason TEXT, dismissed TEXT, last_pestered TEXT, created TEXT);''')