yas-snippets for hugsql

hugsql-create-table

# -*- mode: snippet -*-
# name: hugsql-create-table
# key: create-table
# --
-- :name create-$1-table
-- :command :execute
-- :return :raw
create table if not exists $1 (
  $2
);

hugsql-insert

# -*- mode: snippet -*-
# name: hugsql-insert
# key: insert
# --
-- :name $1
-- :command ${2:$$(yas-choose-value '(":insert" ":returning-execute"))}
-- :result ${3:$$(yas-choose-value '(":one" ":many" ":affected" ":raw"))}
insert into $4 ($5)
values (${5:$(mapconcat (function
                         (lambda (x)
                           (concat ":" x)))
                        (split-string yas-text ", ")
                        ", ")});

hugsql-query

# -*- mode: snippet -*-
# name: hugsql-query
# key: query
# --
-- :name $1
-- :command :query
-- :result ${2:$$(yas-choose-value '(":many" ":one"))}
select *
  from $3;