Loop/update data
data in stormbase can be read/updated using loop statements and C programsSB C interface
loop table_name(col1, coll2, ...) function function_name(param1, param2, ...) update (updated_col1, updated_col1, ...) where ...Parameters, update clause and where clause are optional
SB will execute 3 C functions
1/ <function_name>_before: optional "before function" called once, where you allocated the object you will need
2/ <function_name>: mandatory "loop function" called once per line fecthed, where you populate the objects
3/ <function_name>_after: optional "after function" called once, where you free memory
See input/output of these functions in common.h
basic read
basic update
passing parameters
mutex
standard update functions
fn_update_idx1
fn_update_idx1_num
fn_copy_col
fn_concat
skip
If before fn returns SKIP, the rest of the loop is skip