C# Class Universe.DataManager.DataManagerBase

Inheritance: IDataConnector

Show file Open project: Virtual-Universe/Virtual-Universe

Public Methods

Method	Description
CloseDatabase ( DataReaderConnection connection ) : void
ConCat ( string toConcat ) : string
ConnectToDatabase ( string connectionString, string migratorName, bool validateTables ) : void
ConvertTypeToColumnType ( string typeString ) : ColumnTypeDef
Copy ( ) : IGenericData
CopyTableToTable ( string sourceTableName, string destinationTableName, ColumnDefinition columnDefinitions, IndexDefinition indexDefinitions ) : void
CreateTable ( string table, ColumnDefinition columns, IndexDefinition indexDefinitions ) : void
Delete ( string table, QueryFilter queryFilter ) : bool
DeleteByTime ( string table, string key ) : bool
DropTable ( string tableName ) : void
EnsureTableExists ( string tableName, ColumnDefinition columnDefinitions, IndexDefinition indexDefinitions, string>.Dictionary renameColumns ) : void
ForceRenameTable ( string oldTableName, string newTableName ) : void
GetColumnTypeStringSymbol ( ColumnTypeDef coldef ) : string
GetColumnTypeStringSymbol ( ColumnTypes type ) : string
GetUniverseVersion ( string migratorName ) : System.Version
Insert ( string table, object>.Dictionary row ) : bool
Insert ( string table, object values ) : bool
Insert ( string table, object values, string updateKey, object updateValue ) : bool
InsertMultiple ( string table, List values ) : bool
InsertSelect ( string tableA, string fieldsA, string tableB, string valuesB ) : bool
Query ( string wantedValue, QueryTables tables, QueryFilter queryFilter, bool>.Dictionary sort, uint start, uint count ) : List
Query ( string wantedValue, string table, QueryFilter queryFilter, bool>.Dictionary sort, uint start, uint count ) : List
QueryData ( string whereClause, QueryTables tables, string wantedValue ) : DataReaderConnection
QueryData ( string whereClause, string table, string wantedValue ) : DataReaderConnection
QueryFullData ( string whereClause, QueryTables tables, string wantedValue ) : List
QueryFullData ( string whereClause, string table, string wantedValue ) : List
QueryNames ( string keyRow, object keyValue, QueryTables tables, string wantedValue ) : List>.Dictionary
QueryNames ( string keyRow, object keyValue, string table, string wantedValue ) : List>.Dictionary
RenameTable ( string oldTableName, string newTableName ) : void
Replace ( string table, object>.Dictionary row ) : bool
TableExists ( string table ) : bool
Update ( string table, object>.Dictionary values, int>.Dictionary incrementValue, QueryFilter queryFilter, uint start, uint count ) : bool
UpdateTable ( string table, ColumnDefinition columns, IndexDefinition indexDefinitions, string>.Dictionary renameColumns ) : void
VerifyTableExists ( string tableName, ColumnDefinition columnDefinitions, IndexDefinition indexDefinitions ) : bool
WriteUniverseVersion ( System.Version version, string migrationName ) : void

Protected Methods

Method	Description
CopyAllDataBetweenMatchingTables ( string sourceTableName, string destinationTableName, ColumnDefinition columnDefinitions, IndexDefinition indexDefinitions ) : void
ExtractColumnsFromTable ( string tableName ) : List
ExtractIndicesFromTable ( string tableName ) : IndexDefinition>.Dictionary

Method Details

CloseDatabase() public abstract method

public abstract CloseDatabase ( DataReaderConnection connection ) : void
connection	DataReaderConnection
return	void

ConCat() public abstract method

public abstract ConCat ( string toConcat ) : string
toConcat	string
return	string

ConnectToDatabase() public abstract method

public abstract ConnectToDatabase ( string connectionString, string migratorName, bool validateTables ) : void
connectionString	string
migratorName	string
validateTables	bool
return	void

ConvertTypeToColumnType() public method

public ConvertTypeToColumnType ( string typeString ) : ColumnTypeDef
typeString	string
return	Universe.Framework.Utilities.ColumnTypeDef

Copy() public abstract method

public abstract Copy ( ) : IGenericData
return	IGenericData

CopyAllDataBetweenMatchingTables() protected abstract method

protected abstract CopyAllDataBetweenMatchingTables ( string sourceTableName, string destinationTableName, ColumnDefinition columnDefinitions, IndexDefinition indexDefinitions ) : void
sourceTableName	string
destinationTableName	string
columnDefinitions	Universe.Framework.Utilities.ColumnDefinition
indexDefinitions	Universe.Framework.Utilities.IndexDefinition
return	void

CopyTableToTable() public method

public CopyTableToTable ( string sourceTableName, string destinationTableName, ColumnDefinition columnDefinitions, IndexDefinition indexDefinitions ) : void
sourceTableName	string
destinationTableName	string
columnDefinitions	Universe.Framework.Utilities.ColumnDefinition
indexDefinitions	Universe.Framework.Utilities.IndexDefinition
return	void

CreateTable() public abstract method

public abstract CreateTable ( string table, ColumnDefinition columns, IndexDefinition indexDefinitions ) : void
table	string
columns	Universe.Framework.Utilities.ColumnDefinition
indexDefinitions	Universe.Framework.Utilities.IndexDefinition
return	void

Delete() public abstract method

public abstract Delete ( string table, QueryFilter queryFilter ) : bool
table	string
queryFilter	QueryFilter
return	bool

DeleteByTime() public abstract method

public abstract DeleteByTime ( string table, string key ) : bool
table	string
key	string
return	bool

DropTable() public abstract method

public abstract DropTable ( string tableName ) : void
tableName	string
return	void

EnsureTableExists() public method

public EnsureTableExists ( string tableName, ColumnDefinition columnDefinitions, IndexDefinition indexDefinitions, string>.Dictionary renameColumns ) : void
tableName	string
columnDefinitions	Universe.Framework.Utilities.ColumnDefinition
indexDefinitions	Universe.Framework.Utilities.IndexDefinition
renameColumns	string>.Dictionary
return	void

ExtractColumnsFromTable() protected abstract method

protected abstract ExtractColumnsFromTable ( string tableName ) : List
tableName	string
return	List

ExtractIndicesFromTable() protected abstract method

protected abstract ExtractIndicesFromTable ( string tableName ) : IndexDefinition>.Dictionary
tableName	string
return	IndexDefinition>.Dictionary

ForceRenameTable() public abstract method

public abstract ForceRenameTable ( string oldTableName, string newTableName ) : void
oldTableName	string
newTableName	string
return	void

GetColumnTypeStringSymbol() public abstract method

public abstract GetColumnTypeStringSymbol ( ColumnTypeDef coldef ) : string
coldef	Universe.Framework.Utilities.ColumnTypeDef
return	string

GetColumnTypeStringSymbol() public abstract method

public abstract GetColumnTypeStringSymbol ( ColumnTypes type ) : string
type	ColumnTypes
return	string

GetUniverseVersion() public method

public GetUniverseVersion ( string migratorName ) : System.Version
migratorName	string
return	System.Version

Insert() public abstract method

public abstract Insert ( string table, object>.Dictionary row ) : bool
table	string
row	object>.Dictionary
return	bool

Insert() public abstract method

public abstract Insert ( string table, object values ) : bool
table	string
values	object
return	bool

Insert() public abstract method

public abstract Insert ( string table, object values, string updateKey, object updateValue ) : bool
table	string
values	object
updateKey	string
updateValue	object
return	bool

InsertMultiple() public abstract method

public abstract InsertMultiple ( string table, List values ) : bool
table	string
values	List
return	bool

InsertSelect() public abstract method

public abstract InsertSelect ( string tableA, string fieldsA, string tableB, string valuesB ) : bool
tableA	string
fieldsA	string
tableB	string
valuesB	string
return	bool

Query() public abstract method

public abstract Query ( string wantedValue, QueryTables tables, QueryFilter queryFilter, bool>.Dictionary sort, uint start, uint count ) : List
wantedValue	string
tables	QueryTables
queryFilter	QueryFilter
sort	bool>.Dictionary
start	uint
count	uint
return	List

Query() public abstract method

public abstract Query ( string wantedValue, string table, QueryFilter queryFilter, bool>.Dictionary sort, uint start, uint count ) : List
wantedValue	string
table	string
queryFilter	QueryFilter
sort	bool>.Dictionary
start	uint
count	uint
return	List

QueryData() public abstract method

public abstract QueryData ( string whereClause, QueryTables tables, string wantedValue ) : DataReaderConnection
whereClause	string
tables	QueryTables
wantedValue	string
return	DataReaderConnection

QueryData() public abstract method

public abstract QueryData ( string whereClause, string table, string wantedValue ) : DataReaderConnection
whereClause	string
table	string
wantedValue	string
return	DataReaderConnection

QueryFullData() public abstract method

public abstract QueryFullData ( string whereClause, QueryTables tables, string wantedValue ) : List
whereClause	string
tables	QueryTables
wantedValue	string
return	List

QueryFullData() public abstract method

public abstract QueryFullData ( string whereClause, string table, string wantedValue ) : List
whereClause	string
table	string
wantedValue	string
return	List

QueryNames() public abstract method

public abstract QueryNames ( string keyRow, object keyValue, QueryTables tables, string wantedValue ) : List>.Dictionary
keyRow	string
keyValue	object
tables	QueryTables
wantedValue	string
return	List>.Dictionary

QueryNames() public abstract method

public abstract QueryNames ( string keyRow, object keyValue, string table, string wantedValue ) : List>.Dictionary
keyRow	string
keyValue	object
table	string
wantedValue	string
return	List>.Dictionary

RenameTable() public method

public RenameTable ( string oldTableName, string newTableName ) : void
oldTableName	string
newTableName	string
return	void

Replace() public abstract method

public abstract Replace ( string table, object>.Dictionary row ) : bool
table	string
row	object>.Dictionary
return	bool

TableExists() public abstract method

public abstract TableExists ( string table ) : bool
table	string
return	bool

Update() public abstract method

public abstract Update ( string table, object>.Dictionary values, int>.Dictionary incrementValue, QueryFilter queryFilter, uint start, uint count ) : bool
table	string
values	object>.Dictionary
incrementValue	int>.Dictionary
queryFilter	QueryFilter
start	uint
count	uint
return	bool

UpdateTable() public abstract method

public abstract UpdateTable ( string table, ColumnDefinition columns, IndexDefinition indexDefinitions, string>.Dictionary renameColumns ) : void
table	string
columns	Universe.Framework.Utilities.ColumnDefinition
indexDefinitions	Universe.Framework.Utilities.IndexDefinition
renameColumns	string>.Dictionary
return	void

VerifyTableExists() public method

public VerifyTableExists ( string tableName, ColumnDefinition columnDefinitions, IndexDefinition indexDefinitions ) : bool
tableName	string
columnDefinitions	Universe.Framework.Utilities.ColumnDefinition
indexDefinitions	Universe.Framework.Utilities.IndexDefinition
return	bool

WriteUniverseVersion() public method

public WriteUniverseVersion ( System.Version version, string migrationName ) : void
version	System.Version
migrationName	string
return	void