private FastQuery CreateSelectTestQuery(SqliteConnection connection, ConnectionPool pool)
{
var sql = $"SELECT A,B FROM `{TestTable}` WHERE `A`=@A AND `B`=@B;";
var fq = new FastQuery(sql, connection, pool);
return(fq);
}
private void CreateMetadataQueries(SqliteConnection connection, ConnectionPool pool)
{
InsertMetadataRowQuery = CreateInsertMetadataRowQuery(connection, pool);
FindMetadataQuery = CreateFindMetadataQuery(connection, pool);
GetExactMetadataQuery = CreateGetExactMetadataQuery(connection, pool);
IncrementCounterQuery = CreateIncrementCounterQuery(connection, pool);
}
private FastQuery CreateInsertTestQuery(SqliteConnection connection, ConnectionPool pool)
{
var sql = $"INSERT OR REPLACE INTO `{TestTable}`(`A`, `B`, `RawData`) VALUES(@A, @B, @RawData);";
var fq = new FastQuery(sql, connection, pool);
return(fq);
}
private FastQuery CreateRollbackQuery(SqliteConnection connection, ConnectionPool pool)
{
var sql = $"ROLLBACK;";
var fq = new FastQuery(sql, connection, pool);
return(fq);
}
private FastQuery CreateCommitQuery(SqliteConnection connection, ConnectionPool pool)
{
var sql = $"COMMIT;";
var fq = new FastQuery(sql, connection, pool);
return(fq);
}
private FastQuery CreateBeginConcurrentQuery(SqliteConnection connection, ConnectionPool pool)
{
var sql = $"BEGIN CONCURRENT;";
var fq = new FastQuery(sql, connection, pool);
return(fq);
}
private FastQuery CreateIncrementCounterQuery(SqliteConnection connection, ConnectionPool pool)
{
var sql = $"UPDATE {MetadataTable} SET `Counter` = `Counter` + 1 " +
$"WHERE `PK` = @Pk";
var fq = new FastQuery(sql, connection, pool);
return(fq);
}
private FastQuery CreateInsertMetadataRowQuery(SqliteConnection connection, ConnectionPool pool)
{
#pragma warning disable HAA0201 // Implicit string concatenation allocation
var sql = $"INSERT INTO {MetadataTable} " +
$"(`PK`, `RepoId`, `ContainerId`, `ParentId`, `Counter`, `Version`, `RemoteId`, `Permissions`, `SchemaType`, `Schema`, `Metadata`) " +
$"VALUES (@PK, @RepoId, @ContainerId, @ParentId, @Counter, @Version, @RemoteId, @Permissions, @SchemaType, @Schema, @Metadata)";
var fq = new FastQuery(sql, connection, pool);
return(fq);
}
private FastQuery CreateGetExactMetadataQuery(SqliteConnection connection, ConnectionPool pool)
{
var sql = $"SELECT * " +
$"from {MetadataTable} " +
$"WHERE `PK` = @Pk";
// TODO optional params via coalesce
var fq = new FastQuery(sql, connection, pool);
return(fq);
}
public StorageQueries(SqliteConnection connection, ConnectionPool pool)
{
_connection = connection;
_pool = pool;
BeginQuery = CreateBeginQuery(connection, pool);
BeginConcurrentQuery = CreateBeginConcurrentQuery(connection, pool);
CommitQuery = CreateCommitQuery(connection, pool);
RollbackQuery = CreateRollbackQuery(connection, pool);
InsertTestQuery = CreateInsertTestQuery(connection, pool);
SelectTestQuery = CreateSelectTestQuery(connection, pool);
CreateStreamBlockQueries(connection, pool);
CreateContainerBlockQueries(connection, pool);
CreateMetadataQueries(connection, pool);
}
