• Главная
• Universe
• DataManager
• MySQL
• MySQLDataLoader

C# Класс Universe.DataManager.MySQL.MySQLDataLoader

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод	Описание
CloseDatabase ( DataReaderConnection connection ) : void
CloseDatabase ( MySqlConnection 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
ExecuteNonQuery ( string sql, object>.Dictionary parameters ) : void
ExecuteNonQuery ( string connStr, string sql, object>.Dictionary parameters ) : void
ExecuteNonQuery ( string connStr, string sql, object>.Dictionary parameters, bool spamConsole ) : 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 sql, object>.Dictionary parameters ) : IDataReader
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

Защищенные методы

Метод	Описание
CopyAllDataBetweenMatchingTables ( string sourceTableName, string destinationTableName, ColumnDefinition columnDefinitions, IndexDefinition indexDefinitions ) : void
ExtractColumnsFromTable ( string tableName ) : List
ExtractIndicesFromTable ( string tableName ) : IndexDefinition>.Dictionary

Приватные методы

Метод	Описание
AddValueToList ( Dictionary &dic, string key, string value ) : void
InsertOrReplace ( string table, object>.Dictionary row, bool insert ) : bool
Query2 ( string sqll, QueryFilter queryFilter, bool>.Dictionary sort, uint start, uint count ) : List
QueryData2 ( string query ) : IDataReader
QueryFullData2 ( string query ) : List
QueryNames2 ( string keyRow, object keyValue, string query ) : List>.Dictionary

Описание методов