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]); } }