aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorWojciech Kosior <kwojtus@protonmail.com>2020-06-04 11:04:55 +0200
committerWojciech Kosior <kwojtus@protonmail.com>2020-06-04 13:04:48 +0200
commit5b42795d2537a6bc1735018eea40d087c8ca40f2 (patch)
treefbd984449c48182c3d1c34d203750a9f303ef248
parent9d22d22cd11035e1d80bafaa393c9f634576553a (diff)
download0tdns-5b42795d2537a6bc1735018eea40d087c8ca40f2.tar.gz
0tdns-5b42795d2537a6bc1735018eea40d087c8ca40f2.zip
adjust table names
-rwxr-xr-xsrc/hourly.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/hourly.py b/src/hourly.py
index c11f3f0..c1c598b 100755
--- a/src/hourly.py
+++ b/src/hourly.py
@@ -13,7 +13,7 @@ db_config_path = '/etc/0tdns/db_connection_config.yml'
def sync_ovpn_config(cursor, vpn_id, config_path, config_hash):
cursor.execute('''
select ovpn_config
- from vpn
+ from user_side_vpn
where id = %s and ovpn_config_sha256 = %s
''', (vpn_id, config_hash))
@@ -30,7 +30,7 @@ def get_vpn_connections(cursor, hour):
# )
cursor.execute('''
select v.id, v.ovpn_config_sha256
- from queries as q join vpn as v
+ from user_side_queries as q join user_side_vpn as v
on v.id = q.vpn_id;
''')
return cursor.fetchall()