CodeKit Code Table Update Methods

These methods update the code table. They never call commit in order to not disturb any transactions in progress. If the library handle that you provide to CodeKit is not set up to autocommit, call commit yourself after calling these methods.

remove()

$codekit->remove($code_set, $code_code);

The remove() method removes a code record.

$codekit->remove('city_id', $city_id);

get()

# PHP
list( $code_desc, $code_order, $code_flag ) =
    $codekit->get($code_set, $code_code);
# Perl
( $code_desc, $code_order, $code_flag ) =
    $codekit->get($code_set, $code_code);
This is an internal method used to retrieve all of a code's fields.

put()

$codekit->put($code_set,  $code_code,
                  $code_desc, $code_order, $code_flag);
This is an internal method used to write all of a code's fields. The code is added, updated or deleted as necessary. Putting a blank description will remove() the code record.

The code_order and code_flag parameters are optional.

When a code is first added and the code_order parameter is missing, blank or undefined and the code_code value is numeric then the code_code value is entered into the code_order field. This supports numeric sorts on numeric codes by default.