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 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(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 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)); }