LIST

exec fireflyiii importer

kubectl exec --stdin --tty fireflyiii-importer-9dfd577c-r92wb -- php artisan importer:import /import/joint_activobank.json kubectl exec --stdin --tty fireflyiii-importer-9dfd577c-r92wb -- php artisan importer:import /import/joint_kbc.json

August 4, 2024

fireflyiii api update rules to caps

export clt="..." # get from Profile > OAUTH > Personal Access Token get all rules (check metadata to see if all fits in one page) curl -H "Authorization: Bearer ${clt}" "https://fireflyiii.hs.tjenwellens.eu/api/v1/rules?limit=100" > rules.json get the one rule you need cat rules.json| jq '.data[] | select(.id == "54")|.attributes' > rules.54.continente-category.json curl -v -X 'PUT' --data "@rules.54.continente-category.json" -H "content-type: application/json" -H "Authorization: Bearer ${clt}" "https://fireflyiii.hs.tjenwellens.eu/api/v1/rules/54" | jq cat rules.json| jq '.data[] | select(....

August 4, 2024

backup postgres database

backup `pg_dump dbname > dumpfile https://www.postgresql.org/docs/current/backup-dump.html pg_dump -h $DBHOST -p $DBPORT -U $DBUSER --format=p --clean -d $DBNAME > /var/lib/backup/$DBNAME.sql https://github.com/firefly-iii/kubernetes/blob/main/charts/firefly-db/templates/backup.tpl pg_dump -h localhost -p 5432 -U firefly --format=p --clean -d firefly > /db-bcp/firefly.sql restore `psql dbname < dumpfile https://www.postgresql.org/docs/current/backup-dump.html psql -h $DBHOST -p $DBPORT -U $DBUSER < /var/lib/backup/${DBNAME}.sql https://github.com/firefly-iii/kubernetes/blob/main/charts/firefly-db/templates/firefly-db-restore-job.yml psql -h localhost -p 5432 -U firefly < /var/lib/postgresql/data/firefly.sql and maybe run this on the core (NOT the db) php artisan firefly-iii:correct-database

July 27, 2024

firefly-iii migrate data from mariadb to postgresql

src: https://github.com/orgs/firefly-iii/discussions/7698#discussioncomment-6544051

July 27, 2024

helm install firefly 3

➜ helmfile git:(main) ✗ helm install firefly-iii firefly-iii/firefly-iii-stack –create-namespace -n firefly2 -f firefly/values.yaml

July 23, 2024