StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POright way of testing for optional field values
primarykey
Id
7606450
data
AcceptedAnswerId
7606804
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-09-30T05:56:34.870
FavoriteCount
0
LastActivityDate
2011-09-30T07:49:33.293
LastEditDate
2011-09-30T07:49:33.293
LastEditorUserId
855171
OwnerUserId
855171
ParentId
0
PostTypeId
1
Score
0
ViewCount
164
LastEditorDisplayName
text
Body
While writing a method in my app which uses <code>playframework</code>,I need to get user input for <code>Address</code> fields and search db for a matching one.If I can't find a matching address ,I have to create a new Address. Here only <code>addressLine1</code> and <code>country</code> are the required fields. A user can ignore the addressLine2. while taking input from the html form ,the textfields for optional fields return an empty string.So,to test the creation of Address ,I decided to create a <code>Map<String,String></code> to be passed to the <code>POST</code> method.. I tried <pre><code>addrparams = new Map<String,String>(); addrparams.put("addressline1","clayton st"); addrparams.put("country","US"); </code></pre> This caused nullpointer exception when the jpql query tried to bind values fro the map for the missing options fields. <pre><code>String query="select distinct a from Address a where a.addressLine1=:addressline1 and a.addressLine2=:addressline2 and a.country=:country"; Address address = Address.find(query).bind("addressline1",addressline1).bind("addressline2",addressline2).bind("country", country).first(); .. </code></pre> I solved this by putting empty strings for all optional fields <pre><code>addrparams = new Map<String,String>(); addrparams.put("addressline1","clayton st"); addrparams.put("addressline2",""); addrparams.put("country","US"); </code></pre> I hope this is the correct way to do this..If someone can point out better approach at testing such situations,it would help me a lot The Address class <pre><code>@Entity public class Address extends Model { @Required String addressLine1; String addressLine2; @Required String country; ... } </code></pre> update: The stacktrace is <a href="http://pastebin.com/RnyRgdL9" rel="nofollow">here</a> The Account.java:207 where nullptr exception occurs,is this line <pre><code>Address address = Address.find(query).bind("addressline1",addressline1).bind("addressline2",addressline2).bind("country", country).first(); </code></pre>
Tags
<java><playframework><optional>
Title
right way of testing for optional field values
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USjimgardener
UserOwnerUserId
1. USjimgardener
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. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.