How to get all rows from table using sql_orm ?

[matt-42]

How to get all rows from table using sql_orm ?

[matt-42]

You have a forall method for this: see this example: https://github.com/TechEmpower/FrameworkBenchmarks/blob/master/frameworks/C%2B%2B/lithium/lithium.cc#L189 Matthieu Garrigues

…

On Thu, May 14, 2020 at 7:46 AM aditya ***@***.***> wrote: How to get all rows from table using sql_orm ? Please guide me here Thanks, adibro500 — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#11>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAGOV6AA4VDYXT6LEMTE2HTRROAR7ANCNFSM4NAL27MQ> .

[adibro500]

Not working with sql commands.

con("select name, age from users;").map([] (std::string name, int age) { std::cout << name << ":" << age << std::endl; });

This example not working.

[matt-42]

Are you using mysql, postgres or sqlite ? Matthieu Garrigues

…

On Thu, May 14, 2020 at 9:34 AM aditya ***@***.***> wrote: Not working with sql commands. con("select name, age from users;").map([] (std::string name, int age) { std::cout << name << ":" << age << std::endl; }); This example not working. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#11 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAGOV6BWKIAVXM3VDUE27A3RRONJXANCNFSM4NAL27MQ> .

[adibro500]

using mysql

[adibro500]

Also I am getting CORS error

[adibro500]

the Access-Control-Allow-Origin working only in get apis

[matt-42]

Use the prepared statement api for the map method:

connection.prepare("Select id,time from items_table;").map([...])

I'll add an issue to have the map method on the non prepared mysql queries.

[matt-42]

CORS error mean you use different hostname or port to serve the API. You should use the same otherwise the browser will block the request. Matthieu Garrigues

…

On Thu, May 14, 2020 at 11:24 AM aditya ***@***.***> wrote: the Access-Control-Allow-Origin working only in get apis — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

[adibro500]

Getting this error:
error: 'struct li::mysql_statement<li::mysql_functions_blocking>' has no member named 'map'

[matt-42]

Sorry I forgot to call the prepared statement, use this instead:
connection.prepare("Select id,time from items_table;")().map([...])

[adibro500]

getting this error :

/usr/local/include/c++/9.3.0/tuple:1277:29: error: incomplete type 'std::tuple_size<main()::<lambda(li::http_request&, li::http_response&)>::<lambda(std::string&, std::string&, std::string, std::string&, std::string&)> >' used in nested name specifier 1277 | inline constexpr size_t tuple_size_v = tuple_size<_Tp>::value; | ^~~~~~~~~~~~

Can you post the complete expression ? Like what to be passed in map function ?

[matt-42]

can you share the code that generated this error ?

[adibro500]

This code caused the error:

db.connect().prepare("Select id,post from post_items;")().map([&](std::string id, std::string post) {

});

what i am doing wrong ?

Please look at my most recent edit

[matt-42]

Do you still have this compilation error ? I've added a test and it seems to compile and work fine on my computer. (But it fails on travis, still have to find why...):
https://github.com/matt-42/lithium/blob/master/libraries/sql/tests/mysql.cc#L53

[adibro500]

which compiler and compiler version you are using ?

[adibro500]

I am using gcc version 9.3.0

[matt-42]

I also have gcc 9.3.0, can you share a simple c++ pease of code that would allow me to reproduce the error ?

[adibro500]

db.connect().prepare("Select id,post from post_items;")().map([&](std::string id, std::string post) {

});

[matt-42]

this code is right, the error must come from somewhere else. If you want me to help more please share a c++ file that I can compile myself.

[matt-42]

Also note that on master the non prepared query API is finished.
You can now use:

db.connect()("Select id,post from post_items;").map([&](std::string id, std::string post) {

});

[matt-42]

Did you succeed ? can we close this issue ?

[adibro500]

Yes working