int main(void) { attachsql_connect_t *con= NULL; attachsql_error_t *error= NULL; const char *query= "SELECT * FROM t1 WHERE name = ? AND age > ?"; attachsql_return_t ret= ATTACHSQL_RETURN_NONE; con= attachsql_connect_create("localhost", 3306, "test", "test", "testdb", NULL); attachsql_statement_prepare(con, strlen(query), query, &error); while((ret != ATTACHSQL_RETURN_EOF) && (error == NULL)) { ret= attachsql_connect_poll(con, &error); } if (error != NULL) { printf("Error occurred: %s", attachsql_error_message(error)); attachsql_error_free(error); attachsql_statement_close(con); attachsql_connect_destroy(con); return 1; } const char *name= "fred"; uint32_t age= 30; attachsql_statement_set_string(con, 0, strlen(name), name, NULL); attachsql_statement_set_int(con, 1, age, NULL); attachsql_statement_execute(con, &error); ret= ATTACHSQL_RETURN_NONE; while ((ret != ATTACHSQL_RETURN_EOF) && (error == NULL)) { ret= attachsql_connect_poll(con, &error); if (ret != ATTACHSQL_RETURN_ROW_READY) { continue; } attachsql_statement_row_get(con, &error); printf("ID: %d, ", attachsql_statement_get_int(con, 0, &error)); size_t len; char *name_data= attachsql_statement_get_char(con, 1, &len, &error); printf("Name: %.*s, ", (int)len, name_data); printf("Age: %d\n", attachsql_statement_get_int(con, 2, &error)); attachsql_statement_row_next(con); } if (error != NULL) { printf("Error occurred: %s", attachsql_error_message(error)); attachsql_error_free(error); } attachsql_statement_close(con); attachsql_connect_destroy(con); }
int attachsql_drv_execute(db_stmt_t *stmt, db_result_set_t *rs) { (void) rs; attachsql_connect_t *con= (attachsql_connect_t *)stmt->connection->ptr; attachsql_return_t aret= ATTACHSQL_RETURN_NONE; attachsql_error_t *error= NULL; uint16_t i; int8_t tinyint; int16_t smallint; int32_t normalint; int64_t bigint; float float_type; double double_type; db_time_t *time_data; if (con == NULL) return 1; for (i= 0; i < stmt->bound_param_len; i++) { db_bind_t *param= &stmt->bound_param[i]; switch(param->type) { case DB_TYPE_TINYINT: tinyint= *(int8_t*)param->buffer; attachsql_statement_set_int(con, i, tinyint, NULL); break; case DB_TYPE_SMALLINT: smallint= *(int16_t*)param->buffer; attachsql_statement_set_int(con, i, smallint, NULL); break; case DB_TYPE_INT: normalint= *(int32_t*)param->buffer; attachsql_statement_set_int(con, i, normalint, NULL); break; case DB_TYPE_BIGINT: bigint= *(int64_t*)param->buffer; attachsql_statement_set_bigint(con, i, bigint, NULL); break; case DB_TYPE_FLOAT: float_type= *(float*)param->buffer; attachsql_statement_set_float(con, i, float_type, NULL); break; case DB_TYPE_DOUBLE: double_type= *(double*)param->buffer; attachsql_statement_set_double(con, i, double_type, NULL); break; case DB_TYPE_TIME: time_data= (db_time_t*)param->buffer; attachsql_statement_set_time(con, i, time_data->hour, time_data->minute, time_data->second, 0, false, NULL); break; case DB_TYPE_DATE: case DB_TYPE_DATETIME: case DB_TYPE_TIMESTAMP: time_data= (db_time_t*)param->buffer; attachsql_statement_set_datetime(con, i, time_data->year, time_data->month, time_data->day, time_data->hour, time_data->minute, time_data->second, 0, NULL); break; case DB_TYPE_CHAR: case DB_TYPE_VARCHAR: attachsql_statement_set_string(con, i, param->max_len, param->buffer, NULL); case DB_TYPE_NONE: default: attachsql_statement_set_null(con, i, NULL); /* Not supported */ } } attachsql_statement_execute(con, &error); while(aret != ATTACHSQL_RETURN_EOF) { aret= attachsql_connect_poll(con, &error); if (aret == ATTACHSQL_RETURN_ROW_READY) { return 0; } if (error) { log_text(LOG_ALERT, "libAttachSQL Execute Failed: %u:%s", attachsql_error_code(error), attachsql_error_message(error)); attachsql_error_free(error); return SB_DB_ERROR_FAILED; } } return SB_DB_ERROR_NONE; }