Serialize To Redis

[edsionlee]

How can I serialize a MySQL result set into Redis? It needs to include the field names and values, and also be deserializable back into a MySQL result set from Redis!

[rbock]

Please provide more detailed information of what you want to achieve?

I have zero experience with Redis. But given that Redis is a key/value store, I would imagine something like

for (const auto& row : db(select(all_of(tab)).from(tab))) {
  client.set(key("id), row.id); // assuming some imaginary redis client
  client.set(key("name"), row.name); // Note that this could be optional
  client.set(key("date"). row.date); // This might need to be serialized by your code or the redis client
}

[edsionlee]

Is there an easier way to iterate through the result set directly, instead of manually handling each variable? If done manually, different structures require writing different code!

[rbock]

You mean iterating through the columns? You can get a tuple of values using row.as_tuple().

I think it would be possible to create a tuple of names, too. Then you could iterate through names and values in parallel.

[edsionlee]

Yes.. you are right. For example, in the example above, the effect I want to achieve is:

std::map<std::string, std::string> mapReuslt;
for (const auto& row : db(select(all_of(tab)).from(tab))) {
mapResult[row.column_name()] = row.column_value();
}

Can you provide some ideas on how to achieve this effect?

[rbock]

If you are into template programming, then result_row.h and field_spec.h should give you all the ideas you need.

Otherwise, waiting might be easier. I like the idea, but I a pretty pre-occupied with other work in the next 3 weeks.

[edsionlee]

Thank you

[edsionlee]

May I ask when this feature is scheduled to be added?

[rbock]

I pushed an experimental version 244998c.

This should work for reading results. WDYT?

[edsionlee]

ok!

[rbock]

OK, pushed to main, too.

Next step would be to provide a tuple of columns for tables. That would allow you to do the inverse for insert.