1 #set ($myClassName = "${glSqlClauseInterfaceName}${database.DaoGenDbName}")
\r
5 namespace ${glPackageBaseCommonSqlClause} {
\r
7 [System.Serializable]
\r
8 public class ${myClassName} : ${glSqlClauseAbstractName} {
\r
10 protected String _fetchScopeSqlSuffix = "";
\r
11 protected String _lockSqlSuffix = "";
\r
13 public ${myClassName}(String tableName)
\r
14 : base(tableName) {}
\r
16 protected override OrderByNullsSetupper createOrderByNullsSetupper() {
\r
17 return new OrderByNullsSetupperByCaseWhen();
\r
20 protected override void doFetchFirst() {
\r
24 protected override void doFetchPage() {
\r
25 _fetchScopeSqlSuffix = " limit " + this.getPageStartIndex() + ", " + this.getFetchSize();
\r
28 protected override void doClearFetchPageClause() {
\r
29 _fetchScopeSqlSuffix = "";
\r
32 public override ${glSqlClauseInterfaceName} lockForUpdate() {
\r
33 _lockSqlSuffix = " for update";
\r
37 protected override String createSelectHint() {
\r
41 protected override String createFromBaseTableHint() {
\r
45 protected override String createFromHint() {
\r
49 protected override String createSqlSuffix() {
\r
50 return _fetchScopeSqlSuffix + _lockSqlSuffix;
\r
54 // ===================================================================================
\r
55 // Query Update Override
\r
56 // =====================
\r
57 protected override bool isUpdateSubQueryUseLocalTableSupported() {
\r