public void setup() { util = new PendingToResourceUtil("Data Source=db", "dev_folder", Path.Combine(Environment.CurrentDirectory, "res")); if (Directory.Exists("res")) { Directory.Delete("res", true); } }
public void MoveDbRecords() { var util = new PendingToResourceUtil(ConnString, "dev", "res"); util.MoveDbRecord( new List <FileData> { new FileData { file_id = file_ids[0], saved_path = "newp0", parent_folder = "parent0" }, new FileData { file_id = file_ids[1], saved_path = "newp1", parent_folder = "parent1" }, }); ///// verify using (var conn = new SQLiteConnection(ConnString)) { conn.Open(); int i = 0; foreach (var fid in new Guid[] { file_ids[0], file_ids[1] }) { using (var cmd = conn.CreateCommand()) { cmd.CommandText = "select * from Files where file_id = @id"; cmd.Parameters.Add(new SQLiteParameter("@id", fid)); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { Assert.AreEqual("name_" + i, reader["file_name"]); Assert.AreEqual("path_" + i, reader["file_path"]); Assert.AreEqual(1000L + i, reader["file_size"]); Assert.AreEqual("newp" + i, reader["saved_path"]); Assert.AreEqual("parent" + i, reader["parent_folder"]); Assert.AreEqual(dev_id, reader["device_id"]); Assert.AreEqual(0L, reader["type"]); Assert.AreEqual(1024L, reader["width"]); Assert.AreEqual(768L, reader["height"]); } } } using (var checkCmd = conn.CreateCommand()) { checkCmd.CommandText = "select 1 from PendingFiles where file_id= @id"; checkCmd.Parameters.Add(new SQLiteParameter("@id", file_ids[0])); Assert.AreEqual(null, checkCmd.ExecuteScalar()); } i++; } // foreach } }
public void GetPendingFiles() { var util = new PendingToResourceUtil(ConnString, "dev", "res"); var fids = file_ids.Take(2).ToList(); var result = util.GetPendingFiles(fids).OrderBy(x => x.file_id).ToList(); Assert.AreEqual(2, result.Count); Assert.AreEqual(fids[0], result[0].file_id); Assert.AreEqual("name_0", result[0].file_name); Assert.AreEqual("saved_0", result[0].saved_path); Assert.AreEqual("devfolder", result[0].dev_folder); Assert.AreEqual(fids[1], result[1].file_id); Assert.AreEqual("name_1", result[1].file_name); Assert.AreEqual("saved_1", result[1].saved_path); Assert.AreEqual("devfolder", result[1].dev_folder); }