| | |
|---|
| | | return recipes; |
|---|
| | | } |
|---|
| | | |
|---|
| | | std::vector<std::string> RecipeManager::getAllPPID() const { |
|---|
| | | std::vector<std::string> vecPPID; |
|---|
| | | |
|---|
| | | if (!m_pDB) { |
|---|
| | | return vecPPID; |
|---|
| | | } |
|---|
| | | |
|---|
| | | const std::string query = "SELECT ppid FROM recipes ORDER BY ppid;"; |
|---|
| | | auto result = m_pDB->fetchResults(query); |
|---|
| | | |
|---|
| | | for (const auto& row : result) { |
|---|
| | | if (!row.empty()) { |
|---|
| | | vecPPID.push_back(row[0]); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | return vecPPID; |
|---|
| | | } |
|---|
| | | |
|---|
| | | RecipeInfo RecipeManager::getRecipeByPPID(const std::string& ppid) { |
|---|
| | | RecipeInfo info; |
|---|
| | | auto rows = m_pDB->fetchResults("SELECT ppid, description, create_time FROM recipes WHERE ppid = '" + ppid + "';"); |
|---|
