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 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 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.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 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 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);''')