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