is anyone using SQLDelight server side to connect ...

# server

[Fred Bowker]

is anyone using SQLDelight server side to connect to postgresql that has a working gradle file

[simon.vergauwen]

It should be the same for server-side than it’s for any other Gradle project. This is working for me.

plugins {
  kotlin("jvm") version "1.6.10"
  id("com.squareup.sqldelight") version "1.5.3"
}

sqldelight {
  database("Database") {
    packageName = "io.github.nomisrev"
    dialect = "postgresql"
  }
}

[simon.vergauwen]

This is how I am connecting

fun Datasource() = HikariConfig().apply {
  jdbcUrl = "jdbc:<postgresql://localhost:5432/databaseName>"
  username = "admin"
  password = "admin"
  driverClassName = "org.postgresql.Driver"
}.let(::HikariDataSource)

val driver: SqlDriver = dataSource.asJdbcDriver()
Database.Schema.migrate(driver, 1, 1)
return driver

[simon.vergauwen]

With these additional dependencies:

implementation("com.zaxxer:HikariCP:5.0.1")
implementation("com.squareup.sqldelight:jdbc-driver:1.5.3")
implementation("org.postgresql:postgresql:42.2.20")

[Fred Bowker]

the gradle plugin looks to be generating some code from the migrations i have in the sqm file

[Fred Bowker]

though with the generated code I now get

[Fred Bowker]

import com.concida.dal.newInstance
import com.concida.dal.schema
import com.squareup.sqldelight.Transacter
import com.squareup.sqldelight.db.SqlDriver

public interface Database : Transacter {
  public companion object {
    public val Schema: SqlDriver.Schema
      get() = Database::class.schema

    public operator fun invoke(driver: SqlDriver): Database = Database::class.newInstance(driver)
  }
}

[Fred Bowker]

it can’t find

import com.concida.dal.newInstance
import com.concida.dal.schema

any idea what I put here or if these should be auto generated

[Fred Bowker]

cheers for your help

[simon.vergauwen]

The newInstance and schema code is generated in this file for me.

[simon.vergauwen]

Screenshot 2022-01-27 at 17.26.48.png

[Fred Bowker]

Ok I think the issue is my fault I simply had create table sqm file

[Fred Bowker]

I’ll need a schema and database file

[Fred Bowker]

no I don’t think that’s the issue

[Fred Bowker]

I tried generating with out table migration but now get /Users/bowker/Src/LocoVoco/LocoVoco/dal/src/main/sqldelight/Cafe.sq line 1:0 - SqlDelight files must be placed in a package directory.

[Fred Bowker]

which doesn’t look rite as packages would need to be under LocoVoco/dal/src/main/kotlin but the docs spedify src/main/sqldelight

[hfhbd]

Maybe this helps you: https://github.com/hfhbd/ComposeTodo/tree/main/clients/src/commonMain
Edit, oh I thought I use migrations :D

[Fred Bowker]

I take it my issue isn’t

[Fred Bowker]

fun Datasource() = HikariConfig().apply {
  jdbcUrl = "jdbc:<postgresql://localhost:5432/databaseName>"
  username = "admin"
  password = "admin"
  driverClassName = "org.postgresql.Driver"
}.let(::HikariDataSource)

val driver: SqlDriver = dataSource.asJdbcDriver()
Database.Schema.migrate(driver, 1, 1)
return drive

that I don’t have this when I run gradle

[Fred Bowker]

I thought that is only for connecting at runtime or am i missing something

[Fred Bowker]

yeah I’m trying with migrations but if I could get to work anyway that would be a start

[Fred Bowker]

cheers I look at that github link

[hfhbd]

BTW I added the derive schema from migration option: https://github.com/hfhbd/ComposeTodo/pull/456

[Fred Bowker]

I’ve tried both, weirdly with non schema migration I get /Users/bowker/Src/LocoVoco/LocoVoco/dal/src/main/sqldelight/schema.sq line 1:0 - SqlDelight files must be placed in a package directory

[Fred Bowker]

but my packages are under main/kotlin so doesn’t really make much sense

[hfhbd]

You should use the same package name used for kotlin files for SqlDelight files too.

[Fred Bowker]

yup it’s generating under the correct package name

[Fred Bowker]

just doesn’t greate me a schema or newInstance

[Fred Bowker]

seems a stupid question but I don’t need to create a datasource such as

[Fred Bowker]

fun Datasource() = HikariConfig().apply {
  jdbcUrl = "jdbc:<postgresql://localhost:5432/databaseName>"
  username = "admin"
  password = "admin"
  driverClassName = "org.postgresql.Driver"
}.let(::HikariDataSource)

[Fred Bowker]

for this to work I thought that was just for connecting at runtime

[hfhbd]

Nope, for generating code, you dont need Hikari.
You must move your .sq to src/main/com/example/something/foo.sq

[Fred Bowker]

ok cool got it working my problem was the path ive got it working at https://github.com/hfhbd/ComposeTodo/tree/main/clients/src/commonMain

[Fred Bowker]

basically I hadn’t got the directory structure correct