• Home
• Sqlite

C# Class Sqlite, chronojump

Mostra file Open project: GNOME/chronojump Class Usage Examples

Public Properties

Property	Type	Description
IsOpened	bool
SafeClose	bool
sqlFileServer	string

Protected Properties

Property	Type	Description
conversionSubRate	int
conversionSubRateTotal	int
dbcmd	Mono.Data.Sqlite.SqliteCommand
dbcon	Mono.Data.Sqlite.SqliteConnection

Public Methods

Method	Description
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

Protected Methods

Method	Description
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

Private Methods

Method	Description
addChronopicPortNameIfNotExists ( ) : void
sqlite2SelectWorks ( ) : bool
sqlite3SelectWorks ( ) : bool
updateVersion ( string newVersion ) : string

Method Details

Property Details