C# Class Universe.DataManager.SQLite.SQLiteLoader

Inheritance: DataManagerBase

Afficher le fichier Open project: Virtual-Universe/Virtual-Universe Class Usage Examples

Protected Properties

Свойство	Type	Description
_locks	object>.Dictionary
m_Fields	FieldInfo>.Dictionary
m_connectionString	string
m_fileName	string

Méthodes publiques

Méthode	Description
CloseDatabase ( DataReaderConnection connection ) : void
ConCat ( string toConcat ) : string
ConnectToDatabase ( string connectionString, string migratorName, bool validateTables ) : void
Copy ( ) : IGenericData
CreateTable ( string table, ColumnDefinition columns, IndexDefinition indexDefinitions ) : void
Delete ( string table, QueryFilter queryFilter ) : bool
DeleteByTime ( string table, string key ) : bool
DropTable ( string tableName ) : void
ForceRenameTable ( string oldTableName, string newTableName ) : void
GetColumnTypeStringSymbol ( ColumnTypeDef coldef ) : string
GetColumnTypeStringSymbol ( ColumnTypes type ) : string
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
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

Méthodes protégées

Méthode	Description
CloseReaderCommand ( Community.CsharpSqlite.SQLiteClient.SqliteCommand cmd ) : void
CopyAllDataBetweenMatchingTables ( string sourceTableName, string destinationTableName, ColumnDefinition columnDefinitions, IndexDefinition indexDefinitions ) : void
ExecuteNonQuery ( Community.CsharpSqlite.SQLiteClient.SqliteCommand cmd ) : int
ExtractColumnsFromTable ( string tableName ) : List
ExtractIndicesFromTable ( string tableName ) : IndexDefinition>.Dictionary
GetLock ( ) : object
PrepReader ( string query ) : Community.CsharpSqlite.SQLiteClient.SqliteCommand
PrepReader ( Community.CsharpSqlite.SQLiteClient.SqliteCommand &cmd ) : void

Private Methods

Méthode	Description
AddParam ( Community.CsharpSqlite.SQLiteClient.SqliteCommand &cmd, string key, object value ) : void
AddParam ( Community.CsharpSqlite.SQLiteClient.SqliteCommand &cmd, string key, object value, bool convertByteString ) : void
AddParams ( Community.CsharpSqlite.SQLiteClient.SqliteCommand &cmd, object>.Dictionary ps ) : void
AddValueToList ( Dictionary &dic, string key, string value ) : void
InsertOrReplace ( string table, object>.Dictionary row, bool insert ) : bool
Query2 ( string query, QueryFilter queryFilter, bool>.Dictionary sort, uint start, uint count ) : List
QueryData2 ( string query, Community.CsharpSqlite.SQLiteClient.SqliteConnection &conn ) : IDataReader
QueryFullData2 ( string query ) : List
QueryNames2 ( string keyRow, object keyValue, string query ) : List>.Dictionary
UnescapeSql ( Community.CsharpSqlite.SQLiteClient.SqliteCommand cmd ) : void

Method Details

CloseDatabase() public méthode

public CloseDatabase ( DataReaderConnection connection ) : void
connection	DataReaderConnection
Résultat	void

CloseReaderCommand() protected méthode

protected CloseReaderCommand ( Community.CsharpSqlite.SQLiteClient.SqliteCommand cmd ) : void
cmd	Community.CsharpSqlite.SQLiteClient.SqliteCommand
Résultat	void

ConCat() public méthode

public ConCat ( string toConcat ) : string
toConcat	string
Résultat	string

ConnectToDatabase() public méthode

public ConnectToDatabase ( string connectionString, string migratorName, bool validateTables ) : void
connectionString	string
migratorName	string
validateTables	bool
Résultat	void

Copy() public méthode

public Copy ( ) : IGenericData
Résultat	IGenericData

CopyAllDataBetweenMatchingTables() protected méthode

protected CopyAllDataBetweenMatchingTables ( string sourceTableName, string destinationTableName, ColumnDefinition columnDefinitions, IndexDefinition indexDefinitions ) : void
sourceTableName	string
destinationTableName	string
columnDefinitions	Universe.Framework.Utilities.ColumnDefinition
indexDefinitions	Universe.Framework.Utilities.IndexDefinition
Résultat	void

CreateTable() public méthode

public CreateTable ( string table, ColumnDefinition columns, IndexDefinition indexDefinitions ) : void
table	string
columns	Universe.Framework.Utilities.ColumnDefinition
indexDefinitions	Universe.Framework.Utilities.IndexDefinition
Résultat	void

Delete() public méthode

public Delete ( string table, QueryFilter queryFilter ) : bool
table	string
queryFilter	QueryFilter
Résultat	bool

DeleteByTime() public méthode

public DeleteByTime ( string table, string key ) : bool
table	string
key	string
Résultat	bool

DropTable() public méthode

public DropTable ( string tableName ) : void
tableName	string
Résultat	void

ExecuteNonQuery() protected méthode

protected ExecuteNonQuery ( Community.CsharpSqlite.SQLiteClient.SqliteCommand cmd ) : int
cmd	Community.CsharpSqlite.SQLiteClient.SqliteCommand
Résultat	int

ExtractColumnsFromTable() protected méthode

protected ExtractColumnsFromTable ( string tableName ) : List
tableName	string
Résultat	List

ExtractIndicesFromTable() protected méthode

protected ExtractIndicesFromTable ( string tableName ) : IndexDefinition>.Dictionary
tableName	string
Résultat	IndexDefinition>.Dictionary

ForceRenameTable() public méthode

public ForceRenameTable ( string oldTableName, string newTableName ) : void
oldTableName	string
newTableName	string
Résultat	void

GetColumnTypeStringSymbol() public méthode

public GetColumnTypeStringSymbol ( ColumnTypeDef coldef ) : string
coldef	Universe.Framework.Utilities.ColumnTypeDef
Résultat	string

GetColumnTypeStringSymbol() public méthode

public GetColumnTypeStringSymbol ( ColumnTypes type ) : string
type	ColumnTypes
Résultat	string

GetLock() protected méthode

protected GetLock ( ) : object
Résultat	object

Insert() public méthode

public Insert ( string table, object>.Dictionary row ) : bool
table	string
row	object>.Dictionary
Résultat	bool

Insert() public méthode

public Insert ( string table, object values ) : bool
table	string
values	object
Résultat	bool

Insert() public méthode

public Insert ( string table, object values, string updateKey, object updateValue ) : bool
table	string
values	object
updateKey	string
updateValue	object
Résultat	bool

InsertMultiple() public méthode

public InsertMultiple ( string table, List values ) : bool
table	string
values	List
Résultat	bool

InsertSelect() public méthode

public InsertSelect ( string tableA, string fieldsA, string tableB, string valuesB ) : bool
tableA	string
fieldsA	string
tableB	string
valuesB	string
Résultat	bool

PrepReader() protected méthode

protected PrepReader ( string query ) : Community.CsharpSqlite.SQLiteClient.SqliteCommand
query	string
Résultat	Community.CsharpSqlite.SQLiteClient.SqliteCommand

PrepReader() protected méthode

protected PrepReader ( Community.CsharpSqlite.SQLiteClient.SqliteCommand &cmd ) : void
cmd	Community.CsharpSqlite.SQLiteClient.SqliteCommand
Résultat	void

Query() public méthode

public 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
Résultat	List

Query() public méthode

public 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
Résultat	List

QueryData() public méthode

public QueryData ( string whereClause, QueryTables tables, string wantedValue ) : DataReaderConnection
whereClause	string
tables	QueryTables
wantedValue	string
Résultat	DataReaderConnection

QueryData() public méthode

public QueryData ( string whereClause, string table, string wantedValue ) : DataReaderConnection
whereClause	string
table	string
wantedValue	string
Résultat	DataReaderConnection

QueryFullData() public méthode

public QueryFullData ( string whereClause, QueryTables tables, string wantedValue ) : List
whereClause	string
tables	QueryTables
wantedValue	string
Résultat	List

QueryFullData() public méthode

public QueryFullData ( string whereClause, string table, string wantedValue ) : List
whereClause	string
table	string
wantedValue	string
Résultat	List

QueryNames() public méthode

public QueryNames ( string keyRow, object keyValue, QueryTables tables, string wantedValue ) : List>.Dictionary
keyRow	string
keyValue	object
tables	QueryTables
wantedValue	string
Résultat	List>.Dictionary

QueryNames() public méthode

public QueryNames ( string keyRow, object keyValue, string table, string wantedValue ) : List>.Dictionary
keyRow	string
keyValue	object
table	string
wantedValue	string
Résultat	List>.Dictionary

Replace() public méthode

public Replace ( string table, object>.Dictionary row ) : bool
table	string
row	object>.Dictionary
Résultat	bool

TableExists() public méthode

public TableExists ( string table ) : bool
table	string
Résultat	bool

Update() public méthode

public 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
Résultat	bool

UpdateTable() public méthode

public 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
Résultat	void

Property Details

_locks protected_oe static_oe property

protected static Dictionary _locks
Résultat	object>.Dictionary

m_Fields protected_oe property

protected Dictionary m_Fields
Résultat	FieldInfo>.Dictionary

m_connectionString protected_oe property

protected string m_connectionString
Résultat	string

m_fileName protected_oe property

protected string m_fileName
Résultat	string