diff options
author | Wojciech Kosior <kwojtus@protonmail.com> | 2020-06-04 11:04:55 +0200 |
---|---|---|
committer | Wojciech Kosior <kwojtus@protonmail.com> | 2020-06-04 13:04:48 +0200 |
commit | 5b42795d2537a6bc1735018eea40d087c8ca40f2 (patch) | |
tree | fbd984449c48182c3d1c34d203750a9f303ef248 /src | |
parent | 9d22d22cd11035e1d80bafaa393c9f634576553a (diff) | |
download | 0tdns-5b42795d2537a6bc1735018eea40d087c8ca40f2.tar.gz 0tdns-5b42795d2537a6bc1735018eea40d087c8ca40f2.zip |
adjust table names
Diffstat (limited to 'src')
-rwxr-xr-x | src/hourly.py | 4 |
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() |