public void TestManageDropDatabase()
{
string query = @"DROP DATABASE myDB;";
ClassParsing myClass = new ClassParsing();
string name = "myDB";
ClassDropDatabase myDroppedDatabase = new ClassDropDatabase(name);
Assert.AreEqual(myClass.ManageDropDatabase(query).getDatabaseName(), myDroppedDatabase.getDatabaseName());
}
public void TestManageDeleteCondition()
{
string query = @"DELETE FROM myTable WHERE id=1;";
ClassParsing myClass = new ClassParsing();
string name = "myTable";
string condition = "id=1";
ClassDelete myDeletedTable = new ClassDelete(name, condition);
Assert.AreEqual(myClass.ManageDelete(query).getCondition(), myDeletedTable.getCondition());
}
public void TestManageCreateDatabase()
{
string query = @"CREATE DATABASE myDB;";
ClassParsing myClass = new ClassParsing();
string name = "myDB";
ClassCreateDatabase myCreatedDB = new ClassCreateDatabase(name);
string a = myClass.ManageCreateDatabase(query).getName();
Assert.AreEqual(myClass.ManageCreateDatabase(query).getName(), myCreatedDB.getName());
}
public void TestManageDeleteTable()
{
string query = @"CREATE TABLE myTable (column1 int,column2 String,column3 int);";
ClassParsing myClass = new ClassParsing();
string name = "myTable";
string[] values = { "column1 int true", "column2 string false", "column3 int false" };
ClassCreateTable myCreatedTable = new ClassCreateTable(name, values);
Assert.AreEqual(myClass.ManageCreateTable(query).getTableName(), myCreatedTable.getTableName());
}
public void TestManageCreateTableTableValues()
{
string query = @"CREATE TABLE myTable (column1 int true,column2 string false,column3 int false);";
ClassParsing myClass = new ClassParsing();
//string name = "myTable";
string[] values = { "column1 int true", "column2 string false", "column3 int false" };
string[] expectedValues = myClass.ManageCreateTable(query).getTableValues();
for (int i = 0; i < values.Length; i++)
{
Assert.AreEqual(expectedValues[i], values[i]);
}
}
