magic-api/src/main/java/org/ssssssss/magicapi/dialect/DmDialect.java

package org.ssssssss.magicapi.dialect;

import org.ssssssss.magicapi.modules.BoundSql;

/**
 * @description: 达梦数据库方言
 * @author: qijiantuoluowang
 * @create: 2020-12-09 19:33
 **/
public class DmDialect implements Dialect {

	@Override
	public boolean match(String jdbcUrl) {
		return jdbcUrl.contains(":dm:");
	}

	@Override
	public String getPageSql(String sql, BoundSql boundSql, long offset, long limit) {
		limit = (offset >= 1) ? (offset + limit) : limit;
		boundSql.addParameter(limit);
		boundSql.addParameter(offset);
		return "SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( " +
				sql + " ) TMP WHERE ROWNUM <= ? ) WHERE ROW_ID > ?";
	}
}