private TableData(string name, BaseData database, List<ColumnData> columns)
{
Name = name;
DataBase = database;
Columns = columns;
VerifyPhysicalModel();
}
public static int Update(string tableName, string databaseName, List<string> columnNames, List<string> columnOldValues, List<string> columnNewValues)
{
int count = 0;
BaseData bd = new BaseData(databaseName);
TableData table = bd.GetTable(tableName);
for(int i = 0; i < columnNames.Count; i++)
{
count += table.UpdateValue(columnNames[i], columnOldValues[i], columnNewValues[i]);
}
return count;
}
public static int DeleteAll(string tableName, string databaseName)
{
BaseData bd = new BaseData(databaseName);
TableData table = bd.GetTable(tableName);
return table.DeleteAll();
}
public static int DeleteByColumnValues(string tableName, string databaseName, List<string> columnNames, List<string> columnValues)
{
BaseData bd = new BaseData(databaseName);
TableData table = bd.GetTable(tableName);
return table.DeleteByColumnValues(columnNames, columnValues);
}
public static int InsertInto(string tableName, string databaseName, List<string> values, List<string> columns = null)
{
BaseData bd = new BaseData(databaseName);
TableData table = bd.GetTable(tableName);
return table.Insert(values, columns);
}
public static TableData CreateNew(string name, BaseData database, List<ColumnData> columns)
{
TableData table = new TableData(name, database, columns);
return table;
}
public static TableData CreateNew(string name, BaseData database, List <ColumnData> columns)
{
TableData table = new TableData(name, database, columns);
return(table);
}
public static void DropDatabase(string databaseName)
{
BaseData database = new BaseData(databaseName);
database.Drop();
}
public static BaseData CreateDataBase(string name, int size = 10, int filegrowth = 5, string datasourse = null, string filepath = null)
{
BaseData dataBase = new BaseData(name, size, filegrowth, datasourse, filepath);
dataBase.CreatePhysicalModel();
return dataBase;
}
