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";
}
protected BaseNpgsqlTokenStore(NpgsqlConnection conn, NpgsqlSchema schema,
TokenType storedTokenType, IScopeStore scopeStore, IClientStore clientStore)
{
StoredTokenType = storedTokenType;
Conn = conn;
Schema = schema;
_serializer = JsonSerializerFactory.Create();
_serializer.Converters.Add(new ClaimsPrincipalConverter());
_serializer.Converters.Add(new ClientConverter(clientStore));
_serializer.Converters.Add(new ScopeConverter(scopeStore));
_scopeStore = scopeStore;
_clientStore = clientStore;
// Queries
_revokeQuery = $"DELETE FROM {Schema}.tokens " +
"WHERE subject = @subject " +
" AND client = @client " +
" AND token_type = @tokenType";
_removeQuery = $"DELETE FROM {Schema}.tokens " +
"WHERE key = @key " +
" AND token_type = @tokenType";
_getQuery = $"SELECT * FROM {Schema}.tokens " +
"WHERE key = @key " +
" AND token_type = @tokenType";
_getAllQuery = $"SELECT * FROM {Schema}.tokens " +
"WHERE subject = @subject " +
" AND token_type = @tokenType";
_insertQuery = "INSERT INTO " +
$"{Schema}.tokens(key, token_type, subject, client, expiry, model) " +
"VALUES(@key, @token_type, @subject, @client, @expiry, @model); ";
}
