using System;
using System.Collections.Generic;
using System.ComponentModel.Composition;
+using System.Data.SQLite;
using System.Diagnostics;
using System.Diagnostics.Contracts;
using System.IO;
using System.Linq;
+using System.Text;
using System.Threading;
using System.Threading.Tasks;
using Castle.ActiveRecord;
using Pithos.Interfaces;
using Pithos.Network;
using log4net;
-using log4net.Appender;
-using log4net.Config;
-using log4net.Layout;
namespace Pithos.Core.Agents
{
if (!File.Exists(Path.Combine(_pithosDataPath ,"pithos.db")))
ActiveRecordStarter.CreateSchema();
- }
+
+ CreateTrigger();
+
+ }
+
+ private void CreateTrigger()
+ {
+ using (var connection = GetConnection())
+ using (var triggerCommand = connection.CreateCommand())
+ {
+ var cmdText = new StringBuilder()
+ .AppendLine("CREATE TRIGGER IF NOT EXISTS update_last_modified UPDATE ON FileState FOR EACH ROW")
+ .AppendLine("BEGIN")
+ .AppendLine("UPDATE FileState SET Modified=datetime('now') WHERE Id=old.Id;")
+ .AppendLine("END;")
+ .AppendLine("CREATE TRIGGER IF NOT EXISTS insert_last_modified INSERT ON FileState FOR EACH ROW")
+ .AppendLine("BEGIN")
+ .AppendLine("UPDATE FileState SET Modified=datetime('now') WHERE Id=new.Id;")
+ .AppendLine("END;")
+ .ToString();
+ triggerCommand.CommandText = cmdText;
+ triggerCommand.ExecuteNonQuery();
+ }
+ }
+
private static InPlaceConfigurationSource GetConfiguration(string pithosDbPath)
{
},
};
- var connectionString = String.Format(@"Data Source={0}\pithos.db;Version=3", pithosDbPath);
+ var connectionString = String.Format(@"Data Source={0}\pithos.db;Version=3;Enlist=N", pithosDbPath);
properties.Add("connection.connection_string", connectionString);
var source = new InPlaceConfigurationSource();
{
action();
}
+ catch (SQLiteException ex)
+ {
+ Log.ErrorFormat("[ERROR] SQL \n{0}", ex);
+ }
catch (Exception ex)
{
- Log.ErrorFormat("[ERROR] STATE \n{0}",ex);
+ Log.ErrorFormat("[ERROR] STATE \n{0}", ex);
}
+// ReSharper disable AccessToModifiedClosure
queue.DoAsync(loop);
+// ReSharper restore AccessToModifiedClosure
});
};
loop();
select new {state.Id, state.FilePath}).ToList();
//and check each one
var missingStates= (from path in statePaths
- where !File.Exists(path.FilePath)
+ where !File.Exists(path.FilePath) && !Directory.Exists(path.FilePath)
select path.Id).ToList();
//Finally, retrieve the states that correspond to the deleted files
var deletedFiles = from state in fileStates
var pairs = currentFiles.Union(deletedFiles);
- Parallel.ForEach(pairs, pair =>
+ foreach(var pair in pairs)
{
var fileState = pair.State;
var file = pair.File;
if (fileState == null)
{
//This is a new file
- var fullPath = pair.File.FullName.ToLower();
- var createState = FileState.CreateForAsync(fullPath, this.BlockSize, this.BlockHash);
+ var fullPath = pair.File.FullName;
+ var createState = FileState.CreateForAsync(fullPath, BlockSize, BlockHash);
createState.ContinueWith(state => _persistenceAgent.Post(state.Result.Create));
}
else if (file == null)
//This file was deleted while we were down. We should mark it as deleted
//We have to go through UpdateStatus here because the state object we are using
//was created by a different ORM session.
- UpdateStatus(fileState.Id,state=> state.FileStatus = FileStatus.Deleted);
+ _persistenceAgent.Post(()=> UpdateStatusDirect(fileState.Id, FileStatus.Deleted));
}
else
{
//If the hashes don't match the file was changed
if (fileState.Checksum != hashString)
{
- UpdateStatus(fileState.Id, state => state.FileStatus = FileStatus.Modified);
+ _persistenceAgent.Post(() => UpdateStatusDirect(fileState.Id, FileStatus.Modified));
}
}
- });
+ };
}
-
+ private int UpdateStatusDirect(Guid id, FileStatus status)
+ {
+ using (log4net.ThreadContext.Stacks["StatusAgent"].Push("UpdateStatusDirect"))
+ {
+
+ try
+ {
+
+ using (var connection = GetConnection())
+ using (
+ var command = new SQLiteCommand("update FileState set FileStatus= :fileStatus where Id = :id ",
+ connection))
+ {
+ command.Parameters.AddWithValue("fileStatus", status);
+
+ command.Parameters.AddWithValue("id", id);
+
+ var affected = command.ExecuteNonQuery();
+
+ return affected;
+ }
+
+ }
+ catch (Exception exc)
+ {
+ Log.Error(exc.ToString());
+ throw;
+ }
+ }
+ }
+
+ private int UpdateStatusDirect(string path, FileStatus status)
+ {
+ using (log4net.ThreadContext.Stacks["StatusAgent"].Push("UpdateStatusDirect"))
+ {
+
+ try
+ {
+
+
+ using (var connection = GetConnection())
+ using (
+ var command =
+ new SQLiteCommand("update FileState set FileStatus= :fileStatus where FilePath = :path COLLATE NOCASE",
+ connection))
+ {
+
+
+ command.Parameters.AddWithValue("fileStatus", status);
+
+ command.Parameters.AddWithValue("path", path);
+
+ var affected = command.ExecuteNonQuery();
+ return affected;
+ }
+ }
+ catch (Exception exc)
+ {
+ Log.Error(exc.ToString());
+ throw;
+ }
+ }
+ }
+
+ private int UpdateStatusDirect(string absolutePath, FileStatus fileStatus, FileOverlayStatus overlayStatus)
+ {
+ using (log4net.ThreadContext.Stacks["StatusAgent"].Push("UpdateStatusDirect"))
+ {
+
+ try
+ {
+
+
+ using (var connection = GetConnection())
+ using (
+ var command =
+ new SQLiteCommand(
+ "update FileState set OverlayStatus= :overlayStatus, FileStatus= :fileStatus where FilePath = :path COLLATE NOCASE ",
+ connection))
+ {
+
+ command.Parameters.AddWithValue("path", absolutePath);
+ command.Parameters.AddWithValue("fileStatus", fileStatus);
+ command.Parameters.AddWithValue("overlayStatus", overlayStatus);
+
+ var affected = command.ExecuteNonQuery();
+ return affected;
+ }
+ }
+ catch (Exception exc)
+ {
+ Log.Error(exc.ToString());
+ throw;
+ }
+ }
+ }
+
public string BlockHash { get; set; }
}
- private string _pithosDataPath;
-
- public T GetStatus<T>(string path,Func<FileState,T> getter,T defaultValue )
- {
- if (String.IsNullOrWhiteSpace(path))
- throw new ArgumentNullException("path");
- if (!Path.IsPathRooted(path))
- throw new ArgumentException("path must be a rooted path", "path");
- if (getter == null)
- throw new ArgumentNullException("getter");
- Contract.EndContractBlock();
-
+ private readonly string _pithosDataPath;
- try
- {
- var state = FileState.FindByFilePath(path);
- return state == null ? defaultValue : getter(state);
- }
- catch (Exception exc)
- {
- Log.ErrorFormat(exc.ToString());
- return defaultValue;
- }
- }
- /// <summary>
- /// Sets the status of a file, creating a new FileState entry if one doesn't already exist.
- /// </summary>
- /// <param name="path"></param>
- /// <param name="setter"></param>
- public void SetStatus(string path,Action<FileState> setter)
- {
- if (String.IsNullOrWhiteSpace(path))
- throw new ArgumentNullException("path", "path can't be empty");
- if (setter==null)
- throw new ArgumentNullException("setter", "setter can't be empty");
- Contract.EndContractBlock();
-
- _persistenceAgent.Post(() =>
- {
- using (new SessionScope())
- {
- var filePath = path.ToLower();
- var state = FileState.FindByFilePath(filePath);
- if (state != null)
- {
- setter(state);
- state.Save();
- }
- else
- {
- state = new FileState {FilePath = filePath};
- setter(state);
- state.Save();
- }
- }
- });
- }
-
- /// <summary>
- /// Sets the status of a file only if the file already exists
- /// </summary>
- /// <param name="path"></param>
- /// <param name="setter"></param>
- private void UpdateStatus(string path, Action<FileState> setter)
+ public FileState GetStateByFilePath(string path)
{
if (String.IsNullOrWhiteSpace(path))
throw new ArgumentNullException("path");
if (!Path.IsPathRooted(path))
throw new ArgumentException("The path must be rooted", "path");
- if (setter == null)
- throw new ArgumentNullException("setter");
Contract.EndContractBlock();
- Debug.Assert(!path.Contains(FolderConstants.CacheFolder));
- Debug.Assert(!path.EndsWith(".ignore"));
-
- if (String.IsNullOrWhiteSpace(path))
- throw new ArgumentNullException("path", "path can't be empty");
-
- if (setter == null)
- throw new ArgumentNullException("setter", "setter can't be empty");
-
- _persistenceAgent.Post(() =>
+ try
{
- using (new SessionScope())
- {
- var filePath = path.ToLower();
-
- var state = FileState.FindByFilePath(filePath);
- if (state == null)
- {
- Log.WarnFormat("[NOFILE] Unable to set status for {0}.", filePath);
- return;
- }
- setter(state);
- state.Save();
- }
- });
- }
-
- /// <summary>
- /// Sets the status of a specific state
- /// </summary>
- /// <param name="path"></param>
- /// <param name="setter"></param>
- private void UpdateStatus(Guid stateID, Action<FileState> setter)
- {
- if (setter == null)
- throw new ArgumentNullException("setter");
- Contract.EndContractBlock();
-
-
- _persistenceAgent.Post(() =>
- {
- using (new SessionScope())
+ using (var connection = GetConnection())
+ using (var command = new SQLiteCommand("select Id, FilePath, OverlayStatus,FileStatus ,Checksum ,Version ,VersionTimeStamp,IsShared ,SharedBy ,ShareWrite from FileState where FilePath=:path COLLATE NOCASE", connection))
{
- var state = FileState.Find(stateID);
- if (state == null)
+
+ command.Parameters.AddWithValue("path", path);
+
+ using (var reader = command.ExecuteReader())
{
- Log.WarnFormat("[NOFILE] Unable to set status for {0}.", stateID);
- return;
- }
- setter(state);
- state.Save();
+ if (reader.Read())
+ {
+ //var values = new object[reader.FieldCount];
+ //reader.GetValues(values);
+ var state = new FileState
+ {
+ Id = reader.GetGuid(0),
+ FilePath = reader.IsDBNull(1)?"":reader.GetString(1),
+ OverlayStatus =reader.IsDBNull(2)?FileOverlayStatus.Unversioned: (FileOverlayStatus) reader.GetInt64(2),
+ FileStatus = reader.IsDBNull(3)?FileStatus.Missing:(FileStatus) reader.GetInt64(3),
+ Checksum = reader.IsDBNull(4)?"":reader.GetString(4),
+ Version = reader.IsDBNull(5)?default(long):reader.GetInt64(5),
+ VersionTimeStamp = reader.IsDBNull(6)?default(DateTime):reader.GetDateTime(6),
+ IsShared = !reader.IsDBNull(7) && reader.GetBoolean(7),
+ SharedBy = reader.IsDBNull(8)?"":reader.GetString(8),
+ ShareWrite = !reader.IsDBNull(9) && reader.GetBoolean(9)
+ };
+/*
+ var state = new FileState
+ {
+ Id = (Guid) values[0],
+ FilePath = (string) values[1],
+ OverlayStatus = (FileOverlayStatus) (long)values[2],
+ FileStatus = (FileStatus) (long)values[3],
+ Checksum = (string) values[4],
+ Version = (long?) values[5],
+ VersionTimeStamp = (DateTime?) values[6],
+ IsShared = (long)values[7] == 1,
+ SharedBy = (string) values[8],
+ ShareWrite = (long)values[9] == 1
+ };
+*/
+ return state;
+ }
+ else
+ {
+ return null;
+ }
+
+ }
}
-
- });
+ }
+ catch (Exception exc)
+ {
+ Log.ErrorFormat(exc.ToString());
+ throw;
+ }
}
public FileOverlayStatus GetFileOverlayStatus(string path)
try
{
- var state = FileState.FindByFilePath(path);
- return state == null ? FileOverlayStatus.Unversioned : state.OverlayStatus;
+
+ using (var connection = GetConnection())
+ using (var command = new SQLiteCommand("select OverlayStatus from FileState where FilePath=:path COLLATE NOCASE", connection))
+ {
+
+ command.Parameters.AddWithValue("path", path);
+
+ var s = command.ExecuteScalar();
+ return (FileOverlayStatus) Convert.ToInt32(s);
+ }
}
catch (Exception exc)
{
}
}
- public void SetFileOverlayStatus(string path, FileOverlayStatus overlayStatus)
+ private string GetConnectionString()
{
- if (String.IsNullOrWhiteSpace(path))
- throw new ArgumentNullException("path");
- if (!Path.IsPathRooted(path))
- throw new ArgumentException("The path must be rooted","path");
- Contract.EndContractBlock();
-
- SetStatus(path.ToLower(),s=>s.OverlayStatus=overlayStatus);
+ var connectionString = String.Format(@"Data Source={0}\pithos.db;Version=3;Enlist=N;Pooling=True", _pithosDataPath);
+ return connectionString;
}
- /*public void RemoveFileOverlayStatus(string path)
+ private SQLiteConnection GetConnection()
{
- if (String.IsNullOrWhiteSpace(path))
- throw new ArgumentNullException("path");
- if (!Path.IsPathRooted(path))
- throw new ArgumentException("The path must be rooted", "path");
- Contract.EndContractBlock();
-
- _persistenceAgent.Post(() =>
- InnerRemoveFileOverlayStatus(path));
+ var connectionString = GetConnectionString();
+ var connection = new SQLiteConnection(connectionString);
+ connection.Open();
+ using(var cmd =connection.CreateCommand())
+ {
+ cmd.CommandText = "PRAGMA journal_mode=WAL";
+ cmd.ExecuteNonQuery();
+ }
+ return connection;
}
- private static void InnerRemoveFileOverlayStatus(string path)
+ public void SetFileOverlayStatus(string path, FileOverlayStatus overlayStatus)
{
if (String.IsNullOrWhiteSpace(path))
throw new ArgumentNullException("path");
if (!Path.IsPathRooted(path))
- throw new ArgumentException("The path must be rooted", "path");
- Contract.EndContractBlock();
-
- FileState.DeleteByFilePath(path);
- }*/
-
- public void RenameFileOverlayStatus(string oldPath, string newPath)
- {
- if (String.IsNullOrWhiteSpace(oldPath))
- throw new ArgumentNullException("oldPath");
- if (!Path.IsPathRooted(oldPath))
- throw new ArgumentException("The oldPath must be rooted", "oldPath");
- if (String.IsNullOrWhiteSpace(newPath))
- throw new ArgumentNullException("newPath");
- if (!Path.IsPathRooted(newPath))
- throw new ArgumentException("The newPath must be rooted", "newPath");
+ throw new ArgumentException("The path must be rooted","path");
Contract.EndContractBlock();
- _persistenceAgent.Post(() =>
- InnerRenameFileOverlayStatus(oldPath, newPath));
+ _persistenceAgent.Post(() => FileState.StoreOverlayStatus(path,overlayStatus));
}
- private static void InnerRenameFileOverlayStatus(string oldPath, string newPath)
+ /* public void RenameFileOverlayStatus(string oldPath, string newPath)
{
if (String.IsNullOrWhiteSpace(oldPath))
throw new ArgumentNullException("oldPath");
throw new ArgumentException("The newPath must be rooted", "newPath");
Contract.EndContractBlock();
- var state = FileState.FindByFilePath(oldPath);
-
- if (state == null)
- {
- Log.WarnFormat("[NOFILE] Unable to set status for {0}.", oldPath);
- return;
- }
- //NOTE: This will cause problems if path is used as a key in relationships
- state.FilePath = newPath;
- state.Update();
- }
+ _persistenceAgent.Post(() =>FileState.RenameState(oldPath, newPath));
+ }*/
public void SetFileState(string path, FileStatus fileStatus, FileOverlayStatus overlayStatus)
{
throw new ArgumentException("The path must be rooted", "path");
Contract.EndContractBlock();
- UpdateStatus(path.ToLower(),state=>
- {
- state.FileStatus = fileStatus;
- state.OverlayStatus = overlayStatus;
- });
+ Debug.Assert(!path.Contains(FolderConstants.CacheFolder));
+ Debug.Assert(!path.EndsWith(".ignore"));
+
+ _persistenceAgent.Post(() => UpdateStatusDirect(path, fileStatus, overlayStatus));
}
+/*
public void StoreInfo(string path,ObjectInfo objectInfo)
{
if (String.IsNullOrWhiteSpace(path))
//Forgetting to use a sessionscope results in two sessions being created, one by
//FirstOrDefault and one by Save()
var state =FileState.FindByFilePath(filePath);
+
//Create a new empty state object if this is a new file
state = state ?? new FileState();
state.FileStatus = FileStatus.Unchanged;
state.OverlayStatus = FileOverlayStatus.Normal;
- //Create a list of tags from the ObjectInfo's tag dictionary
- //Make sure to bind each tag to its parent state so we don't have to save each tag separately
- //state.Tags = (from pair in objectInfo.Tags
- // select
- // new FileTag
- // {
- // FileState = state,
- // Name = pair.Key,
- // Value = pair.Value
- // }
- // ).ToList();
-
+
//Do the save
state.Save();
}
});
}
-
+*/
+ public void StoreInfo(string path, ObjectInfo objectInfo)
+ {
+ if (String.IsNullOrWhiteSpace(path))
+ throw new ArgumentNullException("path");
+ if (!Path.IsPathRooted(path))
+ throw new ArgumentException("The path must be rooted", "path");
+ if (objectInfo == null)
+ throw new ArgumentNullException("objectInfo", "objectInfo can't be empty");
+ Contract.EndContractBlock();
+
+ _persistenceAgent.Post(() => StoreInfoDirect(path, objectInfo));
+
+ }
+
+ private void StoreInfoDirect(string path, ObjectInfo objectInfo)
+ {
+ try
+ {
+
+ using (var connection = GetConnection())
+ using (var command = new SQLiteCommand(connection))
+ {
+ if (StateExists(path, connection))
+ command.CommandText =
+ "update FileState set FileStatus= :fileStatus where FilePath = :path COLLATE NOCASE ";
+ else
+ {
+ command.CommandText =
+ "INSERT INTO FileState (Id,FilePath,Checksum,Version,VersionTimeStamp,FileStatus,OverlayStatus) VALUES (:id,:path,:checksum,:version,:versionTimeStamp,:fileStatus,:overlayStatus)";
+ command.Parameters.AddWithValue("id", Guid.NewGuid());
+ }
+
+ command.Parameters.AddWithValue("path", path);
+ command.Parameters.AddWithValue("checksum", objectInfo.Hash);
+ command.Parameters.AddWithValue("version", objectInfo.Version);
+ command.Parameters.AddWithValue("versionTimeStamp",
+ objectInfo.VersionTimestamp);
+ command.Parameters.AddWithValue("fileStatus", FileStatus.Unchanged);
+ command.Parameters.AddWithValue("overlayStatus",
+ FileOverlayStatus.Normal);
+
+ var affected = command.ExecuteNonQuery();
+ return;
+ }
+ }
+ catch (Exception exc)
+ {
+ Log.Error(exc.ToString());
+ throw;
+ }
+ }
+
+ private bool StateExists(string filePath,SQLiteConnection connection)
+ {
+ using (var command = new SQLiteCommand("Select count(*) from FileState where FilePath=:path COLLATE NOCASE", connection))
+ {
+ command.Parameters.AddWithValue("path", filePath);
+ var result = command.ExecuteScalar();
+ return ((long)result >= 1);
+ }
+
+ }
+
public void SetFileStatus(string path, FileStatus status)
- {
- UpdateStatus(path.ToLower(), state=>state.FileStatus = status);
+ {
+ if (String.IsNullOrWhiteSpace(path))
+ throw new ArgumentNullException("path");
+ if (!Path.IsPathRooted(path))
+ throw new ArgumentException("The path must be rooted", "path");
+ Contract.EndContractBlock();
+
+ _persistenceAgent.Post(() => UpdateStatusDirect(path, status));
}
public FileStatus GetFileStatus(string path)
throw new ArgumentException("The path must be rooted", "path");
Contract.EndContractBlock();
- var state = FileState.FindByFilePath(path);
- return (state==null)?FileStatus.Missing:state.FileStatus ;
+
+ using (var connection = GetConnection())
+ {
+ var command = new SQLiteCommand("select FileStatus from FileState where FilePath=:path COLLATE NOCASE", connection);
+ command.Parameters.AddWithValue("path", path);
+
+ var statusValue = command.ExecuteScalar();
+ if (statusValue==null)
+ return FileStatus.Missing;
+ return (FileStatus)Convert.ToInt32(statusValue);
+ }
}
+ /// <summary>
+ /// Deletes the status of the specified file
+ /// </summary>
+ /// <param name="path"></param>
public void ClearFileStatus(string path)
{
if (String.IsNullOrWhiteSpace(path))
throw new ArgumentException("The path must be rooted", "path");
Contract.EndContractBlock();
- //TODO:SHOULDN'T need both clear file status and remove overlay status
- _persistenceAgent.Post(() =>
- {
- using (new SessionScope())
- {
- FileState.DeleteByFilePath(path);
- }
- });
+ _persistenceAgent.Post(() => DeleteDirect(path));
}
- public void UpdateFileChecksum(string path, string checksum)
+ /// <summary>
+ /// Deletes the status of the specified folder and all its contents
+ /// </summary>
+ /// <param name="path"></param>
+ public void ClearFolderStatus(string path)
{
if (String.IsNullOrWhiteSpace(path))
throw new ArgumentNullException("path");
if (!Path.IsPathRooted(path))
- throw new ArgumentException("The path must be rooted", "path");
+ throw new ArgumentException("The path must be rooted", "path");
Contract.EndContractBlock();
- _persistenceAgent.Post(() =>
+ _persistenceAgent.Post(() => DeleteFolderDirect(path));
+ }
+
+ public IEnumerable<FileState> GetChildren(FileState fileState)
+ {
+ if (fileState == null)
+ throw new ArgumentNullException("fileState");
+ Contract.EndContractBlock();
+
+ var children = from state in FileState.Queryable
+ where state.FilePath.StartsWith(fileState.FilePath + "\\")
+ select state;
+ return children;
+ }
+
+ private int DeleteDirect(string filePath)
+ {
+ using (log4net.ThreadContext.Stacks["StatusAgent"].Push("DeleteDirect"))
{
- using (new SessionScope())
+
+ try
{
- var state = FileState.FindByFilePath(path);
- if (state == null)
+
+
+ using (var connection = GetConnection())
{
- Log.WarnFormat("[NOFILE] Unable to set checkesum for {0}.", path);
- return;
+ var command = new SQLiteCommand("delete from FileState where FilePath = :path COLLATE NOCASE",
+ connection);
+
+ command.Parameters.AddWithValue("path", filePath);
+
+ var affected = command.ExecuteNonQuery();
+ return affected;
}
- state.Checksum = checksum;
- state.Update();
}
- });
+ catch (Exception exc)
+ {
+ Log.Error(exc.ToString());
+ throw;
+ }
+ }
+ }
+
+ private int DeleteFolderDirect(string filePath)
+ {
+ using (log4net.ThreadContext.Stacks["StatusAgent"].Push("DeleteDirect"))
+ {
+
+ try
+ {
+
+
+ using (var connection = GetConnection())
+ {
+ var command = new SQLiteCommand("delete from FileState where FilePath = :path or FilePath like :path + '/%' COLLATE NOCASE",
+ connection);
+
+ command.Parameters.AddWithValue("path", filePath);
+
+ var affected = command.ExecuteNonQuery();
+ return affected;
+ }
+ }
+ catch (Exception exc)
+ {
+ Log.Error(exc.ToString());
+ throw;
+ }
+ }
+ }
+
+ public void UpdateFileChecksum(string path, string checksum)
+ {
+ if (String.IsNullOrWhiteSpace(path))
+ throw new ArgumentNullException("path");
+ if (!Path.IsPathRooted(path))
+ throw new ArgumentException("The path must be rooted", "path");
+ Contract.EndContractBlock();
+
+ _persistenceAgent.Post(() => FileState.UpdateChecksum(path, checksum));
}
}