svnno****@sourc*****
svnno****@sourc*****
2007年 7月 10日 (火) 22:05:11 JST
Revision: 225
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=225
Author: takeharu
Date: 2007-07-10 22:01:46 +0900 (Tue, 10 Jul 2007)
Log Message:
-----------
added mydbflute
Added Paths:
-----------
pompei/trunk/mydbflute/dbflute-0.5.2/templates/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model/Control.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model/Object.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/Control.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ExtensionInterface.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ExtensionObject.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ExtensionProxyInterface.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/Interface.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/Object.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ProxyInterface.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/repository/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/repository/Control.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/repository/MainRepository.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/repository/Repository.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/Control.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/sequence.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/sequence.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/sequence.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/sequence.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/sequence.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/columns.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/db.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/drop.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/foreignkey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/index.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/primarykey.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/table.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/tablefk.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/unique.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/Control.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/axion/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/axion/createdb.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/db2400/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/db2400/createdb.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/hypersonic/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/hypersonic/createdb.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/mssql/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/mssql/createdb.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/mysql/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/mysql/createdb.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/oracle/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/oracle/createdb.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/postgresql/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/postgresql/createdb.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/sapdb/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/sapdb/createdb.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/sybase/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/sybase/createdb.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/Control.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.axion
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.cloudscape
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.db2
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.db2400
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.hypersonic
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.interbase
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.mssql
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.mysql
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.oracle
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.postgresql
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.sapdb
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.sybase
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/scheduler.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/turbine.props
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/Control.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/axion/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/axion/row.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/axion/val.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2/row.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2/val.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2400/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2400/row.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2400/val.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/hypersonic/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/hypersonic/row.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/hypersonic/val.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/msaccess/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/msaccess/row.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/msaccess/val.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mssql/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mssql/row.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mssql/val.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mysql/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mysql/row.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mysql/val.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/oracle/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/oracle/row.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/oracle/val.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/postgresql/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/postgresql/row.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/postgresql/val.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sapdb/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sapdb/row.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sapdb/val.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sybase/
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sybase/row.vm
pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sybase/val.vm
-------------- next part --------------
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model/Control.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model/Control.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model/Control.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,26 @@
+#set ($basePath = $generator.OutputPath)
+
+#foreach ($dataModel in $dataModels)
+ #foreach ($database in $dataModel.Databases)
+
+ #if ($database.Package)
+ #set ($package = $database.Package)
+ #else
+ #set ($package = $targetPackage)
+ #end
+
+ #set ( $path = $strings.getPackageAsPath($package) )
+ $files.mkdir("$outputDirectory/$path")
+
+ #foreach ($tbl in $database.Tables)
+ #if (!$tbl.isForReferenceOnly())
+ $tbl.Name
+ #set ( $firstcap=$tbl.JavaName )
+
+ #set ( $fname = "${firstcap}.java" )
+ #set ( $path = "${strings.getPackageAsPath($package)}$fname" )
+ $generator.parse("ojb/model/Object.vm",$path,"table",$tbl)
+ #end
+ #end
+ #end
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model/Object.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model/Object.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model/Object.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,47 @@
+package ${package};
+
+#if ($table.BaseClass)
+ #set ($extendsBaseClass = "extends $table.BaseClass" )
+#else
+ #set ($extendsBaseClass = "" )
+#end
+
+import java.io.Serializable;
+import java.util.Date;
+import java.math.BigDecimal;
+
+/**
+ * ${table.JavaName}
+#if ($addTimeStamp)
+ * This class was autogenerated by Torque on:
+ *
+ * [$now]
+ *
+#end
+ */
+public class ${table.JavaName}
+{
+ #foreach ($col in $table.Columns)
+ private $col.JavaPrimitive $col.UncapitalisedJavaName;
+ #end
+
+ #foreach ($col in $table.Columns)
+
+ /**
+ * Get the $col.JavaName
+ * @return $col.JavaPrimitive
+ */
+ public $col.JavaPrimitive get${col.JavaName}()
+ {
+ return $col.UncapitalisedJavaName;
+ }
+
+ /**
+ * Set the value of $cfc
+ */
+ public void set${col.JavaName}($col.JavaPrimitive v)
+ {
+ this.$col.UncapitalisedJavaName = v;
+ }
+ #end
+}
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/Control.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/Control.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/Control.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,60 @@
+#set ( $basePath = ${generator.OutputPath} )
+
+#foreach ($dataModel in $dataModels)
+ #foreach ($database in $dataModel.Databases)
+
+ #if ($database.Package)
+ #set ($package = $database.Package)
+ #else
+ #set ($package = $targetPackage)
+ #end
+
+ #set ( $path = $strings.getPackageAsPath($package) )
+ $files.mkdir("$outputDirectory/$path")
+
+ #foreach ($tbl in $database.Tables)
+ $tbl.Name
+ #set ( $firstcap=$tbl.JavaName )
+
+ #set ( $fname = "${firstcap}.java" )
+ #set ( $path = "${strings.getPackageAsPath($package)}$fname" )
+
+ #if (!$files.file($basePath,$path).exists())
+ $generator.parse("ojb/model/ExtensionObject.vm",$path,"table",$tbl)
+ #end
+
+ #set ( $fname = "${basePrefix}${firstcap}.java" )
+ #set ( $path = "${strings.getPackageAsPath($package)}$fname" )
+ $generator.parse("ojb/model/Object.vm",$path,"table",$tbl)
+
+ #if ( $ojbUseProxy == true )
+
+ #set ( $fname = "${firstcap}ProxyInterface.java" )
+ #set ( $path = "${strings.getPackageAsPath($package)}$fname" )
+ #if (!$files.file($basePath,$path).exists())
+ $generator.parse("ojb/model/ExtensionProxyInterface.vm",$path,"table",$tbl)
+ #end
+
+ #set ( $fname = "${basePrefix}${firstcap}ProxyInterface.java" )
+ #set ( $path = "${strings.getPackageAsPath($package)}$fname" )
+ $generator.parse("ojb/model/ProxyInterface.vm",$path,"table",$tbl)
+
+ #end
+
+ #if ($ojbUseInterface == true )
+
+ #set ( $fname = "${firstcap}Interface.java" )
+ #set ( $path = "${strings.getPackageAsPath($package)}$fname" )
+ #if (!$files.file($basePath,$path).exists())
+ $generator.parse("ojb/model/ExtensionInterface.vm",$path,"table",$tbl)
+ #end
+
+ #set ( $fname = "${basePrefix}${firstcap}Interface.java" )
+ #set ( $path = "${strings.getPackageAsPath($package)}$fname" )
+ $generator.parse("ojb/model/Interface.vm",$path,"table",$tbl)
+
+ #end
+ #end
+ #end
+
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ExtensionInterface.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ExtensionInterface.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ExtensionInterface.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,26 @@
+#set ($interface = "")
+#if ($table.Interface)
+ #set ($interface = ", $table.Interface")
+#end
+
+package $package;
+
+#if ($table.isAbstract())
+ #set ($abstract = "abstract")
+#end
+
+/**
+#if ($addTimeStamp)
+ * The skeleton for this interface was autogenerated by Torque on:
+ *
+ * [$now]
+ *
+#end
+ * You should add additional methods to this interface to meet the
+ * application requirements. This class will only be generated as
+ * long as it does not already exist in the output directory.
+ */
+public interface ${table.JavaName}Interface
+ extends ${basePrefix}${table.JavaName}Interface
+{
+}
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ExtensionObject.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ExtensionObject.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ExtensionObject.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,29 @@
+#set ($interface = "")
+#if ($table.Interface)
+ #set ($interface = ", $table.Interface")
+#end
+
+package $package;
+
+#if ($table.isAbstract())
+ #set ($abstract = "abstract")
+#end
+
+import org.apache.torque.om.Persistent;
+
+/**
+#if ($addTimeStamp)
+ * The skeleton for this class was autogenerated by Torque on:
+ *
+ * [$now]
+ *
+#end
+ * You should add additional methods to this class to meet the
+ * application requirements. This class will only be generated as
+ * long as it does not already exist in the output directory.
+ */
+public $!abstract class $table.JavaName
+ extends $basePrefix$table.JavaName
+ implements ${table.JavaName}Interface
+{
+}
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ExtensionProxyInterface.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ExtensionProxyInterface.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ExtensionProxyInterface.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,23 @@
+#set ($interface = "")
+#if ($table.Interface)
+ #set ($interface = ", $table.Interface")
+#end
+
+package $package;
+
+
+/**
+#if ($addTimeStamp)
+ * The skeleton for this interface was autogenerated by Torque on:
+ *
+ * [$now]
+ *
+#end
+ * You should add additional methods to this interface to meet the
+ * application requirements. This class will only be generated as
+ * long as it does not already exist in the output directory.
+ */
+public interface ${table.JavaName}ProxyInterface
+ extends ${basePrefix}${table.JavaName}ProxyInterface
+{
+}
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/Interface.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/Interface.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/Interface.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,39 @@
+package ${package};
+
+import java.io.Serializable;
+import java.util.Date;
+import java.math.BigDecimal;
+
+/**
+#if ($addTimeStamp)
+ * This interface was autogenerated by Torque on:
+ *
+ * [$now]
+ *
+#end
+ * You should not use this interface directly. It should not even be
+ * extended all references should be to ${table.JavaName}Interface
+ */
+public interface ${basePrefix}${table.JavaName}Interface extends Serializable
+{
+
+ #foreach ($col in $table.Columns)
+ #set ( $cfc=$col.JavaName )
+ #set ( $cfc=$cfc.replaceFirst(".", $cfc.substring(0,1).toUpperCase()) )
+ #set ( $clo=$col.Name.toLowerCase() )
+ #set ( $cjtype = $col.JavaPrimitive )
+
+ /**
+ * Get the $cfc
+ * @return $cjtype
+ */
+ public $cjtype get${cfc}();
+
+ /**
+ * Set the value of $cfc
+ */
+ public void set${cfc}($cjtype v );
+
+ #end
+
+}
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/Object.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/Object.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/Object.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,77 @@
+package ${package};
+
+#if ($table.BaseClass)
+ #set ($extendsBaseClass = "extends $table.BaseClass" )
+#else
+ #set ($extendsBaseClass = "" )
+#end
+
+ #if ($table.Interface)
+ #if ($ojbUseInterface == true)
+ #set ($interface = "Serializable, ${basePrefix}${table.JavaName}Interface, $table.Interface" )
+ #else
+ #set ($interface = "Serializable, $table.Interface" )
+ #end
+#else
+ #if ($ojbUseInterface == true)
+ #set ($interface = "Serializable, ${basePrefix}${table.JavaName}Interface" )
+ #else
+ #set ($interface = "Serializable" )
+ #end
+ #end
+
+import java.io.Serializable;
+import java.util.Date;
+import java.math.BigDecimal;
+
+/**
+#if ($addTimeStamp)
+ * This class was autogenerated by Torque on:
+ *
+ * [$now]
+ *
+#end
+ * You should not use this class directly. It should not even be
+ * extended all references should be to $table.JavaName
+ */
+public class ${basePrefix}${table.JavaName} $extendsBaseClass
+ implements $interface
+{
+
+ #foreach ($col in $table.Columns)
+ #set ( $cjtype = $col.JavaPrimitive )
+ #set ( $clo=$col.Name.toLowerCase() )
+ #set ( $defaultValue = "null" )
+ #if ( $cjtype == "boolean")
+ #set ( $defaultValue = "false" )
+ #elseif ($cjtype == "int")
+ #set ( $defaultValue = "0" )
+ #end
+ private $cjtype $clo = $defaultValue;
+ #end
+
+ #foreach ($col in $table.Columns)
+ #set ( $cfc=$col.JavaName )
+ #set ( $cfc=$cfc.replaceFirst(".", $cfc.substring(0,1).toUpperCase()) )
+ #set ( $clo=$col.Name.toLowerCase() )
+ #set ( $cjtype = $col.JavaPrimitive )
+
+ /**
+ * Get the $cfc
+ * @return $cjtype
+ */
+ public $cjtype get${cfc}()
+ {
+ return $clo;
+ }
+
+ /**
+ * Set the value of $cfc
+ */
+ public void set${cfc}($cjtype v )
+ {
+ this.$clo = v;
+ }
+
+ #end
+}
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ProxyInterface.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ProxyInterface.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/model_broken/ProxyInterface.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,33 @@
+package ${package};
+
+import java.io.Serializable;
+import java.util.Date;
+
+/**
+#if ($addTimeStamp)
+ * This interface was autogenerated by Torque on:
+ *
+ * [$now]
+ *
+#end
+ * You should not use this proxy interface directly. It should
+ * not even be extended all references should be to
+ * ${table.JavaName}ProxyInterface
+ */
+public interface ${basePrefix}${table.JavaName}ProxyInterface extends Serializable
+{
+
+ #foreach ($col in $table.PrimaryKey)
+ #set ( $cfc=$col.JavaName )
+ #set ( $cfc=$cfc.replaceFirst(".", $cfc.substring(0,1).toUpperCase()) )
+ #set ( $clo=$col.Name.toLowerCase() )
+ #set ( $cjtype = $col.JavaPrimitive )
+
+ /**
+ * Get the $cfc
+ * @return $cjtype
+ */
+ public $cjtype get${cfc}();
+
+ #end
+}
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/repository/Control.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/repository/Control.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/repository/Control.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,19 @@
+#set ( $mrname = "ojb/repository/MainRepository.vm" )
+#set ( $rname = "ojb/repository/Repository.vm" )
+#set ( $basepath = $generator.OutputPath)
+
+#foreach ($dataModel in $dataModels)
+ #if($velocityCount==1)
+ $generator.parse("ojb/repository/MainRepository.vm","repository.xml","dataModel",$dataModel)
+ #end
+#end
+
+#foreach ($dataModel in $dataModels)
+ #if ($project)
+ #set ( $outFile = "repository_${dataModel.shortName}.xml" )
+ #set ( $modelCount = $velocityCount )
+
+ File to be created: $outFile
+ $generator.parse($rname,$outFile,"dataModel",$dataModel)
+ #end
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/repository/MainRepository.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/repository/MainRepository.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/repository/MainRepository.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,57 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<!--
+ Repository for the Apache ObJectRelationalBridge (OJB) System.
+ Generated by Torque on: [$now]
+-->
+
+<!-- defining entities for include-files -->
+<!DOCTYPE descriptor-repository PUBLIC
+ "-//Apache Software Foundation//DTD OJB Repository//EN"
+ "repository.dtd"
+[
+<!ENTITY internal SYSTEM "repository_internal.xml">
+#foreach ($dataModel in $dataModels)
+<!ENTITY $dataModel.shortName SYSTEM "repository_${dataModel.shortName}.xml">
+#end
+]>
+
+<descriptor-repository version="1.0" isolation-level="read-uncommitted">
+<!-- The Default JDBC Connection. If a Class does not specify its own JDBC Connection,
+ the Connection specified here will be used. -->
+
+ <jdbc-connection-descriptor id="default"
+ jcd-alias="default"
+ default-connection="true"
+ platform="$ojbPlatform"
+ jdbc-level="${jdbcLevel}"
+ #if ($ojbUseJNDI)
+ jndi-datasource-name="$ojbJNDISource"
+ #else
+ driver="$databaseDriver"
+ protocol="$urlProtocol"
+ subprotocol="$urlSubprotocol"
+ dbalias="$urlDbalias"
+ #end
+ username="$databaseUser"
+ password="$!databasePassword"
+ >
+ <sequence-manager className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
+ <attribute attribute-name="grabSize" attribute-value="5"/>
+ <attribute attribute-name="globalSequenceId" attribute-value="true"/>
+ <attribute attribute-name="globalSequenceStart" attribute-value="10000"/>
+ </sequence-manager>
+ </jdbc-connection-descriptor>
+
+
+ <!-- include internal mappings here -->
+ &internal;
+
+ <!-- include mappings here -->
+#foreach ($dataModel in $dataModels)
+ &${dataModel.shortName};
+#end
+
+</descriptor-repository>
+
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/repository/Repository.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/repository/Repository.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/ojb/repository/Repository.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,106 @@
+#set ( $database = $dataModel.database )
+#set ( $unknownTorqueTypes = [ 'NULL', 'OTHER', 'JAVA_OBJECT', 'DISTINCT', 'STRUCT', 'ARRAY', 'REF', 'BOOLEANINT', 'BOOLEANCHAR' ] )
+#set ( $mappedJdbcTypes = ['INTEGER', 'BLOB', 'BLOB', 'BLOB', 'BLOB', 'BLOB', 'BLOB', 'INTEGER', 'CHAR' ] )
+#set ( $fieldsWithNoSize = ['INTEGER', 'BLOB', 'CLOB', 'DATE', 'TIME', 'TIMESTAMP', 'BINARY', 'BIGINT', 'SMALLINT', 'TINYINT' ] )
+#if ($database.Package)
+ #set ($package = $database.Package)
+#else
+ #set ($package = $targetPackage)
+#end
+
+#foreach ($table in $database.tables)
+
+<!--
+==============================================================
+ TABLE $table.Name
+==============================================================
+$!table.getDescription()
+-->
+ <class-descriptor
+ #if ($ojbUseProxy)
+ proxy="dynamic"
+ #end
+ class="${package}.${table.JavaName}"
+ table="$table.Name"
+ >
+ #set ( $indices = [ "" ] )
+ #foreach ($index in $table.getIndices())
+ #set ( $indexColumnListString = $index.getColumnList() )
+ #set ( $indexColumnList = $indexColumnListString.split(",") )
+ #foreach ( $indexedColumn in $indexColumnList )
+ #set ( $result = $indices.add($indexedColumn) )
+ #end
+ #end
+ #foreach ($col in $table.Columns)
+
+<!--
+ COLUMN $col.Name
+..............................................
+$!col.getDescription()
+-->
+ #set ( $mappingPos = $unknownTorqueTypes.indexOf($col.TorqueType) )
+ #set ( $size = "" )
+ #set ( $precision = "" )
+ #set ( $colType = $col.getType() )
+ #set ( $colTypeClass = $colType.getClass() )
+ #set ( $colTypeClassName = $colTypeClass.getName() )
+ ## === determine the type of the field. OJB recognizes less types than Torque, thus unkown types must be mapped
+ #if ($mappingPos != -1)
+ #set ( $jdbcFieldType = $mappedJdbcTypes.get($mappingPos) )
+ #if ( $mappedJdbcTypes.get($mappingPos) == "CHAR" )
+ #set ( $size = "1" )
+ #else
+ #set ( $size = "" )
+ #end
+ #else ## == no mapping is required
+ #set ( $jdbcFieldType = $col.TorqueType )
+ ## === split the size field into length and precision
+ #if ($col.size != "")
+ #set ( $sizeList = $size.split(",") )
+ #set ( $foundPart = 0 )
+ ## == unfortunatedly $sizeList.get(0) dows not work so I did this hack
+ #foreach ( $part in $sizeList)
+ #if ($foundPart == 0)
+ #set ( $size = $part )
+ #set ( $foundPart = 1 )
+ #elseif ($foundPart == 1)
+ #set ( $precision = $part )
+ #set ( $foundPart = 2 )
+ #end
+ #end
+ #end
+ #end
+
+ <field-descriptor id="$velocityCount"
+ name="$col.UncapitalisedJavaName"
+ column="$col.Name"
+ jdbc-type="$jdbcFieldType"
+#if ($col.isNotNull())
+ nullable="false"
+#end
+#if ($indices.indexOf($col.Name) != -1)
+ indexed="true"
+#end
+#if ($col.isPrimaryKey())
+ primarykey="true"
+#end
+#if ($col.isAutoIncrement())
+ autoincrement="true"
+#end
+#if ($size != "" && $size != "0")
+ length="${size}"
+#end
+#if ($precision != "")
+ precision="${precision}"
+#end
+#if ($col.TorqueType == "BOOLEANINT")
+ conversion="org.apache.ojb.broker.accesslayer.conversions.Boolean2IntFieldConversion"
+#end
+#if ($col.TorqueType == "BOOLEANCHAR")
+ conversion="insert-conversion-class-here"
+#end
+ />
+
+ #end
+ </class-descriptor>
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/Control.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/Control.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/Control.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,40 @@
+#set ( $basepath = "sql/base/$targetDatabase" )
+#set ( $dbprops = $properties.load("sql/base/$targetDatabase/db.props") )
+#set ( $fname= "sql/base/$targetDatabase/table.vm" )
+#set ( $fnamekeys= "sql/base/$targetDatabase/tablefk.vm" )
+#set ( $idname = "sql/id-table/idtable.$targetDatabase" )
+
+#foreach ($dataModel in $dataModels)
+
+ #set ( $outFile = "${dataModel.name}.sql" )
+
+ File to be created: $outFile
+
+ #set ( $database = $dataModel.database )
+ #foreach ($tbl in $database.tables)
+ Primary Key:#if ($tbl.hasPrimaryKey()) Yes #else No #end
+ #if (!$tbl.isSkipSql())
+ $generator.parse($fname,$outFile,"table",$tbl)
+ #end
+ #end
+
+ #foreach ($tbl in $database.tables)
+ #if (!$tbl.isSkipSql())
+ $generator.parse($fnamekeys,$outFile,"tablefk",$tbl)
+ #end
+ #end
+
+ #if ($idmodel)
+
+ Creating id-table
+
+ #set ($tbl = $idmodel.database.getTable("ID_TABLE"))
+ $generator.parse($fname,$outFile,"table",$tbl)
+
+ ## Generate inserts into ID-TABLE for initial ids.
+ #set ( $initialID = 1 )
+ $generator.parse($idname, $outFile, "tables", $database.tables)
+
+ #end
+
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,13 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #set ( $size = $col.printSize() )
+ #set ( $default = $col.DefaultSetting )
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"") )
+ #if ($col.isAutoIncrement() && $table.IdMethod == "native")
+ #set ( $autoIncrement = $dbprops.get("AUTOINCREMENT") )
+ #else
+ #set ( $autoIncrement = " " )
+ #end
+ #set ( $entry = "$col.Name $type $autoIncrement," )
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,40 @@
+# JDBC to Axion mappings.
+
+BIT = BIT
+TINYINT = TINYINT
+SMALLINT = SMALLINT
+INTEGER = INTEGER
+BIGINT = BIGINT
+FLOAT = FLOAT
+REAL = REAL
+DOUBLE = DOUBLE
+NUMERIC = NUMERIC
+DECIMAL = INTEGER
+CHAR = VARCHAR
+VARCHAR = varchar
+LONGVARCHAR = VARCHAR
+DATE = date
+TIME = time
+TIMESTAMP = timestamp
+BINARY = BINARY
+VARBINARY = BINARY
+LONGVARBINARY = LONGVARBINARY
+NULL = NULL
+OTHER = OTHER
+JAVA_OBJECT =
+DISTINCT =
+STRUCT =
+ARRAY =
+BLOB =
+CLOB =
+REF =
+
+AUTOINCREMENT = IDENTITY
+NOTNULL = NOT NULL
+
+primaryKeyInsideTableDirective = true
+indexInsideTableDirective = false
+
+removeNotNullWithAutoIncrement = false
+
+suppressDefaults = true
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+drop table if exists $table.Name;
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($fk in $table.ForeignKeys)
+## FOREIGN KEY ($fk.LocalColumnNames) REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($index in $table.Indices)
+CREATE #if($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.hasPrimaryKey())
+## PRIMARY KEY($table.printPrimaryKey()),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,20 @@
+
+-----------------------------------------------------------------------------
+-- $table.Name
+-----------------------------------------------------------------------------
+##$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+##set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$pk,$fk,$unique,$index]))$strings.chop($cols,2)#else$cols#end
+#if($strings.allEmpty([$fk,$unique,$index]) && $pk.length()>0)$strings.chop($pk,2)#else$pk#end
+##if($strings.allEmpty([$unique,$index]) && $fk.length() >0)$strings.chop($fk,2)#else$fk#end
+#if($unique.length()>0)$strings.chop($unique,2)#else$unique#end
+
+);
+
+#if($index.length() > 0)$strings.chop($index,1)#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/tablefk.vm
===================================================================
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/axion/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+## UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,13 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #set ( $size = $col.printSize() )
+ #set ( $default = $col.DefaultSetting )
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"") )
+ #if ($col.isAutoIncrement() && $table.IdMethod == "native")
+ #set ( $autoIncrement = $dbprops.get("AUTOINCREMENT") )
+ #else
+ #set ( $autoIncrement = " " )
+ #end
+ #set ( $entry = "$col.Name $type $size $autoIncrement," )
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,41 @@
+# Taken from java.sql.Types in the IBM 1.3 JDK
+# JDBC to Cloudscape mappings.
+
+BIT = BIT
+TINYINT = TINYINT
+SMALLINT = SMALLINT
+INTEGER = INT
+BIGINT = LONGINT
+FLOAT = FLOAT
+REAL = REAL
+DOUBLE = DOUBLE PRECISION
+NUMERIC = NUMERIC
+DECIMAL = DECIMAL
+CHAR = CHAR
+VARCHAR = VARCHAR
+LONGVARCHAR = LONG VARCHAR
+DATE = DATE
+TIME = TIME
+TIMESTAMP = TIMESTAMP
+BINARY = LONG BINARY
+VARBINARY = LONG BINARY
+LONGVARBINARY = LONG VARBINARY
+NULL =
+OTHER =
+JAVA_OBJECT = SERIALIZE
+DISTINCT =
+STRUCT =
+ARRAY =
+BLOB =
+CLOB =
+REF =
+
+AUTOINCREMENT = DEFAULT AUTOINCREMENT
+NOTNULL = NOT NULL
+
+primaryKeyInsideTableDirective = true
+indexInsideTableDirective = false
+
+removeNotNullWithAutoIncrement = false
+
+suppressDefaults = true
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+drop table if exists $table.Name;
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($fk in $table.ForeignKeys)
+ FOREIGN KEY ($fk.LocalColumnNames) REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($index in $table.Indices)
+CREATE #if($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.hasPrimaryKey())
+ PRIMARY KEY($table.printPrimaryKey()),
+#end
\ No newline at end of file
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,20 @@
+
+-----------------------------------------------------------------------------
+-- $table.Name
+-----------------------------------------------------------------------------
+##$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+##set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$pk,$unique]))$strings.chop($cols,1)#else$cols#end
+#if($strings.allEmpty([$unique]) && $pk.length()>0)$strings.chop($pk,2)#else$pk#end
+##if($strings.allEmpty([$unique,$index]) && $fk.length() >0)$strings.chop($fk,2)#else$fk#end
+#if($unique.length()>0)$strings.chop($unique,2)#else$unique#end
+
+);
+
+#if($index.length() > 0)$strings.chop($index,1)#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/tablefk.vm
===================================================================
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/cloudscape/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,24 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #set ( $size = $col.printSize() )
+ #if ( $type == "INTEGER" )
+ #set ( $size = "" )
+ #end
+ #set ( $rawsize = $col.Size )
+ #set ( $torquetype = $col.TorqueType )
+ #set ( $default = $col.DefaultSetting )
+ #if ($col.isAutoIncrement() && $table.IdMethod == "native")
+ #set ( $autoIncrement = $dbprops.get("AUTOINCREMENT") )
+ #else
+ #set ( $autoIncrement = " " )
+ #end
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"") )
+ #if ( $torquetype == "BINARY" )
+ #set ( $entry = "$col.Name CHAR($rawsize) FOR BIT DATA $default $nullString $autoIncrement," )
+ #elseif ( $torquetype == "VARBINARY" )
+ #set ( $entry = "$col.Name VARCHAR($rawsize) FOR BIT DATA $default $nullString $autoIncrement," )
+ #else
+ #set ( $entry = "$col.Name $type $size $default $nullString $autoIncrement," )
+ #end
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,41 @@
+# Taken from java.sql.Types in the IBM 1.3 JDK
+# JDBC to DB2 mappings.
+
+BIT =
+TINYINT =
+SMALLINT = SMALLINT
+INTEGER = INTEGER
+BIGINT = BIGINT
+FLOAT = FLOAT
+REAL = REAL
+DOUBLE = DOUBLE
+NUMERIC = NUMERIC
+DECIMAL = DECIMAL
+CHAR = VARCHAR
+VARCHAR = VARCHAR
+LONGVARCHAR = LONG VARCHAR
+DATE = DATE
+TIME = TIME
+TIMESTAMP = TIMESTAMP
+BINARY = CHAR(n) FOR BIT DATA
+# For DB2/400, VARBINARY must be changed to VARCHAR (32000) FOR BIT DATA
+VARBINARY = VARCHAR(n) FOR BIT DATA
+LONGVARBINARY = LONG VARCHAR FOR BIT DATA
+NULL = NULL
+OTHER =
+JAVA_OBJECT =
+DISTINCT = DISTINCT
+STRUCT =
+ARRAY =
+BLOB = BLOB
+CLOB = CLOB
+REF =
+
+AUTOINCREMENT = GENERATED ALWAYS AS IDENTITY
+NOTNULL = NOT NULL
+
+removeNotNullWithAutoIncrement = true
+
+suppressDefaults = false
+maxColumnNameLength = 18
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,6 @@
+drop table $table.Name;
+#set ($seqName = "~~novalue~~")
+#set ($seqName = $table.SequenceName)
+#if(!$seqName == "~~novalue~~")
+drop sequence $seqName restrict;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,16 @@
+
+-----------------------------------------------------------------------------
+-- $table.Name: FOREIGN KEYS
+-----------------------------------------------------------------------------
+#foreach ($fk in $table.ForeignKeys)
+ALTER TABLE $table.Name
+ ADD CONSTRAINT $fk.Name FOREIGN KEY ($fk.LocalColumnNames)
+ REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
+#if ($fk.hasOnUpdate())
+ ON UPDATE $fk.OnUpdate
+#end
+#if ($fk.hasOnDelete())
+ ON DELETE $fk.OnDelete
+#end
+;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($index in $table.Indices)
+CREATE #if($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#if ($table.hasPrimaryKey())
+ALTER TABLE $table.Name
+ ADD PRIMARY KEY ($table.printPrimaryKey());
+#end
\ No newline at end of file
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/sequence.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/sequence.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/sequence.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.IdMethod == "native")
+CREATE SEQUENCE $table.SequenceName;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,25 @@
+
+-----------------------------------------------------------------------------
+-- $table.Name
+-----------------------------------------------------------------------------
+$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$unique]))$strings.chop($cols,2)#else$cols#end
+#if($unique.length()>0)$strings.chop($unique,2)#end
+
+);
+
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+#if($pk.length()>0)$pk#end
+
+##set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+##if ($fk.length()>0)$fk#end
+
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($index.length() > 0)$index#end
+
+##set $sequence = $generator.parse("$basepath/sequence.vm", "", "table", $tbl)
+##if ($sequence.length()>0)$sequence#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/tablefk.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/tablefk.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/tablefk.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#if ($fk.length()>0)$fk#end
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,13 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #set ( $size = $col.printSize() )
+ #set ( $default = $col.DefaultSetting )
+ #if ($col.isAutoIncrement() && $table.IdMethod == "native")
+ #set ( $autoIncrement = $dbprops.get("AUTOINCREMENT") )
+ #else
+ #set ( $autoIncrement = " " )
+ #end
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"") )
+ #set ( $entry = "$col.Name $type $size $default $nullString $autoIncrement," )
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,38 @@
+# Taken from java.sql.Types in the IBM 1.3 JDK
+# JDBC to DB2/400 mappings.
+
+BIT =
+TINYINT = SMALLINT
+SMALLINT = SMALLINT
+INTEGER = INT
+BIGINT = BIGINT
+FLOAT = FLOAT
+REAL = REAL
+DOUBLE = DOUBLE PRECISION
+NUMERIC = NUMERIC
+DECIMAL = DEC
+CHAR = VARCHAR
+VARCHAR = VARCHAR
+LONGVARCHAR = LONG VARCHAR
+DATE = DATE
+TIME = TIME
+TIMESTAMP = TIMESTAMP
+BINARY =
+VARBINARY = VARCHAR (32000) FOR BIT DATA
+LONGVARBINARY =LONG VARCHAR FOR BIT DATA
+NULL =
+OTHER =
+JAVA_OBJECT =
+DISTINCT =
+STRUCT =
+ARRAY =
+BLOB =
+CLOB =
+REF =
+
+AUTOINCREMENT =
+NOTNULL = NOT NULL
+
+removeNotNullWithAutoIncrement = true
+maxColumnNameLength = 30
+suppressDefaults = false
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,13 @@
+drop table $table.Name;
+#*
+
+DB2 looks like oracle but I'm not sure
+about the sequences.
+
+#foreach ($col in $table.Columns)
+#if ($col.isAutoIncrement())
+drop sequence if exists ${table.Name}_SEQ;
+#end
+#end
+*#
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,5 @@
+#foreach ($fk in $table.ForeignKeys)
+ALTER TABLE $table.Name
+ ADD CONSTRAINT ${table.Name}_FK_${velocityCount} FOREIGN KEY ($fk.LocalColumnNames)
+ REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames);
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($index in $table.Indices)
+CREATE #if($index.IsUnique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,5 @@
+#if ($table.hasPrimaryKey())
+ALTER TABLE $table.Name
+ ADD CONSTRAINT ${table.Name}_PK
+PRIMARY KEY ($table.printPrimaryKey());
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/sequence.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/sequence.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/sequence.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.IdMethod == "sequence")
+CREATE SEQUENCE $table.SequenceName;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,26 @@
+
+-----------------------------------------------------------------------------
+-- $table.Name
+-----------------------------------------------------------------------------
+$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$unique]))$strings.chop($cols,2)#else$cols#end
+#if($unique.length()>0)$strings.chop($unique,2)#end
+
+);
+
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+#if($pk.length()>0)$pk#end
+
+#set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#if ($fk.length()>0)$fk#end
+
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($index.length() > 0)$index#end
+
+##set $sequence = $generator.parse("$basepath/sequence.vm", "", "table", $tbl)
+##if ($sequence.length()>0)$sequence#end
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/tablefk.vm
===================================================================
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/db2400/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,13 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #set ( $size = $col.printSize() )
+ #set ( $default = $col.DefaultSetting )
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"") )
+ #if ($col.isAutoIncrement() && $table.IdMethod == "native")
+ #set ( $autoIncrement = $dbprops.get("AUTOINCREMENT") )
+ #else
+ #set ( $autoIncrement = " " )
+ #end
+ #set ( $entry = "$col.Name $type $size $autoIncrement," )
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,41 @@
+# Taken from java.sql.Types in the IBM 1.3 JDK
+# JDBC to Cloudscape mappings.
+
+BIT = BIT
+TINYINT = TINYINT
+SMALLINT = SMALLINT
+INTEGER = INT
+BIGINT = LONGINT
+FLOAT = FLOAT
+REAL = REAL
+DOUBLE = DOUBLE PRECISION
+NUMERIC = NUMERIC
+DECIMAL = DECIMAL
+CHAR = CHAR
+VARCHAR = VARCHAR
+LONGVARCHAR = LONG VARCHAR
+DATE = DATE
+TIME = TIME
+TIMESTAMP = TIMESTAMP
+BINARY = LONG BINARY
+VARBINARY = LONG BINARY
+LONGVARBINARY = LONG VARBINARY
+NULL =
+OTHER =
+JAVA_OBJECT = SERIALIZE
+DISTINCT =
+STRUCT =
+ARRAY =
+BLOB =
+CLOB =
+REF =
+
+AUTOINCREMENT = DEFAULT AUTOINCREMENT
+NOTNULL = NOT NULL
+
+primaryKeyInsideTableDirective = true
+indexInsideTableDirective = false
+
+removeNotNullWithAutoIncrement = false
+
+suppressDefaults = true
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+drop table if exists $table.Name;
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($fk in $table.ForeignKeys)
+ FOREIGN KEY ($fk.LocalColumnNames) REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($index in $table.Indices)
+CREATE #if($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.hasPrimaryKey())
+ PRIMARY KEY($table.printPrimaryKey()),
+#end
\ No newline at end of file
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,20 @@
+
+-----------------------------------------------------------------------------
+-- $table.Name
+-----------------------------------------------------------------------------
+##$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+##set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$pk,$unique]))$strings.chop($cols,1)#else$cols#end
+#if($strings.allEmpty([$unique]) && $pk.length()>0)$strings.chop($pk,2)#else$pk#end
+##if($strings.allEmpty([$unique,$index]) && $fk.length() >0)$strings.chop($fk,2)#else$fk#end
+#if($unique.length()>0)$strings.chop($unique,2)#else$unique#end
+
+);
+
+#if($index.length() > 0)$strings.chop($index,1)#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/tablefk.vm
===================================================================
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/derby/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,14 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #set ( $size = $col.printSize() )
+ #set ( $default = $col.DefaultSetting )
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"") )
+ #if ($col.isAutoIncrement() && $table.IdMethod == "native")
+ #set ( $autoIncrement = $dbprops.get("AUTOINCREMENT") )
+ #else
+ #set ( $autoIncrement = " " )
+ #end
+ #set ( $colName = $strings.concat(['"',$col.Name,'"']) )
+ #set ( $entry = "$colName $type $size $default $nullString $autoIncrement," )
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,41 @@
+# Taken from java.sql.Types in the IBM 1.3 JDK
+# JDBC to Interbase mappings.
+
+BIT =
+TINYINT =
+SMALLINT =
+INTEGER = INTEGER
+BIGINT =
+FLOAT =
+REAL =
+DOUBLE =
+NUMERIC =
+DECIMAL =
+CHAR = VARCHAR
+VARCHAR = VARCHAR
+LONGVARCHAR = VARCHAR
+DATE =
+TIME =
+TIMESTAMP = timestamp
+BINARY =
+VARBINARY = BLOB
+LONGVARBINARY =
+NULL =
+OTHER =
+JAVA_OBJECT =
+DISTINCT =
+STRUCT =
+ARRAY =
+BLOB =
+CLOB =
+REF =
+
+AUTOINCREMENT = IDENTITY
+NOTNULL = NOT NULL
+
+primaryKeyInsideTableDirective = true
+indexInsideTableDirective = false
+
+removeNotNullWithAutoIncrement = false
+
+suppressDefaults = true
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+drop table if exists $table.Name;
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($fk in $table.ForeignKeys)
+ FOREIGN KEY ($fk.LocalColumnNames) REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($index in $table.Indices)
+CREATE #if($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.hasPrimaryKey())
+ PRIMARY KEY($table.printPrimaryKey()),
+#end
\ No newline at end of file
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,20 @@
+
+/* --------------------------------------------------------------------------
+$table.Name
+-------------------------------------------------------------------------- */
+##$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+##set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$pk,$unique]))$strings.chop($cols,1)#else$cols#end
+#if($strings.allEmpty([$unique]) && $pk.length()>0)$strings.chop($pk,2)#else$pk#end
+##if($strings.allEmpty([$unique,$index]) && $fk.length() >0)$strings.chop($fk,2)#else$fk#end
+#if($unique.length()>0)$strings.chop($unique,2)#else$unique#end
+
+);
+
+#if($index.length() > 0)$strings.chop($index,1)#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/tablefk.vm
===================================================================
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/firebird/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,13 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #set ( $size = $col.printSize() )
+ #set ( $default = $col.DefaultSetting )
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"") )
+ #if ($col.isAutoIncrement() && $table.IdMethod == "native")
+ #set ( $autoIncrement = $dbprops.get("AUTOINCREMENT") )
+ #else
+ #set ( $autoIncrement = " " )
+ #end
+ #set ( $entry = "$col.Name $type $size $autoIncrement," )
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,43 @@
+# Taken from java.sql.Types in the IBM 1.3 JDK
+# JDBC to Hypersonic mappings.
+
+BIT = BIT
+TINYINT = TINYINT
+SMALLINT = SMALLINT
+INTEGER = integer
+BIGINT = BIGINT
+FLOAT = FLOAT
+REAL = REAL
+DOUBLE = DOUBLE
+NUMERIC = NUMERIC
+DECIMAL = DECIMAL
+CHAR = VARCHAR
+VARCHAR = VARCHAR
+LONGVARCHAR = VARCHAR
+DATE = date
+TIME = time
+TIMESTAMP = timestamp
+BINARY = BINARY
+VARBINARY = BINARY
+LONGVARBINARY = LONGVARBINARY
+NULL = NULL
+OTHER = OTHER
+JAVA_OBJECT =
+DISTINCT =
+STRUCT =
+ARRAY =
+BLOB =
+CLOB =
+REF =
+
+AUTOINCREMENT = IDENTITY
+NOTNULL = NOT NULL
+
+idMethod=identity
+
+primaryKeyInsideTableDirective = true
+indexInsideTableDirective = false
+
+removeNotNullWithAutoIncrement = false
+
+suppressDefaults = true
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+drop table if exists $table.Name;
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,5 @@
+#foreach ($fk in $table.ForeignKeys)
+ ALTER TABLE $table.Name
+ ADD CONSTRAINT $fk.Name FOREIGN KEY ($fk.LocalColumnNames)
+ REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames);
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($index in $table.Indices)
+CREATE #if($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.hasPrimaryKey())
+ PRIMARY KEY($table.printPrimaryKey()),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,20 @@
+
+-----------------------------------------------------------------------------
+-- $table.Name
+-----------------------------------------------------------------------------
+##$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+##set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$pk,$fk,$unique]))$strings.chop($cols,2)#else$cols#end
+#if($strings.allEmpty([$fk,$unique]) && $pk.length()>0)$strings.chop($pk,2)#else$pk#end
+##if($strings.allEmpty([$unique,$index]) && $fk.length() >0)$strings.chop($fk,2)#else$fk#end
+#if($unique.length()>0)$strings.chop($unique,2)#else$unique#end
+
+);
+
+#if($index.length() > 0)$strings.chop($index,1)#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/tablefk.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/tablefk.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/tablefk.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#if ($fk.length()>0)$fk#end
+
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/hypersonic/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,14 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #set ( $size = $col.printSize() )
+ #set ( $default = $col.DefaultSetting )
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"") )
+ #if ($col.isAutoIncrement() && $table.IdMethod == "native")
+ #set ( $autoIncrement = $dbprops.get("AUTOINCREMENT") )
+ #else
+ #set ( $autoIncrement = " " )
+ #end
+ #set ( $colName = $strings.concat(['"',$col.Name,'"']) )
+ #set ( $entry = "$colName $type $size $default $nullString $autoIncrement," )
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,41 @@
+# Taken from java.sql.Types in the IBM 1.3 JDK
+# JDBC to Interbase mappings.
+
+BIT =
+TINYINT =
+SMALLINT =
+INTEGER = INTEGER
+BIGINT =
+FLOAT =
+REAL =
+DOUBLE =
+NUMERIC =
+DECIMAL =
+CHAR = VARCHAR
+VARCHAR = VARCHAR
+LONGVARCHAR = VARCHAR
+DATE =
+TIME =
+TIMESTAMP = timestamp
+BINARY =
+VARBINARY = BLOB
+LONGVARBINARY =
+NULL =
+OTHER =
+JAVA_OBJECT =
+DISTINCT =
+STRUCT =
+ARRAY =
+BLOB =
+CLOB =
+REF =
+
+AUTOINCREMENT = IDENTITY
+NOTNULL = NOT NULL
+
+primaryKeyInsideTableDirective = true
+indexInsideTableDirective = false
+
+removeNotNullWithAutoIncrement = false
+
+suppressDefaults = true
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+drop table if exists $table.Name;
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($fk in $table.ForeignKeys)
+ FOREIGN KEY ($fk.LocalColumnNames) REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($index in $table.Indices)
+CREATE #if($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.hasPrimaryKey())
+ PRIMARY KEY($table.printPrimaryKey()),
+#end
\ No newline at end of file
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,20 @@
+
+/* --------------------------------------------------------------------------
+$table.Name
+-------------------------------------------------------------------------- */
+##$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+##set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$pk,$unique]))$strings.chop($cols,1)#else$cols#end
+#if($strings.allEmpty([$unique]) && $pk.length()>0)$strings.chop($pk,2)#else$pk#end
+##if($strings.allEmpty([$unique,$index]) && $fk.length() >0)$strings.chop($fk,2)#else$fk#end
+#if($unique.length()>0)$strings.chop($unique,2)#else$unique#end
+
+);
+
+#if($index.length() > 0)$strings.chop($index,1)#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/tablefk.vm
===================================================================
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/interbase/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,13 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #set ( $size = $col.printSize() )
+ #set ( $default = $col.DefaultSetting )
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"") )
+ #if ($col.isAutoIncrement() && $table.IdMethod == "native")
+ #set ( $autoIncrement = $dbprops.get("AUTOINCREMENT") )
+ #else
+ #set ( $autoIncrement = " " )
+ #end
+ #set ( $entry = "$col.Name $type $size $autoIncrement," )
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,41 @@
+# Taken from java.sql.Types in the IBM 1.3 JDK
+# JDBC to MSAccess.
+
+BIT = BIT
+TINYINT = TINYINT
+SMALLINT = SMALLINT
+INTEGER = integer
+BIGINT = BIGINT
+FLOAT = FLOAT
+REAL = REAL
+DOUBLE = DOUBLE
+NUMERIC = NUMERIC
+DECIMAL = DECIMAL
+CHAR = VARCHAR
+VARCHAR = VARCHAR
+LONGVARCHAR = MEMO
+DATE = date
+TIME = time
+TIMESTAMP = timestamp
+BINARY = BINARY
+VARBINARY = BINARY
+LONGVARBINARY = BINARY
+NULL = NULL
+OTHER = OTHER
+JAVA_OBJECT =
+DISTINCT =
+STRUCT =
+ARRAY =
+BLOB =
+CLOB =
+REF =
+
+AUTOINCREMENT = IDENTITY
+NOTNULL = NOT NULL
+
+primaryKeyInsideTableDirective = true
+indexInsideTableDirective = false
+
+removeNotNullWithAutoIncrement = false
+
+suppressDefaults = true
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+drop table $table.Name;
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($fk in $table.ForeignKeys)
+ FOREIGN KEY ($fk.LocalColumnNames) REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($index in $table.Indices)
+CREATE #if($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.hasPrimaryKey())
+ PRIMARY KEY($table.printPrimaryKey()),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,20 @@
+
+-----------------------------------------------------------------------------
+-- $table.Name
+-----------------------------------------------------------------------------
+$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+##set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$pk,$fk,$unique,$index]))$strings.chop($cols,2)#else$cols#end
+#if($strings.allEmpty([$fk,$unique,$index]) && $pk.length()>0)$strings.chop($pk,2)#else$pk#end
+##if($strings.allEmpty([$unique,$index]) && $fk.length() >0)$strings.chop($fk,2)#else$fk#end
+#if($unique.length()>0)$strings.chop($unique,2)#else$unique#end
+
+);
+
+#if($index.length() > 0)$strings.chop($index,1)#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/tablefk.vm
===================================================================
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/msaccess/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,18 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #if ($type == "INT" || $type == "TEXT")
+ #set ( $size = "" )
+ #else
+ #set ( $size = $col.printSize() )
+ #end
+ #set ( $default = $col.DefaultSetting )
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),$dbprops.get("NULL")) )
+ #if ($col.isAutoIncrement() && $table.IdMethod == "native")
+ #set ( $autoIncrement = $dbprops.get("AUTOINCREMENT") )
+ #else
+ #set ( $autoIncrement = " " )
+ #end
+ #set ( $entry = "$col.Name $type $size $default $nullString $autoIncrement," )
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,35 @@
+BIT = BIT
+TINYINT = TINYINT
+SMALLINT = SMALLINT
+INTEGER = INT
+BIGINT = BIGINT
+FLOAT = FLOAT
+REAL = REAL
+DOUBLE = FLOAT
+NUMERIC = NUMERIC
+DECIMAL = DECIMAL
+CHAR = CHAR
+VARCHAR = VARCHAR
+LONGVARCHAR = TEXT
+DATE = DATETIME
+TIME = DATETIME
+TIMESTAMP = DATETIME
+BINARY = BINARY(7132)
+VARBINARY = IMAGE
+LONGVARBINARY = IMAGE
+NULL = NULL
+OTHER =
+JAVA_OBJECT =
+DISTINCT =
+STRUCT =
+ARRAY =
+BLOB =
+CLOB =
+REF =
+
+AUTOINCREMENT = IDENTITY (1,1)
+NOTNULL = NOT NULL
+
+removeNotNullWithAutoIncrement = false
+suppressDefaults = false
+maxColumnNameLength = 30
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,29 @@
+#foreach ($fk in $table.ForeignKeys)
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND name='$fk.Name')
+ ALTER TABLE $table.Name DROP CONSTRAINT $fk.Name;
+#end
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = '$table.Name')
+BEGIN
+ DECLARE @reftable_${velocityCount} nvarchar(60), @constraintname_${velocityCount} nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = '$table.Name'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_${velocityCount}, @constraintname_${velocityCount}
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '+ ＠ reftable_${velocityCount}+' drop constraint '+ ＠ constraintname_${velocityCount})
+ FETCH NEXT from refcursor into @reftable_${velocityCount}, @constraintname_${velocityCount}
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE $table.Name
+END
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,16 @@
+#foreach ($fk in $table.ForeignKeys)
+BEGIN
+ALTER TABLE $table.Name
+ ADD CONSTRAINT $fk.Name FOREIGN KEY ($fk.LocalColumnNames)
+ REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
+#if ($fk.hasOnUpdate())
+ ON UPDATE $fk.OnUpdate
+#end
+#if ($fk.hasOnDelete())
+ ON DELETE $fk.OnDelete
+#end
+END
+;
+
+#end
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($index in $table.Indices)
+CREATE #if($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.hasPrimaryKey())
+ CONSTRAINT ${table.Name}_PK PRIMARY KEY($table.printPrimaryKey()),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,20 @@
+
+/* ---------------------------------------------------------------------- */
+/* $table.Name */
+/* ---------------------------------------------------------------------- */
+
+$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$pk,$unique]))$strings.chop($cols,1)#else$cols#end
+#if($strings.allEmpty([$unique]) && $pk.length()>0)$strings.chop($pk,2)#else$pk#end
+#if($unique.length()>0)$strings.chop($unique,2)#end
+);
+
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($index.length() > 0)$index#end
+
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/tablefk.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/tablefk.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/tablefk.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,8 @@
+
+/* ---------------------------------------------------------------------- */
+/* $table.Name */
+/* ---------------------------------------------------------------------- */
+
+#set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#if($fk.length() >0)$fk#end
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mssql/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,17 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #if ( $type == 'MEDIUMTEXT' || $type == 'LONGTEXT' || $type == 'BLOB' || $type == 'MEDIUMBLOB' || $type == 'LONGBLOB' )
+ #set ( $size = '' )
+ #else
+ #set ( $size = $col.printSize() )
+ #end
+ #set ( $default = $col.DefaultSetting )
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"") )
+ #if ($col.isAutoIncrement() && $table.IdMethod == "native")
+ #set ( $autoIncrement = $dbprops.get("AUTOINCREMENT") )
+ #else
+ #set ( $autoIncrement = " " )
+ #end
+ #set ( $entry = "$col.Name $type $size $default $nullString $autoIncrement," )
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,47 @@
+# Taken from java.sql.Types in the IBM 1.3 JDK
+# JDBC to MySQL mappings.
+#
+# A good MySQL resource for determining these mappings is at
+# http://www.mysql.com/doc/C/o/Column_types.html
+
+BIT = BIT
+TINYINT = TINYINT
+SMALLINT = SMALLINT
+INTEGER = INTEGER
+BIGINT = BIGINT
+FLOAT = FLOAT
+REAL = REAL
+DOUBLE = DOUBLE
+NUMERIC = DECIMAL
+DECIMAL = DECIMAL
+CHAR = CHAR
+VARCHAR = VARCHAR
+LONGVARCHAR = MEDIUMTEXT
+DATE = DATETIME
+TIME = TIME
+TIMESTAMP = TIMESTAMP
+BINARY = BLOB
+VARBINARY = MEDIUMBLOB
+LONGVARBINARY = LONGBLOB
+NULL = NULL
+OTHER =
+JAVA_OBJECT =
+DISTINCT =
+STRUCT =
+ARRAY =
+BLOB = LONGBLOB
+CLOB = LONGTEXT
+REF =
+
+AUTOINCREMENT = AUTO_INCREMENT
+NOTNULL = NOT NULL
+
+removeNotNullWithAutoIncrement = false
+suppressDefaults = false
+maxColumnNameLength = 64
+
+
+# See mysql docs for valid table type names.
+# For example, if you wanted to use the transactional type InnoDB,
+# then specify "tableType = InnoDB"
+#tableType = MyISAM
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+drop table if exists $table.Name;
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,10 @@
+#foreach ($fk in $table.ForeignKeys)
+ FOREIGN KEY ($fk.LocalColumnNames) REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
+ #if ($fk.hasOnUpdate())
+ ON UPDATE $fk.OnUpdate
+ #end
+ #if ($fk.hasOnDelete())
+ ON DELETE $fk.OnDelete
+ #end
+,
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($index in $table.Indices)
+ INDEX $index.Name ($index.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.hasPrimaryKey())
+ PRIMARY KEY($table.printPrimaryKey()),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,19 @@
+
+# -----------------------------------------------------------------------
+# $table.Name
+# -----------------------------------------------------------------------
+$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+#set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$pk,$fk,$unique,$index]))$strings.chop($cols,2)#else$cols#end
+#if($strings.allEmpty([$fk,$unique,$index]) && $pk.length()>0)$strings.chop($pk,2)#else$pk#end
+#if($strings.allEmpty([$unique,$index]) && $fk.length() >0)$strings.chop($fk,2)#else$fk#end
+#if($strings.allEmpty([$index]) && $unique.length()>0)$strings.chop($unique,2)#else$unique#end
+#if($index.length() > 0)$strings.chop($index,2)#end
+
+)#if($dbprops.get("tableType")) Type=$dbprops.get("tableType")#end;
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/tablefk.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/tablefk.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/tablefk.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/mysql/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,8 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #set ( $size = $col.printSize() )
+ #set ( $default = $col.DefaultSetting )
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"") )
+ #set ( $entry = "$col.Name $type $size $default $nullString," )
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,49 @@
+# Taken from java.sql.Types in the IBM 1.3 JDK
+# JDBC to Oracle mappings.
+#
+# Good Oracle resources for determining these mappings include:
+# http://technet.oracle.com/doc/oracle8i_816/java.816/a81354/basic3.htm
+# http://technet.oracle.com/docs/tech/migration/workbench/doc_library/MSAccess/ch3.htm
+
+BIT = NUMBER (1, 0)
+TINYINT = NUMBER (3, 0)
+SMALLINT = NUMBER (5, 0)
+INTEGER = NUMBER
+BIGINT = NUMBER (20, 0)
+FLOAT = FLOAT
+REAL = NUMBER
+DOUBLE = FLOAT
+NUMERIC = NUMBER
+DECIMAL = NUMBER
+CHAR = CHAR
+VARCHAR = VARCHAR2
+LONGVARCHAR = VARCHAR2 (2000)
+DATE = DATE
+TIME = DATE
+TIMESTAMP = DATE
+BINARY = LONG RAW
+VARBINARY = BLOB
+LONGVARBINARY = LONG RAW
+NULL =
+OTHER =
+JAVA_OBJECT =
+DISTINCT =
+STRUCT =
+ARRAY =
+BLOB = BLOB
+CLOB = CLOB
+REF =
+
+NOTNULL = NOT NULL
+
+primaryKeyInsideTableDirective = true
+foreignKeyInsideTableDirective = true
+indexInsideTableDirective = false
+
+removeNotNullWithAutoIncrement = false
+
+suppressDefaults = false
+
+maxColumnNameLength = 30
+
+idMethod = sequence
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+DROP TABLE $table.Name CASCADE CONSTRAINTS;
+#if ($table.IdMethod == "native")
+DROP SEQUENCE $table.SequenceName;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,13 @@
+#foreach ($fk in $table.ForeignKeys)
+ALTER TABLE $table.Name
+ ADD CONSTRAINT $fk.Name FOREIGN KEY ($fk.LocalColumnNames)
+ REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
+#if ($fk.hasOnUpdate() && !$fk.OnUpdate.equalsIgnoreCase("cascade"))
+ON UPDATE $fk.OnUpdate
+#end
+#if ($fk.hasOnDelete())
+ON DELETE $fk.OnDelete
+#end
+;
+
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($index in $table.Indices)
+CREATE#if ($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,7 @@
+#set ($length = $table.Name.length())
+#if ($length > 27)#set ($length=27)#end
+#if ($table.hasPrimaryKey())
+ALTER TABLE $table.Name
+ ADD CONSTRAINT ${table.Name.substring(0,$length)}_PK
+PRIMARY KEY ($table.printPrimaryKey());
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/sequence.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/sequence.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/sequence.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.IdMethod == "native")
+CREATE SEQUENCE $table.SequenceName INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE ORDER;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,22 @@
+
+-----------------------------------------------------------------------------
+-- $table.Name
+-----------------------------------------------------------------------------
+$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$unique]))$strings.chop($cols,2)#else$cols#end
+#if($unique.length()>0)$strings.chop($unique,2)#end
+
+);
+
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+#if($pk.length()>0)$pk#end
+
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($index.length() > 0)$index#end
+
+#set ( $sequence = $generator.parse("$basepath/sequence.vm", "", "table", $tbl) )
+#if ($sequence.length()>0)$sequence#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/tablefk.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/tablefk.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/tablefk.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#if ($fk.length()>0)$fk#end
+
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/oracle/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ CONSTRAINT $unique.Name UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,47 @@
+#foreach ($col in $table.Columns)
+ #if ($col.TorqueType.indexOf("BOOLEAN") != -1)
+ #set ( $type = $dbprops.get($col.TorqueType) )
+ #else
+ #set ( $type = $dbprops.get($col.Type) )
+ #end
+ #if ($col.TorqueType.indexOf("INT") == -1)
+ #set ( $size = $col.printSize() )
+ #else
+ #set ( $size = "" )
+ #end
+ #if (($table.IdMethod == "native") && ($col.isPrimaryKey()))
+ #set ( $default = "DEFAULT nextval('$table.SequenceName')" )
+ #else
+ #set ( $default = $col.DefaultSetting )
+ #end
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"") )
+ #set ( $entry = "$col.Name $type $size $default $nullString" )
+ #if ($col.isAutoIncrement() && $table.IdMethod == "native")
+ #set ( $autoIncrement = $dbprops.get("AUTOINCREMENT") )
+ #else
+ #set ( $autoIncrement = " " )
+ #end
+ #set ( $entry = $strings.select($col.isAutoIncrement(), "$col.Name $autoIncrement", $entry) )
+##
+## the following works if you want to inline your foreign keys
+## if you turn it on, be sure to comment out foreignkey.vm
+#if (false)
+ #if ($col.isForeignKey())
+ #set ($fk = $col.ForeignKey)
+ #set ($entry = "$entry REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)")
+ #if ($fk.hasOnUpdate())
+ #set ($entry = "$entry ON UPDATE $fk.OnUpdate ")
+ #end
+ #if ($fk.hasOnDelete())
+ #set ($entry = "$entry ON DELETE $fk.OnDelete ")
+ #end
+ #end
+#end
+## add a nice comment
+#if ($col.isForeignKey())
+ #set ($fk = $col.ForeignKey)
+ -- REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
+#end
+#set ( $entry = $strings.collapseSpaces("$entry,") )
+ $strings.sub($entry," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,50 @@
+# Taken from java.sql.Types in the IBM 1.3 JDK
+# JDBC to PostgreSQL mappings.
+#
+# See http://www.postgresql.org/idocs/index.php?datatype.html for more
+# information on PostgreSQL data types.
+
+BIT = boolean
+TINYINT = int2
+SMALLINT = int2
+INTEGER = integer
+BIGINT = int8
+FLOAT = float
+REAL = float
+BOOLEANCHAR = char
+BOOLEANINT = int2
+
+DOUBLE = double precision
+# numeric(precision, scale) / decimal(precision, scale)
+NUMERIC = numeric
+DECIMAL = decimal
+CHAR = char
+VARCHAR = varchar
+LONGVARCHAR = bytea
+DATE = date
+TIME = time
+TIMESTAMP = timestamp
+BINARY = bytea
+VARBINARY = bytea
+LONGVARBINARY = bytea
+NULL =
+OTHER =
+JAVA_OBJECT =
+DISTINCT =
+STRUCT =
+ARRAY =
+BLOB =
+CLOB = text
+REF =
+
+AUTOINCREMENT = serial
+NOTNULL = NOT NULL
+
+primaryKeyInsideTableDirective = true
+indexInsideTableDirective = false
+
+removeNotNullWithAutoIncrement = true
+
+suppressDefaults = false
+idMethod=sequence
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+DROP TABLE $table.Name;
+#if ($table.IdMethod == "native")
+DROP SEQUENCE $table.SequenceName;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,18 @@
+##
+## The following will only work for non-circular references
+## if you have a dependancy chain, you will need to use
+## ADD CONSTRAINT syntax (with INITIALLY DEFERRED)
+## which is sticky and version dependant
+##
+#foreach ($fk in $table.ForeignKeys)
+ALTER TABLE $table.Name
+ ADD CONSTRAINT $fk.Name FOREIGN KEY ($fk.LocalColumnNames)
+ REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
+#if ($fk.hasOnUpdate())
+ ON UPDATE $fk.OnUpdate
+#end
+#if ($fk.hasOnDelete())
+ ON DELETE $fk.OnDelete
+#end
+;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($index in $table.Indices)
+CREATE#if($index.Unique) UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.hasPrimaryKey())
+ PRIMARY KEY ($table.printPrimaryKey()),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/sequence.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/sequence.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/sequence.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.IdMethod == "native")
+CREATE SEQUENCE $table.SequenceName;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,21 @@
+
+-----------------------------------------------------------------------------
+-- $table.Name
+-----------------------------------------------------------------------------
+$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+#set ( $sequence = $generator.parse("$basepath/sequence.vm", "", "table", $tbl) )
+#if ($sequence.length()>0)$sequence#end
+
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table",$tbl) )
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$pk,$unique]))$strings.chop($cols,2)#else$cols#end
+#if($strings.allEmpty([$unique]) && $pk.length()>0)$strings.chop($pk,2)#else$pk#end
+#if($unique.length() > 0)$strings.chop($unique,2)#end
+
+);
+#if($index.length() > 0)$strings.chop($index,1)#end
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/tablefk.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/tablefk.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/tablefk.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,7 @@
+
+----------------------------------------------------------------------
+-- $table.Name
+----------------------------------------------------------------------
+
+#set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#if($fk.length() >0)$fk#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/postgresql/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ CONSTRAINT $unique.Name UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,8 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #set ( $size = $col.printSize() )
+ #set ( $default = $col.DefaultSetting )
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"") )
+ #set ( $entry = "$col.Name $type $size $default $nullString," )
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,48 @@
+# Taken from java.sql.Types in the IBM 1.3 JDK
+# JDBC to SapDB mappings.
+
+BIT = FIXED(1,0)
+TINYINT = CHAR BYTE
+SMALLINT = SMALLINT
+INTEGER = INTEGER
+BIGINT = FIXED(38,0)
+FLOAT = FLOAT
+REAL = REAL
+DOUBLE = DOUBLE PRECISION
+NUMERIC = DECIMAL
+DECIMAL = DECIMAL
+CHAR = CHAR
+VARCHAR = VARCHAR
+LONGVARCHAR = LONG VARCHAR
+DATE = DATE
+TIME = TIME
+TIMESTAMP = TIMESTAMP
+BINARY = CHAR(254) BYTE
+VARBINARY = LONG BYTE
+LONGVARBINARY = LONG BYTE
+NULL = NULL
+OTHER =
+JAVA_OBJECT = LONG BYTE
+DISTINCT = DISTINCT
+STRUCT =
+ARRAY =
+BLOB = LONG BYTE
+CLOB = LONG UNICODE
+REF =
+BOOLEAN = BOOLEAN
+BOOLEANINT = SMALLINT
+BOOLEANCHAR = CHAR
+
+
+AUTOINCREMENT = DEFAULT SERIAL
+NOTNULL = NOT NULL
+
+primaryKeyInsideTableDirective = true
+foreignKeyInsideTableDirective = true
+indexInsideTableDirective = false
+
+removeNotNullWithAutoIncrement = false
+
+suppressDefaults = false
+
+idMethod=sequence
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+drop table $table.Name cascade ;
+#if ($table.IdMethod == "native")
+drop sequence $table.SequenceName;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,7 @@
+#foreach ($fk in $table.ForeignKeys)
+ALTER TABLE $table.Name
+ FOREIGN KEY $fk.Name ($fk.LocalColumnNames)
+ REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
+;
+
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($index in $table.Indices)
+CREATE #if($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#if ($table.hasPrimaryKey())
+ALTER TABLE $table.Name
+ ADD PRIMARY KEY ($table.printPrimaryKey()) ;
+#end
\ No newline at end of file
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/sequence.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/sequence.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/sequence.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.IdMethod == "native")
+CREATE SEQUENCE $table.SequenceName;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,22 @@
+
+-----------------------------------------------------------------------------
+-- $table.Name
+-----------------------------------------------------------------------------
+$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$unique]))$strings.chop($cols,2)#else$cols#end
+#if($unique.length()>0)$strings.chop($unique,2)#end
+
+);
+
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+#if($pk.length()>0)$pk#end
+
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($index.length() > 0)$index#end
+
+#set ( $sequence = $generator.parse("$basepath/sequence.vm", "", "table", $tbl) )
+#if ($sequence.length()>0)$sequence#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/tablefk.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/tablefk.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/tablefk.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#if ($fk.length()>0)$fk#end
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sapdb/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/columns.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/columns.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/columns.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,25 @@
+#foreach ($col in $table.Columns)
+ #set ( $type = $dbprops.get($col.Type) )
+ #if ($type == "INT" || $type == "TEXT")
+ #set ( $size = "" )
+ #else
+ #set ( $size = $col.printSize() )
+ #end
+ #if ( $dbprops.get("suppressDefaults") == "true" )
+ #set ( $default = "" )
+ #else
+ #set ( $default = $col.DefaultSetting )
+ #end
+ #if ( ($dbprops.get("removeNotNullWithAutoIncrement") == "true") && $col.isAutoIncrement() && $col.isNotNull() )
+ #set ( $nullString = "" )
+ #else
+ #set ( $nullString = $strings.select($col.isNotNull(), $dbprops.get("NOTNULL"),"NULL") )
+ #end
+ #if ($col.isAutoIncrement() && $table.IdMethod == "native")
+ #set ( $autoIncrement = $dbprops.get("AUTOINCREMENT") )
+ #else
+ #set ( $autoIncrement = " " )
+ #end
+ #set ( $entry = "$col.Name $type $size $default $nullString $autoIncrement," )
+ $strings.sub($strings.collapseSpaces($entry)," ,",",")
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/db.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/db.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/db.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,69 @@
+# Taken from java.sql.Types in the IBM 1.3 JDK
+# JDBC to Sybase mappings.
+
+BIT = BIT
+TINYINT = TINYINT
+SMALLINT = SMALLINT
+INTEGER = INT
+BIGINT = BIGINT
+FLOAT = FLOAT
+REAL = REAL
+DOUBLE = FLOAT
+NUMERIC = NUMERIC
+DECIMAL = DECIMAL
+CHAR = CHAR
+VARCHAR = VARCHAR
+LONGVARCHAR = TEXT
+DATE = DATETIME
+TIME = TIMESTAMP
+TIMESTAMP = DATETIME
+BINARY = BINARY
+VARBINARY = IMAGE
+LONGVARBINARY = IMAGE
+NULL = NULL
+OTHER =
+JAVA_OBJECT =
+DISTINCT =
+STRUCT =
+ARRAY =
+BLOB =
+CLOB =
+REF =
+
+#
+# This is the autoincrement value if using native methods for
+# incrementing keys. Most likely IDENTITIY wrt Sybase ASE.
+# Leaving the value blank should be used when Torque's IDBroker
+# is used to autoincrement keys.
+#
+# Default: [blank]
+#
+AUTOINCREMENT =
+
+#
+# If true, the NOT NULL values will not be printed in generated
+# SQL files if the column is set to autoincrement. Should be true
+# when the internal IDENTITY attribute ( above ) is used in a column
+# for autoincrementing keys.
+#
+# Default: false
+#
+removeNotNullWithAutoIncrement = false
+
+#
+# If true, defaults are not included in generated SQL.
+#
+# Default: false
+#
+suppressDefaults = false
+
+#
+# The string to place in the generated SQL for columns which cannot
+# be NULL.
+#
+# Default: NOT NULL
+#
+NOTNULL = NOT NULL
+
+maxColumnNameLength = 30
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/drop.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/drop.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/drop.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,9 @@
+#foreach ($fk in $table.ForeignKeys)
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND name='$fk.Name')
+ ALTER TABLE $table.Name DROP CONSTRAINT $fk.Name;
+#end
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = '$table.Name')
+BEGIN
+ DROP TABLE $table.Name
+END
+;
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/foreignkey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/foreignkey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/foreignkey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,9 @@
+#foreach ($fk in $table.ForeignKeys)
+BEGIN
+ALTER TABLE $table.Name
+ ADD CONSTRAINT $fk.Name FOREIGN KEY ($fk.LocalColumnNames)
+ REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
+END
+;
+
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/index.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/index.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/index.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($index in $table.Indices)
+CREATE #if($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name ($index.ColumnList);
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/primarykey.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/primarykey.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/primarykey.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#if ($table.hasPrimaryKey())
+ CONSTRAINT ${table.Name}_PK PRIMARY KEY($table.printPrimaryKey()),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/table.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/table.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/table.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,19 @@
+
+/* ---------------------------------------------------------------------- */
+/* $table.Name */
+/* ---------------------------------------------------------------------- */
+
+$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+CREATE TABLE $table.Name
+(
+#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
+#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
+#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
+#if($strings.allEmpty([$pk,$unique]))$strings.chop($cols,1)#else$cols#end
+#if($strings.allEmpty([$unique]) && $pk.length()>0)$strings.chop($pk,2)#else$pk#end
+#if($unique.length()>0)$strings.chop($unique,2)#end
+
+);
+
+#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
+#if($index.length() > 0)$index#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/tablefk.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/tablefk.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/tablefk.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,8 @@
+
+/* ---------------------------------------------------------------------- */
+/* $table.Name */
+/* ---------------------------------------------------------------------- */
+
+#set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
+#if($fk.length() >0)$fk#end
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/unique.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/unique.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/base/sybase/unique.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+#foreach ($unique in $table.Unices)
+ UNIQUE ($unique.ColumnList),
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/Control.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/Control.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/Control.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,2 @@
+#set ( $fname = "sql/db-init/$targetDatabase/createdb.vm" )
+$generator.parse($fname,"")
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/axion/createdb.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/axion/createdb.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/axion/createdb.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/db2400/createdb.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/db2400/createdb.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/db2400/createdb.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,8 @@
+## Not implemented for DB2/400... yet ;-)
+
+#*
+#foreach ($databaseName in $databaseNames)
+drop database if exists $databaseName;
+create database $databaseName;
+#end
+*#
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/hypersonic/createdb.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/hypersonic/createdb.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/hypersonic/createdb.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+ECHO Not implemented
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/mssql/createdb.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/mssql/createdb.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/mssql/createdb.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+ECHO Not implemented
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/mysql/createdb.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/mysql/createdb.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/mysql/createdb.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($databaseName in $databaseNames)
+drop database if exists $databaseName;
+create database $databaseName;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/oracle/createdb.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/oracle/createdb.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/oracle/createdb.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($databaseName in $databaseNames)
+-- drop database $databaseName;
+-- create database $databaseName;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/postgresql/createdb.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/postgresql/createdb.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/postgresql/createdb.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($databaseName in $databaseNames)
+drop database $databaseName;
+create database $databaseName;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/sapdb/createdb.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/sapdb/createdb.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/sapdb/createdb.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($databaseName in $databaseNames)
+-- drop database $databaseName;
+-- create database $databaseName;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/sybase/createdb.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/sybase/createdb.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/db-init/sybase/createdb.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,10 @@
+#foreach ($databaseName in $databaseNames)
+USE MASTER
+;
+
+DROP DATABASE $databaseName
+;
+
+CREATE DATABASE $databaseName
+;
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/Control.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/Control.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/Control.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,6 @@
+#set ( $fname = "sql/id-table/idtable.$targetDatabase" )
+#foreach ($dataModel in $dataModels)
+#set ( $outFile = "${dataModel.name}-idtable-init.sql" )
+$generator.parse($fname,"$outFile","tables",$dataModel.database.tables)
+#set ( $initialID = $initialID + 1000 )
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.axion
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.axion 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.axion 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($tbl in $tables)
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES ($initialID, '$tbl.Name', $initialIDValue, $initialIDStep);
+#set ( $initialID = $initialID + 1 )
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.cloudscape
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.cloudscape 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.cloudscape 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($tbl in $tables)
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES ($initialID, '$tbl.Name', $initialIDValue, $initialIDStep);
+#set ( $initialID = $initialID + 1 )
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.db2
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.db2 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.db2 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($tbl in $tables)
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES ($initialID, '$tbl.Name', $initialIDValue, $initialIDStep);
+#set ( $initialID = $initialID + 1 )
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.db2400
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.db2400 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.db2400 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,5 @@
+#foreach ($tbl in $tables)
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES ($initialID, '$tbl.Name', $initialIDValue, $initialIDStep);
+#set ( $initialID = $initialID + 1 )
+#end
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.hypersonic
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.hypersonic 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.hypersonic 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($tbl in $tables)
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES ($initialID, '$tbl.Name', $initialIDValue, $initialIDStep);
+#set ( $initialID = $initialID + 1 )
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.interbase
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.interbase 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.interbase 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($tbl in $tables)
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES ($initialID, '$tbl.Name', $initialIDValue, $initialIDStep);
+#set ( $initialID = $initialID + 1 )
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.mssql
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.mssql 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.mssql 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($tbl in $tables)
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES ($initialID, '$tbl.Name', $initialIDValue, $initialIDStep);
+#set ( $initialID = $initialID + 1 )
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.mysql
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.mysql 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.mysql 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($tbl in $tables)
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES ($initialID, '$tbl.Name', $initialIDValue, $initialIDStep);
+#set ( $initialID = $initialID + 1 )
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.oracle
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.oracle 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.oracle 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($tbl in $tables)
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES ($initialID, '$tbl.Name', $initialIDValue, $initialIDStep);
+#set ( $initialID = $initialID + 1 )
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.postgresql
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.postgresql 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.postgresql 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($tbl in $tables)
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES ($initialID, '$tbl.Name', $initialIDValue, $initialIDStep);
+#set ( $initialID = $initialID + 1 )
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.sapdb
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.sapdb 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.sapdb 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,5 @@
+#foreach ($tbl in $tables)
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES ($initialID, '$tbl.Name', $initialIDValue, $initialIDStep);
+#set ( $initialID = $initialID + 1 )
+#end
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.sybase
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.sybase 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/idtable.sybase 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+#foreach ($tbl in $tables)
+insert into ID_TABLE (ID_TABLE_ID, TABLE_NAME, NEXT_ID, QUANTITY) VALUES ($initialID, '$tbl.Name', $initialIDValue, $initialIDStep);
+#set ( $initialID = $initialID + 1 )
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/scheduler.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/scheduler.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/scheduler.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,12 @@
+# -------------------------------------------------------------------------
+# The values for the ID_TABLE_ID column in the ID_TABLE will have
+# reserved values from 1-100 for scheduler tables. The rest will
+# be for tables used for projects.
+# -------------------------------------------------------------------------
+initialID = 20
+
+#
+# Setting for initial Value and Step
+#
+initialIDValue = 1000
+initialIDStep = 10
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/turbine.props
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/turbine.props 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/id-table/turbine.props 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,12 @@
+# -------------------------------------------------------------------------
+# The values for the ID_TABLE_ID column in the ID_TABLE will have
+# reserved values from 1-100 for turbine tables. The rest will
+# be for tables used for projects.
+# -------------------------------------------------------------------------
+initialID = 1
+
+#
+# Setting for initial Value and Step
+#
+initialIDValue = 1000
+initialIDStep = 10
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/Control.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/Control.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/Control.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,5 @@
+#set ( $fname= "sql/load/${targetDatabase}/row.vm" )
+
+#foreach ($r in $data)
+$generator.parse($fname,"","row",$r)
+#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/axion/row.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/axion/row.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/axion/row.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+INSERT INTO $row.Table.Name (##
+#set ($comma="")#foreach($col in $row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
+ VALUES (#set ($comma="")#foreach($col in $row.ColumnValues)$comma${generator.parse("sql/load/hypersonic/val.vm", "", "column", $col)}#set ($comma=",")#end);
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/axion/val.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/axion/val.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/axion/val.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+#if($column.Column.needEscapedValue())$column.EscapedValue#else$column.Value#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2/row.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2/row.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2/row.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+INSERT INTO $row.Table.Name (##
+#set ($comma="")#foreach($col in $row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
+ VALUES (#set ($comma="")#foreach($col in $row.ColumnValues)$comma${generator.parse("sql/load/mysql/val.vm", "", "column", $col)}#set ($comma=",")#end);
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2/val.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2/val.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2/val.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+#if($column.Column.needEscapedValue())$column.EscapedValue#else$column.Value#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2400/row.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2400/row.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2400/row.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+INSERT INTO $row.Table.Name (##
+#set ($comma="")#foreach($col in $row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
+ VALUES (#set ($comma="")#foreach($col in $row.ColumnValues)$comma${generator.parse("sql/load/mysql/val.vm", "", "column", $col)}#set ($comma=",")#end);
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2400/val.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2400/val.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/db2400/val.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+#if($column.Column.needEscapedValue())$column.EscapedValue#else$column.Value#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/hypersonic/row.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/hypersonic/row.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/hypersonic/row.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+INSERT INTO $row.Table.Name (##
+#set ($comma="")#foreach($col in $row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
+ VALUES (#set ($comma="")#foreach($col in $row.ColumnValues)$comma${generator.parse("sql/load/hypersonic/val.vm", "", "column", $col)}#set ($comma=",")#end);
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/hypersonic/val.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/hypersonic/val.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/hypersonic/val.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+#if($column.Column.needEscapedValue())$column.EscapedValue#else$column.Value#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/msaccess/row.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/msaccess/row.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/msaccess/row.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+INSERT INTO $row.Table.Name (##
+#set ($comma="")#foreach($col in $row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
+ VALUES (#set ($comma="")#foreach($col in $row.ColumnValues)$comma${generator.parse("sql/load/msaccess/val.vm", "", "column", $col)}#set ($comma=",")#end);
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/msaccess/val.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/msaccess/val.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/msaccess/val.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+#if($column.Column.needEscapedValue())$column.EscapedValue#else$column.Value#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mssql/row.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mssql/row.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mssql/row.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+INSERT INTO $row.Table.Name (##
+#set ($comma="")#foreach($col in $row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
+ VALUES (#set ($comma="")#foreach($col in $row.ColumnValues)$comma${generator.parse("sql/load/mssql/val.vm", "", "column", $col)}#set ($comma=",")#end);
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mssql/val.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mssql/val.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mssql/val.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+#if($column.Column.needEscapedValue())$column.EscapedValue#else$column.Value#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mysql/row.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mysql/row.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mysql/row.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+INSERT INTO $row.Table.Name (##
+#set ($comma="")#foreach($col in $row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
+ VALUES (#set ($comma="")#foreach($col in $row.ColumnValues)$comma${generator.parse("sql/load/mysql/val.vm", "", "column", $col)}#set ($comma=",")#end);
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mysql/val.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mysql/val.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/mysql/val.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+#if($column.Column.needEscapedValue())$column.EscapedValue#else$column.Value#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/oracle/row.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/oracle/row.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/oracle/row.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+INSERT INTO $row.Table.Name (##
+#set ($comma="")#foreach($col in $row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
+ VALUES (#set ($comma="")#foreach($col in $row.ColumnValues)$comma${generator.parse("sql/load/oracle/val.vm", "", "column", $col)}#set ($comma=",")#end);
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/oracle/val.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/oracle/val.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/oracle/val.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+#if($column.Column.needEscapedValue())$column.EscapedValue#else$column.Value#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/postgresql/row.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/postgresql/row.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/postgresql/row.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,4 @@
+INSERT INTO $row.Table.Name (##
+#set ($comma="")#foreach($col in $row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
+ VALUES (#set ($comma="")#foreach($col in $row.ColumnValues)$comma${generator.parse("sql/load/postgresql/val.vm", "", "column", $col)}#set ($comma=",")#end);
+
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/postgresql/val.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/postgresql/val.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/postgresql/val.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+#if($column.Column.needEscapedValue())$column.EscapedValue#else$column.Value#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sapdb/row.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sapdb/row.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sapdb/row.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+INSERT INTO $row.Table.Name (##
+#set ($comma="")#foreach($col in $row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
+ VALUES (#set ($comma="")#foreach($col in $row.ColumnValues)$comma${generator.parse("sql/load/sapdb/val.vm", "", "column", $col)}#set ($comma=",")#end);
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sapdb/val.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sapdb/val.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sapdb/val.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+#if($column.Column.needEscapedValue())$column.EscapedValue#else$column.Value#end
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sybase/row.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sybase/row.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sybase/row.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1,3 @@
+INSERT INTO $row.Table.Name (##
+#set ($comma="")#foreach($col in $row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
+ VALUES (#set ($comma="")#foreach($col in $row.ColumnValues)$comma${generator.parse("sql/load/sybase/val.vm", "", "column", $col)}#set ($comma=",")#end);
Added: pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sybase/val.vm
===================================================================
--- pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sybase/val.vm 2007-07-10 12:57:38 UTC (rev 224)
+++ pompei/trunk/mydbflute/dbflute-0.5.2/templates/_unused/sql/load/sybase/val.vm 2007-07-10 13:01:46 UTC (rev 225)
@@ -0,0 +1 @@
+#if($column.Column.needEscapedValue())$column.EscapedValue#else$column.Value#end