polycule-connect/polyculeconnect/migrations/0_create_backend_table.up.sql

CREATE TABLE "backend" (
    id TEXT NOT NULL PRIMARY KEY,
    name TEXT NOT NULL UNIQUE,
    oidc_issuer TEXT NOT NULL,
    oidc_client_id TEXT NOT NULL,
    oidc_client_secret TEXT NOT NULL,
    oidc_redirect_uri TEXT NOT NULL
);
Add basic way to get backend from query (#48) Because polyculeconnect is a OIDC proxy, we need to know which auth backend to use. This is provided using a query param or a form, so we need to get it from our own middleware. This commit adds the following elements: - basic DB storage for the backends - support for DB migrations and a first test migration (not definitive) - middleware to get the backend from the request and put it in the context - test that the backend exists in the auth flow 2024-08-16 09:02:44 +00:00			`CREATE TABLE "backend" (`
			`id TEXT NOT NULL PRIMARY KEY,`
Replace previous backend service with new storage (#48) 2024-08-16 11:49:59 +00:00			`name TEXT NOT NULL UNIQUE,`
			`oidc_issuer TEXT NOT NULL,`
			`oidc_client_id TEXT NOT NULL,`
			`oidc_client_secret TEXT NOT NULL,`
			`oidc_redirect_uri TEXT NOT NULL`
Add basic way to get backend from query (#48) Because polyculeconnect is a OIDC proxy, we need to know which auth backend to use. This is provided using a query param or a form, so we need to get it from our own middleware. This commit adds the following elements: - basic DB storage for the backends - support for DB migrations and a first test migration (not definitive) - middleware to get the backend from the request and put it in the context - test that the backend exists in the auth flow 2024-08-16 09:02:44 +00:00			`);`