Delete rows

Rows can be deleted by the HTTP DELETE command.

The URI syntax to delete a column is:

http://hostname:port/rdm/dbname/tablename/?key=keyname&start=keyvalue[;keyvalue]

If a specified key is a compound key the keyvalues should be separated by a semicolon ‘;’ and specified in the order they are defined in the schema.

If a key is not unique all rows that match the specified key values will be updated.

If a table does not have a key the special keyname “rowid” can be used with the internal rowid value for the row that should be updated. All tables can use the “rowid” special key even if they have other keys defined.

curl -i -X "DELETE" http://localhost:21553/rdm/BICYCLE_DB/BICYCLE?key=rowid&value=3

curl -i -X "DELETE" "http://localhost:21553/rdm/BICYCLE_DB/BICYCLE?key=MANUFACTURER_ID_MODEL&value=1;Domane"

curl -i -X "DELETE" "http://localhost:21553/rdm/BICYCLE_DB/MANFUFACTURER?key=NAME&value=Trek Bicycle Corporation"