scray.jdbc.extractors.ScrayMSSQLDialect.scala Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of scray-jdbc Show documentation

scray adapter to r/w JDBC tables

The newest version!

package scray.jdbc.extractors

import scray.querying.description.internal.Domain
import scray.querying.description.TableIdentifier
import scray.querying.description.QueryRange

/**
 * MSSQL dialect for Scray
 */
object ScrayMSSQLDialect extends ScraySQLDialect("MSSQL") {
  
  /**
   * MSSQL implements limits by offset and fetch
   * Warning: can only be applied if there will be an order by clause
   */
  override def getEnforcedLimit(rangeOpt: Option[QueryRange], where: List[Domain[_]]): (String, List[Domain[_]]) = rangeOpt.map { range =>
    val sbuf = new StringBuffer
    if(range.skip.isDefined || range.limit.isDefined) {
      sbuf.append(s" OFFSET ${range.skip.getOrElse(0L)} ROWS ")
      range.limit.foreach { limit =>
        sbuf.append(s" FETCH NEXT ${limit} ROWS ONLY ")
      }
    }
    (sbuf.toString, List())
  }.getOrElse(("", List()))

  /**
   * we scan if the URL is of format:
   * jdbc:sqlserver://...
   * 
   * correct format according to Microsoft is:
   * jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks;user=MyUserName;password=*****;
   */
  override def isDialectJdbcURL(jdbcURL: String): Boolean =
    jdbcURL.toUpperCase().startsWith("JDBC:SQLSERVER://")
  
  override val DRIVER_CLASS_NAME = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
}