{"repo":"takezoe/tranquil","free":true,"listed":false,"github":"https://github.com/takezoe/tranquil","clone":"git clone https://github.com/takezoe/tranquil.git","description":"Type-safe SQL builder for Scala","language":"Scala","stars":31,"topics":["scala","database","sql","jdbc"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Tranquil Tranquil an experiment of type-safe SQL builder for Scala. Usage First, ready table definitions like following: Then you can assemble SQL using type-safe DSL. Generated SQL is: Grouping and aggregation are possible as follows: Also you can assemble insert, update and delete SQL in the same way. Code generator Tranquil has a code generator to generate case classes and table definitions like explained above from database schema. You can run the code generator as follows: Source files would be generated into /src/main/scala/models/Tables.scala in default. In addition, you can configure the code generator via Settings which is passed to CodeGenerator . Settings has following properties: property type description ------------------- ----------------- ------------------------------------------------ driver String JDBC driver classname (required) url String JDBC connection url (required) username String JDBC connection username (required) password String JDBC connection password (required) catalog String catalog (default is \"%\") schemaPattern String schema pattern (default is \"%\") tablePattern String table pattern (default is \"%\") includeTablePattern String regular expression which matches included tables (default is \"\") excludeTablePattern String regular expression which matches excluded tables (default is \"\") packageName String package name of generated source (default is \"models\") targetDir File output directory of generated source (default is new File(\"src/main/scala\"))","default_branch":null,"files":null,"tree":[],"storefront":"/r/takezoe","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/takezoe/tranquil/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}