cake

2.0.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
HexDocs
Current section
Files
Jump to
Readme 38 Versions 1 Dependency Dependants Files Activity
cake src cake@update.erl
Raw
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]).

-spec to_query(cake@internal@write_query:update(RLS)) -> cake@internal@write_query:write_query(RLS).
to_query(Updt) ->
    _pipe = Updt,
    {update_query, _pipe}.

-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}.

-spec table(cake@internal@write_query:update(RLX), binary()) -> cake@internal@write_query:update(RLX).
table(Updt, Tbl_nm) ->
    erlang:setelement(
        2,
        Updt,
        begin
            _pipe = Tbl_nm,
            {update_table, _pipe}
        end
    ).

-spec get_table(cake@internal@write_query:update(any())) -> cake@internal@write_query:update_table().
get_table(Updt) ->
    erlang:element(2, Updt).

-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}.

-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}.

-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}.

-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}.

-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}.

-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}.

-spec set_null(binary()) -> cake@internal@write_query:update_set().
set_null(Col) ->
    _pipe = null_param,
    {update_param_set, Col, _pipe}.

-spec set_expression(binary(), binary()) -> cake@internal@write_query:update_set().
set_expression(Col, Exp) ->
    _pipe = [Col],
    {update_expression_set, _pipe, Exp}.

-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}.

-spec sets_expression(list(binary()), binary()) -> cake@internal@write_query:update_set().
sets_expression(Cols, Exp) ->
    _pipe = Cols,
    {update_expression_set, _pipe, Exp}.

-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}.

-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.

-spec set(
    cake@internal@write_query:update(RMH),
    cake@internal@write_query:update_set()
) -> cake@internal@write_query:update(RMH).
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.

-spec set_replace(
    cake@internal@write_query:update(RMK),
    cake@internal@write_query:update_set()
) -> cake@internal@write_query:update(RMK).
set_replace(Updt, St) ->
    erlang:setelement(
        4,
        Updt,
        begin
            _pipe = [St],
            {update_sets, _pipe}
        end
    ).

-spec sets(
    cake@internal@write_query:update(RMN),
    list(cake@internal@write_query:update_set())
) -> cake@internal@write_query:update(RMN).
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.

-spec sets_replace(
    cake@internal@write_query:update(RMR),
    list(cake@internal@write_query:update_set())
) -> cake@internal@write_query:update(RMR).
sets_replace(Updt, Sts) ->
    erlang:setelement(
        4,
        Updt,
        begin
            _pipe = Sts,
            {update_sets, _pipe}
        end
    ).

-spec from_table(cake@internal@write_query:update(RMV), binary()) -> cake@internal@write_query:update(RMV).
from_table(Updt, Tbl_nm) ->
    erlang:setelement(
        5,
        Updt,
        begin
            _pipe = Tbl_nm,
            {from_table, _pipe}
        end
    ).

-spec from_sub_query(
    cake@internal@write_query:update(RMY),
    cake@internal@read_query:read_query(),
    binary()
) -> cake@internal@write_query:update(RMY).
from_sub_query(Updt, Qry, Als) ->
    erlang:setelement(
        5,
        Updt,
        begin
            _pipe = Qry,
            {from_sub_query, _pipe, Als}
        end
    ).

-spec no_from(cake@internal@write_query:update(RNB)) -> cake@internal@write_query:update(RNB).
no_from(Updt) ->
    erlang:setelement(5, Updt, no_from).

-spec get_from(cake@internal@write_query:update(any())) -> cake@internal@read_query:from().
get_from(Updt) ->
    erlang:element(5, Updt).

-spec join(
    cake@internal@write_query:update(RNG),
    cake@internal@read_query:join()
) -> cake@internal@write_query:update(RNG).
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.

-spec replace_join(
    cake@internal@write_query:update(RNJ),
    cake@internal@read_query:join()
) -> cake@internal@write_query:update(RNJ).
replace_join(Updt, Jn) ->
    erlang:setelement(
        6,
        Updt,
        begin
            _pipe = [Jn],
            {joins, _pipe}
        end
    ).

-spec joins(
    cake@internal@write_query:update(RNM),
    list(cake@internal@read_query:join())
) -> cake@internal@write_query:update(RNM).
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.

-spec replace_joins(
    cake@internal@write_query:update(RNQ),
    list(cake@internal@read_query:join())
) -> cake@internal@write_query:update(RNQ).
replace_joins(Updt, Jns) ->
    erlang:setelement(
        6,
        Updt,
        begin
            _pipe = Jns,
            {joins, _pipe}
        end
    ).

-spec no_join(cake@internal@write_query:update(RNU)) -> cake@internal@write_query:update(RNU).
no_join(Updt) ->
    erlang:setelement(6, Updt, no_joins).

-spec get_joins(cake@internal@write_query:update(any())) -> cake@internal@read_query:joins().
get_joins(Updt) ->
    erlang:element(6, Updt).

-spec where(
    cake@internal@write_query:update(RNZ),
    cake@internal@read_query:where()
) -> cake@internal@write_query:update(RNZ).
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.

-spec or_where(
    cake@internal@write_query:update(ROC),
    cake@internal@read_query:where()
) -> cake@internal@write_query:update(ROC).
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.

-spec xor_where(
    cake@internal@write_query:update(ROF),
    cake@internal@read_query:where()
) -> cake@internal@write_query:update(ROF).
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.

-spec replace_where(
    cake@internal@write_query:update(ROI),
    cake@internal@read_query:where()
) -> cake@internal@write_query:update(ROI).
replace_where(Updt, Whr) ->
    erlang:setelement(7, Updt, Whr).

-spec no_where(cake@internal@write_query:update(ROL)) -> cake@internal@write_query:update(ROL).
no_where(Updt) ->
    erlang:setelement(7, Updt, no_where).

-spec get_where(cake@internal@write_query:update(any())) -> cake@internal@read_query:where().
get_where(Updt) ->
    erlang:element(7, Updt).

-spec returning(cake@internal@write_query:update(ROQ), list(binary())) -> cake@internal@write_query:update(ROQ).
returning(Updt, Rtrn) ->
    case Rtrn of
        [] ->
            erlang:setelement(8, Updt, no_returning);

        _ ->
            erlang:setelement(
                8,
                Updt,
                begin
                    _pipe = Rtrn,
                    {returning, _pipe}
                end
            )
    end.

-spec no_returning(cake@internal@write_query:update(ROU)) -> cake@internal@write_query:update(ROU).
no_returning(Updt) ->
    erlang:setelement(8, Updt, no_returning).

-spec epilog(cake@internal@write_query:update(ROX), binary()) -> cake@internal@write_query:update(ROX).
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.

-spec no_epilog(cake@internal@write_query:update(RPA)) -> cake@internal@write_query:update(RPA).
no_epilog(Updt) ->
    erlang:setelement(9, Updt, no_epilog).

-spec get_epilog(cake@internal@write_query:update(any())) -> cake@internal@read_query:epilog().
get_epilog(Updt) ->
    erlang:element(9, Updt).

-spec comment(cake@internal@write_query:update(RPF), binary()) -> cake@internal@write_query:update(RPF).
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.

-spec no_comment(cake@internal@write_query:update(RPI)) -> cake@internal@write_query:update(RPI).
no_comment(Updt) ->
    erlang:setelement(10, Updt, no_comment).

-spec get_comment(cake@internal@write_query:update(any())) -> cake@internal@read_query:comment().
get_comment(Updt) ->
    erlang:element(10, Updt).
Operator	Description	Example
name:	Match package name. Supports * wildcards and repo/package form	name:phx* or name:hexpm/phoenix
description:	Full-text search of package descriptions	description:auth
depends:	Packages depending on a given package. Supports repo:package form	depends:ecto or depends:hexpm:ecto
build_tool:	Filter by build tool	build_tool:mix
updated_after:	Packages updated after an ISO8601 datetime	updated_after:2025-01-01T00:00:00Z
extra:	Match custom metadata (key,value). Nested keys are separated by commas	extra:license,MIT