with
{query, params} = ~SQL[from pages]
|> ~SQL[where not url = any?({{state.lock}}) and not host = any?({{state.politeness}})]
|> ~SQL"select url limit 1"
|> to_sql()
IO.inspect({query, params})
I get
iex(1)> DBHandler.page_to_scrape()
20:07:41.399 [error] GenServer DBHandler terminating
** (UndefinedFunctionError) function nil.token_to_string/1 is undefined
nil.token_to_string({:select, [line: 0, column: 6, file: nil], [{:ident, [line: 0, column: 10, file: nil], [~c"url"]}]})
(elixir 1.18.3) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(sql 0.1.0) lib/sql.ex:113: String.Chars.SQL.to_string/1
(sql 0.1.0) lib/sql.ex:41: SQL.to_sql/1
(dbhandler 0.1.0) lib/dbhandler.ex:136: DBHandler.handle_call/3
(stdlib 4.3.1.6) gen_server.erl:1149: :gen_server.try_handle_call/4
(stdlib 4.3.1.6) gen_server.erl:1178: :gen_server.handle_msg/6
(stdlib 4.3.1.6) proc_lib.erl:240: :proc_lib.init_p_do_apply/3
Last message (from #PID<0.573.0>): :page_to_scrape
State: %{lock: [], politeness: []}
Client #PID<0.573.0> is alive
(stdlib 4.3.1.6) gen.erl:256: :gen.do_call/4
(elixir 1.18.3) lib/gen_server.ex:1125: GenServer.call/3
(elixir 1.18.3) src/elixir.erl:386: :elixir.eval_external_handler/3
(stdlib 4.3.1.6) erl_eval.erl:748: :erl_eval.do_apply/7
(elixir 1.18.3) src/elixir.erl:364: :elixir.eval_forms/4
(elixir 1.18.3) lib/module/parallel_checker.ex:120: Module.ParallelChecker.verify/1
(iex 1.18.3) lib/iex/evaluator.ex:336: IEx.Evaluator.eval_and_inspect/3
(iex 1.18.3) lib/iex/evaluator.ex:310: IEx.Evaluator.eval_and_inspect_parsed/3
Database handler started!
** (exit) exited in: GenServer.call(DBHandler, :page_to_scrape, 60000)
** (EXIT) an exception was raised:
** (UndefinedFunctionError) function nil.token_to_string/1 is undefined
nil.token_to_string({:select, [line: 0, column: 6, file: nil], [{:ident, [line: 0, column: 10, file: nil], [~c"url"]}]})
(elixir 1.18.3) lib/enum.ex:1714: Enum."-map/2-lists^map/1-1-"/2
(sql 0.1.0) lib/sql.ex:113: String.Chars.SQL.to_string/1
(sql 0.1.0) lib/sql.ex:41: SQL.to_sql/1
(dbhandler 0.1.0) lib/dbhandler.ex:136: DBHandler.handle_call/3
(stdlib 4.3.1.6) gen_server.erl:1149: :gen_server.try_handle_call/4
(stdlib 4.3.1.6) gen_server.erl:1178: :gen_server.handle_msg/6
(stdlib 4.3.1.6) proc_lib.erl:240: :proc_lib.init_p_do_apply/3
(elixir 1.18.3) lib/gen_server.ex:1128: GenServer.call/3
iex:1: (file)
