Variables
const auto	TABLE_FLIGHTS = QStringLiteral("flights")

const auto	TABLE_PILOTS = QStringLiteral("pilots")

const auto	TABLE_TAILS = QStringLiteral("tails")

const auto	TABLE_AIRCRAFT = QStringLiteral("aircraft")

const auto	TABLE_AIRPORTS = QStringLiteral("airports")

const auto	TABLE_CURRENCIES = QStringLiteral("currencies")

const auto	TABLE_SIMULATORS = QStringLiteral("simulators")

const auto	FLIGHTS_ROWID = QStringLiteral("flight_id")

const auto	FLIGHTS_DOFT = QStringLiteral("doft")

const auto	FLIGHTS_DEPT = QStringLiteral("dept")

const auto	FLIGHTS_DEST = QStringLiteral("dest")

const auto	FLIGHTS_TOFB = QStringLiteral("tofb")

const auto	FLIGHTS_TONB = QStringLiteral("tonb")

const auto	FLIGHTS_PIC = QStringLiteral("pic")

const auto	FLIGHTS_ACFT = QStringLiteral("acft")

const auto	FLIGHTS_TBLK = QStringLiteral("tblk")

const auto	FLIGHTS_TSPSE = QStringLiteral("tSPSE")

const auto	FLIGHTS_TSPME = QStringLiteral("tSPME")

const auto	FLIGHTS_TMP = QStringLiteral("tMP")

const auto	FLIGHTS_TNIGHT = QStringLiteral("tNIGHT")

const auto	FLIGHTS_TIFR = QStringLiteral("tIFR")

const auto	FLIGHTS_TPIC = QStringLiteral("tPIC")

const auto	FLIGHTS_TPICUS = QStringLiteral("tPICUS")

const auto	FLIGHTS_TSIC = QStringLiteral("tSIC")

const auto	FLIGHTS_TDUAL = QStringLiteral("tDUAL")

const auto	FLIGHTS_TFI = QStringLiteral("tFI")

const auto	FLIGHTS_TSIM = QStringLiteral("tSIM")

const auto	FLIGHTS_PILOTFLYING = QStringLiteral("pilotFlying")

const auto	FLIGHTS_TODAY = QStringLiteral("toDay")

const auto	FLIGHTS_TONIGHT = QStringLiteral("toNight")

const auto	FLIGHTS_LDGDAY = QStringLiteral("ldgDay")

const auto	FLIGHTS_LDGNIGHT = QStringLiteral("ldgNight")

const auto	FLIGHTS_AUTOLAND = QStringLiteral("autoland")

const auto	FLIGHTS_SECONDPILOT = QStringLiteral("secondPilot")

const auto	FLIGHTS_THIRDPILOT = QStringLiteral("thirdPilot")

const auto	FLIGHTS_APPROACHTYPE = QStringLiteral("approachType")

const auto	FLIGHTS_FLIGHTNUMBER = QStringLiteral("flightNumber")

const auto	FLIGHTS_REMARKS = QStringLiteral("remarks")

const auto	TAILS_ROWID = QStringLiteral("tail_id")

const auto	TAILS_REGISTRATION = QStringLiteral("registration")

const auto	TAILS_COMPANY = QStringLiteral("company")

const auto	TAILS_MAKE = QStringLiteral("make")

const auto	TAILS_MODEL = QStringLiteral("model")

const auto	TAILS_VARIANT = QStringLiteral("variant")

const auto	TAILS_MULTIPILOT = QStringLiteral("multipilot")

const auto	TAILS_MULTIENGINE = QStringLiteral("multiengine")

const auto	TAILS_ENGINETYPE = QStringLiteral("engineType")

const auto	TAILS_WEIGHTCLASS = QStringLiteral("weightClass")

const auto	PILOTS_ROWID = QStringLiteral("pilot_id")

const auto	PILOTS_LASTNAME = QStringLiteral("lastname")

const auto	PILOTS_FIRSTNAME = QStringLiteral("firstname")

const auto	PILOTS_ALIAS = QStringLiteral("alias")

const auto	PILOTS_COMPANY = QStringLiteral("company")

const auto	PILOTS_EMPLOYEEID = QStringLiteral("employeeid")

const auto	PILOTS_PHONE = QStringLiteral("phone")

const auto	PILOTS_EMAIL = QStringLiteral("email")

const auto	CURRENCIES_EXPIRYDATE = QStringLiteral("expiryDate")

const auto	CURRENCIES_CURRENCYNAME = QStringLiteral("currencyName")

const auto	SIMULATORS_ROWID = QStringLiteral("session_id")

const auto	SIMULATORS_DATE = QStringLiteral("date")

const auto	SIMULATORS_TIME = QStringLiteral("totalTime")

const auto	SIMULATORS_TYPE = QStringLiteral("deviceType")

const auto	SIMULATORS_ACFT = QStringLiteral("aircraftType")

const auto	SIMULATORS_REG = QStringLiteral("registration")

const auto	SIMULATORS_REMARKS = QStringLiteral("remarks")

const auto	AIRPORTS_ICAO = QStringLiteral("icao")

const auto	AIRPORTS_IATA = QStringLiteral("iata")

const auto	AIRPORTS_NAME = QStringLiteral("name")

const auto	AIRPORTS_LAT = QStringLiteral("lat")

const auto	AIRPORTS_LON = QStringLiteral("long")

const auto	AIRPORTS_COUNTRY = QStringLiteral("country")

const auto	AIRPORTS_ALTITIDUE = QStringLiteral("alt")

const auto	AIRPORTS_UTC_OFFSET = QStringLiteral("utcoffset")

const auto	AIRPORTS_TZ_OLSON = QStringLiteral("tzolson")

const auto	ROWID = QStringLiteral("rowid")

const auto	NULL_TIME_hhmm = QStringLiteral("00:00")

Detailed Description

The OPL::Db namespace provides string literals to programatically access the database

Example usage, do: newData.insert(OPL::Db::FLIGHTS_DEP, ui->deptLocLineEdit->text()); newData.value(OPL::Db::AIRCRAFT_MULTIPILOT);

instead of: newData.insert("dept", ui->deptLocLineEdit->text()); newData.value("multipilot");

Declaring these literals here avoids memory allocation at runtime for construction of temporary qstrings like ("dept").

Variables

Detailed Description