diff options
Diffstat (limited to 'app/models')
-rw-r--r-- | app/models/Tables.scala | 223 | ||||
-rw-r--r-- | app/models/Views.scala | 84 |
2 files changed, 185 insertions, 122 deletions
diff --git a/app/models/Tables.scala b/app/models/Tables.scala index 7d4406c..ff1f267 100644 --- a/app/models/Tables.scala +++ b/app/models/Tables.scala | |||
@@ -1,89 +1,78 @@ | |||
1 | package models | 1 | package models |
2 | |||
3 | // AUTO-GENERATED Slick data model | 2 | // AUTO-GENERATED Slick data model |
4 | /** Stand-alone Slick data model for immediate use */ | 3 | /** Stand-alone Slick data model for immediate use */ |
5 | object Tables extends { | 4 | object Tables extends { |
6 | val profile = scala.slick.driver.PostgresDriver | 5 | val profile = play.api.db.slick.Config.driver |
7 | } with Tables | 6 | } with Tables |
8 | 7 | ||
9 | /** Slick data model trait for extension, choice of backend or usage in the cake pattern. (Make sure to initialize this late.) */ | 8 | /** Slick data model trait for extension, choice of backend or usage in the cake pattern. (Make sure to initialize this late.) */ |
10 | trait Tables { | 9 | trait Tables { |
11 | val profile: scala.slick.driver.JdbcProfile | 10 | val profile: scala.slick.driver.JdbcProfile |
12 | |||
13 | import profile.simple._ | 11 | import profile.simple._ |
14 | import scala.slick.model.ForeignKeyAction | 12 | import scala.slick.model.ForeignKeyAction |
15 | |||
16 | // NOTE: GetResult mappers for plain SQL are only generated for tables where Slick knows how to map the types of all columns. | 13 | // NOTE: GetResult mappers for plain SQL are only generated for tables where Slick knows how to map the types of all columns. |
17 | |||
18 | import scala.slick.jdbc.{GetResult => GR} | 14 | import scala.slick.jdbc.{GetResult => GR} |
19 | 15 | ||
20 | /** DDL for all tables. Call .create to execute. */ | 16 | /** DDL for all tables. Call .create to execute. */ |
21 | lazy val ddl = Bids.ddl ++ Charges.ddl ++ Items.ddl ++ Transactions.ddl ++ Users.ddl | 17 | lazy val ddl = Bids.ddl ++ Charges.ddl ++ Items.ddl ++ Transactions.ddl ++ Users.ddl |
22 | 18 | ||
23 | /** Entity class storing rows of table Bids | 19 | /** Entity class storing rows of table Bids |
24 | * @param uuid Database column uuid DBType(varchar), PrimaryKey, Length(36,true) | 20 | * @param uuid Database column uuid DBType(varchar), PrimaryKey, Length(36,true) |
25 | * @param itemUuid Database column item_uuid DBType(varchar), Length(36,true) | 21 | * @param itemUuid Database column item_uuid DBType(varchar), Length(36,true) |
26 | * @param userUuid Database column user_uuid DBType(varchar), Length(36,true) | 22 | * @param userUuid Database column user_uuid DBType(varchar), Length(36,true) |
27 | * @param bidDate Database column bid_date DBType(timestamptz) | 23 | * @param bidDate Database column bid_date DBType(timestamptz) |
28 | * @param offer Database column offer DBType(numeric) */ | 24 | * @param offer Database column offer DBType(numeric) */ |
29 | case class Bid(uuid: String, itemUuid: String, userUuid: String, bidDate: java.sql.Timestamp, offer: scala.math.BigDecimal) | 25 | case class Bid(uuid: String, itemUuid: String, userUuid: String, bidDate: java.sql.Timestamp, offer: scala.math.BigDecimal) |
30 | |||
31 | /** GetResult implicit for fetching Bid objects using plain SQL queries */ | 26 | /** GetResult implicit for fetching Bid objects using plain SQL queries */ |
32 | implicit def GetResultBid(implicit e0: GR[String], e1: GR[java.sql.Timestamp], e2: GR[scala.math.BigDecimal]): GR[Bid] = GR { | 27 | implicit def GetResultBid(implicit e0: GR[String], e1: GR[java.sql.Timestamp], e2: GR[scala.math.BigDecimal]): GR[Bid] = GR{ |
33 | prs => import prs._ | 28 | prs => import prs._ |
34 | Bid.tupled((<<[String], <<[String], <<[String], <<[java.sql.Timestamp], <<[scala.math.BigDecimal])) | 29 | Bid.tupled((<<[String], <<[String], <<[String], <<[java.sql.Timestamp], <<[scala.math.BigDecimal])) |
35 | } | 30 | } |
36 | |||
37 | /** Table description of table bids. Objects of this class serve as prototypes for rows in queries. */ | 31 | /** Table description of table bids. Objects of this class serve as prototypes for rows in queries. */ |
38 | class Bids(_tableTag: Tag) extends Table[Bid](_tableTag, "bids") { | 32 | class Bids(_tableTag: Tag) extends Table[Bid](_tableTag, "bids") { |
39 | def * = (uuid, itemUuid, userUuid, bidDate, offer) <>(Bid.tupled, Bid.unapply) | 33 | def * = (uuid, itemUuid, userUuid, bidDate, offer) <> (Bid.tupled, Bid.unapply) |
40 | |||
41 | /** Maps whole row to an option. Useful for outer joins. */ | 34 | /** Maps whole row to an option. Useful for outer joins. */ |
42 | def ? = (uuid.?, itemUuid.?, userUuid.?, bidDate.?, offer.?).shaped.<>({ r => import r._; _1.map(_ => Bid.tupled((_1.get, _2.get, _3.get, _4.get, _5.get)))}, (_: Any) => throw new Exception("Inserting into ? projection not supported.")) | 35 | def ? = (uuid.?, itemUuid.?, userUuid.?, bidDate.?, offer.?).shaped.<>({r=>import r._; _1.map(_=> Bid.tupled((_1.get, _2.get, _3.get, _4.get, _5.get)))}, (_:Any) => throw new Exception("Inserting into ? projection not supported.")) |
43 | 36 | ||
44 | /** Database column uuid DBType(varchar), PrimaryKey, Length(36,true) */ | 37 | /** Database column uuid DBType(varchar), PrimaryKey, Length(36,true) */ |
45 | val uuid: Column[String] = column[String]("uuid", O.PrimaryKey, O.Length(36, varying = true)) | 38 | val uuid: Column[String] = column[String]("uuid", O.PrimaryKey, O.Length(36,varying=true)) |
46 | /** Database column item_uuid DBType(varchar), Length(36,true) */ | 39 | /** Database column item_uuid DBType(varchar), Length(36,true) */ |
47 | val itemUuid: Column[String] = column[String]("item_uuid", O.Length(36, varying = true)) | 40 | val itemUuid: Column[String] = column[String]("item_uuid", O.Length(36,varying=true)) |
48 | /** Database column user_uuid DBType(varchar), Length(36,true) */ | 41 | /** Database column user_uuid DBType(varchar), Length(36,true) */ |
49 | val userUuid: Column[String] = column[String]("user_uuid", O.Length(36, varying = true)) | 42 | val userUuid: Column[String] = column[String]("user_uuid", O.Length(36,varying=true)) |
50 | /** Database column bid_date DBType(timestamptz) */ | 43 | /** Database column bid_date DBType(timestamptz) */ |
51 | val bidDate: Column[java.sql.Timestamp] = column[java.sql.Timestamp]("bid_date") | 44 | val bidDate: Column[java.sql.Timestamp] = column[java.sql.Timestamp]("bid_date") |
52 | /** Database column offer DBType(numeric) */ | 45 | /** Database column offer DBType(numeric) */ |
53 | val offer: Column[scala.math.BigDecimal] = column[scala.math.BigDecimal]("offer") | 46 | val offer: Column[scala.math.BigDecimal] = column[scala.math.BigDecimal]("offer") |
54 | 47 | ||
55 | /** Foreign key referencing Items (database name bids_items_fk) */ | 48 | /** Foreign key referencing Items (database name bids_items_fk) */ |
56 | lazy val itemsFk = foreignKey("bids_items_fk", itemUuid, Items)(r => r.uuid, onUpdate = ForeignKeyAction.NoAction, onDelete = ForeignKeyAction.NoAction) | 49 | lazy val itemsFk = foreignKey("bids_items_fk", itemUuid, Items)(r => r.uuid, onUpdate=ForeignKeyAction.NoAction, onDelete=ForeignKeyAction.NoAction) |
57 | /** Foreign key referencing Users (database name bids_users_fk) */ | 50 | /** Foreign key referencing Users (database name bids_users_fk) */ |
58 | lazy val usersFk = foreignKey("bids_users_fk", userUuid, Users)(r => r.uuid, onUpdate = ForeignKeyAction.NoAction, onDelete = ForeignKeyAction.NoAction) | 51 | lazy val usersFk = foreignKey("bids_users_fk", userUuid, Users)(r => r.uuid, onUpdate=ForeignKeyAction.NoAction, onDelete=ForeignKeyAction.NoAction) |
59 | } | 52 | } |
60 | |||
61 | /** Collection-like TableQuery object for table Bids */ | 53 | /** Collection-like TableQuery object for table Bids */ |
62 | lazy val Bids = new TableQuery(tag => new Bids(tag)) | 54 | lazy val Bids = new TableQuery(tag => new Bids(tag)) |
63 | 55 | ||
64 | /** Entity class storing rows of table Charges | 56 | /** Entity class storing rows of table Charges |
65 | * @param uuid Database column uuid DBType(varchar), PrimaryKey, Length(36,true) | 57 | * @param uuid Database column uuid DBType(varchar), PrimaryKey, Length(36,true) |
66 | * @param startDate Database column start_date DBType(timestamptz) | 58 | * @param startDate Database column start_date DBType(timestamptz) |
67 | * @param endDate Database column end_date DBType(timestamptz) | 59 | * @param endDate Database column end_date DBType(timestamptz) |
68 | * @param fee Database column fee DBType(numeric) | 60 | * @param fee Database column fee DBType(numeric) |
69 | * @param rate Database column rate DBType(numeric) */ | 61 | * @param rate Database column rate DBType(numeric) */ |
70 | case class Charge(uuid: String, startDate: java.sql.Timestamp, endDate: java.sql.Timestamp, fee: scala.math.BigDecimal, rate: scala.math.BigDecimal) | 62 | case class Charge(uuid: String, startDate: java.sql.Timestamp, endDate: java.sql.Timestamp, fee: scala.math.BigDecimal, rate: scala.math.BigDecimal) |
71 | |||
72 | /** GetResult implicit for fetching Charge objects using plain SQL queries */ | 63 | /** GetResult implicit for fetching Charge objects using plain SQL queries */ |
73 | implicit def GetResultCharge(implicit e0: GR[String], e1: GR[java.sql.Timestamp], e2: GR[scala.math.BigDecimal]): GR[Charge] = GR { | 64 | implicit def GetResultCharge(implicit e0: GR[String], e1: GR[java.sql.Timestamp], e2: GR[scala.math.BigDecimal]): GR[Charge] = GR{ |
74 | prs => import prs._ | 65 | prs => import prs._ |
75 | Charge.tupled((<<[String], <<[java.sql.Timestamp], <<[java.sql.Timestamp], <<[scala.math.BigDecimal], <<[scala.math.BigDecimal])) | 66 | Charge.tupled((<<[String], <<[java.sql.Timestamp], <<[java.sql.Timestamp], <<[scala.math.BigDecimal], <<[scala.math.BigDecimal])) |
76 | } | 67 | } |
77 | |||
78 | /** Table description of table charges. Objects of this class serve as prototypes for rows in queries. */ | 68 | /** Table description of table charges. Objects of this class serve as prototypes for rows in queries. */ |
79 | class Charges(_tableTag: Tag) extends Table[Charge](_tableTag, "charges") { | 69 | class Charges(_tableTag: Tag) extends Table[Charge](_tableTag, "charges") { |
80 | def * = (uuid, startDate, endDate, fee, rate) <>(Charge.tupled, Charge.unapply) | 70 | def * = (uuid, startDate, endDate, fee, rate) <> (Charge.tupled, Charge.unapply) |
81 | |||
82 | /** Maps whole row to an option. Useful for outer joins. */ | 71 | /** Maps whole row to an option. Useful for outer joins. */ |
83 | def ? = (uuid.?, startDate.?, endDate.?, fee.?, rate.?).shaped.<>({ r => import r._; _1.map(_ => Charge.tupled((_1.get, _2.get, _3.get, _4.get, _5.get)))}, (_: Any) => throw new Exception("Inserting into ? projection not supported.")) | 72 | def ? = (uuid.?, startDate.?, endDate.?, fee.?, rate.?).shaped.<>({r=>import r._; _1.map(_=> Charge.tupled((_1.get, _2.get, _3.get, _4.get, _5.get)))}, (_:Any) => throw new Exception("Inserting into ? projection not supported.")) |
84 | 73 | ||
85 | /** Database column uuid DBType(varchar), PrimaryKey, Length(36,true) */ | 74 | /** Database column uuid DBType(varchar), PrimaryKey, Length(36,true) */ |
86 | val uuid: Column[String] = column[String]("uuid", O.PrimaryKey, O.Length(36, varying = true)) | 75 | val uuid: Column[String] = column[String]("uuid", O.PrimaryKey, O.Length(36,varying=true)) |
87 | /** Database column start_date DBType(timestamptz) */ | 76 | /** Database column start_date DBType(timestamptz) */ |
88 | val startDate: Column[java.sql.Timestamp] = column[java.sql.Timestamp]("start_date") | 77 | val startDate: Column[java.sql.Timestamp] = column[java.sql.Timestamp]("start_date") |
89 | /** Database column end_date DBType(timestamptz) */ | 78 | /** Database column end_date DBType(timestamptz) */ |
@@ -93,151 +82,141 @@ trait Tables { | |||
93 | /** Database column rate DBType(numeric) */ | 82 | /** Database column rate DBType(numeric) */ |
94 | val rate: Column[scala.math.BigDecimal] = column[scala.math.BigDecimal]("rate") | 83 | val rate: Column[scala.math.BigDecimal] = column[scala.math.BigDecimal]("rate") |
95 | } | 84 | } |
96 | |||
97 | /** Collection-like TableQuery object for table Charges */ | 85 | /** Collection-like TableQuery object for table Charges */ |
98 | lazy val Charges = new TableQuery(tag => new Charges(tag)) | 86 | lazy val Charges = new TableQuery(tag => new Charges(tag)) |
99 | 87 | ||
100 | /** Entity class storing rows of table Items | 88 | /** Entity class storing rows of table Items |
101 | * @param uuid Database column uuid DBType(varchar), PrimaryKey, Length(36,true) | 89 | * @param uuid Database column uuid DBType(varchar), PrimaryKey, Length(36,true) |
102 | * @param userUuid Database column user_uuid DBType(varchar), Length(36,true) | 90 | * @param userUuid Database column user_uuid DBType(varchar), Length(36,true) |
103 | * @param startDate Database column start_date DBType(timestamptz) | 91 | * @param startDate Database column start_date DBType(timestamptz) |
104 | * @param endDate Database column end_date DBType(timestamptz) | 92 | * @param endDate Database column end_date DBType(timestamptz) |
105 | * @param itemName Database column item_name DBType(varchar), Length(20,true) | 93 | * @param itemName Database column item_name DBType(varchar), Length(20,true) |
106 | * @param shortDesc Database column short_desc DBType(varchar), Length(30,true) | 94 | * @param shortDesc Database column short_desc DBType(varchar), Length(30,true) |
107 | * @param longDesc Database column long_desc DBType(text), Length(2147483647,true) | 95 | * @param longDesc Database column long_desc DBType(text), Length(2147483647,true) |
108 | * @param initialPrice Database column initial_price DBType(numeric) */ | 96 | * @param initialPrice Database column initial_price DBType(numeric) */ |
109 | case class Item(uuid: String, userUuid: String, startDate: java.sql.Timestamp, endDate: java.sql.Timestamp, itemName: String, shortDesc: String, longDesc: String, initialPrice: scala.math.BigDecimal) | 97 | case class Item(uuid: String, userUuid: String, startDate: java.sql.Timestamp, endDate: java.sql.Timestamp, itemName: String, shortDesc: String, longDesc: String, initialPrice: scala.math.BigDecimal) |
110 | |||
111 | /** GetResult implicit for fetching Item objects using plain SQL queries */ | 98 | /** GetResult implicit for fetching Item objects using plain SQL queries */ |
112 | implicit def GetResultItem(implicit e0: GR[String], e1: GR[java.sql.Timestamp], e2: GR[scala.math.BigDecimal]): GR[Item] = GR { | 99 | implicit def GetResultItem(implicit e0: GR[String], e1: GR[java.sql.Timestamp], e2: GR[scala.math.BigDecimal]): GR[Item] = GR{ |
113 | prs => import prs._ | 100 | prs => import prs._ |
114 | Item.tupled((<<[String], <<[String], <<[java.sql.Timestamp], <<[java.sql.Timestamp], <<[String], <<[String], <<[String], <<[scala.math.BigDecimal])) | 101 | Item.tupled((<<[String], <<[String], <<[java.sql.Timestamp], <<[java.sql.Timestamp], <<[String], <<[String], <<[String], <<[scala.math.BigDecimal])) |
115 | } | 102 | } |
116 | |||
117 | /** Table description of table items. Objects of this class serve as prototypes for rows in queries. */ | 103 | /** Table description of table items. Objects of this class serve as prototypes for rows in queries. */ |
118 | class Items(_tableTag: Tag) extends Table[Item](_tableTag, "items") { | 104 | class Items(_tableTag: Tag) extends Table[Item](_tableTag, "items") { |
119 | def * = (uuid, userUuid, startDate, endDate, itemName, shortDesc, longDesc, initialPrice) <>(Item.tupled, Item.unapply) | 105 | def * = (uuid, userUuid, startDate, endDate, itemName, shortDesc, longDesc, initialPrice) <> (Item.tupled, Item.unapply) |
120 | |||
121 | /** Maps whole row to an option. Useful for outer joins. */ | 106 | /** Maps whole row to an option. Useful for outer joins. */ |
122 | def ? = (uuid.?, userUuid.?, startDate.?, endDate.?, itemName.?, shortDesc.?, longDesc.?, initialPrice.?).shaped.<>({ r => import r._; _1.map(_ => Item.tupled((_1.get, _2.get, _3.get, _4.get, _5.get, _6.get, _7.get, _8.get)))}, (_: Any) => throw new Exception("Inserting into ? projection not supported.")) | 107 | def ? = (uuid.?, userUuid.?, startDate.?, endDate.?, itemName.?, shortDesc.?, longDesc.?, initialPrice.?).shaped.<>({r=>import r._; _1.map(_=> Item.tupled((_1.get, _2.get, _3.get, _4.get, _5.get, _6.get, _7.get, _8.get)))}, (_:Any) => throw new Exception("Inserting into ? projection not supported.")) |
123 | 108 | ||
124 | /** Database column uuid DBType(varchar), PrimaryKey, Length(36,true) */ | 109 | /** Database column uuid DBType(varchar), PrimaryKey, Length(36,true) */ |
125 | val uuid: Column[String] = column[String]("uuid", O.PrimaryKey, O.Length(36, varying = true)) | 110 | val uuid: Column[String] = column[String]("uuid", O.PrimaryKey, O.Length(36,varying=true)) |
126 | /** Database column user_uuid DBType(varchar), Length(36,true) */ | 111 | /** Database column user_uuid DBType(varchar), Length(36,true) */ |
127 | val userUuid: Column[String] = column[String]("user_uuid", O.Length(36, varying = true)) | 112 | val userUuid: Column[String] = column[String]("user_uuid", O.Length(36,varying=true)) |
128 | /** Database column start_date DBType(timestamptz) */ | 113 | /** Database column start_date DBType(timestamptz) */ |
129 | val startDate: Column[java.sql.Timestamp] = column[java.sql.Timestamp]("start_date") | 114 | val startDate: Column[java.sql.Timestamp] = column[java.sql.Timestamp]("start_date") |
130 | /** Database column end_date DBType(timestamptz) */ | 115 | /** Database column end_date DBType(timestamptz) */ |
131 | val endDate: Column[java.sql.Timestamp] = column[java.sql.Timestamp]("end_date") | 116 | val endDate: Column[java.sql.Timestamp] = column[java.sql.Timestamp]("end_date") |
132 | /** Database column item_name DBType(varchar), Length(20,true) */ | 117 | /** Database column item_name DBType(varchar), Length(20,true) */ |
133 | val itemName: Column[String] = column[String]("item_name", O.Length(20, varying = true)) | 118 | val itemName: Column[String] = column[String]("item_name", O.Length(20,varying=true)) |
134 | /** Database column short_desc DBType(varchar), Length(30,true) */ | 119 | /** Database column short_desc DBType(varchar), Length(30,true) */ |
135 | val shortDesc: Column[String] = column[String]("short_desc", O.Length(30, varying = true)) | 120 | val shortDesc: Column[String] = column[String]("short_desc", O.Length(30,varying=true)) |
136 | /** Database column long_desc DBType(text), Length(2147483647,true) */ | 121 | /** Database column long_desc DBType(text), Length(2147483647,true) */ |
137 | val longDesc: Column[String] = column[String]("long_desc", O.Length(214748364 |