Untitled
unknown
plain_text
3 years ago
1.1 kB
2
Indexable
for (unsigned i = 0; i < current_data.authors.size(); i++) { result r = tx.exec("SELECT * FROM public.author WHERE \"First_Name\"=\'%s\' AND \"Middle_Name\"=\'%s\' AND \"Last_Name\"=\'%s\'", W.esc(current_data.authors[i].first_name).c_str(), W.esc(current_data.authors[i].middle_name).c_str(), W.esc(current_data.authors[i].last_name).c_str()); int count = 0; int id; for(auto const &row: r) { for(auto const &col: row) { id = field; } count++; } if(!count)sprintf(buffer, "INSERT INTO public.author(\"First_Name\", \"Middle_Name\", \"Last_Name\") VALUES(\'%s\', \'%s\', \'%s\');", W.esc(current_data.authors[i].first_name).c_str(), W.esc(current_data.authors[i].middle_name).c_str(), W.esc(current_data.authors[i].last_name).c_str()); else // use id to insert paper paper.authorid = id; }
Editor is loading...