Feat: list_items query

[nelsonic]

As outlined in #145 (comment) we need a way of querying the list_items table
which will have multiple entries for the same item to reflect re-ordering the items on a list.

Note: for now, the fact that full history of changes to lists 📜
is stored in the list_items table is not visible anywhere in the interface. 🙈
i.e. people using the App (MVP) have no idea they can "undo" changes. ◀️
Once we have a chance to work on the wireframes for this, we can publicise it. 📣

Todo

• Create the SQL (or Ecto) query for returning the list of items.
  should:
  • GROUP BY item_id so that similar entries in the list_items table are ignored
  • ignore records in list_items where position=999999.999 as per EPIC: lists Schema + Setup #356
    which signifies that an item was removed from the list.

This should be enough to get this working. 💭

[nelsonic]

Will be working on this tomorrow morning.

[nelsonic]

Side quest: #358

[nelsonic]

I wish this had been T1h .... but sadly, it wasn't. ⏳ 😢
It's what I'm looking at next though. 🧑‍💻
Because it's contained in the PR #345
And I really don't want to be refactoring it.

Once that's done, we can add the Hyperlink URLs feature #141
Which is already working in the Demo: https://amemo.fly.dev

[nelsonic]

Simplified significantly by using cids. ✅

mvp/lib/app/item.ex

Lines 227 to 242 in a386f98

	def items_with_timers(person_id \\ 0) do
	all_list = App.List.get_all_list_for_person(person_id)
	# dbg(all_list)
	seq = App.ListItems.get_list_items(all_list.cid)
	# dbg(seq)
	sql = """
	SELECT i.id, i.cid, i.text, i.status, i.person_id, i.updated_at,
	t.start, t.stop, t.id as timer_id
	FROM items i
	FULL JOIN timers AS t ON t.item_id = i.id
	WHERE i.cid = any($1)
	AND i.status IS NOT NULL
	AND i.text IS NOT NULL
	ORDER BY timer_id ASC;
	"""