StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19884492
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-11-09T23:33:11.593
FavoriteCount
0
LastActivityDate
2013-11-09T23:33:11.593
LastEditDate
LastEditorUserId
0
OwnerUserId
1697985
ParentId
19877185
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Let's say you have the following case class and Slick table: <pre><code>case class User(id: Option[Int], first: String, last: String) object Users extends Table[User]("users") { def id = column[Int]("id", O.PrimaryKey, O.AutoInc) def first = column[String]("first") def last = column[String]("last") def * = id.? ~ first ~ last <> (User, User.unapply _) } </code></pre> The important things to consider here is the fact that User.id is an Option, because when we create it we will set it to None and the DB will generate the number for it. Now you need to define a new insert mapping which omits the autoincremented column. This is needed because some databases don't allow you to insert into a column which is labeled as Auto Incremental. So instead of: <pre><code>INSERT INTO users VALUES (NULL, "first, "last") </code></pre> Slick will generate: <pre><code>INSERT INTO user(first, last) VALUES ("first", "last") </code></pre> The mapping looks like this (which must be placed inside Users): <pre><code>def forInsert = first ~ last <> ({ t => User(None, t._1, t._2)}, { (u: User) => Some((u.first, u.last))}) </code></pre> Finally getting the auto-generated id is simple. We only need to specify in the returning the id column: <pre><code>val userId = Users.forInsert returning Users.id insert User(None, "First", "Last") </code></pre> Or you could instead move the returning statement: <pre><code>def forInsert = first ~ last <> ({ t => User(None, t._1, t._2)}, { (u: User) => Some((u.first, u.last))}) returning id </code></pre> And simplify your insert calls: <pre><code>val userId = Users.forInsert insert User(None, "First", "Last") </code></pre> <a href="http://slick.typesafe.com/doc/1.0.0/lifted-embedding.html#inserting" rel="nofollow">Source</a>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to return a sequence generation for an Id
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAkos Krivachy
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to return a sequence generation for an Id
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 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.