bool ScientistRepository::addScientist(Scientist scientist) { ofstream file; file.open(fileName.c_str(), std::ios::app); if (file.is_open()) { string name = scientist.getName(); enum sexType sex = scientist.getSex(); int yearBorn = scientist.getYearBorn(); int yearDied = scientist.getYearDied(); file << name << constants::FILE_DELIMETER << sex << constants::FILE_DELIMETER << yearBorn << constants::FILE_DELIMETER; if (yearDied != constants::YEAR_DIED_DEFAULT_VALUE) { file << yearDied; } file << '\n'; } else { return false; } file.close(); return true; }
bool ScientistRepository::addScientist(Scientist scientist) { db.open(); if (!db.isOpen()) { return false; } QSqlQuery query(db); stringstream sqlQuery; sqlQuery << "INSERT INTO Scientists (name, Gender, BirthYear, DeathYear) VALUES (" << "'" << scientist.getName() << "', " << scientist.getSex() << ", " << scientist.getYearBorn() << ", " << scientist.getYearDied() << ")"; if (!query.exec(QString::fromStdString(sqlQuery.str()))) { return false; } db.close(); return true; }
bool ScientistRepository::editScientist(Scientist scientist, int id) { db.open(); if (!db.isOpen()) { return false; } QSqlQuery query(db); stringstream sqlQuery; sqlQuery << "UPDATE Scientists SET " << "name = " << "'" << scientist.getName() << "', " << "sex = " << scientist.getSex() << ", " << "yearBorn = " << scientist.getYearBorn() << ", " << "yearDied = " << scientist.getYearDied() << ", " << "info = " << "'" << scientist.getInfo() << "' " << "WHERE id = " << id; if (!query.exec(QString::fromStdString(sqlQuery.str()))) { return false; } db.close(); return true; }
bool ScientistRepository::removeScientist(Scientist scientist) { db.open(); QSqlQuery query(db); stringstream sqlQuery; //All scientists with the exact same information as the input scientist will be deleted from the database. The primary key is irrelevant. sqlQuery << "DELETE FROM scientists WHERE name = '" << scientist.getName() << "' AND sex = " << scientist.getSex() << " AND yearBorn = " << scientist.getYearBorn(); if (scientist.getYearDied() == constants::YEAR_NOT_ENTERED_DEFAULT_VALUE) { //No year of death entered, search empty fields sqlQuery << " AND yearDied IS NULL"; } else { //year of death entered, normal search sqlQuery << " AND yearDied = " << scientist.getYearDied(); } bool success = query.exec(QString::fromStdString(sqlQuery.str())); db.close(); return success; }
bool ScientistRepository::addScientist(Scientist scientist) { if(db.open()) { QSqlQuery query(db); string tableCreation ="CREATE TABLE IF NOT EXISTS scientists(sci_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , name VARCHAR, sex INTEGER, yearBorn INTEGER, yearDied INTEGER)"; query.exec(QString(tableCreation.c_str())); string sSex = utils::intToString(scientist.getSex()); string sYearBorn = utils::intToString(scientist.getYearBorn()); string queryInsert = "INSERT INTO scientists(name,sex,yearBorn)VALUES('"+scientist.getName()+"','"+sSex+"','"+sYearBorn+"')"; if(query.exec(QString(queryInsert.c_str()))) //exec returns true if it is successful { if(scientist.getYearDied() != constants::YEAR_NOT_ENTERED_DEFAULT_VALUE) { string sYearDied = utils::intToString(scientist.getYearDied()); queryInsert = "UPDATE scientists SET yearDied = '" + sYearDied + "' WHERE sci_id = (SELECT MAX(sci_id) FROM scientists)"; query.exec(QString(queryInsert.c_str())); } } else { //first query failed db.close(); return false; } db.close(); } else //file open failed return false; return true; }
void Database::add(Scientist scientist) { QSqlQuery query(connectDatabase()); query.prepare("INSERT INTO Scientists (Name, Gender, YearOfBirth, YearOfDeath) VALUES (:Name, :Gender, :YearOfBirth, :YearOfDeath)"); query.bindValue(":Name", QString::fromStdString(scientist.getName())); query.bindValue(":Gender", QString::fromStdString(scientist.getGender())); query.bindValue(":YearOfBirth", QString::number(scientist.getBirthYear())); query.bindValue(":YearOfDeath", QString::number(scientist.getDeathYear())); query.exec(); }