public OrderedSetIterator(List <string> tables, IStandardDatabase underlineDatabase)
{
_tables = tables;
this.underlineDatabase = underlineDatabase;
_worldNumbers = ReadWorldNumbers(tables);
CreateOrderedSetOfWorldNoTable(_tables, _worldNumbers);
}
public OrderedSetIterator(List<string> tables, IStandardDatabase underlineDatabase)
{
_tables = tables;
this.underlineDatabase = underlineDatabase;
_worldNumbers = ReadWorldNumbers(tables);
CreateOrderedSetOfWorldNoTable(_tables, _worldNumbers);
}
private void createAttributeTables(string tableName, List<string> attNames, List<string> attTypes, IStandardDatabase underlineDatabase)
{
String[] attributeNames1 = { "var", "v", "TupleExistence", "p" };
String[] attributeTypes1 = { "INT", "INT", "NVARCHAR(MAX)", "float" };
underlineDatabase.CreateNewTable(tableName + "_0", attributeNames1, attributeTypes1);
for (int i = 1; i <= attNames.Count; i++)
{
string attributeTableName = tableName + "_" + i;
String[] attributeNames = { "var", "v", attNames[i-1], "p" };
String[] attributeTypes = { "INT", "INT", attTypes[i-1], "float" };
underlineDatabase.CreateNewTable(attributeTableName, attributeNames, attributeTypes);
}
}
private void createPossibleWorldsTable(string tableName, List<string> attNames, List<string> attTypes, IStandardDatabase underlineDatabase)
{
String[] attributeNames = { "worldNo" };
String[] attributeTypes = { "INT" };
string attributeTableName = tableName + "_PossibleWorlds";
List<String> attributeNamesList = attributeNames.ToList();
List<String> attributeTypesList = attributeTypes.ToList();
attributeNamesList.AddRange(attNames);
attributeTypesList.AddRange(attTypes);
// p is the last attribute
attributeNamesList.Add("p");
attributeTypesList.Add("float");
underlineDatabase.CreateNewTable(attributeTableName, attributeNamesList.ToArray(), attributeTypesList.ToArray());
}
public CreateTableHandler(Query.CreateTableQuery.SqlCreateTableQuery cquery, IStandardDatabase underlineDatabase)
{
this.cquery = cquery;
this.underlineDatabase = underlineDatabase;
}
private void createAttributeTables(string tableName, List <string> attNames, List <string> attTypes, IStandardDatabase underlineDatabase)
{
String[] attributeNames1 = { "var", "v", "TupleExistence", "p" };
String[] attributeTypes1 = { "INT", "INT", "NVARCHAR(MAX)", "float" };
underlineDatabase.CreateNewTable(tableName + "_0", attributeNames1, attributeTypes1);
for (int i = 1; i <= attNames.Count; i++)
{
string attributeTableName = tableName + "_" + i;
String[] attributeNames = { "var", "v", attNames[i - 1], "p" };
String[] attributeTypes = { "INT", "INT", attTypes[i - 1], "float" };
underlineDatabase.CreateNewTable(attributeTableName, attributeNames, attributeTypes);
}
}
private void createPossibleWorldsTable(string tableName, List <string> attNames, List <string> attTypes, IStandardDatabase underlineDatabase)
{
String[] attributeNames = { "worldNo" };
String[] attributeTypes = { "INT" };
string attributeTableName = tableName + "_PossibleWorlds";
List <String> attributeNamesList = attributeNames.ToList();
List <String> attributeTypesList = attributeTypes.ToList();
attributeNamesList.AddRange(attNames);
attributeTypesList.AddRange(attTypes);
// p is the last attribute
attributeNamesList.Add("p");
attributeTypesList.Add("float");
underlineDatabase.CreateNewTable(attributeTableName, attributeNamesList.ToArray(), attributeTypesList.ToArray());
}
public CreateTableHandler(Query.CreateTableQuery.SqlCreateTableQuery cquery, IStandardDatabase underlineDatabase)
{
this.cquery = cquery;
this.underlineDatabase = underlineDatabase;
}
public ExtensionalTreeWalker(QueryTree queryTree, IStandardDatabase underlineDatabase)
{
this.underlineDatabase = underlineDatabase;
_queryTree = queryTree;
}
public InsertQueryHandler(SqlInsertQuery query, IStandardDatabase underlineDatabase)
{
this.query = query;
this.underlineDatabase = underlineDatabase;
}
public InsertQueryHandler(SqlInsertQuery query, IStandardDatabase underlineDatabase)
{
this.query = query;
this.underlineDatabase = underlineDatabase;
}
public ExtensionalTreeWalker(QueryTree queryTree, IStandardDatabase underlineDatabase)
{
this.underlineDatabase = underlineDatabase;
_queryTree = queryTree;
}
public SelectQueryHandler(SqlSelectQuery squery, IStandardDatabase underlineDatabase)
{
_query = squery;
this.underlineDatabase = underlineDatabase;
}
public SelectQueryHandler(SqlSelectQuery squery, IStandardDatabase underlineDatabase)
{
_query = squery;
this.underlineDatabase = underlineDatabase;
}
