Packages
cake
2.1.0
4.1.0
4.0.0
3.0.0
2.2.2
2.2.1
2.2.0
2.1.3
2.1.2
2.1.1
2.1.0
2.0.2
2.0.1
2.0.0
1.1.2
1.1.1
1.1.0
1.0.1
1.0.0
1.0.0-rc.0
retired
0.15.0
retired
0.14.0
retired
0.13.0
retired
0.12.0
retired
0.11.0
retired
0.10.1
retired
0.10.0
retired
0.9.2
retired
0.9.1
retired
0.9.0
retired
0.8.0
retired
0.7.0
retired
0.6.0
retired
0.5.0
retired
0.4.0
retired
0.3.0
retired
0.2.0
retired
0.1.0
retired
0.0.1
retired
🎂 An SQL query builder for Gleam for SQL dialects 🐘PostgreSQL, 🪶SQLite, 🦭MariaDB, and 🐬MySQL
Current section
Files
Jump to
Current section
Files
src/cake@update.erl
-module(cake@update).
-compile([no_auto_import, nowarn_unused_vars, nowarn_unused_function, nowarn_nomatch]).
-export([to_query/1, new/0, table/2, get_table/1, set_bool/2, set_true/1, set_false/1, set_float/2, set_int/2, set_string/2, set_null/1, set_expression/2, set_sub_query/2, sets_expression/2, sets_sub_query/2, get_set/1, set/2, set_replace/2, sets/2, sets_replace/2, from_table/2, from_sub_query/3, no_from/1, get_from/1, join/2, replace_join/2, joins/2, replace_joins/2, no_join/1, get_joins/1, where/2, or_where/2, xor_where/2, replace_where/2, no_where/1, get_where/1, returning/2, no_returning/1, epilog/2, no_epilog/1, get_epilog/1, comment/2, no_comment/1, get_comment/1]).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 63).
-spec to_query(cake@internal@write_query:update(SAY)) -> cake@internal@write_query:write_query(SAY).
to_query(Updt) ->
_pipe = Updt,
{update_query, _pipe}.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 71).
-spec new() -> cake@internal@write_query:update(any()).
new() ->
{update,
no_update_table,
no_update_modifier,
no_update_sets,
no_from,
no_joins,
no_where,
no_returning,
no_epilog,
no_comment}.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 89).
-spec table(cake@internal@write_query:update(SBD), binary()) -> cake@internal@write_query:update(SBD).
table(Updt, Tbl_nm) ->
erlang:setelement(
2,
Updt,
begin
_pipe = Tbl_nm,
{update_table, _pipe}
end
).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 95).
-spec get_table(cake@internal@write_query:update(any())) -> cake@internal@write_query:update_table().
get_table(Updt) ->
erlang:element(2, Updt).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 103).
-spec set_bool(binary(), boolean()) -> cake@internal@write_query:update_set().
set_bool(Col, V) ->
_pipe = V,
_pipe@1 = {bool_param, _pipe},
{update_param_set, Col, _pipe@1}.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 109).
-spec set_true(binary()) -> cake@internal@write_query:update_set().
set_true(Col) ->
_pipe = true,
_pipe@1 = {bool_param, _pipe},
{update_param_set, Col, _pipe@1}.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 115).
-spec set_false(binary()) -> cake@internal@write_query:update_set().
set_false(Col) ->
_pipe = false,
_pipe@1 = {bool_param, _pipe},
{update_param_set, Col, _pipe@1}.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 121).
-spec set_float(binary(), float()) -> cake@internal@write_query:update_set().
set_float(Col, V) ->
_pipe = V,
_pipe@1 = {float_param, _pipe},
{update_param_set, Col, _pipe@1}.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 127).
-spec set_int(binary(), integer()) -> cake@internal@write_query:update_set().
set_int(Col, V) ->
_pipe = V,
_pipe@1 = {int_param, _pipe},
{update_param_set, Col, _pipe@1}.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 133).
-spec set_string(binary(), binary()) -> cake@internal@write_query:update_set().
set_string(Col, V) ->
_pipe = V,
_pipe@1 = {string_param, _pipe},
{update_param_set, Col, _pipe@1}.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 139).
-spec set_null(binary()) -> cake@internal@write_query:update_set().
set_null(Col) ->
_pipe = null_param,
{update_param_set, Col, _pipe}.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 145).
-spec set_expression(binary(), binary()) -> cake@internal@write_query:update_set().
set_expression(Col, Exp) ->
_pipe = [Col],
{update_expression_set, _pipe, Exp}.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 151).
-spec set_sub_query(binary(), cake@internal@read_query:read_query()) -> cake@internal@write_query:update_set().
set_sub_query(Col, Qry) ->
_pipe = [Col],
{update_sub_query_set, _pipe, Qry}.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 159).
-spec sets_expression(list(binary()), binary()) -> cake@internal@write_query:update_set().
sets_expression(Cols, Exp) ->
_pipe = Cols,
{update_expression_set, _pipe, Exp}.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 170).
-spec sets_sub_query(list(binary()), cake@internal@read_query:read_query()) -> cake@internal@write_query:update_set().
sets_sub_query(Cols, Qry) ->
_pipe = Cols,
{update_sub_query_set, _pipe, Qry}.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 179).
-spec get_set(cake@internal@write_query:update(any())) -> list(cake@internal@write_query:update_set()).
get_set(Updt) ->
case erlang:element(4, Updt) of
no_update_sets ->
[];
{update_sets, Sets} ->
Sets
end.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 188).
-spec set(
cake@internal@write_query:update(SBN),
cake@internal@write_query:update_set()
) -> cake@internal@write_query:update(SBN).
set(Updt, St) ->
case erlang:element(4, Updt) of
no_update_sets ->
erlang:setelement(
4,
Updt,
begin
_pipe = [St],
{update_sets, _pipe}
end
);
{update_sets, Sets} ->
erlang:setelement(
4,
Updt,
begin
_pipe@1 = Sets,
_pipe@2 = lists:append(_pipe@1, [St]),
{update_sets, _pipe@2}
end
)
end.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 198).
-spec set_replace(
cake@internal@write_query:update(SBQ),
cake@internal@write_query:update_set()
) -> cake@internal@write_query:update(SBQ).
set_replace(Updt, St) ->
erlang:setelement(
4,
Updt,
begin
_pipe = [St],
{update_sets, _pipe}
end
).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 204).
-spec sets(
cake@internal@write_query:update(SBT),
list(cake@internal@write_query:update_set())
) -> cake@internal@write_query:update(SBT).
sets(Updt, Sts) ->
case erlang:element(4, Updt) of
no_update_sets ->
erlang:setelement(
4,
Updt,
begin
_pipe = Sts,
{update_sets, _pipe}
end
);
{update_sets, Sets} ->
erlang:setelement(
4,
Updt,
begin
_pipe@1 = Sets,
_pipe@2 = lists:append(_pipe@1, Sts),
{update_sets, _pipe@2}
end
)
end.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 214).
-spec sets_replace(
cake@internal@write_query:update(SBX),
list(cake@internal@write_query:update_set())
) -> cake@internal@write_query:update(SBX).
sets_replace(Updt, Sts) ->
erlang:setelement(
4,
Updt,
begin
_pipe = Sts,
{update_sets, _pipe}
end
).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 225).
-spec from_table(cake@internal@write_query:update(SCB), binary()) -> cake@internal@write_query:update(SCB).
from_table(Updt, Tbl_nm) ->
erlang:setelement(
5,
Updt,
begin
_pipe = Tbl_nm,
{from_table, _pipe}
end
).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 231).
-spec from_sub_query(
cake@internal@write_query:update(SCE),
cake@internal@read_query:read_query(),
binary()
) -> cake@internal@write_query:update(SCE).
from_sub_query(Updt, Qry, Als) ->
erlang:setelement(
5,
Updt,
begin
_pipe = Qry,
{from_sub_query, _pipe, Als}
end
).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 241).
-spec no_from(cake@internal@write_query:update(SCH)) -> cake@internal@write_query:update(SCH).
no_from(Updt) ->
erlang:setelement(5, Updt, no_from).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 247).
-spec get_from(cake@internal@write_query:update(any())) -> cake@internal@read_query:from().
get_from(Updt) ->
erlang:element(5, Updt).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 258).
-spec join(
cake@internal@write_query:update(SCM),
cake@internal@read_query:join()
) -> cake@internal@write_query:update(SCM).
join(Updt, Jn) ->
case erlang:element(6, Updt) of
{joins, Jns} ->
erlang:setelement(
6,
Updt,
begin
_pipe = Jns,
_pipe@1 = lists:append(_pipe, [Jn]),
{joins, _pipe@1}
end
);
no_joins ->
erlang:setelement(
6,
Updt,
begin
_pipe@2 = [Jn],
{joins, _pipe@2}
end
)
end.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 270).
-spec replace_join(
cake@internal@write_query:update(SCP),
cake@internal@read_query:join()
) -> cake@internal@write_query:update(SCP).
replace_join(Updt, Jn) ->
erlang:setelement(
6,
Updt,
begin
_pipe = [Jn],
{joins, _pipe}
end
).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 279).
-spec joins(
cake@internal@write_query:update(SCS),
list(cake@internal@read_query:join())
) -> cake@internal@write_query:update(SCS).
joins(Updt, Jns) ->
case {Jns, erlang:element(6, Updt)} of
{[], _} ->
erlang:setelement(
6,
Updt,
begin
_pipe = Jns,
{joins, _pipe}
end
);
{Jns@1, {joins, Updt_joins}} ->
erlang:setelement(
6,
Updt,
begin
_pipe@1 = Updt_joins,
_pipe@2 = lists:append(_pipe@1, Jns@1),
{joins, _pipe@2}
end
);
{Jns@2, no_joins} ->
erlang:setelement(
6,
Updt,
begin
_pipe@3 = Jns@2,
{joins, _pipe@3}
end
)
end.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 293).
-spec replace_joins(
cake@internal@write_query:update(SCW),
list(cake@internal@read_query:join())
) -> cake@internal@write_query:update(SCW).
replace_joins(Updt, Jns) ->
erlang:setelement(
6,
Updt,
begin
_pipe = Jns,
{joins, _pipe}
end
).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 299).
-spec no_join(cake@internal@write_query:update(SDA)) -> cake@internal@write_query:update(SDA).
no_join(Updt) ->
erlang:setelement(6, Updt, no_joins).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 305).
-spec get_joins(cake@internal@write_query:update(any())) -> cake@internal@read_query:joins().
get_joins(Updt) ->
erlang:element(6, Updt).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 320).
-spec where(
cake@internal@write_query:update(SDF),
cake@internal@read_query:where()
) -> cake@internal@write_query:update(SDF).
where(Updt, Whr) ->
case erlang:element(7, Updt) of
no_where ->
erlang:setelement(7, Updt, Whr);
{and_where, Wheres} ->
erlang:setelement(
7,
Updt,
begin
_pipe = Wheres,
_pipe@1 = lists:append(_pipe, [Whr]),
{and_where, _pipe@1}
end
);
_ ->
erlang:setelement(
7,
Updt,
begin
_pipe@2 = [erlang:element(7, Updt), Whr],
{and_where, _pipe@2}
end
)
end.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 338).
-spec or_where(
cake@internal@write_query:update(SDI),
cake@internal@read_query:where()
) -> cake@internal@write_query:update(SDI).
or_where(Updt, Whr) ->
case erlang:element(7, Updt) of
no_where ->
erlang:setelement(7, Updt, Whr);
{or_where, Wheres} ->
erlang:setelement(
7,
Updt,
begin
_pipe = Wheres,
_pipe@1 = lists:append(_pipe, [Whr]),
{or_where, _pipe@1}
end
);
_ ->
erlang:setelement(
7,
Updt,
begin
_pipe@2 = [erlang:element(7, Updt), Whr],
{or_where, _pipe@2}
end
)
end.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 361).
-spec xor_where(
cake@internal@write_query:update(SDL),
cake@internal@read_query:where()
) -> cake@internal@write_query:update(SDL).
xor_where(Updt, Whr) ->
case erlang:element(7, Updt) of
no_where ->
erlang:setelement(7, Updt, Whr);
{xor_where, Wheres} ->
erlang:setelement(
7,
Updt,
begin
_pipe = Wheres,
_pipe@1 = lists:append(_pipe, [Whr]),
{xor_where, _pipe@1}
end
);
_ ->
erlang:setelement(
7,
Updt,
begin
_pipe@2 = [erlang:element(7, Updt), Whr],
{xor_where, _pipe@2}
end
)
end.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 372).
-spec replace_where(
cake@internal@write_query:update(SDO),
cake@internal@read_query:where()
) -> cake@internal@write_query:update(SDO).
replace_where(Updt, Whr) ->
erlang:setelement(7, Updt, Whr).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 378).
-spec no_where(cake@internal@write_query:update(SDR)) -> cake@internal@write_query:update(SDR).
no_where(Updt) ->
erlang:setelement(7, Updt, no_where).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 384).
-spec get_where(cake@internal@write_query:update(any())) -> cake@internal@read_query:where().
get_where(Updt) ->
erlang:element(7, Updt).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 393).
-spec returning(cake@internal@write_query:update(SDW), list(binary())) -> cake@internal@write_query:update(SDW).
returning(Updt, Rtrn) ->
case Rtrn of
[] ->
erlang:setelement(8, Updt, no_returning);
_ ->
erlang:setelement(
8,
Updt,
begin
_pipe = Rtrn,
{returning, _pipe}
end
)
end.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 406).
-spec no_returning(cake@internal@write_query:update(SEA)) -> cake@internal@write_query:update(SEA).
no_returning(Updt) ->
erlang:setelement(8, Updt, no_returning).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 414).
-spec epilog(cake@internal@write_query:update(SED), binary()) -> cake@internal@write_query:update(SED).
epilog(Updt, Eplg) ->
Eplg@1 = begin
_pipe = Eplg,
gleam@string:trim(_pipe)
end,
case Eplg@1 of
<<""/utf8>> ->
erlang:setelement(9, Updt, no_epilog);
_ ->
erlang:setelement(
9,
Updt,
begin
_pipe@1 = (<<" "/utf8, Eplg@1/binary>>),
{epilog, _pipe@1}
end
)
end.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 424).
-spec no_epilog(cake@internal@write_query:update(SEG)) -> cake@internal@write_query:update(SEG).
no_epilog(Updt) ->
erlang:setelement(9, Updt, no_epilog).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 430).
-spec get_epilog(cake@internal@write_query:update(any())) -> cake@internal@read_query:epilog().
get_epilog(Updt) ->
erlang:element(9, Updt).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 438).
-spec comment(cake@internal@write_query:update(SEL), binary()) -> cake@internal@write_query:update(SEL).
comment(Updt, Cmmnt) ->
Cmmnt@1 = begin
_pipe = Cmmnt,
gleam@string:trim(_pipe)
end,
case Cmmnt@1 of
<<""/utf8>> ->
erlang:setelement(10, Updt, no_comment);
_ ->
erlang:setelement(
10,
Updt,
begin
_pipe@1 = (<<" "/utf8, Cmmnt@1/binary>>),
{comment, _pipe@1}
end
)
end.
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 448).
-spec no_comment(cake@internal@write_query:update(SEO)) -> cake@internal@write_query:update(SEO).
no_comment(Updt) ->
erlang:setelement(10, Updt, no_comment).
-file("/Users/leo/local-dev/gleam/gleam-cake/src/cake/update.gleam", 454).
-spec get_comment(cake@internal@write_query:update(any())) -> cake@internal@read_query:comment().
get_comment(Updt) ->
erlang:element(10, Updt).