StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POhow to handle fileupload into a table in play framework?
primarykey
Id
19424782
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-10-17T10:55:55.193
FavoriteCount
2
LastActivityDate
2013-10-25T05:19:46.607
LastEditDate
2013-10-17T19:22:36.750
LastEditorUserId
1863963
OwnerUserId
1863963
ParentId
0
PostTypeId
1
Score
1
ViewCount
375
LastEditorDisplayName
text
Body
<p>i have a table called system it has some columns mainly number / char types but there is one binary type for holding a document (word or excel etc)</p> <p>ignore for now if we should hold the file inline or external i.e. bfile or blob... the question is more about how to handle it in the play framework</p> <p>I have got the form working with the model view and controller... but i set it up without the file-field just to get it working:</p> <p>I have a case class in the model</p> <pre><code>case class System(sys_id: Pk[Long] = NotAssigned , sys_name: String , sys_desc: String , sys_owner1: Long , sys_owner2: Long) </code></pre> <p>a form in the controller </p> <pre><code>val systemForm = Form( mapping( "sys_id" -> ignored(NotAssigned:Pk[Long]), "sys_name" -> nonEmptyText, "sys_desc" -> nonEmptyText, "sys_owner1" -> longNumber, "sys_owner2" -> longNumber )(System.apply)(System.unapply) ) </code></pre> <p>and a form in the view</p> <pre><code>@form(routes.Systems.save(), 'class -> "form-horizontal") { @inputText(systemForm("sys_name"), '_label -> "System Name") @inputText(systemForm("sys_desc"), '_label -> "Description") @select( systemForm("sys_owner1"), persons, '_label -> "Primary Owner", '_default -> "-- Choose a person --", '_showConstraints -> false ) @select( systemForm("sys_owner2"), persons, '_label -> "Secondary Owner", '_default -> "-- Choose a person --", '_showConstraints -> false ) <div class="control-group"> <div class="controls"> <input type="submit" value="Create System" class="btn btn-success"> or <a href="@routes.Systems.list()" class="btn">Cancel</a> </div> </div> } </code></pre> <p>This all works well... but now i want to add the file in, what should i do? I have seen this <a href="http://www.playframework.com/documentation/2.1.2/ScalaFileUpload" rel="nofollow">http://www.playframework.com/documentation/2.1.2/ScalaFileUpload</a> but it confuses me it makes no mention of if or how i should change the case class - and what variable is the file stored in (if it is) so that I can access it in my code?</p> <p>should I modify my case class (if so what type should i add)? should I modify the Form in the controller (again if so what type should I add?)</p> <p>im not bothered whether I store it inline or as a bfile - but how can I handle it as asked above?</p> <p>Thank you</p>
Tags
<forms><scala><file-upload><playframework><playframework-2.0>
Title
how to handle fileupload into a table in play framework?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USmbrambley
UserOwnerUserId
1. USmbrambley
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
  POhow to handle fileupload into a table in play framework?
  UserUserId
  USsmallufo
  VoteTypeVoteTypeId
  VTFavorite
2. VO
  singulars
  PostPostId
  POhow to handle fileupload into a table in play framework?
  UserUserId
  UStehlexx
  VoteTypeVoteTypeId
  VTFavorite
3. VO
  singulars
  PostPostId
  POhow to handle fileupload into a table in play framework?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
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.