-
Notifications
You must be signed in to change notification settings - Fork 5
/
lab_inject.cpp
37 lines (30 loc) · 887 Bytes
/
lab_inject.cpp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
#include <iostream>
#include <string>
using namespace std;
#include "libsqlite.hpp"
int main()
{
try
{
sqlite::sqlite db( "pokedex.sqlite" );
cout << "Find all the pokemon related to ______" << endl;
string userInput;
getline( cin, userInput );
auto cur = db.get_statement();
cur->set_sql( "SELECT a.identifier "
"FROM pokemon_species AS a "
"LEFT JOIN pokemon_species AS b "
" ON a.evolution_chain_id = b.evolution_chain_id "
"WHERE b.identifier = LOWER(\"" + userInput + "\");" );
cur->prepare();
while( cur->step() )
cout << cur->get_text(0) << ", ";
cout << endl;
}
catch( sqlite:: exception e )
{
cerr << e.what() << endl;
return 1;
}
return 0;
}