Baze de date embedded – exercitiu practic (pentru programatori mid-level)

jegmihai, on 06 septembrie 2018 - 22:03, said:

dani.user, on 02 iulie 2018 - 20:09, said:

auto PhoneBook::createDatabaseMainTable() -> void
{
static QString const createTableQuery{
	 "CREATE TABLE contacts (id INTEGER PRIMARY KEY AUTOINCREMENT, lastname "
	 "TEXT, firstname TEXT, phonenumber TEXT);"
};
static QString const errorMessage{ "Could now create the table." };
QSqlQuery query;
if (!query.exec(createTableQuery)) {
	 QMessageBox::critical(this, errorMessage, query.lastError().text());
	 std::exit(EXIT_FAILURE);
}
}

jegmihai, on 07 septembrie 2018 - 22:27, said:

auto PhoneBook::createDatabaseMainTable() -> void
{
static QString const createTableQuery{
	 "CREATE TABLE contacts (id INTEGER PRIMARY KEY AUTOINCREMENT, lastname "
	 "TEXT, firstname TEXT, phonenumber TEXT);"
};
static QString const errorMessage{ "Could now create the table." };
QSqlQuery query;
if (!query.exec(createTableQuery)) {
	 QMessageBox::critical(this, errorMessage, query.lastError().text());
	 std::exit(EXIT_FAILURE);
}
}

dani.user, on 07 septembrie 2018 - 22:40, said:

CrocodiluMereuVesel, on 08 septembrie 2018 - 01:29, said:

jegmihai, on 09 septembrie 2018 - 10:15, said:

Quote

• intersectie de branchuri de executie al programului
  
  
• posibila  schimbare de executie fie al branchului de business logic fie la drive-codeului.

• pornirea si oprirea aplicatiei,
  
  
• firul principal de executie al programului(schema logica generalista a programului)
  
  
• operatiuni de I/O
  
  
• operatiuni de managment al resurselor(memorie, disc, loguri, etc)
  
  
• operatiuni de negociere asupra protocoalelor (conexiuni cu baze de date , servicii web, etc)
  
  
• operatiuni de interactiune cu alte API-uri

Quote

if (!query.exec(createTableQuery)) {
		 QMessageBox::critical(this, errorMessage, query.lastError().text());
		 std::exit(EXIT_FAILURE);
}

try {
   query.exec(createTableQuery)
}catch {
  QMessageBox::critical(this, errorMessage, query.lastError().text());
  std::exit(EXIT_FAILURE);
}

Edited by CrocodiluMereuVesel, 10 September 2018 - 21:55.

OriginalCopy, on 11 septembrie 2018 - 22:26, said:

OriginalCopy, on 11 septembrie 2018 - 22:26, said:

class IStoragePlugin
{
public:
virtual ~IStoragePlugin() = default;
virtual auto addContact(QString const& lastName, QString const& firstName, QString const& phoneNumber) -> void = 0;

virtual auto searchContact(QString const& lastName, QString const& firstName) -> QSqlQuery = 0;

virtual auto updateContact(QString const& lastName, QString const& firstName, QString const& phoneNumber, int const id) -> void = 0;

virtual auto deleteContact(int const id) -> void = 0;
}