aboutsummaryrefslogtreecommitdiff
path: root/src/Database.py
diff options
context:
space:
mode:
authorGravatar jesopo2018-11-05 18:23:02 +0000
committerGravatar jesopo2018-11-05 18:23:02 +0000
commit6b8593a09b6340e902f2522ac0eaf4fb0357e7bd (patch)
tree816f3bbae8837fa0ea42d518a9ff3b7f75a3f4a2 /src/Database.py
parentCheck that a server's STS policy has a `duration` before doing (diff)
signature
Pass connection parameters around in their own object (IRCConnectionParameters)
Diffstat (limited to 'src/Database.py')
-rw-r--r--src/Database.py14
1 files changed, 8 insertions, 6 deletions
diff --git a/src/Database.py b/src/Database.py
index 77e83fdc..8dcf42ec 100644
--- a/src/Database.py
+++ b/src/Database.py
@@ -12,18 +12,20 @@ class Servers(Table):
username = username or nickname
realname = realname or nickname
self.database.execute(
- """INSERT INTO servers (alias, hostname, port, password, ipv4,
- tls, bindhost, nickname, username, realname) VALUES (
+ """INSERT INTO servers (alias, hostname, port, password, tls,
+ ipv4, bindhost, nickname, username, realname) VALUES (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?)""",
- [alias, hostname, port, password, ipv4, tls, bindhost, nickname,
+ [alias, hostname, port, password, tls, ipv4, bindhost, nickname,
username, realname])
def get_all(self):
return self.database.execute_fetchall(
"SELECT server_id, alias FROM servers")
- def get(self, id: int):
+ def get(self, id: int) -> typing.Tuple[int, typing.Optional[str], str,
+ int, typing.Optional[str], bool, bool, typing.Optional[str], str,
+ typing.Optional[str], typing.Optional[str]]:
return self.database.execute_fetchone(
- """SELECT server_id, alias, hostname, port, password, ipv4,
- tls, bindhost, nickname, username, realname FROM servers WHERE
+ """SELECT server_id, alias, hostname, port, password, tls,
+ ipv4, bindhost, nickname, username, realname FROM servers WHERE
server_id=?""",
[id])