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