public void UseWithoutParams() { String expected = "Invalid DBname"; String actual = DbInterpretter.Execute("use"); Assert.AreEqual(expected, actual); }
public void CorrectUseOfUse() { String expected = "Database unitTestingDB set active as empty. you can try to restore."; String actual = DbInterpretter.Execute("use unitTestingDB"); Assert.AreEqual(expected, actual); }
public void ExecuteDropHelp() { String expected = "Drop tbName |-> Drop table from current db"; String actual = DbInterpretter.Execute("drop -h"); Assert.AreEqual(expected, actual); }
public void ExecuteUpdateHelp() { String expected = "Update <table name> set <field=value>+ where <condition> |-> Update table entries on selected fields"; String actual = DbInterpretter.Execute("update -h"); Assert.AreEqual(expected, actual); }
public void ExecuteHelpHelp() { String expected = "help |-> this help"; String actual = DbInterpretter.Execute("help -h"); Assert.AreEqual(expected, actual); }
public void ExecuteCreateHelp() { String expected = "Create <table> (<field names>) |-> Create a table on current db"; String actual = DbInterpretter.Execute("create -h"); Assert.AreEqual(expected, actual); }
public void ExecuteByeHelp() { String expected = "bye |-> quit"; String actual = DbInterpretter.Execute("bye -h"); Assert.AreEqual(expected, actual); }
public void ExecuteSelectHelp() { String expected = "Select <*|fields list> from <table> [where <condition>] |-> List tables from current db"; String actual = DbInterpretter.Execute("select -h"); Assert.AreEqual(expected, actual); }
public void ExecuteDeleteHelp() { String expected = "Delete from <table name> where <condition> |-> Delete table from current db"; String actual = DbInterpretter.Execute("delete -h"); Assert.AreEqual(expected, actual); }
public void ExecuteUseHelp() { String expected = "Use DBname |-> Set the DBname database active (as empty)"; String actual = DbInterpretter.Execute("use -h"); Assert.AreEqual(expected, actual); }
public void ExecuteInsertHelp() { String expected = "Insert into <table name> (<fields list>) values (<values list>) |-> Insert int table on current db"; String actual = DbInterpretter.Execute("insert -h"); Assert.AreEqual(expected, actual); }
public void ExecuteSaveHelp() { String expected = "Save [path] |-> Saves the database to a provided or default path " + "\nSave tableName [path] [CSV] |-> Saves a table from current DB to a provided or default path"; String actual = DbInterpretter.Execute("Save -h"); Assert.AreEqual(expected, actual); }
public void ExecuteRestoreHelp() { String expected = "Restore [path [CSV]] |-> Restore the database from a provided or default path " + "\nRestore tbName [path [CSV]] |-> Restore a table from current DB from a provided or default path"; String actual = DbInterpretter.Execute("Restore -h"); Assert.AreEqual(expected, actual); }
public void ByeTest() { String expected = "Bye!"; String actual = DbInterpretter.Execute("bye"); Assert.AreEqual(actual, expected); Assert.AreEqual(DbInterpretter.isRunning, false); }
public void RestoreWithoutParamsTest() { String expected = "Database unitTestingDB set active as empty. you can try to restore."; String actual = DbInterpretter.Execute("use unitTestingDB"); Assert.AreEqual(expected, actual); expected = "Database error: Invalid db load path path:DB.unitTestingDB"; actual = DbInterpretter.Execute("restore"); Assert.AreEqual(expected, actual); }
public void CreateWithoutParamsTest() { String expected = "Database unitTestingDB set active as empty. you can try to restore."; String actual = DbInterpretter.Execute("use unitTestingDB"); Assert.AreEqual(expected, actual); expected = "Ceva Eroare??????? TO DO!"; actual = DbInterpretter.Execute("create"); Assert.AreEqual(expected, actual); }
public void DropWithoutParamsTest() { String expected = "Database unitTestingDB set active as empty. you can try to restore."; String actual = DbInterpretter.Execute("use unitTestingDB"); Assert.AreEqual(expected, actual); expected = "Database error: Table not in db."; actual = DbInterpretter.Execute("drop"); Assert.AreEqual(expected, actual); }
public void CreateWithColumns() { String expected = "Database unitTestingDB set active as empty. you can try to restore."; String actual = DbInterpretter.Execute("use unitTestingDB"); Assert.AreEqual(expected, actual); expected = "Ok"; actual = DbInterpretter.Execute("Create unitTestingTable1 (col1, col2)"); Assert.AreEqual(expected, actual); }
public void CreateWithoutColumns() { String expected = "Database unitTestingDB set active as empty. you can try to restore."; String actual = DbInterpretter.Execute("use unitTestingDB"); Assert.AreEqual(expected, actual); expected = "Console error: Syntax error"; actual = DbInterpretter.Execute("Create unitTestingTable1"); Assert.AreEqual(expected, actual); }
public void SaveWithoutParamsTest() { String expected = "Database unitTestingDB set active as empty. you can try to restore."; String actual = DbInterpretter.Execute("use unitTestingDB"); Assert.AreEqual(expected, actual); expected = "Database error: Save to DB.unitTestingDB failed!"; actual = DbInterpretter.Execute("save"); Assert.AreEqual(expected, actual); }
public void UpdateWithoutParamsTest() { String expected = "Database unitTestingDB set active as empty. you can try to restore."; String actual = DbInterpretter.Execute("use unitTestingDB"); Assert.AreEqual(expected, actual); expected = "Database error: No table named "; actual = DbInterpretter.Execute("update"); Assert.AreEqual(expected, actual); }
public void DropTableTest() { String expected = "Database unitTestingDB set active as empty. you can try to restore."; String actual = DbInterpretter.Execute("use unitTestingDB"); Assert.AreEqual(expected, actual); expected = "Ok"; actual = DbInterpretter.Execute("Create unitTestingTable1 (col1, col2)"); Assert.AreEqual(expected, actual); expected = "Table unitTestingTable1 removed"; actual = DbInterpretter.Execute("drop unitTestingTable1"); Assert.AreEqual(expected, actual); expected = "Database error: No table named unitTestingTable1"; actual = DbInterpretter.Execute("Select * from unitTestingTable1"); Assert.AreEqual(expected, actual); }