feat(storage): primary key for all tables and general qol refactoring (#2431)

This is a massive overhaul to the SQL Storage for Authelia. It facilitates a whole heap of utility commands to help manage the database, primary keys, ensures all database requests use a context for cancellations, and paves the way for a few other PR's which improve the database.

Fixes #1337

1 files changed, 22 insertions, 0 deletions

diff --git a/internal/storage/sql_provider_backend_sqlite.go b/internal/storage/sql_provider_backend_sqlite.go
new file mode 100644
index 000000000..b11b82239
--- /dev/null
+++ b/internal/storage/sql_provider_backend_sqlite.go
@@ -0,0 +1,22 @@
+package storage
+
+import (
+	_ "github.com/mattn/go-sqlite3" // Load the SQLite Driver used in the connection string.
+)
+
+// SQLiteProvider is a SQLite3 provider.
+type SQLiteProvider struct {
+	SQLProvider
+}
+
+// NewSQLiteProvider constructs a SQLite provider.
+func NewSQLiteProvider(path string) (provider *SQLiteProvider) {
+	provider = &SQLiteProvider{
+		SQLProvider: NewSQLProvider(providerSQLite, "sqlite3", path),
+	}
+
+	// All providers have differing SELECT existing table statements.
+	provider.sqlSelectExistingTables = querySQLiteSelectExistingTables
+
+	return provider
+}