src/main/scala/fis/base/model/SeqIdPostgreSqlAdapter.scala
author Tomas Zeman <tzeman@volny.cz>
Fri, 10 Feb 2012 09:53:04 +0100
changeset 7 8ef5e77ad79e
parent 6 98d9c92a726f
permissions -rw-r--r--
base entity addons: entityTable()
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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: