diff mbox series

[1/2] openvpn: Create database schema if not exists

Message ID 20200525091730.4059-1-michael.tremer@ipfire.org
State Accepted
Commit 75bb55e716f57667d6a34a99f15fc0cdacc1081b
Headers
Series [1/2] openvpn: Create database schema if not exists |

Commit Message

Michael Tremer May 25, 2020, 9:17 a.m. UTC 
  Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
---
 html/cgi-bin/logs.cgi/ovpnclients.dat | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
diff mbox series

Patch

diff --git a/html/cgi-bin/logs.cgi/ovpnclients.dat b/html/cgi-bin/logs.cgi/ovpnclients.dat
index 2009990ec..a064893a1 100755
--- a/html/cgi-bin/logs.cgi/ovpnclients.dat
+++ b/html/cgi-bin/logs.cgi/ovpnclients.dat
@@ -95,6 +95,21 @@  unless ($to_datestring ge $from_datestring) {
 	$errormessage = "$Lang::tr{'error the to date has to be later than the from date'}";
 }
 
+# Initialise database
+my $cursor = $database_handle->prepare("
+	CREATE TABLE IF NOT EXISTS sessions(
+		common_name TEXT NOT NULL,
+		connected_at TEXT NOT NULL,
+		disconnected_at TEXT,
+		bytes_received INTEGER,
+		bytes_sent INTEGER
+	);
+
+	-- Create index for speeding up searches
+	CREATE INDEX IF NOT EXISTS sessions_common_name ON sessions(common_name);
+");
+$cursor->execute();
+
 my $database_query = qq(
 	SELECT
         common_name, SUM(