restSQL: SQL Resource DELETE Path XML or JSON

Method	DELETE
Path	/res/{resName}/{resId}
Query Params	None
Request body	One or more child rows to delete of parent matching path params.	Request.xsd	Content-Type: application/xml or application/json
Response body	Number of rows deleted.	Response.xsd	Content-Type: application/xml or application/json

Description

Deletes children of a one-to-many hierarchial SQL Resource or associations to children of a many-to-many hierarchical SQL Resource.

XML Examples

A one-to-many hierarchical SQL Resource (child rows are deleted):

DELETE /restsql/res/LanguageFilm/3 HTTP/1.1
Content-Type: application/xml
Accept: application/xml

<request>
   <film film_id="3" />
   <film film_id="43" />
   <film film_id="67" />
</request>

HTTP/1.1 200 OK
Content-Type: application/xml

<writeResponse rowsAffected="3" />

A many-to-many hierarchical SQL Resource (child rows are disassociated):

DELETE /restsql/res/ActorFilm/123 HTTP/1.1
Content-Type: application/xml
Accept: application/xml

<request>
   <film film_id="3" />
   <film film_id="43" />
   <film film_id="233" />
</request>

HTTP/1.1 200 OK
Content-Type: application/xml

<writeResponse rowsAffected="3" />

JSON Examples

A one-to-many hierarchical SQL Resource (child rows are deleted):

DELETE /restsql/res/LanguageFilm/3 HTTP/1.1
Content-Type: application/json
Accept: application/json

{ "films": [
      { "film_id": 3 },
      { "film_id": 43 },
      { "film_id": 67 },
   ]
}

HTTP/1.1 200 OK
Content-Type: application/json

{ "rowsAffected": 3 }

A many-to-many hierarchical SQL Resource (child rows are disassociated):

DELETE /restsql/res/ActorFilm/123 HTTP/1.1
Content-Type: application/json
Accept: application/json

{ "films": [
      { "film_id": 3 },
      { "film_id": 43 },
      { "film_id": 233 },
   ]
}

HTTP/1.1 200 OK
Content-Type: application/json

{ "rowsAffected": 3 }