02:17 <wwalker> roflmao

08:42 <casionaut> Has anyone read "programming crystal" book recently? I wonder if it's outdated or not.

13:25 <frojnd> Hm

13:27 <frojnd> My id inside table is defined like this: `id | integer | | not null | nextval('app_id_seq'::regclass)` so when inserting stuff for the table I can ommit id part. But in Crystal, I have to specify id inside insert statement. Why is that?

13:27 <FromGitter> <Blacksmoke16> casionaut: i hear theres another one coming out in another month or two, could just wait for that one

13:27 <FromGitter> <Blacksmoke16> think you can also find a PDF of the first one online too

13:28 <FromGitter> <Blacksmoke16> whats the error you get if you dont

13:29 <analogsalad> Blacksmoke16: A new edition of that book or a different one?

13:30 <FromGitter> <Blacksmoke16> different one

13:30 <frojnd> @Blacksmoke16: Unhandled exception: invalid input syntax for type integer: "foo.bar" (PQ::PQError)

13:30 <FromGitter> <Blacksmoke16> and whats your sql look like?

13:31 <analogsalad> Blacksmoke16: good to know, thanks. I was also looking for a book.

13:33 <analogsalad> "Programming Crystal" was written at v0.27.0. It's probably better to wait for the new one.

13:35 <frojnd> @Blacksmoke16: this is how table looks like: https://termbin.com/uwxd and this is the sql I'm trying to execute: https://termbin.com/2j2a

13:37 <FromGitter> <Blacksmoke16> i think you should update your SQL to specify what fields you're inserting

13:37 <frojnd> @Blacksmoke16 like starting with $2 ?

13:37 <FromGitter> <Blacksmoke16> i.e. it thinks you're going in order and `$1` maps to `id` which fails since its a string

13:39 <FromGitter> <Blacksmoke16> `insert into app (name, package, version_code, version_name, md5) values ($1, $2, $3, $4, $5)`

13:42 <FromGitter> <Blacksmoke16> https://www.postgresql.org/docs/current/sql-insert.html ⏎ ⏎ > The target column names can be listed in any order. If no list of column names is given at all, the default is all the columns of the table in their declared order; or the first N column names, if there are only N columns supplied by the VALUES clause or query. The values supplied by the VALUES clause or query are associated with the

13:42 <FromGitter> ... explicit or implicit column list left-to-right.

13:43 <frojnd> I see

13:43 <frojnd> Thank you

13:43 <frojnd> Hm

13:43 <frojnd> Can I insert such statement directly in Crystal?

13:44 <frojnd> It works in psql shell but not sure how to do it in Crystal

13:44 <FromGitter> <Blacksmoke16> literally just add the column list to your insert query

13:44 <frojnd> Aha ok

14:01 <frojnd> `db.exec "insert into app values (package, version_code, version_name, md5)", "foo.bar", 3, "1235", "219asdf23"` gives me: `Unhandled exception: column "package" does not exist (PQ::PQError)`

14:03 <FromGitter> <Blacksmoke16> does your table have a `package` column?

14:03 <frojnd> Yes

14:03 <frojnd> https://termbin.com/uwxd

14:04 <FromGitter> <Blacksmoke16> i think you need to add the list *before* the `values` keyword

14:05 <casionaut> Blacksmoke16: Good to know that another book is coming. Any other resources you'd recommend for the meanwhile?

14:05 <FromGitter> <Blacksmoke16> https://crystal-lang.org/reference/1.4/

14:05 <FromGitter> <Blacksmoke16> https://crystal-lang.org/api/master/index.html

14:06 <casionaut> Blacksmoke16: cheers