Packages
starmap

0.1.0
Type-Safe, ORM-like SQL Library for gleam
HexDocs
Current section
Files
Jump to
Readme 1 Version 2 Dependencies Dependants Files Activity
starmap src starmap@sqlight@execute.erl
Raw
src/starmap@sqlight@execute.erl

-module(starmap@sqlight@execute).
-compile([no_auto_import, nowarn_unused_vars, nowarn_unused_function, nowarn_nomatch]).

-export([query1/2, query2/2, query3/2, query4/2, query5/2, query6/2, create_table1/2, create_table2/2, create_table3/2, create_table4/2, create_table5/2, create_table6/2, create_table7/2, create_table8/2, create_table9/2, insertion1/2, insertion2/2, insertion3/2, insertion4/2, insertion5/2, insertion6/2]).

-spec query1(
    starmap@query:'query'(starmap@schema:column(IWE, sqlight:value()), any()),
    sqlight:connection()
) -> {ok, list(IWE)} | {error, sqlight:error()}.
query1(Query, Conn) ->
    _pipe = Query,
    _pipe@1 = starmap@sqlight@convert:query1(_pipe),
    sqlight:'query'(
        _pipe@1,
        Conn,
        [],
        gleam@dynamic:element(
            0,
            erlang:element(
                3,
                erlang:element(4, erlang:element(4, erlang:element(3, Query)))
            )
        )
    ).

-spec get_parameters(starmap@query:'query'(any(), sqlight:value())) -> list(sqlight:value()).
get_parameters(Query) ->
    _pipe = erlang:element(5, Query),
    _pipe@1 = starmap@query:unwrap_converted_wheres(_pipe),
    _pipe@2 = gleam@option:values(_pipe@1),
    _pipe@3 = gleam@list:map(_pipe@2, fun(Column) -> case Column of
                {converted_column_value, _, Val} ->
                    {some, Val};

                {converted_columns, _, _} ->
                    none
            end end),
    gleam@option:values(_pipe@3).

-spec query2(
    starmap@query:'query'({starmap@schema:column(IWN, sqlight:value()),
        starmap@schema:column(IWQ, sqlight:value())}, sqlight:value()),
    sqlight:connection()
) -> {ok, list({IWN, IWQ})} | {error, sqlight:error()}.
query2(Query, Conn) ->
    {Column1, Column2} = erlang:element(3, Query),
    Parameters = get_parameters(Query),
    _pipe = Query,
    _pipe@1 = starmap@sqlight@convert:query2(_pipe),
    sqlight:'query'(
        _pipe@1,
        Conn,
        Parameters,
        gleam@dynamic:tuple2(
            erlang:element(3, erlang:element(4, erlang:element(4, Column1))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column2)))
        )
    ).

-spec query3(
    starmap@query:'query'({starmap@schema:column(IWY, sqlight:value()),
        starmap@schema:column(IXB, sqlight:value()),
        starmap@schema:column(IXE, sqlight:value())}, sqlight:value()),
    sqlight:connection()
) -> {ok, list({IWY, IXB, IXE})} | {error, sqlight:error()}.
query3(Query, Conn) ->
    {Column1, Column2, Column3} = erlang:element(3, Query),
    Parameters = get_parameters(Query),
    _pipe = Query,
    _pipe@1 = starmap@sqlight@convert:query3(_pipe),
    sqlight:'query'(
        _pipe@1,
        Conn,
        Parameters,
        gleam@dynamic:tuple3(
            erlang:element(3, erlang:element(4, erlang:element(4, Column1))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column2))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column3)))
        )
    ).

-spec query4(
    starmap@query:'query'({starmap@schema:column(IXM, sqlight:value()),
        starmap@schema:column(IXP, sqlight:value()),
        starmap@schema:column(IXS, sqlight:value()),
        starmap@schema:column(IXV, sqlight:value())}, sqlight:value()),
    sqlight:connection()
) -> {ok, list({IXM, IXP, IXS, IXV})} | {error, sqlight:error()}.
query4(Query, Conn) ->
    {Column1, Column2, Column3, Column4} = erlang:element(3, Query),
    Parameters = get_parameters(Query),
    _pipe = Query,
    _pipe@1 = starmap@sqlight@convert:query4(_pipe),
    sqlight:'query'(
        _pipe@1,
        Conn,
        Parameters,
        gleam@dynamic:tuple4(
            erlang:element(3, erlang:element(4, erlang:element(4, Column1))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column2))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column3))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column4)))
        )
    ).

-spec query5(
    starmap@query:'query'({starmap@schema:column(IYD, sqlight:value()),
        starmap@schema:column(IYG, sqlight:value()),
        starmap@schema:column(IYJ, sqlight:value()),
        starmap@schema:column(IYM, sqlight:value()),
        starmap@schema:column(IYP, sqlight:value())}, sqlight:value()),
    sqlight:connection()
) -> {ok, list({IYD, IYG, IYJ, IYM, IYP})} | {error, sqlight:error()}.
query5(Query, Conn) ->
    {Column1, Column2, Column3, Column4, Column5} = erlang:element(3, Query),
    Parameters = get_parameters(Query),
    _pipe = Query,
    _pipe@1 = starmap@sqlight@convert:query5(_pipe),
    sqlight:'query'(
        _pipe@1,
        Conn,
        Parameters,
        gleam@dynamic:tuple5(
            erlang:element(3, erlang:element(4, erlang:element(4, Column1))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column2))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column3))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column4))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column5)))
        )
    ).

-spec query6(
    starmap@query:'query'({starmap@schema:column(IYX, sqlight:value()),
        starmap@schema:column(IZA, sqlight:value()),
        starmap@schema:column(IZD, sqlight:value()),
        starmap@schema:column(IZG, sqlight:value()),
        starmap@schema:column(IZJ, sqlight:value()),
        starmap@schema:column(IZM, sqlight:value())}, sqlight:value()),
    sqlight:connection()
) -> {ok, list({IYX, IZA, IZD, IZG, IZJ, IZM})} | {error, sqlight:error()}.
query6(Query, Conn) ->
    {Column1, Column2, Column3, Column4, Column5, Column6} = erlang:element(
        3,
        Query
    ),
    Parameters = get_parameters(Query),
    _pipe = Query,
    _pipe@1 = starmap@sqlight@convert:query6(_pipe),
    sqlight:'query'(
        _pipe@1,
        Conn,
        Parameters,
        gleam@dynamic:tuple6(
            erlang:element(3, erlang:element(4, erlang:element(4, Column1))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column2))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column3))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column4))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column5))),
            erlang:element(3, erlang:element(4, erlang:element(4, Column6)))
        )
    ).

-spec create_table1(
    starmap@creation:create_table(starmap@schema:column(any(), sqlight:value())),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
create_table1(Create_table, Conn) ->
    _pipe = Create_table,
    _pipe@1 = starmap@sqlight@convert:create_table1(_pipe),
    sqlight:exec(_pipe@1, Conn).

-spec create_table2(
    starmap@creation:create_table({starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value())}),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
create_table2(Create_table, Conn) ->
    _pipe = Create_table,
    _pipe@1 = starmap@sqlight@convert:create_table2(_pipe),
    sqlight:exec(_pipe@1, Conn).

-spec create_table3(
    starmap@creation:create_table({starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value())}),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
create_table3(Create_table, Conn) ->
    _pipe = Create_table,
    _pipe@1 = starmap@sqlight@convert:create_table3(_pipe),
    sqlight:exec(_pipe@1, Conn).

-spec create_table4(
    starmap@creation:create_table({starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value())}),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
create_table4(Create_table, Conn) ->
    _pipe = Create_table,
    _pipe@1 = starmap@sqlight@convert:create_table4(_pipe),
    sqlight:exec(_pipe@1, Conn).

-spec create_table5(
    starmap@creation:create_table({starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value())}),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
create_table5(Create_table, Conn) ->
    _pipe = Create_table,
    _pipe@1 = starmap@sqlight@convert:create_table5(_pipe),
    sqlight:exec(_pipe@1, Conn).

-spec create_table6(
    starmap@creation:create_table({starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value())}),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
create_table6(Create_table, Conn) ->
    _pipe = Create_table,
    _pipe@1 = starmap@sqlight@convert:create_table6(_pipe),
    sqlight:exec(_pipe@1, Conn).

-spec create_table7(
    starmap@creation:create_table({starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value())}),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
create_table7(Create_table, Conn) ->
    _pipe = Create_table,
    _pipe@1 = starmap@sqlight@convert:create_table7(_pipe),
    sqlight:exec(_pipe@1, Conn).

-spec create_table8(
    starmap@creation:create_table({starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value())}),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
create_table8(Create_table, Conn) ->
    _pipe = Create_table,
    _pipe@1 = starmap@sqlight@convert:create_table8(_pipe),
    sqlight:exec(_pipe@1, Conn).

-spec create_table9(
    starmap@creation:create_table({starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value()),
        starmap@schema:column(any(), sqlight:value())}),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
create_table9(Create_table, Conn) ->
    _pipe = Create_table,
    _pipe@1 = starmap@sqlight@convert:create_table9(_pipe),
    sqlight:exec(_pipe@1, Conn).

-spec insertion1(
    starmap@insertion:insertion(starmap@schema:column(JFV, sqlight:value()), JFV),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
insertion1(Insertion, Conn) ->
    Column1 = erlang:element(3, Insertion),
    Encoding1 = erlang:element(4, erlang:element(4, Column1)),
    Decoder = erlang:element(3, Encoding1),
    Vals@1 = begin
        _pipe = erlang:element(4, Insertion),
        gleam@list:fold(_pipe, [], fun(Vals, Val1) -> _pipe@1 = Vals,
                lists:append(_pipe@1, [(erlang:element(2, Encoding1))(Val1)]) end)
    end,
    _pipe@2 = Insertion,
    _pipe@3 = starmap@sqlight@convert:insertion1(_pipe@2),
    _pipe@4 = sqlight:'query'(_pipe@3, Conn, Vals@1, Decoder),
    gleam@result:map(_pipe@4, fun(_) -> nil end).

-spec insertion2(
    starmap@insertion:insertion({starmap@schema:column(JGC, sqlight:value()),
        starmap@schema:column(JGF, sqlight:value())}, {JGC, JGF}),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
insertion2(Insertion, Conn) ->
    {Column1, Column2} = erlang:element(3, Insertion),
    Encoding1 = erlang:element(4, erlang:element(4, Column1)),
    Encoding2 = erlang:element(4, erlang:element(4, Column2)),
    Decoder = gleam@dynamic:tuple2(
        erlang:element(3, Encoding1),
        erlang:element(3, Encoding2)
    ),
    Vals@1 = begin
        _pipe = erlang:element(4, Insertion),
        gleam@list:fold(
            _pipe,
            [],
            fun(Vals, X) ->
                {Val1, Val2} = X,
                _pipe@1 = Vals,
                lists:append(
                    _pipe@1,
                    [(erlang:element(2, Encoding1))(Val1),
                        (erlang:element(2, Encoding2))(Val2)]
                )
            end
        )
    end,
    _pipe@2 = Insertion,
    _pipe@3 = starmap@sqlight@convert:insertion2(_pipe@2),
    _pipe@4 = sqlight:'query'(_pipe@3, Conn, Vals@1, Decoder),
    gleam@result:map(_pipe@4, fun(_) -> nil end).

-spec insertion3(
    starmap@insertion:insertion({starmap@schema:column(JGM, sqlight:value()),
        starmap@schema:column(JGP, sqlight:value()),
        starmap@schema:column(JGS, sqlight:value())}, {JGM, JGP, JGS}),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
insertion3(Insertion, Conn) ->
    {Column1, Column2, Column3} = erlang:element(3, Insertion),
    Encoding1 = erlang:element(4, erlang:element(4, Column1)),
    Encoding2 = erlang:element(4, erlang:element(4, Column2)),
    Encoding3 = erlang:element(4, erlang:element(4, Column3)),
    Decoder = gleam@dynamic:tuple3(
        erlang:element(3, Encoding1),
        erlang:element(3, Encoding2),
        erlang:element(3, Encoding3)
    ),
    Vals@1 = begin
        _pipe = erlang:element(4, Insertion),
        gleam@list:fold(
            _pipe,
            [],
            fun(Vals, X) ->
                {Val1, Val2, Val3} = X,
                _pipe@1 = Vals,
                lists:append(
                    _pipe@1,
                    [(erlang:element(2, Encoding1))(Val1),
                        (erlang:element(2, Encoding2))(Val2),
                        (erlang:element(2, Encoding3))(Val3)]
                )
            end
        )
    end,
    _pipe@2 = Insertion,
    _pipe@3 = starmap@sqlight@convert:insertion3(_pipe@2),
    _pipe@4 = sqlight:'query'(_pipe@3, Conn, Vals@1, Decoder),
    gleam@result:map(_pipe@4, fun(_) -> nil end).

-spec insertion4(
    starmap@insertion:insertion({starmap@schema:column(JGZ, sqlight:value()),
        starmap@schema:column(JHC, sqlight:value()),
        starmap@schema:column(JHF, sqlight:value()),
        starmap@schema:column(JHI, sqlight:value())}, {JGZ, JHC, JHF, JHI}),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
insertion4(Insertion, Conn) ->
    {Column1, Column2, Column3, Column4} = erlang:element(3, Insertion),
    Encoding1 = erlang:element(4, erlang:element(4, Column1)),
    Encoding2 = erlang:element(4, erlang:element(4, Column2)),
    Encoding3 = erlang:element(4, erlang:element(4, Column3)),
    Encoding4 = erlang:element(4, erlang:element(4, Column4)),
    Decoder = gleam@dynamic:tuple4(
        erlang:element(3, Encoding1),
        erlang:element(3, Encoding2),
        erlang:element(3, Encoding3),
        erlang:element(3, Encoding4)
    ),
    Vals@1 = begin
        _pipe = erlang:element(4, Insertion),
        gleam@list:fold(
            _pipe,
            [],
            fun(Vals, X) ->
                {Val1, Val2, Val3, Val4} = X,
                _pipe@1 = Vals,
                lists:append(
                    _pipe@1,
                    [(erlang:element(2, Encoding1))(Val1),
                        (erlang:element(2, Encoding2))(Val2),
                        (erlang:element(2, Encoding3))(Val3),
                        (erlang:element(2, Encoding4))(Val4)]
                )
            end
        )
    end,
    _pipe@2 = Insertion,
    _pipe@3 = starmap@sqlight@convert:insertion4(_pipe@2),
    _pipe@4 = sqlight:'query'(_pipe@3, Conn, Vals@1, Decoder),
    gleam@result:map(_pipe@4, fun(_) -> nil end).

-spec insertion5(
    starmap@insertion:insertion({starmap@schema:column(JHP, sqlight:value()),
        starmap@schema:column(JHS, sqlight:value()),
        starmap@schema:column(JHV, sqlight:value()),
        starmap@schema:column(JHY, sqlight:value()),
        starmap@schema:column(JIB, sqlight:value())}, {JHP, JHS, JHV, JHY, JIB}),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
insertion5(Insertion, Conn) ->
    {Column1, Column2, Column3, Column4, Column5} = erlang:element(3, Insertion),
    Encoding1 = erlang:element(4, erlang:element(4, Column1)),
    Encoding2 = erlang:element(4, erlang:element(4, Column2)),
    Encoding3 = erlang:element(4, erlang:element(4, Column3)),
    Encoding4 = erlang:element(4, erlang:element(4, Column4)),
    Encoding5 = erlang:element(4, erlang:element(4, Column5)),
    Decoder = gleam@dynamic:tuple5(
        erlang:element(3, Encoding1),
        erlang:element(3, Encoding2),
        erlang:element(3, Encoding3),
        erlang:element(3, Encoding4),
        erlang:element(3, Encoding5)
    ),
    Vals@1 = begin
        _pipe = erlang:element(4, Insertion),
        gleam@list:fold(
            _pipe,
            [],
            fun(Vals, X) ->
                {Val1, Val2, Val3, Val4, Val5} = X,
                _pipe@1 = Vals,
                lists:append(
                    _pipe@1,
                    [(erlang:element(2, Encoding1))(Val1),
                        (erlang:element(2, Encoding2))(Val2),
                        (erlang:element(2, Encoding3))(Val3),
                        (erlang:element(2, Encoding4))(Val4),
                        (erlang:element(2, Encoding5))(Val5)]
                )
            end
        )
    end,
    _pipe@2 = Insertion,
    _pipe@3 = starmap@sqlight@convert:insertion5(_pipe@2),
    _pipe@4 = sqlight:'query'(_pipe@3, Conn, Vals@1, Decoder),
    gleam@result:map(_pipe@4, fun(_) -> nil end).

-spec insertion6(
    starmap@insertion:insertion({starmap@schema:column(JII, sqlight:value()),
        starmap@schema:column(JIL, sqlight:value()),
        starmap@schema:column(JIO, sqlight:value()),
        starmap@schema:column(JIR, sqlight:value()),
        starmap@schema:column(JIU, sqlight:value()),
        starmap@schema:column(JIX, sqlight:value())}, {JII,
        JIL,
        JIO,
        JIR,
        JIU,
        JIX}),
    sqlight:connection()
) -> {ok, nil} | {error, sqlight:error()}.
insertion6(Insertion, Conn) ->
    {Column1, Column2, Column3, Column4, Column5, Column6} = erlang:element(
        3,
        Insertion
    ),
    Encoding1 = erlang:element(4, erlang:element(4, Column1)),
    Encoding2 = erlang:element(4, erlang:element(4, Column2)),
    Encoding3 = erlang:element(4, erlang:element(4, Column3)),
    Encoding4 = erlang:element(4, erlang:element(4, Column4)),
    Encoding5 = erlang:element(4, erlang:element(4, Column5)),
    Encoding6 = erlang:element(4, erlang:element(4, Column6)),
    Decoder = gleam@dynamic:tuple6(
        erlang:element(3, Encoding1),
        erlang:element(3, Encoding2),
        erlang:element(3, Encoding3),
        erlang:element(3, Encoding4),
        erlang:element(3, Encoding5),
        erlang:element(3, Encoding6)
    ),
    Vals@1 = begin
        _pipe = erlang:element(4, Insertion),
        gleam@list:fold(
            _pipe,
            [],
            fun(Vals, X) ->
                {Val1, Val2, Val3, Val4, Val5, Val6} = X,
                _pipe@1 = Vals,
                lists:append(
                    _pipe@1,
                    [(erlang:element(2, Encoding1))(Val1),
                        (erlang:element(2, Encoding2))(Val2),
                        (erlang:element(2, Encoding3))(Val3),
                        (erlang:element(2, Encoding4))(Val4),
                        (erlang:element(2, Encoding5))(Val5),
                        (erlang:element(2, Encoding6))(Val6)]
                )
            end
        )
    end,
    _pipe@2 = Insertion,
    _pipe@3 = starmap@sqlight@convert:insertion6(_pipe@2),
    _pipe@4 = sqlight:'query'(_pipe@3, Conn, Vals@1, Decoder),
    gleam@result:map(_pipe@4, fun(_) -> nil end).
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