klog
Classes | Signals | Public Member Functions | List of all members
DataProxy_SQLite Class Reference
Inheritance diagram for DataProxy_SQLite:
Inheritance graph
[legend]
Collaboration diagram for DataProxy_SQLite:
Collaboration graph
[legend]

Classes

struct  SpecialCallsignInfo
 

Signals

void qsoFound (const QStringList _qs)
 
void queryError (QString functionFailed, QString errorCodeS, QString nativeError, QString failedQuery)
 
void debugLog (QString _func, QString _msg, DebugLogLevel _level)
 
void qsoDeleted (int qsoId)
 
void logChanged ()
 

Public Member Functions

 DataProxy_SQLite (const QString &_parentFunction, const QString &_softVersion="0.0")
 
 DataProxy_SQLite (const QString &_parentFunction, const QString &_softVersion, const QString &_dbPath)
 
void setLogLevel (const DebugLogLevel _l)
 
QString getSoftVersion ()
 
void setPKGVersion (const QString &_pkgVersion)
 
QString getPKGVersion ()
 
QString getDBVersion ()
 
bool reconnectDB ()
 
void createLogModel ()
 
void createLogPanel ()
 
bool haveAtLeastOneLog ()
 
QStringList getColumnNamesFromTableLog ()
 
int getIdFromModeName (const QString &_modeName)
 
int getIdFromBandName (const QString &_bandName)
 
bool isValidMode (const QString &_modeName)
 
bool isValidBand (const QString &_bandName)
 
KLOG_DEPRECATED bool createHashes ()
 
void loadBandDataCache ()
 
void loadModeDataCache ()
 
void loadEntityDataCache ()
 
QStringList getFields ()
 
QStringList getModes ()
 
QStringList getSubModes ()
 
QStringList getModesAndSubmodes ()
 
QStringList sortBandNamesBottonUp (const QStringList _qs)
 
QStringList getBandIDs ()
 
QStringList getModesIDs ()
 
QStringList getBandsInLog (const int _log)
 
QStringList getModesInLog (const int _log)
 
int getMostUsedBand (const int _log)
 
int getMostUsedMode (const int _log)
 
QString getNameFromBandId (const int _id)
 
KLOG_DEPRECATED QString getNameFromModeId (const int _id)
 
QString getSubModeFromId (const int _id)
 
QString getNameFromSubMode (const QString &_sm)
 
QList< int > getModeGroupIds (const int _modeId)
 
bool isModeDeprecated (const QString &_sm)
 
int getBandIdFromFreq (const Frequency _n)
 
QString getBandNameFromFreq (const Frequency _n)
 
Frequency getLowLimitBandFromBandName (const QString &_sm)
 
Frequency getLowLimitBandFromBandId (const int _sm)
 
Frequency getUpperLimitBandFromBandName (const QString &_sm)
 
bool isThisFreqInBand (const QString &_band, const Frequency _fr)
 
int getLastQSOid ()
 
int getLastInsertedQSO ()
 
QDate getFirstQSODateFromCall (const QString &_call)
 
QDate getLastQSODateFromCall (const QString &_call)
 
bool addQSOFromWSJTX (const QString &_dxcall, const QString &_mode, const QString &_band, const double _freq, const QString &_mygrid, const QString &_dxgrid, const QString &_rstTX, const QString &_rstRX, const QString &_sRX, const QString &_sTX, const QString &_comment, const QString &_stationcallsign, const QString &_name, const QString &_operator, const QDateTime &_datetime, const QDateTime &_datetime_off, const double txpower, const int _dxcc, const int _logNumber, bool _sendQSL=true)
 
int addQSO (QSO &_qso)
 
QSO fromDB (const int _qsoId)
 
bool updateQSOFromLoTW (const QSO &_lotwQso, const int _qsoId)
 
bool applyLoTWFieldsToQSO (const QSO &_lotwQso, const int _qsoId)
 
bool deleteQSO (const int _qsoId)
 
int isWorkedB4 (const QString &_qrz, const int _currentLog)
 
int isThisQSODuplicated (const QSO &_qso, const int _secs)
 
bool isQSLReceived (const int _qsoId)
 
bool isQSLLoTWReceived (const int _qsoId)
 
bool isQSOConfirmed (const int _qsoId, const bool _checkPaper, const bool _checkLoTW)
 
bool isQSLSent (const int _qsoId)
 
bool qslSentViaDirect (const int _qsoId, const QDate &_updateDate)
 
bool qslSentViaBureau (const int _qsoId, const QDate &_updateDate)
 
bool qslRecViaBureau (const int _qsoId, const QDate &_updateDate)
 
bool qslRecViaBureau (const int _qsoId, const QDate &_updateDate, const bool _queueSentQSL)
 
bool qslRecViaDirect (const int _qsoId, const QDate &_updateDate)
 
bool qslRecViaDirect (const int _qsoId, const QDate &_updateDate, const bool _queueSentQSL)
 
bool qslSentAsRequested (const int _qsoId, const QDate &_updateDate)
 
bool qslRecAsRequested (const int _qsoId, const QDate &_updateDate)
 
bool setClubLogSent (const int _qsoId, const QString &_st, const QDate &_updateDate)
 
bool setLoTWQSLRec (const int _qsoId, const QString &_st, const QDate &_updateDate)
 
bool isHF (const int _band)
 
bool isWARC (const int _band)
 
bool isVHF (const int _band)
 
bool isUHF (const int _band)
 
int getBandFromId (const int _qsoId)
 
int getModeFromId (const int _qsoId)
 
int getDXCCFromId (const int _qsoId)
 
int getCQZFromId (const int _qsoId)
 
QList< int > getBandModeDXCCCQZlogIDFromId (const int _qsoId)
 
QString getCallFromId (const int _qsoId)
 
QStringList getClubLogRealTimeFromId (const int _qsoId)
 
QStringList getFilteredLocators (const QString &_band, const QString &_mode, const QString &_prop, const QString &_sat, bool _confirmed=false)
 
QVariantList getQSOsForLocator (const QString &_locator, const QString &_band, const QString &_mode, const QString &_prop, const QString &_sat, bool _confirmed=false)
 
bool QRZCOMModifyFullLog (const int _currentLog)
 
bool QRZCOMSentQSOs (const QList< int > &_qsos)
 
bool eQSLModifyFullLog (const int _currentLog)
 
bool eQSLSentQSOs (const QList< int > &_qsos)
 
bool clublogSentQSOs (const QList< int > &_qsos)
 
bool clublogModifyFullLog (const int _currentLog)
 
bool lotwSentQueue (const QDate &_updateDate, const int _currentLog)
 
bool lotwSentYes (const QDate &_updateDate, const int _currentLog, const QString &_station)
 
bool lotwSentQSOs (const QList< int > &_qsos)
 
int lotwUpdateQSLReception (const QString &_call, const QDateTime &_dateTime, const QString &_band, const QString &_mode, const QDate &_qslrdate)
 
QList< int > getQSOsListLoTWToSend (const QString &_stationCallsign, const QString &_myGrid, const QDate &_startDate, const QDate &_endDate, bool _justQueued=true, int _logN=-1)
 
QStringList getQSODetailsForLoTWDownload (const int _id)
 
QList< int > getQSOsListeQSLNotSent (const QString &_stationCallsign, const QDate &_startDate, const QDate &_endDate, bool _justQueued=true)
 
QList< int > getQSOsListClubLogToSent (const QString &_stationCallsign, const QDate &_startDate, const QDate &_endDate, bool _justModified=true, int _logN=-1)
 
QList< int > getQSOsListEQSLToSent (const QString &_stationCallsign, const QDate &_startDate, const QDate &_endDate, bool _justModified=true, int _logN=-1)
 
QList< int > getQSOsListQRZCOMToSent (const QString &_stationCallsign, const QDate &_startDate, const QDate &_endDate, bool _justModified=true, int _logN=-1)
 
QList< int > getQSOsListToBeExported (const QString &_stationCallsign, const QString &_grid, const QDate &_startDate, const QDate &_endDate, int _logN=-1)
 
QList< int > getQSOsAll ()
 
QStringList getGridsToBeSent (const QString &_stationCallsign, const QDate &_startDate, const QDate &_endDate, const ExportMode _em, bool _justModified=true, int _logN=-1)
 
int getContinentIdFromContinentShortName (const QString &_n)
 
QString getContinentShortNameFromEntity (const int _n)
 
int getContinentIdFromEntity (const int _n)
 
QStringList getContinentShortNames ()
 
bool isValidContinentShortName (const QString &_n)
 
bool isValidDXCC (const int _e)
 
QStringList filterValidFields (const QStringList &_fields)
 
int getCQzFromPrefix (const QString &_p)
 
int getCQzFromEntity (const int _n)
 
int getITUzFromEntity (const int _n)
 
int getITUzFromPrefix (const QString &_p)
 
QString getEntityNameFromId (const int _n)
 
int getEntityIdFromName (const QString &_e)
 
QString getEntityMainPrefix (const int _entityN)
 
QMap< EntityData, int > getAllEntiNameISOAndPrefix ()
 
int getEntityIdFromMainPrefix (const QString &_e)
 
bool isNewCQz (int _c)
 
bool isNewEntity (int _e)
 
double getLongitudeFromEntity (const int _e)
 
double getLatitudeFromEntity (const int _e)
 
QString getEntityPrefixes (const int _enti)
 
QStringList getLongPrefixes ()
 
QStringList getSpecialCallsigns ()
 
QList< SpecialCallsignInfo > getSpecialCallsignPairs ()
 
bool addSpecialCallsign (const QString &callsign, int dxccId, int cqz=-1, int ituz=-1)
 
bool removeSpecialCallsign (const QString &callsign)
 
int getKLogSubEntityForCallsign (const QString &callsign, int baseDxcc)
 
QHash< QString, int > getWorldData ()
 
QStringList getEntitiesNames (bool _dxccOnly=true)
 
QStringList getEntitiesIds ()
 
int getHowManyEntities ()
 
int getMaxEntityID (bool limit=true)
 
QList< int > getListOfDXCCIds ()
 
QStringList getOperatingYears (const int _currentLog)
 
void compressDB ()
 
bool unMarkAllQSO ()
 
bool clearLog ()
 
int getQSOonYear (const int _year, const int _logNumber, const QList< int > &modeIds={})
 
int getDXCConYear (const int _year, const int _logNumber, const QList< int > &modeIds={})
 
int getCQzonYear (const int _year, const int _logNumber, const QList< int > &modeIds={})
 
int getQSOsWithDXCC (const int _dxcc, const int _logNumber)
 
int getQSOsAtHour (const int _hour, const int _log)
 
int getQSOsAtHourOnBand (const int _hour, const int _band, const int _log)
 
int getQSOsOnMonth (const int _month, const int _log)
 
int getHowManyQSOInLog (const int _log, const QList< int > &modeIds={})
 
int getHowManyConfirmedQSLInLog (const int _log, const QList< int > &modeIds={})
 
int getHowManyQSLSentInLog (const int _log)
 
int getQSOsWithContinent (const QString &_cont, const int _logNumber)
 
int getQSOsInBand (const QString &_band, const int _log)
 
int getQSOsInMode (const QString &_mode, const int _log)
 
int getDXCCInBand (const int _bandid, const bool _confirmed, const int _log)
 
QList< QList< int > > getTop10QSOPerDXCC (const int _log)
 
bool updateQSONumberPerLog ()
 
bool newDXMarathon (const int _dxcc, const int _cq, const int _year, const int _logNumber)
 
QStringList getContestNames ()
 
QStringList getContestCat (const int _catn)
 
QStringList getContestOverlays ()
 
int getLogNumberFromQSOId (const int _qsoId)
 
QStringList getBandNames ()
 
QStringList getPropModeList ()
 
bool isValidPropMode (const QString &_prop)
 
bool clearSatList ()
 
bool addSatellite (const QString &_arrlId, const QString &_name, const QString &_downLink, const QString &_upLink, const QString &_mode, int id=-1)
 
int getDBSatId (const QString &_arrlId)
 
QStringList getSatellitesList ()
 
Frequency getSatelliteUplink (const QString &_sat, int _pair=0)
 
Frequency getSatelliteDownlink (const QString &_sat, int _pair=0)
 
QString getSatelliteMode (const QString &_sat)
 
QString getSatelliteFullUplink (const QString &_sat)
 
QString getSatelliteFullDownlink (const QString &_sat)
 
QString getSatelliteFullMode (const QString &_sat)
 
QString getSatelliteName (const QString &_sat)
 
QString getSateliteArrlIdFromId (const int _id)
 
KLOG_DEPRECATED QStringList getQSLViaList ()
 
int getHowManyQSOPerPropMode (const QString &_p, const int _logn)
 
int getNumberOfManagedLogs ()
 
QStringList getListOfManagedLogs ()
 
int getMaxLogNumber ()
 
QString getStationCallSignFromLog (const int _log)
 
QStringList getStationCallSignsFromLog (const int _log)
 
QStringList getStationCallSignsFromLogWithLoTWPendingToSend (const int _log)
 
QString getOperatorsFromLog (const int _log)
 
QString getCommentsFromLog (const int _log)
 
QString getLogDateFromLog (const int _log)
 
bool addNewLog (const QStringList _qs)
 
bool doesThisLogExist (const int _log)
 
bool updateISONames ()
 
QString getISOName (const int _n)
 
bool addPrimarySubdivisions ()
 
KLOG_DEPRECATED bool setWAZAwardStatus (const int _qsoId)
 
bool addDXCCEntitySubdivision (const QString &_name, const QString &_short, const QString &_pref, const QString &_group, const int _regId, const int _dxcc, const int _cq, const int _itu, const QDate &_startDate, const QDate &_endDate, const bool _deleted)
 
QList< PrimarySubdivision > getPrimarySubDivisions (const int _entity, const QString &_pref)
 
KLOG_DEPRECATED QString getADIFValueFromRec (const QSqlRecord &_rec, const QString &_fieldName)
 
KLOG_DEPRECATED QString getADIFFromQSOQuery (QSqlRecord _rec, ExportMode _em=ModeADIF, bool _justMarked=false, bool _onlyRequested=false, int _logN=-1)
 
bool showInvalidCallMessage (const QString &_call)
 
QList< QSO * > getSatGridStats (int _log=-1)
 
QList< QSO * > getGridStats (int _log=-1)
 
QList< QSO * > getSatDXCCStats (int _log=-1)
 
int getFieldInBand (ValidFieldsForStats _field, const QString &_band, bool confirmedOnly, QString _mode="ALL", int _log=-1, const QList< int > &modeIds={})
 
bool beginTransaction ()
 
bool commitTransaction ()
 
bool rollbackTransaction ()
 
void loadDuplicateCache (int logId)
 
void clearDuplicateCache ()
 
void addDuplicateCache (int _qsoId, const QSO &qso, const int _bandId, const int _modeId)
 
void removeDuplicateCache (int _qsoId)
 
int findDuplicateId (const QString &call, const QDateTime &newTime, int bandId, int modeId, int marginSeconds)
 
int findDuplicateId (const QSO &qso, int marginSeconds)
 
The documentation for this class was generated from the following files:
Generated by   doxygen 1.8.13