From 6af738107b677f6a511af36fd3b18fa2fcd75f16 Mon Sep 17 00:00:00 2001
From: jesopo
Date: Mon, 1 Oct 2018 14:06:50 +0100
Subject: Implement client-side bindhost

---
 src/Database.py | 17 +++++++++--------
 1 file changed, 9 insertions(+), 8 deletions(-)

(limited to 'src/Database.py')

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
-- 
cgit v1.3.1-10-gc9f91