| author | Tomas Zeman <tzeman@volny.cz> |
| Fri, 10 Feb 2012 09:53:04 +0100 | |
| changeset 7 | 8ef5e77ad79e |
| parent 6 | 98d9c92a726f |
| permissions | -rw-r--r-- |
|
6
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
1 |
/* |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
2 |
* Copyright 2011 Tomas Zeman <tzeman@volny.cz> |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
3 |
* |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
4 |
* Licensed under the Apache License, Version 2.0 (the "License"); |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
5 |
* you may not use this file except in compliance with the License. |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
6 |
* You may obtain a copy of the License at |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
7 |
* |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
8 |
* http://www.apache.org/licenses/LICENSE-2.0 |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
9 |
* |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
10 |
* Unless required by applicable law or agreed to in writing, software |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
11 |
* distributed under the License is distributed on an "AS IS" BASIS, |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
12 |
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
13 |
* See the License for the specific language governing permissions and |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
14 |
* limitations under the License. |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
15 |
*/ |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
16 |
package fis.base.model |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
17 |
|
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
18 |
import org.squeryl.{Session, Table}
|
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
19 |
import org.squeryl.adapters.PostgreSqlAdapter |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
20 |
import org.squeryl.internals.StatementWriter |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
21 |
import scala.collection.mutable.HashSet |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
22 |
|
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
23 |
/** |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
24 |
* Postgres adapter which enables multiple entities to share the same |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
25 |
* sequence. |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
26 |
* |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
27 |
* The implementation is based on Postgres adapter which is |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
28 |
* |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
29 |
* Copyright 2010 Maxime Lévesque |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
30 |
* |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
31 |
* and licensed under the same license (Apache 2). |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
32 |
*/ |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
33 |
class SeqIdPostgreSqlAdapter extends PostgreSqlAdapter {
|
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
34 |
private val seqs = new HashSet[String] |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
35 |
|
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
36 |
override def postCreateTable(t: Table[_], |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
37 |
printSinkWhenWriteOnlyMode: Option[String => Unit]) = {
|
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
38 |
|
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
39 |
val autoIncrementedFields = t.posoMetaData.fieldsMetaData. |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
40 |
filter(_.isAutoIncremented). |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
41 |
filter(f => !seqs.contains(f.sequenceName)) |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
42 |
|
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
43 |
for(fmd <-autoIncrementedFields) {
|
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
44 |
val sw = new StatementWriter(false, this) |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
45 |
sw.write("create sequence ", quoteName(fmd.sequenceName))
|
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
46 |
seqs += fmd.sequenceName |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
47 |
|
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
48 |
if(printSinkWhenWriteOnlyMode == None) {
|
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
49 |
val st = Session.currentSession.connection.createStatement |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
50 |
st.execute(sw.statement) |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
51 |
} |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
52 |
else |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
53 |
printSinkWhenWriteOnlyMode.get.apply(sw.statement + ";") |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
54 |
} |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
55 |
} |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
56 |
} |
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
57 |
|
|
98d9c92a726f
aa0667047f9451b1 Global object id sequence generator (H2, pgsql)
Tomas Zeman <tzeman@volny.cz>
parents:
diff
changeset
|
58 |
// vim: set ts=2 sw=2 et: |