// Start function called from the harness core
public void run()
{
ConsoleServices OutputManager = new ConsoleServices();
string path = Environment.ExpandEnvironmentVariables("%HOMEDRIVE%%HOMEPATH%") + "\\AppData\\Roaming\\ASLibTestHarness\\TestDB.sdf"; // Test Harness DB file path
// ^^^^^^^^^^^^^^^^^^^^^^^^^^ Grab user home path ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Append path to AppData folder and DB file
// Setup
Console.Write("Checking if target folder exists... ");
string dirPath = Environment.ExpandEnvironmentVariables("%HOMEDRIVE%%HOMEPATH%") + "\\AppData\\Roaming\\ASLibTestHarness";
if (!Directory.Exists(dirPath))
{
Console.Write("no, creating folder... ");
Directory.CreateDirectory(dirPath);
}
Console.WriteLine("Done.");
// Get image for later tests
Console.Write("Looking for comic 1023 test image... ");
if (!File.Exists(dirPath + "/1023.png"))
{
Console.Write("no. Please reimport the image to %APPDATA%/ASLibTestHarness.");
Console.ReadLine();
return;
}
Image imageFile = Image.FromFile(dirPath + "/1023.png");
Console.WriteLine("Done.");
Console.Write("Instantiating instance of ASComicDatabase... ");
ASComicDatabase testClass = new ASComicDatabase(path);
Console.WriteLine("Done.");
output = ""; // Reset this, just in case
Console.Write("\nTesting DB creation with path " + path + "... ");
if (testDBCreation(testClass))
{
OutputManager.writePassText();
}
else
{
OutputManager.writeFailText();
if (output != "")
{
Console.WriteLine("TEST OUTPUT:");
Console.WriteLine(output + "\n");
}
Console.WriteLine("Press any key to crash...");
Console.ReadLine();
throw new IOException("Cannot continue without read/write access to DB file!");
}
output = "";
Console.Write("\nTesting Data insertion (for metadata)... ");
if (testInsertMetadata(testClass))
{
OutputManager.writePassText();
if (output != "")
{
Console.WriteLine("TEST OUTPUT:");
Console.WriteLine(output + "\n");
}
}
else
{
OutputManager.writeFailText();
if (output != "")
{
Console.WriteLine("TEST OUTPUT:");
Console.WriteLine(output + "\n");
}
}
Console.Write("Please verify data manually from server explorer...");
Console.ReadLine();
output = "";
Console.Write("\nTesting Data retrieval (for metadata)... ");
if (testReadMetadata(testClass))
{
OutputManager.writePassText();
if (output != "")
{
Console.WriteLine("TEST OUTPUT:");
Console.WriteLine(output + "\n");
}
}
else
{
OutputManager.writeFailText();
if (output != "")
{
Console.WriteLine("TEST OUTPUT:");
Console.WriteLine(output + "\n");
}
}
output = "";
Console.Write("\nTesting image insert... ");
if (testInsertImageData(testClass,imageFile))
{
OutputManager.writePassText();
if (output != "")
{
Console.WriteLine("TEST OUTPUT:");
Console.WriteLine(output + "\n");
}
}
else
{
OutputManager.writeFailText();
if (output != "")
{
Console.WriteLine("TEST OUTPUT:");
Console.WriteLine(output + "\n");
}
}
output = "";
Console.Write("\nTesting image retrieval... ");
if (testReadImage(testClass, dirPath))
{
OutputManager.writePassText();
if (output != "")
{
Console.WriteLine("TEST OUTPUT:");
Console.WriteLine(output + "\n");
}
}
else
{
OutputManager.writeFailText();
if (output != "")
{
Console.WriteLine("TEST OUTPUT:");
Console.WriteLine(output + "\n");
}
}
Console.Write("Please verify data manually in %APPDATA%/ASLibTestHarness/testOut.png...");
Console.ReadLine();
output = "";
Console.Write("\nTesting image delete... ");
if (testDeleteImageData(testClass))
{
OutputManager.writePassText();
if (output != "")
{
Console.WriteLine("TEST OUTPUT:");
Console.WriteLine(output + "\n");
}
}
else
{
OutputManager.writeFailText();
if (output != "")
{
Console.WriteLine("TEST OUTPUT:");
Console.WriteLine(output + "\n");
}
}
Console.Write("Please verify data manually from server explorer...");
Console.ReadLine();
}
// Test getRow function
private bool testReadImage(ASComicDatabase engine, string dirPath)
{
Image img;
try
{
img = engine.getImageRow(1023);
img.Save(dirPath + "/testOut.png");
}
catch
{
return false; // Query failed
}
return true;
}
// Test getRow function
private bool testReadMetadata(ASComicDatabase engine)
{
Dictionary<string,string> dict = new Dictionary<string,string>();
try
{
dict = engine.getRow(1023);
}
catch
{
return false; // Query failed
}
if (dict.ContainsKey("safe_title") && dict.ContainsValue("Late-Night PBS"))
{
return true; // Verified there is actually valid data coming back
}
return false;
}
// Test the insertRow function
private bool testInsertMetadata(ASComicDatabase engine)
{
try
{
ASComicAccess.xkcd.ComicMetadata meta = new ASComicAccess.xkcd.ComicMetadata();
meta.num = "1023";
meta.img = "http://imgs.xkcd.com/comics/late_night_pbs.png";
meta.safe_title = "Late-Night PBS";
meta.alt = "Then it switched to these old black-and-white tapes of Bob Ross slumped against the wall of an empty room, painting the least happy trees you've ever seen. Either PBS needs to beef up studio security or I need to stop using Ambien to sleep.";
meta.transcript = "[[Scruffy is rubbing sleep out of their eyes and talking to clean shaven.]]\nScruffy: Have you ever watched PBS late at night?\nScruffy: I fell asleep after \nDownton\n and woke up at like 3 AM.\n\n[[The upper portion of the panel continues dialogue, while the lower shows a drunk gameshow host and several contestants. The monitor shows a field of crosses, presumably graves.]]\nScruffy: \nWhere in the World is Carmen Sandiego\n was back on, except the host hadn't aged well and he'd clearly been drinking.\nScruffy: Every question took them to some horrible place like Mogadishu or the Cambodian killing fields.\n\n[[Now it shows a bookshelf revealing a hidden room.]]\nScruffy: The kids were freaked out, but they kept playing. Eventually they were told they'd found Carmen Sandiego hiding behind a bookshelf in a Dutch apartment.\n\nScruffy: The Chief appeared and asked \"Are you \nproud\n of what you've become?\"\nScruffy: Then Rockapella walked out and just glared at the kids until they started crying.\nClean-shaven: I, uh, don't remember the old show being that dark.\nScruffy: Maybe we were too young to pick up on it.\n\n{{Title text: Then it switched to these old black-and-white tapes of Bob Ross slumped against the wall of an empty room, painting the least happy trees you've ever seen. Either PBS needs to beef up studio security or I need to stop using Ambien to sleep.}}";
meta.day = "29";
meta.month = "03";
meta.year = "2012";
engine.insertRow(meta);
}
catch
{
return false;
}
return true;
}
// Test updateImgData function
private bool testInsertImageData(ASComicDatabase engine, Image imageFile)
{
try
{
engine.updateImgData(1023, imageFile);
}
catch
{
return false;
}
return true;
}
// Test deleteImgData function
private bool testDeleteImageData(ASComicDatabase engine)
{
try
{
engine.deleteImgData(1023);
}
catch
{
return false;
}
return true;
}
// Test the createDbFile function
private bool testDBCreation(ASComicDatabase engine)
{
try
{
engine.createDbFile();
}
catch (System.IO.IOException e)
{
output = "IOException: Process could not access file.\n\nFULL TRACE:\n" + e.ToString();
return false;
}
catch (Exception e)
{
Debug.WriteLine("UNKNOWN EXCEPTION CAUGHT FROM DB ENGINE:\n\n" + e.ToString()); // Log exception to debug channel
return false; // Fail test
}
return true; // Pass test
}
// Initializer (yes yes, US spelling. Programming convention. I swear.)
internal ViewerCore()
{
// Setup ASLibs components
dbEngine = new ASComicDatabase(Environment.ExpandEnvironmentVariables("%HOMEDRIVE%%HOMEPATH%") + "\\AppData\\Roaming\\xkcd Viewer\\xkcd.sdf");
accessEngine = new ASComicAccess.xkcd();
}
