Пример #1
0
        public void ExecuteUpdateTableTest()
        {
            string dbfile = "taskaludb12.sqlite";
            string path   = Path.GetTempPath() + "\\" + dbfile;

            CreateSQLiteDBFlie(dbfile);
            CreateTableTaskList(dbfile);
            InsertTableTaskList(dbfile, "hoge", 0);

            ListViewFile lvf = new ListViewFile();

            lvf.CreateDate  = new DateTime(2018, 1, 1, 9, 0, 0, DateTimeKind.Utc).ToString("yyyy-MM-dd HH:mm:ss"); //dummy
            lvf.Description = "description2";
            lvf.DueDate     = new DateTime(2019, 1, 1, 9, 1, 0, DateTimeKind.Utc).ToString("yyyy-MM-dd HH:mm:ss");
            lvf.Id          = 0; //dummy
            lvf.Memo        = "memo2";
            lvf.Name        = "name2";
            lvf.Priority    = "";
            lvf.Status      = "Active";
            lvf.WorkHolder  = Path.GetTempPath();

            Debug.Assert(SQLiteClass.ExecuteUpdateTable(path, lvf));
        }