public void DeleteRecordByIdTest() { var sql = new SqLiteTable("familyMoney.db", "testBase", "(id INTEGER PRIMARY KEY, Text_Entry NVARCHAR(2048) NULL)"); sql.InitializeDatabase(); var record = new List <KeyValuePair <string, object> > { new KeyValuePair <string, object>("Text_Entry", "\'Some Text \'") }; sql.AddData(record); sql.AddData(record); sql.AddData(record); sql.AddData(record); var lastRecord = sql.AddData(record); sql.DeleteRecordById(lastRecord); var lines = sql.SelectAll(); sql.DeleteDatabase(); Assert.AreEqual(4, lines.Count()); }
public void SqLiteInitDatabaseTest() { var sql = new SqLiteTable("familyMoney.db", "testBase", "(id INTEGER PRIMARY KEY, Text_Entry NVARCHAR(2048) NULL)"); sql.InitializeDatabase(); Assert.IsTrue(true); }