/// <summary>
/// Call EncryptionModule.EncryptDataBase for encryption purposes then save encrypted DB to file.
/// </summary>
/// <param name="fileStream">Stay at open state after method call </param>
/// <param name="dataBaseToWrite"></param>
private static void EncryptAndWriteDbToFile(FileStream fileStream, DataBaseInstance dataBaseToWrite)
{
MemoryStream streamOfEncryptedDataBase = EncryptionModule.EncryptDataBase(dataBaseToWrite);
streamOfEncryptedDataBase.Position = 0;
streamOfEncryptedDataBase.WriteTo(fileStream);
}
public override int GetHashCode()
{
unchecked
{
return(((DataBaseInstance != null ? DataBaseInstance.GetHashCode() : 0) * 397) ^
(Connection != null ? Connection.GetHashCode() : 0));
}
}
static private DataBaseInstance DecryptDataBaseFromPath(string filePathToDecrypt)
{
byte[] _array = File.ReadAllBytes(filePathToDecrypt);
//
DataBaseInstance inst = SecurityLayer.Modules.DecryptionModule.DecryptDataBase(_array);
return(inst);
}
private static void OpenFileAndWriteEncryptedDb(DataBaseInstance db)
{
using (FileStream _fileStream = new FileStream("./DataBases/" + db.Name + ".soos", FileMode.OpenOrCreate, FileAccess.ReadWrite))
{
EncryptAndWriteDbToFile(_fileStream, db);
_fileStream.Close();
}
}
/// <summary>
/// DataBase file saving
/// </summary>
/// <param name="_dataToSave"></param>
/// <param name="_dataBaseName"></param>
static internal void SaveDataBaseToFolder(this DataBaseInstance db)
{
CreateDirectoryForDataBaseIfThereAreNoOne();
OpenFileAndWriteEncryptedDb(db);
}
static Table QuerySelect(DataBaseInstance inst, Table table, string[] queryList)
{
try
{
if (!IsValidSyntax(queryList[1]))
{
throw new Exception("\nERROR: Invalid query syntax in 'SELECT' params\n");
}
char[] _separator = new char[] { '(', ',', ')' };
string[] _params = queryList[1].Split(_separator, StringSplitOptions.RemoveEmptyEntries);
if (_params.Length == 0)
{
throw new Exception("\nERROR: Invalid query syntax in 'SELECT' params\n");
}
if (IsKeyword(_params[0]))
{
string _keyword = _params[0];
if (_keyword == "*")
{
if (_params.Length != 1)
{
throw new Exception("\nERROR: Invalid query syntax in 'SELECT' params\n");
}
return(table);
}
else if (_keyword == "COUNT")
{
if (_params.Length == 1)
{
return(inst.QueryCountSelection(table, ref _status));
}
else
{
throw new Exception("\nERROR: Invalid query syntax in 'SELECT' params\n");
}
}
else if (_keyword == "AVG")
{
if (_params.Length != 2)
{
throw new Exception("\nERROR: Invalid query syntax in 'SELECT' params\n");
}
string _colName = _params[1];
if (!table.isColumnExists(_colName) && !_colName.Contains('.'))
{
throw new Exception("\nERROR: Invalid column name in 'SELECT' params\n");
}
return(inst.QueryAvgSelection(_colName, table, ref _status));
}
else if (_keyword == "SUM" || _keyword == "MIN" || _keyword == "MAX")
{
if (_params.Length != 2)
{
throw new Exception("\nERROR: Invalid query syntax in 'SELECT' params\n");
}
string _colName = _params[1];
if (!table.isColumnExists(_colName) && !_colName.Contains('.'))
{
throw new Exception("\nERROR: Invalid column name in 'SELECT' params\n");
}
return(inst.QueryMINMAXSUMSelection(_colName, table, _keyword, ref _status));
}
else if (_keyword == "TOP")
{
if (_params.Length != 2)
{
throw new Exception("\nERROR: Invalid query syntax in 'SELECT' params\n");
}
char[] _sep = new char[] { '=' };
string[] _temp = _params[1].Split(_sep, StringSplitOptions.None);
if (_temp.Length != 2)
{
throw new Exception("\nERROR: Invalid query syntax in 'SELECT' params\n");
}
if (_temp[0] == "VALUES")
{
bool isValueCount = true;
int count = Convert.ToInt32(_temp[1]);
return(inst.QueryTopSelection(table, count, isValueCount, ref _status));
}
else if (_temp[0] == "PERC")
{
bool isValueCount = false;
int perc = Convert.ToInt32(_temp[1]);
return(inst.QueryTopSelection(table, perc, isValueCount, ref _status));
}
else
{
throw new Exception("\nERROR: Invalid query syntax in 'SELECT' params\n");
}
}
else
{
throw new Exception("\nERROR: Invalid query syntax in 'SELECT' params\n");
}
}
else
{
List <string> colNames = new List <string>();
foreach (var col in _params)
{
if (table.isColumnExists(col) && col.Contains('.'))
{
colNames.Add(col);
}
else
{
throw new Exception("\nERROR: Invalid column name in 'SELECT' params\n");
}
}
return(inst.QueryColumnSelection(colNames, table, ref _status));
}
throw new Exception("\nERROR: Invalid query syntax in 'SELECT' params\n");
}
catch (Exception e)
{
_status = e.Message;
return(null);
}
}
static Table QuerySort(DataBaseInstance inst, Table table, string[] queryList)
{
try
{
int index = GetIndexOfKeyword(queryList, "ORDER_BY");
if (index == 4)
{
if (!(queryList.Length == 7))
{
throw new Exception("\nERROR: Invalid query syntax in 'ORDER_BY' params\n");
}
bool _isAscending;
string _colName = queryList[5];
if (!_colName.Contains('.'))
{
throw new Exception("\nERROR: Invalid column name in 'ORDER_BY' params\n");
}
if (!table.isColumnExists(_colName))
{
throw new Exception($"There is no column '{_colName}' in table '{table.Name}'!\n");
}
if (queryList[6] == "ASC")
{
_isAscending = true;
}
else if (queryList[6] == "DESC")
{
_isAscending = false;
}
else
{
throw new Exception("\nERROR: Invalid query syntax in 'ORDER_BY' params\n");
}
return(inst.QuerySortTable(_colName, table, _isAscending, ref _status));
}
else if (index == 6)
{
if (!(queryList.Length == 9))
{
throw new Exception("\nERROR: Invalid query syntax in 'ORDER_BY' params\n");
}
bool _isAscending;
string _colName = queryList[7];
if (!_colName.Contains('.'))
{
throw new Exception("\nERROR: Invalid column name in 'ORDER_BY' params\n");
}
if (!table.isColumnExists(_colName))
{
throw new Exception($"There is no column '{_colName}' in table '{table.Name}'!\n");
}
if (queryList[8] == "ASC")
{
_isAscending = true;
}
else if (queryList[8] == "DESC")
{
_isAscending = false;
}
else
{
throw new Exception("\nERROR: Invalid query syntax in 'ORDER_BY' params\n");
}
return(inst.QuerySortTable(_colName, table, _isAscending, ref _status));
}
else if (index == 8)
{
if (!(queryList.Length == 11))
{
throw new Exception("\nERROR: Invalid query syntax in 'ORDER_BY' params\n");
}
bool _isAscending;
string _colName = queryList[9];
if (!_colName.Contains('.'))
{
throw new Exception("\nERROR: Invalid column name in 'ORDER_BY' params\n");
}
if (!table.isColumnExists(_colName))
{
throw new Exception($"There is no column '{_colName}' in table '{table.Name}'!\n");
}
if (queryList[10] == "ASC")
{
_isAscending = true;
}
else if (queryList[10] == "DESC")
{
_isAscending = false;
}
else
{
throw new Exception("\nERROR: Invalid query syntax in 'ORDER_BY' params\n");
}
return(inst.QuerySortTable(_colName, table, _isAscending, ref _status));
}
else if (index == 10)
{
if (!(queryList.Length == 13))
{
throw new Exception("\nERROR: Invalid query syntax in 'ORDER_BY' params\n");
}
bool _isAscending;
string _colName = queryList[11];
if (!_colName.Contains('.'))
{
throw new Exception("\nERROR: Invalid column name in 'ORDER_BY' params\n");
}
if (!table.isColumnExists(_colName))
{
throw new Exception($"There is no column '{_colName}' in table '{table.Name}'!\n");
}
if (queryList[12] == "ASC")
{
_isAscending = true;
}
else if (queryList[12] == "DESC")
{
_isAscending = false;
}
else
{
throw new Exception("\nERROR: Invalid query syntax in 'ORDER_BY' params\n");
}
return(inst.QuerySortTable(_colName, table, _isAscending, ref _status));
}
else if (index == 12)
{
if (!(queryList.Length == 15))
{
throw new Exception("\nERROR: Invalid query syntax in 'ORDER_BY' params\n");
}
bool _isAscending;
string _colName = queryList[13];
if (!_colName.Contains('.'))
{
throw new Exception("\nERROR: Invalid column name in 'ORDER_BY' params\n");
}
if (!table.isColumnExists(_colName))
{
throw new Exception($"There is no column '{_colName}' in table '{table.Name}'!\n");
}
if (queryList[14] == "ASC")
{
_isAscending = true;
}
else if (queryList[14] == "DESC")
{
_isAscending = false;
}
else
{
throw new Exception("\nERROR: Invalid query syntax in 'ORDER_BY' params\n");
}
return(inst.QuerySortTable(_colName, table, _isAscending, ref _status));
}
else
{
throw new Exception("\nERROR: Invalid query syntax in 'ORDER_BY' params\n");
}
}
catch (Exception e)
{
_status = e.Message;
return(null);
}
}
static Table QueryWhere(DataBaseInstance inst, Table table, string[] queryList, string query)
{
try
{
int index = GetIndexOfKeyword(queryList, "WHERE");
if (index == 4)
{
if (query.Contains(" IN ") || query.Contains(" NOT_IN ") || query.Contains(" BETWEEN ") || query.Contains(" NOT_BETWEEN "))
{
if (queryList.Length < 8)
{
throw new Exception("\nERROR: Invalid query syntax in 'WHERE' params\n");
}
string _operator = GetComplexOperator(queryList);
if (queryList[6] != _operator)
{
throw new Exception("\nERROR: Invalid query syntax in 'WHERE' params\n");
}
if (!IsValidSyntax(queryList[7]))
{
throw new Exception("\nERROR: Invalid query syntax in 'WHERE' params\n");
}
string _colName = queryList[5];
if (!_colName.Contains('.'))
{
throw new Exception("\nERROR: Invalid column name in 'WHERE' params\n");
}
if (!table.isColumnExists(_colName))
{
throw new Exception($"There is no column '{_colName}' in table '{table.Name}'!\n");
}
var _column = table.GetColumnByName(_colName);
char[] _sep = new char[] { '(', ',', ')' };
string[] _val = queryList[7].Split(_sep, StringSplitOptions.RemoveEmptyEntries);
object[] _values = new object[_val.Length];
for (int i = 0; i < _val.Length; i++)
{
string stat;
_values[i] = GetData(_val[i], _column, out stat);
if (!(stat == "OK"))
{
throw new Exception(stat);
}
}
return(inst.QueryWhereConditionSelection(table, _colName, _operator, _values, ref _status));
}
else if (queryList.Length >= 6)
{
if (!IsValidSyntax(queryList[5]))
{
throw new Exception("\nERROR: Invalid query syntax in 'WHERE' params\n");
}
string[] _separator = new string[] { "(", ")", GetSeparator(queryList[5]), " " };
string[] conditionParams = queryList[5].Split(_separator, StringSplitOptions.RemoveEmptyEntries);
if (!(conditionParams.Length == 2))
{
throw new Exception("\nERROR: Invalid query syntax in 'WHERE' params\n");
}
string _colName = conditionParams[0];
string _value = conditionParams[1];
if (!_colName.Contains('.'))
{
throw new Exception("\nERROR: Invalid column name in 'WHERE' params\n");
}
if (!table.isColumnExists(_colName))
{
throw new Exception($"There is no column '{_colName}' in table '{table.Name}'!\n");
}
string buff;
var _column = table.GetColumnByName(_colName);
object _data = GetData(_value, _column, out buff);
if (!(buff == "OK"))
{
throw new Exception(buff);
}
return(inst.QueryWhereConditionSelection(table, _colName, GetSeparator(queryList[5]), _data, ref _status));
}
else
{
throw new Exception("\nERROR: Invalid query syntax in 'WHERE' params\n");
}
}
else if (index == 8)
{
if (query.Contains(" IN ") || query.Contains(" NOT_IN ") || query.Contains(" BETWEEN ") || query.Contains(" NOT_BETWEEN "))
{
if (queryList.Length < 12)
{
throw new Exception("\nERROR: Invalid query syntax in 'WHERE' params\n");
}
string _operator = GetComplexOperator(queryList);
if (queryList[10] != _operator)
{
throw new Exception("\nERROR: Invalid query syntax in 'WHERE' params\n");
}
if (!IsValidSyntax(queryList[11]))
{
throw new Exception("\nERROR: Invalid query syntax in 'WHERE' params\n");
}
string _colName = queryList[9];
if (!_colName.Contains('.'))
{
throw new Exception("\nERROR: Invalid column name in 'WHERE' params\n");
}
if (!table.isColumnExists(_colName))
{
throw new Exception($"There is no column '{_colName}' in table '{table.Name}'!\n");
}
var _column = table.GetColumnByName(_colName);
char[] _sep = new char[] { '(', ',', ')' };
string[] _val = queryList[11].Split(_sep, StringSplitOptions.RemoveEmptyEntries);
object[] _values = new object[_val.Length];
for (int i = 0; i < _val.Length; i++)
{
string stat;
_values[i] = GetData(_val[i], _column, out stat);
if (!(stat == "OK"))
{
throw new Exception(stat);
}
}
return(inst.QueryWhereConditionSelection(table, _colName, _operator, _values, ref _status));
}
else if (queryList.Length >= 10)
{
if (!IsValidSyntax(queryList[9]))
{
throw new Exception("\nERROR: Invalid query syntax in 'WHERE' params\n");
}
string[] _separator = new string[] { "(", ")", GetSeparator(queryList[9]) };
string[] conditionParams = queryList[9].Split(_separator, StringSplitOptions.RemoveEmptyEntries);
if (!(conditionParams.Length == 2))
{
throw new Exception("\nERROR: Invalid query syntax in 'WHERE' params\n");
}
string _colName = conditionParams[0];
if (!_colName.Contains('.'))
{
throw new Exception("\nERROR: Invalid column name in 'WHERE' params\n");
}
string _value = conditionParams[1];
if (!table.isColumnExists(_colName))
{
throw new Exception($"There is no column '{_colName}' in table '{table.Name}'!\n");
}
string buff;
var _column = table.GetColumnByName(_colName);
object _data = GetData(_value, _column, out buff);
if (!(buff == "OK"))
{
throw new Exception(buff);
}
return(inst.QueryWhereConditionSelection(table, _colName, GetSeparator(queryList[9]), _data, ref _status));
}//with condition
else
{
throw new Exception("\nERROR: Invalid query syntax in 'WHERE' params\n");
}
}
else
{
throw new Exception("\nERROR: Invalid query syntax in 'WHERE' params\n");
}
}catch (Exception e)
{
_status = e.Message;
return(null);
}
}
static Table GetTable(string[] queryList, DataBaseInstance inst)
{
try
{
string _generalTableName = queryList[3];
if (!inst.isTableExists(_generalTableName))
{
throw new Exception($"There is no table '{_generalTableName}' in database '{inst.Name}'!\n");
}
var _generalTable = inst.GetTableByName(_generalTableName);
if (queryList.Length >= 8)
{
if (queryList[4] == "INNER_JOIN" && queryList[6] == "ON")
{
char[] _separator = new char[] { '(', ',', ')' };
if (!IsValidSyntax(queryList[5]))
{
throw new Exception("\nERROR: Invlid query syntax\n");
}
string[] _innerTableNames = queryList[5].Split(_separator, StringSplitOptions.RemoveEmptyEntries);
if (!IsValidSyntax(queryList[7]))
{
throw new Exception("\nERROR: Invalid query syntax\n");
}
string[] _joinParams = queryList[7].Split(_separator, StringSplitOptions.RemoveEmptyEntries);
if (_joinParams.Length != _innerTableNames.Length)
{
throw new Exception("\nERROR: Count of tables doesn't equals count of params\n");
}
if (_innerTableNames.Length == 0)
{
throw new Exception("ERROR: There is no table names in INNER_JOIN params\n");
}
for (int i = 0; i < _joinParams.Length; i++)
{
if (!inst.isTableExists(_innerTableNames[i]))
{
throw new Exception($"There is no table '{_innerTableNames[i]}' in database '{inst.Name}'!\n");
}
char[] _separ = new char[] { '=' };
string[] colNames = _joinParams[i].Split(_separ, StringSplitOptions.RemoveEmptyEntries);
foreach (var name in colNames)
{
if (!name.Contains('.'))
{
throw new Exception("ERROR: Invalid name of column. It doesn't contains dot\n");
}
}
if (!(colNames.Length == 2))
{
throw new Exception("\nERROR: Invalid number of variable in INNER_JOIN params\n");
}
var _innerTable = inst.GetTableByName(_innerTableNames[i]);
var colNameList = colNames.ToList();
_generalTable = inst.QueryInnerJoinSelection(_generalTable, _innerTable, colNameList, ref _status);
}
return(_generalTable);
}
else if (queryList[4] == "WHERE" || queryList[4] == "ORDER_BY")
{
return(_generalTable);
}
else
{
throw new Exception("\nERROR: Invalid query syntax\n");
}
}
else if (queryList.Length >= 4)
{
return(_generalTable);
}
else
{
throw new Exception("\nERROR: Invalid query syntax\n");
}
}
catch (Exception e)
{
_status = e.Message;
return(null);
}
}
