|
11
|
1 |
/*
|
|
|
2 |
* Copyright 2011 Tomas Zeman <tzeman@volny.cz>
|
|
|
3 |
*
|
|
|
4 |
* Licensed under the Apache License, Version 2.0 (the "License");
|
|
|
5 |
* you may not use this file except in compliance with the License.
|
|
|
6 |
* You may obtain a copy of the License at
|
|
|
7 |
*
|
|
|
8 |
* http://www.apache.org/licenses/LICENSE-2.0
|
|
|
9 |
*
|
|
|
10 |
* Unless required by applicable law or agreed to in writing, software
|
|
|
11 |
* distributed under the License is distributed on an "AS IS" BASIS,
|
|
|
12 |
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
|
|
|
13 |
* See the License for the specific language governing permissions and
|
|
|
14 |
* limitations under the License.
|
|
|
15 |
*/
|
|
|
16 |
package bootstrap.liftweb
|
|
|
17 |
|
|
|
18 |
import fis.base.model._
|
|
|
19 |
import net.liftweb.common._
|
|
|
20 |
import net.liftweb.db.{DB, ConnectionIdentifier}
|
|
|
21 |
import net.liftweb.http._
|
|
|
22 |
import net.liftweb.squerylrecord.SquerylRecord
|
|
|
23 |
import net.liftweb.util._
|
|
|
24 |
import net.liftweb.util.Helpers._
|
|
|
25 |
import net.tz.lift.boot.ProtoBoot
|
|
|
26 |
import net.tz.lift.util.StandardDBVendor
|
|
|
27 |
|
|
|
28 |
class Boot extends ProtoBoot {
|
|
|
29 |
override def boot = {
|
|
|
30 |
|
|
|
31 |
/* DB stuff */
|
|
14
|
32 |
val dbVendor = new FisDbVendor
|
|
|
33 |
DB.defineConnectionManager(FisConnectionIdentifier, dbVendor)
|
|
11
|
34 |
S.addAround(DB.buildLoanWrapper(List(FisConnectionIdentifier)))
|
|
|
35 |
SquerylRecord.init(() => new SeqIdPostgreSqlAdapter)
|
|
14
|
36 |
SquerylTxMgr.initSqueryl(FisConnectionIdentifier,
|
|
|
37 |
() => new SeqIdPostgreSqlAdapter)
|
|
|
38 |
LiftRules.unloadHooks.append(dbVendor.closeAllConnections_! _)
|
|
11
|
39 |
|
|
|
40 |
super.boot
|
|
|
41 |
|
|
|
42 |
}
|
|
|
43 |
}
|
|
|
44 |
|
|
|
45 |
case object FisConnectionIdentifier extends ConnectionIdentifier {
|
|
|
46 |
val jndiName = "fis"
|
|
|
47 |
}
|
|
|
48 |
|
|
|
49 |
import java.sql.Connection
|
|
|
50 |
|
|
|
51 |
class FisDbVendor extends StandardDBVendor(
|
|
|
52 |
"org.postgresql.Driver", Props.get("db.fis.url", ""),
|
|
|
53 |
Props.get("db.fis.user"), Props.get("db.fis.pass")) {
|
|
|
54 |
|
|
|
55 |
val testQuery = "SELECT version()"
|
|
|
56 |
override protected def testConnection(c: Connection) = {
|
|
|
57 |
c.prepareStatement(testQuery).executeQuery
|
|
|
58 |
}
|
|
|
59 |
}
|
|
|
60 |
|
|
14
|
61 |
import org.squeryl._
|
|
|
62 |
import org.squeryl.internals.DatabaseAdapter
|
|
|
63 |
|
|
|
64 |
object SquerylTxMgr {
|
|
|
65 |
def initSqueryl(name: ConnectionIdentifier,
|
|
|
66 |
mkAdapter: () => DatabaseAdapter) = {
|
|
|
67 |
SessionFactory.externalTransactionManagementAdapter =
|
|
|
68 |
Some(new SquerylTxMgr(name, mkAdapter))
|
|
|
69 |
}
|
|
|
70 |
}
|
|
|
71 |
|
|
|
72 |
class SquerylTxMgr(name: ConnectionIdentifier, mkAdapter: () => DatabaseAdapter)
|
|
|
73 |
extends Loggable with Function0[Session] {
|
|
|
74 |
|
|
|
75 |
private object currentSession extends DynoVar[Session]
|
|
|
76 |
|
|
|
77 |
|
|
|
78 |
def apply = currentSession.is openOr {
|
|
|
79 |
DB.use(name) { superConn =>
|
|
|
80 |
val sess = Session.create(superConn.connection, mkAdapter())
|
|
|
81 |
sess.setLogger(s => logger.debug(s))
|
|
|
82 |
currentSession.set(sess)
|
|
|
83 |
sess
|
|
|
84 |
}
|
|
|
85 |
}
|
|
|
86 |
}
|
|
|
87 |
|
|
11
|
88 |
// vim: set ts=2 sw=2 et:
|