private static void StartSql()
{
string dbName = Regex.Replace(dataDirectory, "\\S+\\\\", string.Empty);
Ddl ddl = new Ddl();
Dml dml = new Dml();
using (SqlConnection sqlConnection
= !File.Exists(dataDirectory + ".mdf")
? ddl.CreateDatabase(dataDirectory, dbName, dataSource, integratedSecurity)
: new SqlConnection($"Data Source={dataSource};" +
$"AttachDbFilename={dataDirectory + ".mdf"};" +
$"Integrated Security={integratedSecurity}"))
{
//Opens the sql connection
OpenConnection(sqlConnection);
//Reads and prints the table's date
dml.SelectRows(sqlConnection, dataDirectory, dbName, Resource.SelectEmployees.ToString(), false);
Console.WriteLine("\nTable of Grand Total\n");
dml.SelectRows(sqlConnection, dataDirectory, dbName, Resource.GrandTotal.ToString(), true);
Console.WriteLine("\nSorts by Job Title and Monthly Salary\n");
dml.SelectRows(sqlConnection, dataDirectory, dbName, Resource.SortJobTitleMonthlySalary.ToString(), false);
Console.WriteLine("\nSorts by Job Title and Total Compensation\n");
dml.SelectRows(sqlConnection, dataDirectory, dbName, Resource.SortJobTitleTotalCompensation.ToString(), false);
//Closes the connection
sqlConnection.Close();
}
Console.WriteLine("\nPress <ENTER> to quit...");
Console.ReadKey();
}
private static bool IsFunctionName(string tok)
{
char begin = tok[0];
bool isIdentifier = char.IsLetter(begin) || begin.CompareTo('$') == 0 || begin.CompareTo('_') == 0 || '"' == begin;
return(isIdentifier && !Formatter.Logical.Contains(tok) && !EndClauses.Contains(tok) && !Quantifiers.Contains(tok) &&
!Dml.Contains(tok) && !Formatter.Misc.Contains(tok));
}
public void CreateTable(SqlConnection sqlConnection, string dbName)
{
Dml dml = new Dml();
dbName = Regex.Replace(dbName, "\\S+\\\\", string.Empty);
try
{
using (SqlCommand cmd = new SqlCommand($"USE {dbName}\n"
+ Resource.VeneracionDatabase.ToString(), sqlConnection))
{
cmd.ExecuteNonQuery();
}
//Inserts values in the Table
dml.InsertRows(sqlConnection);
}
catch (IOException ex)
{
Console.WriteLine($"Missing File Error: {ex}");
}
catch (SqlException ex)
{
Console.WriteLine($"Creating Table Error: {ex}");
}
}
public string Perform()
{
_result.Append(Initial);
while (_tokens.MoveNext())
{
_token = _tokens.Current;
_lcToken = _token.ToLowerInvariant();
if ("'".Equals(_token))
{
ExtractStringEnclosedBy("'");
}
else if ("\"".Equals(_token))
{
ExtractStringEnclosedBy("\"");
}
if (IsMultiQueryDelimiter(_token))
{
StartingNewQuery();
}
else if (_afterByOrSetOrFromOrSelect && ",".Equals(_token))
{
CommaAfterByOrFromOrSelect();
}
else if (_afterOn && ",".Equals(_token))
{
CommaAfterOn();
}
else if ("(".Equals(_token))
{
OpenParen();
}
else if (")".Equals(_token))
{
CloseParen();
}
else if (BeginClauses.Contains(_lcToken))
{
BeginNewClause();
}
else if (EndClauses.Contains(_lcToken))
{
EndNewClause();
}
else if ("select".Equals(_lcToken))
{
Select();
}
else if (Dml.Contains(_lcToken))
{
UpdateOrInsertOrDelete();
}
else if ("values".Equals(_lcToken))
{
Values();
}
else if ("on".Equals(_lcToken))
{
On();
}
else if (_afterBetween && _lcToken.Equals("and"))
{
Misc();
_afterBetween = false;
}
else if (Formatter.Logical.Contains(_lcToken))
{
Logical();
}
else if (IsWhitespace(_token))
{
White();
}
else
{
Misc();
}
if (!IsWhitespace(_token))
{
_lastToken = _lcToken;
}
}
return(_result.ToString());
}
