public void getTagsTest()
{
cleanup();
var dbHelper = getDatabaseHelper();
var todoReaderWriter = new TodoReaderWriter(dbHelper);
dbHelper.createTable("tag_maps");
dbHelper.addNotNullColumn("tag_maps", "name", "TEXT");
var tags = todoReaderWriter.getTags("tag_maps", "name");
}
public void addTagTest()
{
cleanup();
var dbHelper = getDatabaseHelper();
var todoReaderWriter = new TodoReaderWriter(dbHelper);
dbHelper.createTable("tag_maps");
dbHelper.addNotNullColumn("tag_maps", "name", "TEXT");
todoReaderWriter.addTag("tag_maps", "name", "tag1");
todoReaderWriter.addTag("tag_maps", "name", "tag2");
var tags = todoReaderWriter.getTags("tag_maps", "name");
Assert.AreEqual(tags[0], "tag1");
Assert.AreEqual(tags[1], "tag2");
}
public void deleteTagTest()
{
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");
Assert.AreEqual(dbHelper.getRecordCount(todoReaderWriter.tagsTableName), 2);
todoReaderWriter.deleteTag("testTag1");
Assert.AreEqual(dbHelper.getRecordCount(todoReaderWriter.tagsTableName), 1);
var tags = todoReaderWriter.getTags(todoReaderWriter.tagsTableName, TagsTableColumnName.name.ToString());
Assert.AreEqual(tags[0], "testTag2");
}
