diff options
| author | 2018-09-19 01:13:54 +0100 | |
|---|---|---|
| committer | 2018-09-19 01:13:54 +0100 | |
| commit | b7dda02951d149837cb888e750feaaaec809d44b (patch) | |
| tree | 404fce8b051300ababbedee73b34dd346b119a88 /Database.py | |
| parent | Only 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.py | 10 |
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): |
