public int Update(CollectTaskInfo taskInfo)
{
var sqlBuffer = new StringBuilder();
sqlBuffer.Append("UPDATE CollectTasks SET ");
sqlBuffer.Append($"Status = {(int)taskInfo.Status}, RetryCount = {taskInfo.RetryCount} ");
sqlBuffer.Append($"WHERE Id = {taskInfo.Id}");
return(SqliteProxy.Execute(sqlBuffer.ToString()));
}
public int Insert(CollectContentInfo contentInfo)
{
var sqlBuffer = new StringBuilder();
sqlBuffer.Append("INSERT INTO CollectContents (CollectId,CollectTaskId,Content) ");
sqlBuffer.Append($"SELECT {contentInfo.CollectId},{contentInfo.CollectTaskId},'{contentInfo.Content}' ");
sqlBuffer.Append($"WHERE NOT EXISTS (SELECT * FROM CollectContents WHERE CollectId = {contentInfo.CollectId} AND CollectTaskId = {contentInfo.CollectTaskId})");
return(SqliteProxy.Execute(sqlBuffer.ToString()));
}
public int Insert(CollectTaskInfo taskInfo)
{
var sqlBuffer = new StringBuilder();
sqlBuffer.Append("INSERT INTO CollectTasks (ParentId,CollectId,Uri,ScriptFilePath,Status,RetryCount) ");
sqlBuffer.Append($"SELECT {taskInfo.ParentId},{taskInfo.CollectId},'{taskInfo.Uri}','{taskInfo.ScriptFilePath}',{(int)taskInfo.Status},{taskInfo.RetryCount} ");
sqlBuffer.Append($"WHERE NOT EXISTS (SELECT * FROM CollectTasks WHERE Uri = '{taskInfo.Uri}')");
return(SqliteProxy.Execute(sqlBuffer.ToString()));
}
public CollectInfo SelectSingle(int id)
{
var sql = $"SELECT * FROM Collects WHERE Id = {id}";
return(SqliteProxy.SelectSingle(sql, this.Convert));
}
public int Insert(CollectInfo collectInfo)
{
var sql = $"INSERT INTO Collects VALUES('{collectInfo.Id}','{collectInfo.Name}','{collectInfo.ScriptFilePath}')";
return(SqliteProxy.Execute(sql));
}
public int Update(int collectId, CollectTaskStatus oldStatus, CollectTaskStatus newStatus)
{
var sql = $"UPDATE CollectTasks SET Status = {(int)newStatus} WHERE CollectId = {collectId} AND Status = {(int)oldStatus}";
return(SqliteProxy.Execute(sql));
}
public CollectTaskInfo SelectSingle(int collectId, CollectTaskStatus status)
{
var sql = $"SELECT * FROM CollectTasks WHERE CollectId = {collectId} AND Status = {(int)status}";
return(SqliteProxy.SelectSingle(sql, this.Convert));
}
