StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POTesting for PUT/POST/DELETE Methods
primarykey
Id
15865827
data
AcceptedAnswerId
15867691
AnswerCount
1
ClosedDate
2013-04-08T08:43:00.090
CommentCount
5
CommunityOwnedDate
CreationDate
2013-04-07T18:01:37.257
FavoriteCount
0
LastActivityDate
2013-04-07T20:54:20.603
LastEditDate
2013-04-07T18:59:21.317
LastEditorUserId
189154
OwnerUserId
189154
ParentId
0
PostTypeId
1
Score
2
ViewCount
482
LastEditorDisplayName
text
Body
I am having some trouble running tests for <code>PUT</code>, <code>POST</code> and <code>DELETE</code> using the unit testing framework <a href="http://phpspec.net/" rel="nofollow noreferrer">phpspec2</a>. This is the code that I have in my unit test: <pre><code>$this->beConstructedWith(new \Tonic\Application(), new \Tonic\Request(array( 'uri' => '/', 'method' => 'PUT', 'Content-Type' => 'application/json', 'data' => '{"name":"testing", "email":"testing@@test.com", "password":"Passw0rd"}' )), array()); $expectedResult = new \stdClass(); $expectedResult->message = "An error was encountered."; $expectedResult->error[] = "The email must be valid."; $response = $this->exec(); $response->shouldReturnAnInstanceOf("Tonic\Response"); $response->contentType->shouldBe("application/json"); $response->body->shouldBe(json_encode($expectedResult)); </code></pre> From looking around the <a href="http://peej.github.io/tonic/" rel="nofollow noreferrer">Tonic</a> code and the examples in the <a href="https://github.com/peej/tonic" rel="nofollow noreferrer">git repository</a> I think I have it set up correctly. The following is the result of running <code>bin/phpspec -v run</code> for this unit test: <img src="https://i.stack.imgur.com/udjLv.png" alt="phpspec2 Error"> When I run an actual request against the Tonic service it works fine. I know I must be doing something wrong in the setup of the unit test but I don't know what. Edit: PUT Method <pre><code>/** * Add a new user to the table. * * @method PUT * @accepts application/json * @provides application/json * @json * @return \Tonic\Response */ public function add() { // Validate the data before we go any futher. $error = $this->validate(); // If the data is invalid then we want to let the requester know. if (true === $error) { $this->output->message = "An error was encountered."; $this->responseCode = \Tonic\Response::NOTFOUND; } else { // Else we want to PUT the data into our table. $query = $this->db->prepare("INSERT INTO `user` (`name`, `email`, `password`, `dateOfBirth`) VALUES (:name, :email, :password, :dateOfBirth)"); $query->bindValue(":name", $this->request->data->name); $query->bindValue(":email", $this->request->data->email); $query->bindValue(":password", hash('sha256', $this->request->data->password)); $query->bindValue(":dateOfBirth", $this->request->data->dateOfBirth); $query->execute(); // Check that the new user was successfully inserted into the database. If not let the requester know what happened. if (0 === $query->rowCount()) { if ("00000" === $query->errorCode()) { $this->output->message = "No rows affected by query."; } else { $this->output->message = "There was an error running the query."; $this->output->error[] = $query->errorInfo(); } $this->responseCode = \Tonic\Response::CONFLICT; } else { // Inserted successfully. $this->output->message = "User successfully created."; $this->responseCode = \Tonic\Response::CREATED; $this->headers["Location"] = "/" . $this->request->data->email; } } return new \Tonic\Response($this->responseCode, $this->output, $this->headers); } </code></pre>
Tags
<php><phpspec><tonic>
Title
Testing for PUT/POST/DELETE Methods
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USNalum
UserOwnerUserId
1. USNalum
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POTesting for PUT/POST/DELETE Methods
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.