public NpgsqlConsentStore(NpgsqlConnection conn, NpgsqlSchema schema) { Preconditions.IsNotNull(conn, nameof(conn)); Preconditions.IsShortString(schema, nameof(schema)); _conn = conn; _schema = schema; _loadAllQuery = "SELECT subject, client_id, scopes " + $"FROM {_schema}.consents " + "WHERE subject = @subject"; _revokeQuery = $"DELETE FROM {_schema}.consents " + "WHERE subject = @subject AND client_id = @client"; _loadQuery = "SELECT subject, client_id, scopes " + $"FROM {_schema}.consents " + "WHERE subject = @subject AND client_id = @client"; _rowExistsQuery = "SELECT COUNT(subject) " + $"FROM {_schema}.consents " + "WHERE subject = @subject AND client_id = @client"; _insertQuery = $"INSERT INTO {_schema}.consents(subject, client_id, scopes) " + "VALUES (@subject, @client, @scopes)"; _updateQuery = $"UPDATE {_schema}.consents " + "SET scopes = @scopes " + "WHERE subject = @subject AND client_id = @client"; }
public NpgsqlClientStore(NpgsqlConnection conn, NpgsqlSchema schema) { Preconditions.IsNotNull(conn, nameof(conn)); Preconditions.IsShortString(schema, nameof(schema)); _conn = conn; _schema = schema; _serializer = JsonSerializerFactory.Create(); _findQuery = "SELECT client_id, model " + $"FROM {_schema}.clients " + "WHERE client_id = @client"; _insertQuery = $"INSERT INTO {_schema}.clients(client_id, model) " + "VALUES(@client, @model);"; }
public NpgsqlScopeStore(NpgsqlConnection conn, NpgsqlSchema schema) { Preconditions.IsNotNull(conn, nameof(conn)); Preconditions.IsShortString(schema, nameof(schema)); _serializer = JsonSerializerFactory.Create(); _conn = conn; _schema = schema; _findQuery = "SELECT name, is_public, model " + $"FROM {_schema}.scopes " + "WHERE name = any (@names)"; _getQuery = "SELECT name, is_public, model " + $"FROM {_schema}.scopes " + "WHERE is_public = @public"; }