C# 클래스 Universe.DataManager.SQLite.SQLiteLoader

상속: DataManagerBase
파일 보기 프로젝트 열기: Virtual-Universe/Virtual-Universe 1 사용 예제들

보호된 프로퍼티들

프로퍼티 타입 설명
_locks object>.Dictionary
m_Fields FieldInfo>.Dictionary
m_connectionString string
m_fileName string

공개 메소드들

메소드 설명
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

보호된 메소드들

메소드 설명
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

비공개 메소드들

메소드 설명
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

메소드 상세

CloseDatabase() 공개 메소드

public CloseDatabase ( DataReaderConnection connection ) : void
connection DataReaderConnection
리턴 void

CloseReaderCommand() 보호된 메소드

protected CloseReaderCommand ( Community.CsharpSqlite.SQLiteClient.SqliteCommand cmd ) : void
cmd Community.CsharpSqlite.SQLiteClient.SqliteCommand
리턴 void

ConCat() 공개 메소드

public ConCat ( string toConcat ) : string
toConcat string
리턴 string

ConnectToDatabase() 공개 메소드

public ConnectToDatabase ( string connectionString, string migratorName, bool validateTables ) : void
connectionString string
migratorName string
validateTables bool
리턴 void

Copy() 공개 메소드

public Copy ( ) : IGenericData
리턴 IGenericData

CopyAllDataBetweenMatchingTables() 보호된 메소드

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
리턴 void

CreateTable() 공개 메소드

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

Delete() 공개 메소드

public Delete ( string table, QueryFilter queryFilter ) : bool
table string
queryFilter QueryFilter
리턴 bool

DeleteByTime() 공개 메소드

public DeleteByTime ( string table, string key ) : bool
table string
key string
리턴 bool

DropTable() 공개 메소드

public DropTable ( string tableName ) : void
tableName string
리턴 void

ExecuteNonQuery() 보호된 메소드

protected ExecuteNonQuery ( Community.CsharpSqlite.SQLiteClient.SqliteCommand cmd ) : int
cmd Community.CsharpSqlite.SQLiteClient.SqliteCommand
리턴 int

ExtractColumnsFromTable() 보호된 메소드

protected ExtractColumnsFromTable ( string tableName ) : List
tableName string
리턴 List

ExtractIndicesFromTable() 보호된 메소드

protected ExtractIndicesFromTable ( string tableName ) : IndexDefinition>.Dictionary
tableName string
리턴 IndexDefinition>.Dictionary

ForceRenameTable() 공개 메소드

public ForceRenameTable ( string oldTableName, string newTableName ) : void
oldTableName string
newTableName string
리턴 void

GetColumnTypeStringSymbol() 공개 메소드

public GetColumnTypeStringSymbol ( ColumnTypeDef coldef ) : string
coldef Universe.Framework.Utilities.ColumnTypeDef
리턴 string

GetColumnTypeStringSymbol() 공개 메소드

public GetColumnTypeStringSymbol ( ColumnTypes type ) : string
type ColumnTypes
리턴 string

GetLock() 보호된 메소드

protected GetLock ( ) : object
리턴 object

Insert() 공개 메소드

public Insert ( string table, object>.Dictionary row ) : bool
table string
row object>.Dictionary
리턴 bool

Insert() 공개 메소드

public Insert ( string table, object values ) : bool
table string
values object
리턴 bool

Insert() 공개 메소드

public Insert ( string table, object values, string updateKey, object updateValue ) : bool
table string
values object
updateKey string
updateValue object
리턴 bool

InsertMultiple() 공개 메소드

public InsertMultiple ( string table, List values ) : bool
table string
values List
리턴 bool

InsertSelect() 공개 메소드

public InsertSelect ( string tableA, string fieldsA, string tableB, string valuesB ) : bool
tableA string
fieldsA string
tableB string
valuesB string
리턴 bool

PrepReader() 보호된 메소드

protected PrepReader ( string query ) : Community.CsharpSqlite.SQLiteClient.SqliteCommand
query string
리턴 Community.CsharpSqlite.SQLiteClient.SqliteCommand

PrepReader() 보호된 메소드

protected PrepReader ( Community.CsharpSqlite.SQLiteClient.SqliteCommand &cmd ) : void
cmd Community.CsharpSqlite.SQLiteClient.SqliteCommand
리턴 void

Query() 공개 메소드

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
리턴 List

Query() 공개 메소드

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
리턴 List

QueryData() 공개 메소드

public QueryData ( string whereClause, QueryTables tables, string wantedValue ) : DataReaderConnection
whereClause string
tables QueryTables
wantedValue string
리턴 DataReaderConnection

QueryData() 공개 메소드

public QueryData ( string whereClause, string table, string wantedValue ) : DataReaderConnection
whereClause string
table string
wantedValue string
리턴 DataReaderConnection

QueryFullData() 공개 메소드

public QueryFullData ( string whereClause, QueryTables tables, string wantedValue ) : List
whereClause string
tables QueryTables
wantedValue string
리턴 List

QueryFullData() 공개 메소드

public QueryFullData ( string whereClause, string table, string wantedValue ) : List
whereClause string
table string
wantedValue string
리턴 List

QueryNames() 공개 메소드

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

QueryNames() 공개 메소드

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

Replace() 공개 메소드

public Replace ( string table, object>.Dictionary row ) : bool
table string
row object>.Dictionary
리턴 bool

TableExists() 공개 메소드

public TableExists ( string table ) : bool
table string
리턴 bool

Update() 공개 메소드

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
리턴 bool

UpdateTable() 공개 메소드

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
리턴 void

프로퍼티 상세

_locks 보호되어 있는 정적으로 프로퍼티

protected static Dictionary _locks
리턴 object>.Dictionary

m_Fields 보호되어 있는 프로퍼티

protected Dictionary m_Fields
리턴 FieldInfo>.Dictionary

m_connectionString 보호되어 있는 프로퍼티

protected string m_connectionString
리턴 string

m_fileName 보호되어 있는 프로퍼티

protected string m_fileName
리턴 string