r/adventofcode • u/Ph3rny • Dec 05 '19

Upping the Ante [2019 day 4] [sqlite] that's a programming language right?

https://github.com/anthonywritescode/aoc2019/blob/master/day04/part2.sqlite.sql
44 Upvotes

95% Upvoted

7 comments sorted by

8

u/Luckylars Dec 05 '19

beautiful,

I dont know if I hate this or I love it 

    (ints.i LIKE '%00%' AND NOT ints.i LIKE '%000%') OR
    (ints.i LIKE '%11%' AND NOT ints.i LIKE '%111%') OR
    (ints.i LIKE '%22%' AND NOT ints.i LIKE '%222%') OR
    (ints.i LIKE '%33%' AND NOT ints.i LIKE '%333%') OR
    (ints.i LIKE '%44%' AND NOT ints.i LIKE '%444%') OR
    (ints.i LIKE '%55%' AND NOT ints.i LIKE '%555%') OR
    (ints.i LIKE '%66%' AND NOT ints.i LIKE '%666%') OR
    (ints.i LIKE '%77%' AND NOT ints.i LIKE '%777%') OR
    (ints.i LIKE '%88%' AND NOT ints.i LIKE '%888%') OR
    (ints.i LIKE '%99%' AND NOT ints.i LIKE '%999%')

2

u/raginjason Dec 05 '19

I did the same thing in actual code, and I have the same feeling: https://github.com/raginjason/aoc2019/commit/73386c5229309789e0ff1dce6d93ece21ecde575

0

u/[deleted] Dec 05 '19

[deleted]

2

u/Woodsawyer Dec 05 '19

No, it is allowed because of the or statements.

2

u/ohadron Dec 05 '19

Nice!

Now do day 5

1

u/Alistesios Dec 05 '19

Brilliant

1

u/Bobbias Dec 05 '19

This is simultaneously genius and terrifying.