+
+QSqlQuery DomainsDatabaseHelper::getDomainQuery(const QString &hostname)
+{
+ // Get a handle for the domains database.
+ QSqlDatabase domainsDatabase = QSqlDatabase::database(CONNECTION_NAME);
+
+ // Instantiate a domain lookup query.
+ QSqlQuery domainLookupQuery(domainsDatabase);
+
+ // Create a hostname field.
+ QSqlField hostnameField(DOMAIN_NAME, QVariant::String);
+
+ // Set the hostname field value.
+ hostnameField.setValue(hostname);
+
+ // SQL escape the hostname field.
+ QString sqlEscapedHostname = domainsDatabase.driver()->formatValue(hostnameField);
+
+ // Prepare the domain lookup query.
+ domainLookupQuery.prepare("SELECT * FROM " + DOMAINS_TABLE + " WHERE " + DOMAIN_NAME + " = " + sqlEscapedHostname);
+
+ // Execute the query.
+ domainLookupQuery.exec();
+
+ // Move to the first entry.
+ domainLookupQuery.first();
+
+ // Return the query.
+ return domainLookupQuery;
+}
+