diff options
| author | 2018-10-01 14:06:50 +0100 | |
|---|---|---|
| committer | 2018-10-01 14:06:50 +0100 | |
| commit | 6af738107b677f6a511af36fd3b18fa2fcd75f16 (patch) | |
| tree | 50846545ac589d33ea0371a5129538b924ec51a2 /src/Database.py | |
| parent | Implement src/IRCObject.py to convert specific objects in to strings when (diff) | |
| signature | ||
Implement client-side bindhost
Diffstat (limited to 'src/Database.py')
| -rw-r--r-- | src/Database.py | 17 |
1 files changed, 9 insertions, 8 deletions
diff --git a/src/Database.py b/src/Database.py index b159ca4f..8c7e7f0d 100644 --- a/src/Database.py +++ b/src/Database.py @@ -5,22 +5,23 @@ class Table(object): self.database = database class Servers(Table): - def add(self, alias, hostname, port, password, ipv4, tls, nickname, - username=None, realname=None): + def add(self, alias, hostname, port, password, ipv4, tls, bindhost, + nickname, username=None, realname=None): username = username or nickname realname = realname or nickname self.database.execute( """INSERT INTO servers (alias, hostname, port, password, ipv4, - tls, nickname, username, realname) VALUES ( - ?, ?, ?, ?, ?, ?, ?, ?)""", - [hostname, port, password, ipv4, tls, nickname, username, realname]) + tls, bindhost, nickname, username, realname) VALUES ( + ?, ?, ?, ?, ?, ?, ?, ?, ?)""", + [hostname, port, password, ipv4, tls, bindhost, nickname, username, + realname]) def get_all(self): return self.database.execute_fetchall( "SELECT server_id, alias FROM servers") def get(self, id): return self.database.execute_fetchone( """SELECT server_id, alias, hostname, port, password, ipv4, - tls, nickname, username, realname FROM servers WHERE + tls, bindhost, nickname, username, realname FROM servers WHERE server_id=?""", [id]) @@ -304,8 +305,8 @@ class Database(object): if not self.has_table("servers"): self.execute("""CREATE TABLE servers (server_id INTEGER PRIMARY KEY, alias TEXT, hostname TEXT, - port INTEGER,password TEXT,ipv4 BOOLEAN, tls BOOLEAN, - nickname TEXT, username TEXT, realname TEXT)""") + port INTEGER, password TEXT, ipv4 BOOLEAN, tls BOOLEAN, + bindhost TEXT, nickname TEXT, username TEXT, realname TEXT)""") def make_channels_table(self): if not self.has_table("channels"): self.execute("""CREATE TABLE channels |
