// Tests for Butterfly queries
public static void butterflyQueryTests(DataManager dm, bool add, bool get, bool increment)
{
ButterflyQueryUnitTest bqTest = new ButterflyQueryUnitTest(dm.getConnection());
if (add)
{
Console.WriteLine("Test 1: Add Butterfly");
if (bqTest.unitTestAddButterfly(19, "Real Cool Butterfly"))
Console.WriteLine("Test 1: Success");
else
Console.WriteLine("Test 1: Success");
}
if (get)
{
Console.WriteLine("Test 2: Get Butterfly");
if (bqTest.unitTestGetButterfly(17))
Console.WriteLine("Test 2: Success");
else
Console.WriteLine("Test 2: Success");
Console.WriteLine("Test 3: Get All Butterflies");
if (bqTest.unitTestGetAll())
Console.WriteLine("Test 3: Success");
else
Console.WriteLine("Test 3: Success");
Console.WriteLine("Test 4: Get All Tags");
if (bqTest.unitTestGetAllTags())
Console.WriteLine("Test 4: Success");
else
Console.WriteLine("Test 4: Success");
}
if (increment)
{
Console.WriteLine("Test 5: Increment sightings");
if (bqTest.unitTestIncrementSightings(1))
Console.WriteLine("Test 5: Succesfully incremented");
else
Console.WriteLine("Test 5: Unable to increment");
}
}
// Tests for Common Sightings queries
public static void commonSightingsTests(DataManager dm)
{
CommonSightingsQueryUnitTest test = new CommonSightingsQueryUnitTest(dm.getConnection());
Console.WriteLine("Test 1: Get top locations");
try
{
test.testByLocation();
Console.WriteLine("Test 1: Success");
}
catch (MySqlException ex)
{
Console.WriteLine("Test 1: Failed");
Console.WriteLine(" " + ex.Message);
}
Console.WriteLine("Test 2: Get top dates");
try
{
test.testByDates();
Console.WriteLine("Test 2: Success");
}
catch (MySqlException ex)
{
Console.WriteLine("Test 2: Failed");
Console.WriteLine(" " + ex.Message);
}
Console.WriteLine("Test 3: Get top species");
try
{
test.testBySpecies();
Console.WriteLine("Test 3: Success");
}
catch (MySqlException ex)
{
Console.WriteLine("Test 3: Failed");
Console.WriteLine(" " + ex.Message);
}
}
public GUI_SightingHistory()
{
dm = new DataManager();
connection = dm.getConnection();
InitializeComponent();
TrackingEntryQuery query = new TrackingEntryQuery(connection);
List<TrackingEntry> entries = new List<TrackingEntry>();
entries = query.getAll();
if (entries != null)
{
foreach (TrackingEntry entry in entries)
{
int index = sightinghistorygrid.Rows.Add();
DataGridViewRow row = sightinghistorygrid.Rows[index];
row.Cells["Column1"].Value = entry.species;
row.Cells["Column2"].Value = entry.tagNumber;
row.Cells["Column3"].Value = entry.entryDate;
row.Cells["Column4"].Value = entry.taggerName;
row.Cells["Column5"].Value = entry.taggerID;
}
}
}
public GUI_CommonSightings()
{
dm = new DataManager();
connection = dm.getConnection();
InitializeComponent();
}
public GUI_TrackingEntry()
{
dm = new DataManager();
connection = dm.getConnection();
InitializeComponent();
}
public GUI_MigrationRoute()
{
dm = new DataManager();
connection = dm.getConnection();
InitializeComponent();
}
public GUI_ImportExport()
{
dm = new DataManager();
InitializeComponent();
}
static void Main(string[] args)
{
DataManager dm = new DataManager();
// Butterfly Query Tests
//butterflyQueryTests(dm, false, false, true);
// Common Sightings query tests
//commonSightingsTests(dm);
// Person Query Tests
//personTests(dm);
trackingEntryTests(dm, false, false, false, false, false, false,
false, true, false, false, false, false, false, false, false);
//locationQueryTests(dm.getConnection(), false, false, false, true);
//dateQueryTests(dm.getConnection(), false, false, true);
//trackingProcessingTests(dm.getConnection(), true, false, false, false);
//DateEntityTest test = new DateEntityTest(dm.getConnection());
//test.testDate();
Console.ReadKey();
dm.closeConnection();
}
public static void trackingEntryTests(DataManager dm, bool add, bool getByEntryID, bool getAll,
bool getByTag, bool getByTagOrdered, bool getInterval, bool getOn, bool getBySpecies,
bool getByLocation, bool getByLocationOrdered, bool getTagged, bool getNotTagged, bool getByType,
bool getByLocationCountry, bool getByLocationStateCountry)
{
TrackingEntryUnitTest test = new TrackingEntryUnitTest(dm.getConnection());
TrackingEntry entry = new TrackingEntry();
entry.taggerID = 1;
entry.type = 'T';
entry.isTagged = true;
entry.taggerName = "Sean Gallagher";
entry.entryDate = "2015-12-12 03:19:00";
entry.species = "Monarch";
entry.tagNumber = 1;
Console.WriteLine("\n--TRACKING ENTRY UNIT TESTS--");
if (add)
{
Console.WriteLine("Test 1: Add Tracking Entry");
if (test.unitTestAddEntry(entry))
Console.WriteLine(" Added successfully");
else
Console.WriteLine(" Not added");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getByEntryID)
{
Console.WriteLine("Test 2: Get Tracking Entry by entry ID");
if (test.unitTestGetEntry(4))
Console.WriteLine("Test 2: Success");
else
Console.WriteLine("Test 2: Entry not found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getAll)
{
Console.WriteLine("Test 3: Get all tracking entries");
if (test.unitTestGetAll())
Console.WriteLine("Test 3: Success");
else
Console.WriteLine("Test 3: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getByTag)
{
Console.WriteLine("Test 4: Get all by tag number");
if (test.unitTestGetByTag(126))
Console.WriteLine("Test 4: Success");
else
Console.WriteLine("Test 4: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getByTagOrdered)
{
Console.WriteLine("Test 5: Get all by tag number in ascending order");
if (test.unitTestGetByTagOrdered(126))
Console.WriteLine("Test 5: Success");
else
Console.WriteLine("Test 5: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getInterval)
{
Console.WriteLine("Test 6: Get all entries in an interval");
if (test.unitTestGetInterval("2015-11-1", "2015-11-20"))
Console.WriteLine("Test 6: Success");
else
Console.WriteLine("Test 6: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getOn)
{
Console.WriteLine("Test 7: Get all entries on a specific date");
if (test.unitTestGetOn("2015-11-1"))
Console.WriteLine("Test 7: Success");
else
Console.WriteLine("Test 7: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getBySpecies)
{
Console.WriteLine("Test 8: Get all entries by species");
if (test.unitTestGetBySpecies("Monarch"))
Console.WriteLine("Test 8: Success");
else
Console.WriteLine("Test 8: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
Console.WriteLine("Test 8: Get all entries by species and date");
if (test.unitTestGetBySpecies("Monarch", "2015-12-13"))
Console.WriteLine("Test 8: Success");
else
Console.WriteLine("Test 8: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getByLocation)
{
Console.WriteLine("Test 9: Get all entries by location");
if (test.unitTestGetByLocation("Dearborn", "MI", "USA"))
Console.WriteLine("Test 9: Success");
else
Console.WriteLine("Test 9: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getByLocationOrdered)
{
Console.WriteLine("Test 10: Get all entries by location in ascending order by date");
if (test.unitTestGetByLocationOrdered("Dearborn", "MI", "USA"))
Console.WriteLine("Test 10: Success");
else
Console.WriteLine("Test 10: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
Console.WriteLine("Test 10: Get all entries by location (state and country only)"
+ " in ascending order by date");
if (test.unitTestGetByLocationOrdered("MI", "USA"))
Console.WriteLine("Test 10: Success");
else
Console.WriteLine("Test 10: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
Console.WriteLine("Test 10: Get all entries by location (country only) in ascending order by date");
if (test.unitTestGetByLocationOrdered("USA"))
Console.WriteLine("Test 10: Success");
else
Console.WriteLine("Test 10: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getTagged)
{
Console.WriteLine("Test 11: Get all tagged entries");
if (test.unitTestGetTagged(true))
Console.WriteLine("Test 11: Success");
else
Console.WriteLine("Test 11: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getNotTagged)
{
Console.WriteLine("Test 12: Get all entries that are not tagged");
if (test.unitTestGetTagged(false))
Console.WriteLine("Test 12: Success");
else
Console.WriteLine("Test 12: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getByType)
{
Console.WriteLine("Test 13: Get all entries by type T");
if (test.unitTestGetByType('T'))
Console.WriteLine("Test 13: Success");
else
Console.WriteLine("Test 13: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
Console.WriteLine("Test 14: Get all entries by type S");
if (test.unitTestGetByType('S'))
Console.WriteLine("Test 14: Success");
else
Console.WriteLine("Test 14: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getByLocationCountry)
{
Console.WriteLine("Test 15: Get all entries by location (country only)");
if (test.unitTestGetByLocation("USA"))
Console.WriteLine("Test 15: Success");
else
Console.WriteLine("Test 15: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
if (getByLocationStateCountry)
{
Console.WriteLine("Test 16: Get all entries by location (state and country only");
if (test.unitTestGetByLocation("MI", "USA"))
Console.WriteLine("Test 16: Success");
else
Console.WriteLine("Test 16: No entries found");
Console.Write("-----------------------------------------");
Console.WriteLine("-----------------------------------------");
}
}
public static void personTests(DataManager dm)
{
PersonQueryUnitTest test = new PersonQueryUnitTest(dm.getConnection());
Person person = new Person();
person.name = "Sean Gallagher";
Console.WriteLine("Test 1: Add Person");
if (test.unitTestAddPerson(person))
Console.WriteLine("Test 1: Success");
else
Console.WriteLine("Test 1: Failed");
Console.WriteLine("Test 2: Get Person (by tag)");
if (test.unitTestGetPerson(1))
Console.WriteLine("Test 2: Success");
else
Console.WriteLine("Test 2: Failed");
Console.WriteLine("Test 3: Get Person (by name)");
if (test.unitTestGetPerson(person.name))
Console.WriteLine("Test 3: Success");
else
Console.WriteLine("Test 3: Failed");
Console.WriteLine("Test 4: Get All");
if (test.unitTestGetAll())
Console.WriteLine("Test 4: Success");
else
Console.WriteLine("Test 4: Failed");
}
public MainMenu()
{
dm = new DataManager();
InitializeComponent();
}
