import type { Knex } from "knex"; import { createAbstraction } from "@webiny/feature/api"; import { KnexClient, SqlSchemaConfig } from "@webiny/api-core-sql"; import { TableManager } from "@webiny/api-core-sql/TableManager.js"; import { createTableManager } from "~/createTableManager.js"; import type { StorageCredential } from "@webiny/self-hosted-auth"; const TABLE_NAME = "webiny_self_hosted_credentials"; export interface ICredentialRow { user_id: string; email: string; data: string; } export const toRow = (credential: StorageCredential): ICredentialRow => ({ user_id: credential.userId, email: credential.email, data: JSON.stringify(credential) }); export const toCredential = (row: ICredentialRow): StorageCredential => { return JSON.parse(row.data) as StorageCredential; }; export interface ICredentialsTable { ensure(): Promise; query(): Knex.QueryBuilder; } /** The credentials table, shared by the four operations that read and write it. */ export const CredentialsTable = createAbstraction( "SelfHostedAuth/Sql/CredentialsTable" ); export namespace CredentialsTable { export type Interface = ICredentialsTable; export type Row = ICredentialRow; } export class KnexCredentialsTable implements ICredentialsTable { constructor( private knex: Knex, private tableManager: TableManager ) {} async ensure(): Promise { await this.tableManager.ensure(TABLE_NAME, t => { t.text("user_id").notNullable(); t.text("email").notNullable(); t.text("data").notNullable(); t.primary(["user_id"]); // Email is the global login key. t.unique(["email"]); }); } query(): Knex.QueryBuilder { return this.knex(this.tableManager.resolve(TABLE_NAME)); } } /** The credentials table on the container's connection and table settings. */ class SqlCredentialsTableImpl extends KnexCredentialsTable implements CredentialsTable.Interface { public constructor(knex: KnexClient.Interface, schemaConfig?: SqlSchemaConfig.Interface) { super(knex.client, createTableManager(knex, schemaConfig)); } } export const SqlCredentialsTable = CredentialsTable.createImplementation({ implementation: SqlCredentialsTableImpl, dependencies: [KnexClient, [SqlSchemaConfig, { optional: true }]] });