public void parseBackUpTest() { Database db = new Database("name"); MiniSQLEngine.MiniSQL q1 = db.Parse("BACKUP DATABASE database TO DISK = 'disk';"); Assert.IsInstanceOfType(q1, typeof(BackupDatabase)); }
public void parseDropDataBaseTest() { Database db = new Database("name"); MiniSQLEngine.MiniSQL q1 = db.Parse("DROP DATABASE database;"); Assert.IsInstanceOfType(q1, typeof(DropDataBase)); }
public void parseDropTableTest() { Database db = new Database("name"); MiniSQLEngine.MiniSQL q1 = db.Parse("DROP TABLE table;"); Assert.IsInstanceOfType(q1, typeof(DropTable)); }
public void parseCreateTableTest() { Database db = new Database("name"); MiniSQLEngine.MiniSQL q1 = db.Parse("CREATE TABLE table (column_def_1);"); Assert.IsInstanceOfType(q1, typeof(CreateTable)); }
public void parseCreateDatabaseTest() { Database db = new Database("name"); MiniSQLEngine.MiniSQL q1 = db.Parse("CREATE DATABASE database;"); Assert.IsInstanceOfType(q1, typeof(CreateDataBase)); }
public void addUserTest() { Database db = new Database("name"); db.setCurrentUser(db.GetUser("admin")); db.Parse("CREATE TABLE table (column TEXT);"); MiniSQLEngine.MiniSQL q1 = db.Parse("ADD USER (user, password, security_profile);"); Assert.IsInstanceOfType(q1, typeof(AddUser)); }
public void parseDeleteTest() { Database db = new Database("name"); db.setCurrentUser(db.GetUser("admin")); db.Parse("CREATE TABLE table (column TEXT);"); MiniSQLEngine.MiniSQL q1 = db.Parse("DELETE FROM table WHERE id=id1;"); Assert.IsInstanceOfType(q1, typeof(Delete)); }
public void parseSelectTest() { Database db = new Database("name"); db.setCurrentUser(db.GetUser("admin")); db.Parse("CREATE TABLE table (column TEXT);"); MiniSQLEngine.MiniSQL q1 = db.Parse("SELECT column FROM table;"); Assert.IsInstanceOfType(q1, typeof(Select)); }
public void parseInsertTest() { Database db = new Database("name"); db.setCurrentUser(db.GetUser("admin")); db.Parse("CREATE TABLE table (column TEXT);"); MiniSQLEngine.MiniSQL q1 = db.Parse("INSERT INTO table (column) VALUES (column1);"); Assert.IsInstanceOfType(q1, typeof(Insert)); }
public void deleteUserTest() { Database db = new Database("name"); db.setCurrentUser(db.GetUser("admin")); db.Parse("CREATE TABLE table (column TEXT);"); MiniSQLEngine.MiniSQL q1 = db.Parse("DELETE USER user;"); Assert.IsInstanceOfType(q1, typeof(DeleteUser)); }
public void revokeTest() { Database db = new Database("name"); db.setCurrentUser(db.GetUser("admin")); db.Parse("CREATE TABLE table (column TEXT);"); MiniSQLEngine.MiniSQL q1 = db.Parse("REVOKE privilege_type ON table TO security_profile;"); Assert.IsInstanceOfType(q1, typeof(Revoke)); }
public void dropSecurityTest() { Database db = new Database("name"); db.setCurrentUser(db.GetUser("admin")); db.Parse("CREATE TABLE table (column TEXT);"); MiniSQLEngine.MiniSQL q1 = db.Parse("DROP SECURITY PROFILE security_profile;"); Assert.IsInstanceOfType(q1, typeof(DropSecurity)); }