aboutsummaryrefslogtreecommitdiff
path: root/Database.py
diff options
context:
space:
mode:
authorGravatar jesopo2018-09-19 01:13:54 +0100
committerGravatar jesopo2018-09-19 01:13:54 +0100
commitb7dda02951d149837cb888e750feaaaec809d44b (patch)
tree404fce8b051300ababbedee73b34dd346b119a88 /Database.py
parentOnly allow the register command on networks that support internal identity (diff)
signature
Add optional aliases for IRCServers, mostly to make logging prettier.
Diffstat (limited to 'Database.py')
-rw-r--r--Database.py10
1 files changed, 5 insertions, 5 deletions
diff --git a/Database.py b/Database.py
index c344c71e..4f3d22fd 100644
--- a/Database.py
+++ b/Database.py
@@ -5,22 +5,22 @@ class Table(object):
self.database = database
class Servers(Table):
- def add(self, hostname, port, password, ipv4, tls, nickname,
+ def add(self, alias, hostname, port, password, ipv4, tls, nickname,
username=None, realname=None):
username = username or nickname
realname = realname or nickname
self.database.execute(
- """INSERT INTO servers (hostname, port, password, ipv4,
+ """INSERT INTO servers (alias, hostname, port, password, ipv4,
tls, nickname, username, realname) VALUES (
?, ?, ?, ?, ?, ?, ?, ?)""",
[hostname, port, password, ipv4, tls, nickname, username, realname])
def get_all(self):
return self.database.execute_fetchall(
- """SELECT server_id, hostname, port, password, ipv4,
+ """SELECT server_id, alias, hostname, port, password, ipv4,
tls, nickname, username, realname FROM servers""")
def get(self, id):
return self.database.execute_fetchone(
- """SELECT server_id, hostname, port, password, ipv4,
+ """SELECT server_id, alias, hostname, port, password, ipv4,
tls, nickname, username, realname FROM servers WHERE
server_id=?""",
[id])
@@ -306,7 +306,7 @@ class Database(object):
def make_servers_table(self):
if not self.has_table("servers"):
self.execute("""CREATE TABLE servers
- (server_id INTEGER PRIMARY KEY, hostname TEXT,
+ (server_id INTEGER PRIMARY KEY, alias TEXT, hostname TEXT,
port INTEGER,password TEXT,ipv4 BOOLEAN, tls BOOLEAN,
nickname TEXT, username TEXT, realname TEXT)""")
def make_channels_table(self):