====== listmonk ======

===== Installation =====

<code ->
mkdir listmonk && cd listmonk
</code>

<code ->
sh -c "$(curl -fsSL https://raw.githubusercontent.com/knadh/listmonk/master/install-prod.sh)"
</code>

**Bei Fehlern**

++++
Einen bestehenden Datenbankcontainer entfernen |

<code ->
docker container ls | grep listmonk
</code>

  * db volume entfernen (portainer) 
  * port in **docker-commpose.yml** anpassen, 9000 ist belegt
  * admin_username und adminpassword in **config.toml** anpassen

++++

++++
Bei erstmaliger Installtion |

<code ->
docker compose down && docker compose up -d db && docker compose run --rm app ./listmonk --install
</code>

dann oder bei Änderung der Konfiguration

<code ->
docker compose down && docker compose up -d db && docker compose up -d app
</code>

++++


===== Abfragen =====

  * [[https://github.com/knadh/listmonk/blob/master/queries.sql]]
  * [[https://github.com/knadh/listmonk/issues/1565#issuecomment-1774507100|How to query subscribers.attribs in templates?]]

<code - gender-qury.json>
Dear 
{{ if eq .subscriber.attribs->>'gender' "male" }}
Mr. 
{{ else if eq .subscriber.attribs->>'gender' "female" }}
Ms.
{{ end }}
{{ .subscriber.name }},
</code>


===== Attribute =====

  * [[https://listmonk.app/docs/querying-and-segmentation/]]
  * [[https://www.cockroachlabs.com/docs/stable/jsonb]]

<code ->
subscribers.attribs->>'gender' = 'female'
</code>