public void detachTagTest()
{
cleanup();
var dbHelper = getDatabaseHelper();
var todoReaderWriter = new TodoReaderWriter(dbHelper);
dbHelper.createTable(todoReaderWriter.tagMapsTableName);
dbHelper.addNotNullColumn(todoReaderWriter.tagMapsTableName, TagMapsTableColumnName.tag_id.ToString(), "INTEGER");
dbHelper.addNotNullColumn(todoReaderWriter.tagMapsTableName, TagMapsTableColumnName.todo_id.ToString(), "INTEGER");
todoReaderWriter.attachTag(0, 0);
todoReaderWriter.attachTag(0, 1);
todoReaderWriter.attachTag(1, 2);
Assert.AreEqual(dbHelper.getRecordCount(todoReaderWriter.tagMapsTableName), 3);
todoReaderWriter.detachTag(0, 0);
Assert.AreEqual(dbHelper.getRecordCount(todoReaderWriter.tagMapsTableName), 2);
todoReaderWriter.detachTag(0, 1);
Assert.AreEqual(dbHelper.getRecordCount(todoReaderWriter.tagMapsTableName), 1);
// 仮に消す対象が存在しなくても正常に処理は終了する。
todoReaderWriter.detachTag(0, 1);
Assert.AreEqual(dbHelper.getRecordCount(todoReaderWriter.tagMapsTableName), 1);
var dics = dbHelper.select("select * FROM " + todoReaderWriter.tagMapsTableName)[0];
Assert.AreEqual(dics[TagMapsTableColumnName.todo_id.ToString()], (long)1);
Assert.AreEqual(dics[TagMapsTableColumnName.tag_id.ToString()], (long)2);
}
public void attachTagTest()
{
cleanup();
var dbHelper = getDatabaseHelper();
var todoReaderWriter = new TodoReaderWriter(dbHelper);
dbHelper.createTable(todoReaderWriter.tagMapsTableName);
dbHelper.addNotNullColumn(todoReaderWriter.tagMapsTableName, TagMapsTableColumnName.tag_id.ToString(), "INTEGER");
dbHelper.addNotNullColumn(todoReaderWriter.tagMapsTableName, TagMapsTableColumnName.todo_id.ToString(), "INTEGER");
todoReaderWriter.attachTag(0, 0);
todoReaderWriter.attachTag(0, 1);
todoReaderWriter.attachTag(1, 1);
todoReaderWriter.attachTag(1, 1);
// 4回タグの付与を行う。重複を一つ含むため、最終的なレコード数は 3 になる。
Assert.AreEqual(dbHelper.getRecordCount(todoReaderWriter.tagMapsTableName), 3);
dbHelper.createTable(todoReaderWriter.tagsTableName);
dbHelper.addNotNullColumn(todoReaderWriter.tagsTableName, TagsTableColumnName.name.ToString(), "TEXT");
todoReaderWriter.addTag(todoReaderWriter.tagsTableName, TagsTableColumnName.name.ToString(), "tag0");
todoReaderWriter.addTag(todoReaderWriter.tagsTableName, TagsTableColumnName.name.ToString(), "tag1");
Todo[] todos = { new Todo(), new Todo() };
todos[0].Title = "todo0title";
todos[1].Title = "todo1title";
todoReaderWriter.add(todos[0]);
todoReaderWriter.add(todos[1]);
List <Tag> tags0 = new List <Tag>(new Tag[] { new Tag("tag0") });
List <Tag> tags1 = new List <Tag>(new Tag[] { new Tag("tag1") });
Assert.AreEqual(todoReaderWriter.getTodoFromTag(tags0).Count, 1);
Assert.AreEqual(todoReaderWriter.getTodoFromTag(tags1).Count, 2);
Assert.AreEqual(todoReaderWriter.getTodoFromTag(tags0)[0].Title, "todo0title");
Assert.AreEqual(todoReaderWriter.getTodoFromTag(tags1)[0].Title, "todo0title");
Assert.AreEqual(todoReaderWriter.getTodoFromTag(tags1)[1].Title, "todo1title");
}
public void getTodoTest1()
{
cleanup();
var dbHelper = getDatabaseHelper();
var todoReaderWriter = new TodoReaderWriter(dbHelper);
dbHelper.createTable(todoReaderWriter.tagsTableName);
dbHelper.addNotNullColumn(todoReaderWriter.tagsTableName, TagsTableColumnName.name.ToString(), "TEXT");
todoReaderWriter.addTag(todoReaderWriter.tagsTableName, TagsTableColumnName.name.ToString(), "testTag1");
todoReaderWriter.addTag(todoReaderWriter.tagsTableName, TagsTableColumnName.name.ToString(), "testTag2");
dbHelper.createTable(todoReaderWriter.tagMapsTableName);
dbHelper.addNotNullColumn(todoReaderWriter.tagMapsTableName, TagMapsTableColumnName.tag_id.ToString(), "INTEGER");
dbHelper.addNotNullColumn(todoReaderWriter.tagMapsTableName, TagMapsTableColumnName.todo_id.ToString(), "INTEGER");
var todos = new List <Todo>(new Todo[] {
new Todo(new DateTime(2010, 01, 01), 0),
new Todo(new DateTime(2010, 01, 01), 1),
new Todo(new DateTime(2010, 01, 01), 2),
new Todo(DateTime.Now, 3),
new Todo(DateTime.Now, 4)
});
todos[0].IsCompleted = true;
todos[1].IsCompleted = true;
todos.ForEach(t => todoReaderWriter.add(t));
todoReaderWriter.attachTag(0, 0);
todoReaderWriter.attachTag(1, 0);
todoReaderWriter.attachTag(1, 1);
todoReaderWriter.attachTag(2, 1);
todoReaderWriter.attachTag(3, 1);
var todoSearchOption = new TodoSearchOption();
todoSearchOption.TagSearchTypeIsOR = true;
// タグ指定なしで実行した場合は全todoが返る
Assert.AreEqual(todoReaderWriter.getTodo(todoSearchOption).Count, 5);
todoSearchOption.Tags = new List <Tag>(new Tag[] { new Tag("testTag1"), new Tag("testTag2") });
var tt = todoReaderWriter.getTodo(todoSearchOption);
Assert.AreEqual(todoReaderWriter.getTodo(todoSearchOption).Count, 4); // タグがついていないTodoが一つあるので、5 - 1 で 4
todoSearchOption.Tags = new List <Tag>(new Tag[] { new Tag("testTag1") });
Assert.AreEqual(todoReaderWriter.getTodo(todoSearchOption).Count, 2);
todoSearchOption.Tags = new List <Tag>(new Tag[] { new Tag("testTag2") });
todoSearchOption.ShouldSelectComplitionTodo = false;
todoSearchOption.SearchStartPoint = new DateTime(2015, 01, 01);
Assert.AreEqual(todoReaderWriter.getTodo(todoSearchOption).Count, 1);
todoSearchOption = new TodoSearchOption();
todoSearchOption.Tags = new List <Tag>(new Tag[] { new Tag("testTag1"), new Tag("testTag2") });
todoSearchOption.TagSearchTypeIsOR = false;
Assert.AreEqual(todoReaderWriter.getTodo(todoSearchOption).Count, 1);
todoSearchOption.TagSearchTypeIsOR = true;
todoSearchOption.ResultCountLimit = 2;
Assert.AreEqual(todoReaderWriter.getTodo(todoSearchOption).Count, 2);
}
