Scala port of great SQL formatter https://github.com/zeroturnaround/sql-formatter, https://github.com/vertical-blank/sql-formatter.
Written with only Scala Standard Library, without dependencies.
libraryDependencies += "com.github.takayahilton" %% "sql-formatter" % "1.2.1"libraryDependencies += "com.github.takayahilton" %%% "sql-formatter" % "1.2.1"libraryDependencies += "com.github.takayahilton" %%% "sql-formatter" % "1.2.1"You can easily use com.github.takayahilton.sqlformatter.SqlFormatter :
import com.github.takayahilton.sqlformatter._ SqlFormatter.format("SELECT * FROM table1")This will output:
SELECT * FROM table1You can pass dialect name to SqlFormatter.of :
import com.github.takayahilton.sqlformatter._ SqlFormatter.of(SqlDialect.CouchbaseN1QL).format("SELECT *")Currently just four SQL dialects are supported:
- StandardSQL - Standard SQL
- CouchbaseN1QL - Couchbase N1QL
- DB2 - IBM DB2
- PLSQL - Oracle PL/SQL
Defaults to two spaces. You can pass indent string to format :
import com.github.takayahilton.sqlformatter._ SqlFormatter.format( "SELECT * FROM table1", indent = " ")This will output:
SELECT * FROM table1You can pass Seq or Map to format :
import com.github.takayahilton.sqlformatter._ // Named placeholders SqlFormatter.format("SELECT * FROM tbl WHERE foo = @foo", params = Map("foo" -> "'bar'")) // Indexed placeholders SqlFormatter.format("SELECT * FROM tbl WHERE foo = ?", params = Seq("'bar'"))Both result in:
SELECT * FROM tbl WHERE foo = 'bar'