C++ example

[sunnyb75]

Can you provide a C++ example/demo to use with RedisSQL module?

[siscia]

Hello,

Do you have a specific library in mind?

The API for hiredis that is the official C library is quite small and terse, at least for synchronous API.

It is not tested, but I would do something like:

redisContext *c = redisConnect("127.0.0.1", 6379);
redisCommand(redisContext, "REDISQL.CREATE_DB DB");

redisCommand(redisContext, "REDISQL.EXEC DB 'create table foo (a, b, c);' ");
redisCommand(redisContext, "REDISQL.EXEC DB 'insert into foo values(1,2,3),(4,5,6);' ");
reply = redisCommand(redisContext, "REDISQL.EXEC DB 'select * from foo' ");

// somehow use this reply object
freeReplyObject(reply); // not sure it is needed

It is just a sketch that I didn't test.

Does it helps?

[siscia]

(And congrats on opening our first issue!)

[nqf]

you can use redis-plus-plus lib

auto pipe = redis-plus-plus->pipeline(false);
pipe.command("REDISQL.CREATE_DB", "TT")
 .command("REDISQL.EXEC", "TT", "COMMAND", "CREATE TABLE foo(name TEXT);")
 .command("REDISQL.EXEC", "TT", "COMMAND", "CREATE INDEX foo_index ON foo(name);")
 .command("REDISQL.EXEC", "TT", "COMMAND", "INSERT INTO foo VALUES("hello")
 .exec();