iPhrXdkL

1$ sqlite users.db 
2     
3play.http.secret.key = "changeme"
4
5play.i18n {
6  langs = [ "en" ]
7
8}
9play.filters {
10  enabled += filters.ExampleFilter
11
12}
13
14play.evolutions.db.default {
15  enabled = true
16  autoApply = true
17  autoApplyDowns = true
18}
19
20slick.dbs.default {
21  profile = "slick.jdbc.SQLiteProfile$"
22  driver = "slick.driver.SQLiteDriver$"
23  db.driver = "org.sqlite.JDBC"
24  db.url = "jdbc:sqlite:/home/saad/play-scala-starter-example/conf/users.db"
25}
26
27play.assets {
28  path = "/public"
29  urlPrefix = "/assets"
30} 
31     
32name := """play-scala-starter-example"""
33
34version := "1.0-SNAPSHOT"
35
36lazy val root = (project in file(".")).enablePlugins(PlayScala)
37
38resolvers += Resolver.sonatypeRepo("snapshots")
39
40scalaVersion := "2.12.7"
41
42crossScalaVersions := Seq("2.11.12", "2.12.7")
43
44libraryDependencies += guice
45libraryDependencies += "org.scalatestplus.play" %% "scalatestplus-play" % "3.1.2" % Test
46libraryDependencies += "com.typesafe.slick" %% "slick" % "3.2.0"
47libraryDependencies += "com.typesafe.slick" %% "slick-codegen" % "3.2.3"
48
49libraryDependencies += evolutions
50libraryDependencies ++= Seq(
51  "com.typesafe.play" %% "play-slick" % "3.0.0",
52  "com.typesafe.play" %% "play-slick-evolutions" % "3.0.0"
53)
54libraryDependencies ++= Seq(
55  cache,
56  javaWs,
57  "org.xerial" % "sqlite-jdbc" % "3.23.1"
58) 
59     
60# --- !Ups
61
62CREATE TABLE IF NOT EXISTS Users(
63ID INTEGER PRIMARY KEY AUTOINCREMENT,
64LastName varchar(255) NOT NULL,
65FirstName varchar(255) NOT NULL,
66Password varchar(255) NOT NULL,
67Email varchar(255) NOT NULL UNIQUE,
68Authenticated boolean
69);
70
71INSERT INTO Users(LastName, FirstName, Password, Email, Authenticated) VALUES ('Saad', 'Ali', 'spadsdditcom', 'asdasdasd', 1);
72
73# --- !Downs
74
75DROP TABLE IF EXISTS Users