static void row_callback(void * u, const tdsl::tds_colmetadata_token & colmd,
const tdsl::tdsl_row & row) {
SERIAL_PRINTLNF("row: %s %s %s %s %s", row [0].as<tdsl::char_view>().data(),
row [1].as<tdsl::char_view>().data(),
row [2].as<tdsl::char_view>().data(),
row [3].as<tdsl::char_view>().data(),
row [4].as<tdsl::char_view>().data());
}
// --------------------------------------------------------------------------------
void loop() {
// Your queries goes here.
if(read_flag==1){
database_read();
read_flag=0;
}
}
void database_read() {
// Execute SELECT query on every tenth loop
auto query{TDSL_PMEMSTR("SELECT TOP (3) Name,ID,Address,City,Country FROM rfid_user")};
SERIAL_PRINTF("Executing query: ");
SERIAL_PRINTLNF_PROGMEM(query.raw_data());
// We're using the row
auto result = driver.execute_query(query, row_callback);
SERIAL_PRINTLNF("Rows affected: %d", result.affected_rows);
}