funsies

// DO NOT EDIT: Code generated by matcha from by_id.matcha

import gleam/list
import gleam/string_builder.{type StringBuilder}

import db/schema.{type Column, type Table}
import gleam/string

fn columns(table: Table) -> StringBuilder {
  let builder = string_builder.from_string("")
  let builder =
    list.fold(table.columns, builder, fn(builder, col: Column) {
      let builder =
        string_builder.append(
          builder,
          string.replace(string.capitalise(col.name), "_", ""),
        )

      builder
    })

  builder
}

fn columns2(table: Table) -> StringBuilder {
  let builder = string_builder.from_string("")
  let builder =
    list.fold(table.columns, builder, fn(builder, col: Column) {
      let builder =
        string_builder.append(builder, string.replace(col.name, "_", ""))

      builder
    })

  builder
}

pub fn render_builder(table table: Table) -> StringBuilder {
  let builder = string_builder.from_string("")
  let builder =
    string_builder.append(
      builder,
      "

",
    )
  let builder =
    string_builder.append(
      builder,
      "
",
    )
  let builder =
    string_builder.append(
      builder,
      "


",
    )
  let builder =
    string_builder.append(
      builder,
      "
import funs/",
    )
  let builder = string_builder.append(builder, table.name)
  let builder =
    string_builder.append(
      builder,
      "_decoder
import funs/",
    )
  let builder = string_builder.append(builder, table.name)
  let builder =
    string_builder.append(
      builder,
      "
import gleam/pgo 

pub fn by_id(db: pgo.Connection, id: Int) -> Result(",
    )
  let builder = string_builder.append(builder, table.name)
  let builder = string_builder.append(builder, ".")
  let builder = string_builder.append(builder, string.capitalise(table.name))
  let builder =
    string_builder.append(
      builder,
      "Row, pgo.QueryError) {
  let query = \"SELECT * FROM ",
    )
  let builder = string_builder.append(builder, table.name)
  let builder =
    string_builder.append(
      builder,
      " WHERE id = $1\"
  pgo.execute(db, [pgo.int(id)], ",
    )
  let builder = string_builder.append(builder, table.name)
  let builder = string_builder.append(builder, ".")
  let builder = string_builder.append(builder, table.name)
  let builder =
    string_builder.append(
      builder,
      "_decoder_)
}
",
    )

  builder
}

pub fn render(table table: Table) -> String {
  string_builder.to_string(render_builder(table: table))
}