public SQLiteTest()
{
db = SQLite.ConnectFile(@"C:\Temp\1.db");
db.T("DROP TABLE IF EXISTS Test1").ExecuteNonQuery();
db.T(@"
CREATE TABLE [Test1]
(
[Name] NVARCHAR(50) NOT NULL ,
[Content] NTEXT NULL,
[Index] INT NOT NULL
)").ExecuteNonQuery();
}
public SQLiteTest()
{
db = SQLite.ConnectFile( @"C:\Temp\1.db" );
db.T( "DROP TABLE IF EXISTS Test1" ).ExecuteNonQuery();
db.T( @"
CREATE TABLE [Test1]
(
[Name] NVARCHAR(50) NOT NULL ,
[Content] NTEXT NULL,
[Index] INT NOT NULL
)" ).ExecuteNonQuery();
}
public void StandardTest1()
{
Assert.IsNull(db.T("SELECT Name FROM Test1").ExecuteScalar(), "空数据表查询测试失败");
Assert.IsNull(db.T("SELECT Name FROM Test1").ExecuteFirstRow(), "空数据表查询测试失败");
Assert.AreEqual(db.T("SELECT COUNT(*) FROM Test1").ExecuteScalar <long>(), 0, "空数据表查询测试失败");
Assert.AreEqual(db.T("INSERT INTO Test1 ( Name, Content, [Index] ) VALUES ( {...} )", "Ivony", "Test", 1).ExecuteNonQuery(), 1, "插入数据测试失败");
Assert.AreEqual(db.T("SELECT * FROM Test1").ExecuteDynamics().Length, 1, "插入数据后查询测试失败");
Assert.IsNotNull(db.T("SELECT Name FROM Test1").ExecuteFirstRow(), "插入数据后查询测试失败");
var dataItem = db.T("SELECT * FROM Test1").ExecuteDynamicObject();
Assert.AreEqual(dataItem.Name, "Ivony", "插入数据后查询测试失败");
Assert.AreEqual(dataItem["Content"], "Test", "插入数据后查询测试失败");
}
