public void DropDB()
{
SQLParser par = new SQLParser();
DropDB sbres = (DropDB)par.Parser("DROP DATABASE db1;");
DropDB sel = new DropDB("db1");
Assert.AreEqual(sbres.GetType(), sel.GetType());
Assert.AreEqual(sbres.getDB(), sel.getDB());
}
/// <summary>
/// Drops the specified database.
/// </summary>
/// <param name="name">The name of the database to drop.</param>
/// <returns>True if the database was found and successfully dropped, false otherwise.</returns>
public static bool Drop(string name)
{
if (name == null)
{
throw new ArgumentNullException("name");
}
if (name == String.Empty)
{
throw new ArgumentException("name");
}
//Only drop if not currently pinned
if (Context.pinned(name))
{
throw new ArgumentException("Database is currently open, please dispose all references and try again.");
}
//Attempt to drop
return(DropDB.drop(name, Context));
}
public SQLtype Parser(string query)
{
//CREATE TABLE
Column[] ct2 = new Column[10];
string[] ct3 = new string[10]; //*
string ct1 = "";
Match matchcreate1 = Regex.Match(query, createTable1);
Match matchcreate2 = Regex.Match(query, createTable2);
if (matchcreate1.Success)
{
ct1 = matchcreate1.Groups[1].Value;
ct3[0] = matchcreate1.Groups[2].Value;
//ct2[0].name = matchcreate1.Groups[2].Value;
//ct2[0].type = matchcreate1.Groups[2].Value;
SQLtype sentencia = new CreateTable(ct1, ct3); //tipos de momento sin implementar*
return(sentencia);
}
else if (matchcreate2.Success)
{
ct1 = matchcreate2.Groups[1].Value;
ct3[0] = matchcreate2.Groups[2].Value; //*
//ct2[0].name = matchcreate2.Groups[2].Value;
//ct2[0].type = matchcreate2.Groups[2].Value;
for (int i = 0; i < matchcreate2.Groups[5].Captures.Count; i++)
{
ct3[i + 1] = matchcreate2.Groups[5].Captures[i].Value; //*
/*ct2[i + 1].name = matchcreate2.Groups[5].Captures[i].Value;
* ct2[i + 1].type = matchcreate2.Groups[6].Captures[i].Value;*/
}
SQLtype sentencia = new CreateTable(ct1, ct3);
return(sentencia);
}
//BACKUP DB
string backupDB1 = "";
string backupDB2 = "";
Match matchBPDB = Regex.Match(query, backupDB);
if (matchBPDB.Success)
{
backupDB1 = matchBPDB.Groups[1].Value;
backupDB2 = matchBPDB.Groups[2].Value;
SQLtype sentencia = new BackUp(backupDB1, backupDB2);
return(sentencia);
}
//CREATE DB
string createDB1 = "";
Match matchcDB = Regex.Match(query, createDB);
if (matchcDB.Success)
{
createDB1 = matchcDB.Groups[1].Value;
SQLtype sentencia = new CreateDB(createDB1);
return(sentencia);
}
//UPDATE
string[] cupdate2 = new string[10];
string cupdate1 = "";
string[] cupdate3 = new string[10];
Match matchUp1 = Regex.Match(query, update1);
Match matchUp2 = Regex.Match(query, update2);
if (Regex.Match(query, update1).Success)
{
cupdate1 = matchUp1.Groups[1].Value;
cupdate2[0] = matchUp1.Groups[2].Value;
cupdate2[1] = matchUp1.Groups[3].Value;
cupdate2[2] = matchUp1.Groups[4].Value;
cupdate3[0] = matchUp1.Groups[5].Value;
cupdate3[1] = matchUp1.Groups[6].Value;
cupdate3[2] = matchUp1.Groups[7].Value;
SQLtype sentencia = new Update(cupdate1, cupdate2, cupdate3);
return(sentencia);
}
else if (Regex.Match(query, update2).Success)
{
cupdate1 = matchUp2.Groups[1].Value;
//The first column of the set
cupdate2[0] = matchUp2.Groups[2].Value;
cupdate2[1] = matchUp2.Groups[3].Value;
cupdate2[2] = matchUp2.Groups[4].Value;
//The second column of the set
cupdate2[3] = matchUp2.Groups[6].Value;
cupdate2[4] = matchUp2.Groups[7].Value;
cupdate2[5] = matchUp2.Groups[8].Value;
cupdate3[0] = matchUp2.Groups[9].Value;
cupdate3[1] = matchUp2.Groups[10].Value;
cupdate3[2] = matchUp2.Groups[11].Value;
SQLtype sentencia = new Update(cupdate1, cupdate2, cupdate3);
return(sentencia);
}
//DELETE
string delete1 = "";
string[] delete2 = new string[10];
Match matchDel = Regex.Match(query, delete);
if (Regex.Match(query, delete).Success)
{
delete1 = matchDel.Groups[1].Value;
delete2[0] = matchDel.Groups[2].Value;
delete2[1] = matchDel.Groups[3].Value;
delete2[2] = matchDel.Groups[4].Value;
SQLtype sentencia = new Delete(delete1, delete2);
return(sentencia);
}
//SELECT
string[] camp1 = new string[10];
string camp2 = "";
string[] camp3 = new string[10];
Match matchS1 = Regex.Match(query, select1);
Match matchS2 = Regex.Match(query, select2);
Match matchS3 = Regex.Match(query, select3);
Match matchS4 = Regex.Match(query, select4);
Match matchS5 = Regex.Match(query, select5);
Match matchS6 = Regex.Match(query, select6);
if (Regex.Match(query, select1).Success)
{
camp1[0] = matchS1.Groups[1].Value;
camp2 = matchS1.Groups[2].Value;
SQLtype sentencia = new Select(camp2, camp1, camp3);
return(sentencia);
}
else if (Regex.Match(query, select2).Success)
{
camp1[0] = matchS2.Groups[1].Value;
camp2 = matchS2.Groups[2].Value;
camp3[0] = matchS2.Groups[3].Value;
camp3[1] = matchS2.Groups[4].Value;
camp3[2] = matchS2.Groups[5].Value;
SQLtype sentencia = new Select(camp2, camp1, camp3);
return(sentencia);
}
else if (Regex.Match(query, select3).Success)
{
camp1[0] = matchS3.Groups[1].Value;
camp2 = matchS3.Groups[2].Value;
SQLtype sentencia = new Select(camp2, camp1, camp3);
return(sentencia);
}
else if (Regex.Match(query, select4).Success)
{
camp1[0] = matchS4.Groups[1].Value;
camp2 = matchS4.Groups[2].Value;
camp3[0] = matchS4.Groups[3].Value;
camp3[1] = matchS4.Groups[4].Value;
camp3[2] = matchS4.Groups[5].Value;
SQLtype sentencia = new Select(camp2, camp1, camp3);
return(sentencia);
}
else if (Regex.Match(query, select5).Success)
{
camp1[0] = matchS5.Groups[1].Value;
for (int i = 0; i < matchS5.Groups[3].Captures.Count; i++)
{
camp1[i + 1] = matchS5.Groups[3].Captures[i].Value;
}
camp2 = matchS5.Groups[4].Value;
SQLtype sentencia = new Select(camp2, camp1, camp3);
return(sentencia);
}
else if (Regex.Match(query, select6).Success)
{
camp1[0] = matchS6.Groups[1].Value;
for (int i = 0; i < matchS6.Groups[3].Captures.Count; i++)
{
camp1[i + 1] = matchS6.Groups[3].Captures[i].Value;
}
camp2 = matchS6.Groups[4].Value;
camp3[0] = matchS6.Groups[5].Value;
camp3[1] = matchS6.Groups[6].Value;
camp3[2] = matchS6.Groups[7].Value;
SQLtype sentencia = new Select(camp2, camp1, camp3);
return(sentencia);
}
//Drop table
string campoDT1 = "";
Match matchDT = Regex.Match(query, dropTable);
if (matchDT.Success)
{
campoDT1 = matchDT.Groups[1].Value;
SQLtype sentencia = new DropTable(campoDT1);
return(sentencia);
}
//Drop DB
string campoDB1 = "";
Match matchDB = Regex.Match(query, dropDB);
if (matchDB.Success)
{
campoDB1 = matchDB.Groups[1].Value;
SQLtype sentencia = new DropDB(campoDB1);
return(sentencia);
}
//Insert
string cinsert1;
string[] cinsert2 = new string[10];
string[] cinsert3 = new string[10];
Match matchI1 = Regex.Match(query, insert1);
Match matchI2 = Regex.Match(query, insert2);
Match matchI3 = Regex.Match(query, insert3);
Match matchI4 = Regex.Match(query, insert4);
if (Regex.Match(query, insert1).Success)
{
cinsert1 = matchI1.Groups[1].Value;
//cinsert3[0] = matchI1.Groups[2].Value;
SQLtype sentencia = new Insert(cinsert1, cinsert2, cinsert3);
return(sentencia);
}
else if (Regex.Match(query, insert2).Success)
{
cinsert1 = matchI2.Groups[1].Value;
cinsert3[0] = matchI2.Groups[2].Value;
for (int i = 0; i < matchI2.Groups[4].Captures.Count; i++)
{
cinsert3[i + 1] = matchI2.Groups[4].Captures[i].Value;
}
SQLtype sentencia = new Insert(cinsert1, cinsert2, cinsert3);
return(sentencia);
}
else if (Regex.Match(query, insert3).Success)
{
cinsert1 = matchI3.Groups[1].Value;
cinsert3[0] = matchI3.Groups[3].Value;
cinsert2[0] = matchI3.Groups[2].Value;
SQLtype sentencia = new Insert(cinsert1, cinsert2, cinsert3);
return(sentencia);
}
else if (Regex.Match(query, insert4).Success)
{
cinsert1 = matchI4.Groups[1].Value;
cinsert3[0] = matchI4.Groups[5].Value;
for (int i = 0; i < matchI4.Groups[7].Captures.Count; i++)
{
cinsert3[i + 1] = matchI4.Groups[7].Captures[i].Value;
}
cinsert2[0] = matchI4.Groups[2].Value;
for (int i = 0; i < matchI4.Groups[4].Captures.Count; i++)
{
cinsert2[i + 1] = matchI4.Groups[4].Captures[i].Value;
}
SQLtype sentencia = new Insert(cinsert1, cinsert2, cinsert3);
return(sentencia);
}
return(null);
}