• 홈
• Sqlite

C# 클래스 Sqlite, chronojump

파일 보기 프로젝트 열기: GNOME/chronojump 1 사용 예제들

공개 프로퍼티들

프로퍼티	타입	설명
IsOpened	bool
SafeClose	bool
sqlFileServer	string

보호된 프로퍼티들

프로퍼티	타입	설명
conversionSubRate	int
conversionSubRateTotal	int
dbcmd	Mono.Data.Sqlite.SqliteCommand
dbcon	Mono.Data.Sqlite.SqliteConnection

공개 메소드들

메소드	설명
ChangeDjToDJna ( ) : bool
CheckFileServer ( ) : bool
CheckTables ( bool defaultDBLocation ) : bool
Close ( ) : void
Connect ( ) : bool
ConnectBlank ( ) : void
ConnectServer ( ) : void
ConvertFromSqlite2To3 ( ) : bool
ConvertToLastChronojumpDBVersion ( ) : bool
Count ( string tableName, bool dbconOpened ) : int
CountCondition ( string tableName, bool dbconOpened, string condition, string operand, string myValue ) : int
CreateDir ( ) : void
CreateFile ( ) : void
CreateTables ( bool server ) : void
Delete ( bool dbconOpened, string tableName, int uniqueID ) : void
DeleteFromAnInt ( bool dbconOpened, string tableName, string colName, int id ) : void
DeleteFromName ( bool dbconOpened, string tableName, string name ) : void
DeleteSelectingField ( bool dbconOpened, string tableName, string fieldName, string id ) : void
DeleteTempEvents ( string tableName ) : void
DisConnect ( ) : bool
Exists ( bool dbconOpened, string tableName, string findName ) : bool
IsSqlite3 ( ) : bool
Max ( string tableName, string column, bool dbconOpened ) : int
Open ( ) : void
PrintConversionRate ( ) : double
PrintConversionSubRate ( ) : double
PrintConversionText ( ) : string
PrintConversionVersion ( ) : double
PrintCreation ( ) : double
SQLBuildQueryString ( string tableName, string test, string variable, int sex, string ageInterval, int countryID, int sportID, int speciallityID, int levelID, int evaluatorID ) : string
Sqlite ( ) : System
TempDataExists ( string tableName ) : int
Update ( bool dbconOpened, string tableName, string columnName, string searchValue, string newValue, string columnNameCondition2, string searchValueCondition2 ) : void
saveClassState ( ) : void
setSqlFilePath ( string filePath ) : void

보호된 메소드들

메소드	설명
DataReaderToStringArray ( SqliteDataReader reader, int columns ) : string[]
alterTableColumn ( Sqlite sqliteObject, string tableName, int columns ) : void
closeIfNeeded ( bool dbconOpened ) : void
convertDJInDJna ( ) : void
convertPersonAndPersonSessionTo77 ( ) : void
convertTables ( Sqlite sqliteObject, string tableName, int columnsBefore, ArrayList columnsToAdd, bool putDescriptionInMiddle ) : void
createTable ( ) : void
createTable ( string tableName ) : void
datesToYYYYMMDD ( ) : void
deleteOrphanedPersons ( ) : void
deleteOrphanedPersonsOld ( ) : void
dropTable ( string tableName ) : void
fillIDDoubleList ( string selectStr ) : IDDoubleList,
fillIDNameList ( string selectStr ) : IDNameList,
openIfNeeded ( bool dbconOpened ) : void
selectDouble ( string sqlSelect ) : double

비공개 메소드들

메소드	설명
addChronopicPortNameIfNotExists ( ) : void
sqlite2SelectWorks ( ) : bool
sqlite3SelectWorks ( ) : bool
updateVersion ( string newVersion ) : string

메소드 상세

프로퍼티 상세