Property | Type | Description | |
---|---|---|---|
CurrentDatabaseDumpFile | string |
Method | Description | |
---|---|---|
Connect ( ) : void |
Opens a connection to the database with the current database save path
|
|
CreateLogTable ( ) : void |
Creates a table for the log inputs (if it doesn't yet exist)
|
|
CreateSettingsTable ( ) : void |
Creates a table for the settings (keys) (if it doesn't yet exist)
|
|
CreateTimeZoneTable ( ) : void |
Creates a table for the time zone (if it doesn't yet exist)
|
|
DatabaseImplementation ( string dbFilePath ) : System | ||
Disconnect ( ) : void |
Closes the connection to the database.
|
|
Dispose ( ) : void | ||
ExecuteDefaultQuery ( string query ) : int |
Executes a query (given as parameter). Also logs the query.
|
|
ExecuteQueryWithTransaction ( List |
||
ExecuteReadQuery ( string query ) : DataTable |
Executes a query (given as a parameter).
|
|
ExecuteScalar ( string query ) : int |
Executes a query scalar. Return 1 in case of an entry, or 0 in case of no entry or an error
|
|
ExecuteScalar2 ( string query ) : object |
Executes a query scalar and returns null if there was an error (or no entry) used for settings. Somehow strange?
|
|
GetDateFilteringStringForQuery ( VisType type, DateTimeOffset date, string datePropertyName = "time" ) : string | ||
GetDbPragmaVersion ( ) : int |
Get the actual database version
|
|
GetLastTimeZoneEntry ( ) : TimeZoneInfo | ||
GetSettingsBool ( string key, bool byDefault ) : bool |
Gets the stored setting value for a given key
|
|
GetSettingsDate ( string key, DateTimeOffset byDefault ) : DateTimeOffset | ||
GetSettingsInt ( string key, int byDefault ) : int |
Gets the stored setting value for a given key
|
|
GetSettingsString ( string key, string byDefault ) : string |
gets the stored setting value for a given key
|
|
GetUserWorkEnd ( DateTimeOffset date ) : DateTime | ||
GetUserWorkStart ( DateTimeOffset date ) : DateTime | ||
HasSetting ( string key ) : bool |
Checks if a settings for a given key is stored. returns false in case of an error
|
|
LogError ( string message ) : void |
Inserts the message (given as a parameter) into the log-database-table (flag: Error).
|
|
LogErrorUnknown ( string tracker ) : void |
Inserts an unknown error with the name of the tracker into the log-database-table (flag: Error). Also logs the query.
|
|
LogInfo ( string message ) : void |
Inserts the message (given as a parameter) into the log-database-table (flag: Info). Also logs the query.
|
|
LogTimeZoneChange ( TimeZoneInfo currentTimeZone ) : void | ||
LogWarning ( string message ) : void |
Inserts the message (given as a parameter) into the log-database-table (flag: Warning). Also logs the query.
|
|
Q ( bool str ) : string |
Q is the James-Bond guy. But for bools.
|
|
Q ( int str ) : string |
Q is the James-Bond guy. But for ints.
|
|
Q ( long str ) : string |
Q is the James-Bond guy. But for longs.
|
|
Q ( string str ) : string |
Q is the James-Bond guy. Improves the string characters not to mess it up in the query string.
|
|
QDate ( DateTime dateTime ) : string |
Formats and magicifies a datetime '%Y-%m-%d'
|
|
QTime ( DateTime dateTime ) : string |
Formats and magicifies a datetime '%Y-%m-%d %H:%M:%S'
|
|
Reconnect ( ) : void | ||
SetSettings ( string key, bool value ) : void |
Saves a setting with a given key or value. Inserts new entry if nothing is yet stored or updates the value.
|
|
SetSettings ( string key, string value ) : void |
Saves a setting with a given key or value. Inserts new entry if nothing is yet stored or updates the value.
|
|
UpdateDbPragmaVersion ( int version ) : void |
Update the database version when an existing table changes
|
Method | Description | |
---|---|---|
WriteQueryToLog ( string query, bool force = false ) : void |
Logs the query if the global setting allows it and it's not enforced my the calling method.
|
public DatabaseImplementation ( string dbFilePath ) : System | ||
dbFilePath | string | |
return | System |
public ExecuteDefaultQuery ( string query ) : int | ||
query | string | |
return | int |
public ExecuteQueryWithTransaction ( List |
||
commands | List |
|
return | void |
public ExecuteReadQuery ( string query ) : DataTable | ||
query | string | |
return | DataTable |
public ExecuteScalar2 ( string query ) : object | ||
query | string | |
return | object |
public GetDateFilteringStringForQuery ( VisType type, DateTimeOffset date, string datePropertyName = "time" ) : string | ||
type | VisType | |
date | DateTimeOffset | |
datePropertyName | string | |
return | string |
public GetLastTimeZoneEntry ( ) : TimeZoneInfo | ||
return | TimeZoneInfo |
public GetSettingsBool ( string key, bool byDefault ) : bool | ||
key | string | |
byDefault | bool | |
return | bool |
public GetSettingsDate ( string key, DateTimeOffset byDefault ) : DateTimeOffset | ||
key | string | |
byDefault | DateTimeOffset | |
return | DateTimeOffset |
public GetSettingsInt ( string key, int byDefault ) : int | ||
key | string | |
byDefault | int | |
return | int |
public GetSettingsString ( string key, string byDefault ) : string | ||
key | string | |
byDefault | string | |
return | string |
public GetUserWorkEnd ( DateTimeOffset date ) : DateTime | ||
date | DateTimeOffset | |
return | DateTime |
public GetUserWorkStart ( DateTimeOffset date ) : DateTime | ||
date | DateTimeOffset | |
return | DateTime |
public LogErrorUnknown ( string tracker ) : void | ||
tracker | string | |
return | void |
public LogTimeZoneChange ( TimeZoneInfo currentTimeZone ) : void | ||
currentTimeZone | TimeZoneInfo | |
return | void |
public SetSettings ( string key, bool value ) : void | ||
key | string | |
value | bool | |
return | void |
public SetSettings ( string key, string value ) : void | ||
key | string | |
value | string | |
return | void |
public UpdateDbPragmaVersion ( int version ) : void | ||
version | int | |
return | void |