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();
}
