public void TestInMemory()
{
var db = new nac.Database.SQLite.Database(null);
db.Command(@"
create table if not exists m1(
p1 varchar(50) not null,
p2 int not null,
p3 varchar(51) not null
)
");
for (int r = 0; r < 50; ++r)
{
db.Command(@"
insert into m1(p1,p2,p3)
values(:p1,:p2,:p3)
", new Dictionary <string, object> {
{ ":p1", "" },
{ ":p2", -1 },
{ ":p3", "" }
});
}
var results = db.Query(@"
select *
from m1
");
Assert.IsTrue(results.Count > 40);
}
public void CreatePopulateAndReadFromTestTable()
{
var db = new nac.Database.SQLite.Database(@"~/Desktop/temp/test.db");
db.Command(@"
drop table if exists test;
CREATE TABLE test(
id INTEGER PRIMARY KEY AUTOINCREMENT,
timestamp datetime DEFAULT CURRENT_TIMESTAMP,
val1 varchar(50),
val2 varchar(50),
val3 varchar(50)
);
");
db.Command(@"
INSERT INTO test (val1,val2,val3)
VALUES(@v1, @v2, @v3)
", new System.Collections.Generic.Dictionary <string, object>
{
{ "@v1", "7" },
{ "@v2", "Happy Birthday!" },
{ "@v3", "8" }
});
var dt = db.Query(@"
select *
from test
");
Assert.IsTrue(string.Equals(dt[0]["val2"] as string, "Happy Birthday!", StringComparison.OrdinalIgnoreCase));
Assert.IsTrue(string.Equals(dt[0]["val3"], "8"));
}
private static void setupDatabase()
{
__internalDatabaseRef = new nac.Database.SQLite.Database(Properties.Settings.Default.DatabaseFilePath);
__internalDatabaseRef.Command(@"
create table if not exists RecentFiles(
FileName varchar(200) not null,
FullPath varchar(2000) not null
)
");
//__internalDatabaseRef.Command(@"drop table HtmlSnippets");
__internalDatabaseRef.Command(@"
create table if not exists HtmlSnippets(
BaseFilePath varchar(2000) not null,
FilePath varchar(2000) not null,
FileName varchar(2000) not null
)
");
}
