public void Delete_Blob(FilePathsDBModel model)
{
using IDbConnection cnn = new SQLiteConnection(_connectionString);
string query = "DELETE FROM Blobs " +
"WHERE FK_FilePathID = @FilePathID;";
cnn.Execute(query, model);
IncrementDatabaseRevision();
}
public void Insert_FilePath(FilePathsDBModel model)
{
using IDbConnection cnn = new SQLiteConnection(_connectionString);
string query = "INSERT INTO FilePaths (FilePath, LastWriteTimeUtc, HashAlgorithm, FileHash) " +
"VALUES (@FilePath, @LastWriteTimeUtc, @HashAlgorithm, @FileHash);";
cnn.Execute(query, model);
IncrementDatabaseRevision();
}
public void Update_LastWriteTimeUtc(FilePathsDBModel model)
{
using IDbConnection cnn = new SQLiteConnection(_connectionString);
string query = "UPDATE FilePaths " +
"SET LastWriteTimeUtc = @LastWriteTimeUtc " +
"WHERE FilePathID = @FilePathID;";
cnn.Execute(query, model);
IncrementDatabaseRevision();
}
public byte[] Select_Blob(FilePathsDBModel model)
{
using IDbConnection cnn = new SQLiteConnection(_connectionString);
string query = "SELECT BlobData " +
"FROM Blobs " +
"WHERE FK_FilePathID = @FilePathID;";
var output = cnn.QuerySingle <byte[]>(query, model);
return(output);
}
public int Select_FilePathID(FilePathsDBModel model)
{
using IDbConnection cnn = new SQLiteConnection(_connectionString);
string query = "SELECT FilePathID " +
"FROM FilePaths " +
"WHERE FilePath = @FilePath;";
int output = cnn.ExecuteScalar <int>(query, model);
return(output);
}