public void GuidDoesExist()
{
_w.output("GUIDDOESEXIST");
bool result = false;
_w.output("here1");
// Create a test database
FAKE_SqlLiteDatabase db = CreateTestDatabase(String.Format("{0}", dbConstants.ID));
_w.output("here");
try {
db.InsertData(dbConstants.table_name, new string[3] {
dbConstants.STATUS,
dbConstants.XML,
dbConstants.GUID
}
, new object[3] {
"boo status", "boo xml", "GUID_A"
});
result = db.TestAddMissingColumn(dbConstants.table_name, new string[1] {
"boomer"
},
new string[1] {
"TEXT"
});
} catch (Exception ex) {
_w.output(ex.ToString());
}
_w.output("here");
Assert.True(db.Exists(dbConstants.table_name, dbConstants.GUID, "GUID_A"));
_w.output(result);
}
public void GuidDoesNotExist()
{
// Create a test database
FAKE_SqlLiteDatabase db = CreateTestDatabase(String.Format("{0}", dbConstants.ID));
db.InsertData(dbConstants.table_name, new string[3] {
dbConstants.STATUS, dbConstants.XML, dbConstants.GUID
}, new object[3] {
"boo status", "boo xml", "GUID_A"
});
bool result = db.TestAddMissingColumn(dbConstants.table_name, new string[1] {
"boomer"
},
new string[1] {
"TEXT"
});
Console.WriteLine("GuidDoesNotExist");
Assert.False(db.Exists(dbConstants.table_name, dbConstants.GUID, "GUID_B"));
}
public void AddingToUniqueColumn()
{
// Create a test database
FAKE_SqlLiteDatabase db = CreateTestDatabase(String.Format("{0}", dbConstants.GUID));
Console.WriteLine("First insert should work");
if (db.Exists("boo", dbConstants.XML, "z"))
{
}
;
db.InsertData(dbConstants.table_name, new string[3] {
dbConstants.STATUS,
dbConstants.XML,
dbConstants.GUID
}
, new object[3] {
"boo status", "boo xml", "GUID_A"
});
Console.WriteLine("inserting a unique GUID_B is okay");
db.InsertData(dbConstants.table_name, new string[3] {
dbConstants.STATUS,
dbConstants.XML,
dbConstants.GUID
}
, new object[3] {
"boo status", "boo xml", "GUID_B"
});
Console.WriteLine("Second insert should fail ");
db.InsertData(dbConstants.table_name, new string[3] {
dbConstants.STATUS,
dbConstants.XML,
dbConstants.GUID
}
, new object[3] {
"boo status", "boo xml", "GUID_A"
});
}
