Status

https://chatgpt.com/share/694bfb93-ae9c-8008-a820-09777285d141

Intent

Project goal:
- Gmail → Postgres sync via FastAPI
- Incremental, resumable, single-run enforced
- Alembic migrations only
- Logging via stdlib, default WARNING

Python version:
- 3.12

Tech stack:
- FastAPI
- SQLAlchemy
- Alembic
- psycopg2
- Gmail API

Graciously sponsored by GPT5

GPT Question (customer) template

See PROMPT.md and PROJECT_STATE.md for further details.

Goal of this change:
- (one sentence)

Current behavior:
- (what happens now)

Expected behavior:
- (what should happen)

Constraints:
- beginner-friendly
- full file contents
- alembic only
- production-safe defaults

Relevant files:
- app/gmail/sync.py
- app/models.py

Scope

use gmail api to get all emails
- store the emails in a database
- generate embeddings
tf-idf + svm
xnli (zero shot transformer) / xlm
llm mit topic modelling (lektion vom 2025-12-16)?
- Promten, dass diese labels mit diesen stichworten relevant sind.
- oder nur die labels

To Do Next

acknowledge, that I have to work locally, as raspi does not have gpu
initiate a project, with local env to make sure I don't publish my sensitive information
install postgresql

Open Tasks (beyond scope of CAS_MAIN project)

Production readiness (not just fastapi dev app/main.py)
[-] authentication

Installation & Setup

Python

venv

python3.12 -m venv venv
source venv/bin/activate
pip install -r app/requirements.txt
pip freeze > requirements.txt

PostgreSQL

Installation

sudo apt update && sudo apt install postgresql postgresql-contrib --fix-missing

(base) tobias@thePC:~$ psql --version && systemctl is-enabled postgresql && systemctl is-active postgresql
# psql (PostgreSQL) 16.11 (Ubuntu 16.11-0ubuntu0.24.04.1)
# enabled
# active

Configure the RDBMS (create user & allow it to create a db)

sudo -u postgres psql

In the postgres=# prompt:

postgres=# CREATE USER mailapp WITH PASSWORD 'MY_SUPERSTRONG_PW';
-- CREATE ROLE
ALTER USER mailapp CREATEDB;
-- ALTER ROLE

Create the database (obsolete due to the use of alembic?)

CREATE DATABASE mail_classifier
  WITH OWNER = mailapp
       ENCODING = 'UTF8'
       LC_COLLATE = 'en_US.UTF-8'
       LC_CTYPE = 'en_US.UTF-8'
       TEMPLATE = template0;
-- CREATE DATABASE
GRANT ALL PRIVILEGES ON DATABASE mail_classifier TO mailapp;
-- GRANT
ALTER DATABASE mail_classifier SET timezone TO 'UTC';
-- ALTER DATABASE
\q
-- BYE

Check, whether user can login

psql -U mailapp -d mail_classifier -h localhost

HBA alteration needed for access

sudo code /etc/postgresql/16/main/pg_hba.conf --no-sandbox --user-data-dir .
add lines:

local   mail_classifier   mailapp   md5
host    mail_classifier   mailapp   127.0.0.1/32   md5

reload the service in order to add the configuration based on the newly added lines

sudo systemctl reload postgresql

Create / enable uuid-ossp extension for UUID generation

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
-- CREATE EXTENSION

SQLAlchemy ORM (Object Relational Mapper) incl. alembic

Not much of a setup done so far. Installed some python packages...

Gmail Setup

Enable GMail API: Google Cloud Console
Create Credentials: Google Cloud Console
Create OAuth client ID: Google Cloud Console
Allow test-user to use the dev environment (e.g. my personal email address): Google Cloud Console

Cron Job for running the sync hourly

crontab -l

0 * * * * curl -X POST http://localhost:8000/sync

Development Environment

fastapi dev main.py

App locally available at: http://127.0.0.1:8000/
App documentation (Swagger UI) locally available at: http://127.0.0.1:8000/docs#/default/sync_gmail_sync_gmail_pos
App documentation (redoc) locally available at: http://127.0.0.1:8000/redoc
OpenAPI JSON Schema: : http://127.0.0.1:8000/openapi.json

Components

DB & Models (ORM)

I am new to alembic (and the whole SQLAlchemy for that), so please point out obvious flaws here.

alembic cheatsheet

About

alembic is the migration tool for SQLAlchemy

Commands

command	explanation
`alembic history`	shows all commits and where the head is at (simmilar to `git history`)

Initial migration

alembic init alembic

generates a version (/alembic/versions/...)

Updates (How to handle future changes)

When adding new tables or columns, generate migrations via Alembic.

Change a model in app/models.py
Example: add a column priority = Column(Integer, default=0) to Email

Run:

alembic revision --autogenerate -m "add priority to email"
alembic upgrade head

Run

source venv/bin/activate
python main.py

Results

roberta (distilled)

{ "metrics": { "accuracy": 0.8187565858798735, "report": { "CATEGORY_PROMOTIONS": { "precision": 0.7105263157894737, "recall": 0.6617647058823529, "f1-score": 0.6852791878172588, "support": 204 }, "IMPORTANT": { "precision": 0.8576615831517792, "recall": 0.93879173290938, "f1-score": 0.8963946869070208, "support": 1258 }, "education/Linux": { "precision": 0.3333333333333333, "recall": 0.18181818181818182, "f1-score": 0.23529411764705882, "support": 22 }, "education/python": { "precision": 1, "recall": 0.9411764705882353, "f1-score": 0.9696969696969697, "support": 17 }, "financial/debit": { "precision": 0.6528925619834711, "recall": 0.4340659340659341, "f1-score": 0.5214521452145214, "support": 182 }, "info@shorten.ch": { "precision": 0.7637362637362637, "recall": 0.6465116279069767, "f1-score": 0.7002518891687658, "support": 215 }, "accuracy": 0.8187565858798735, "macro avg": { "precision": 0.7196916763323867, "recall": 0.6340214421951768, "f1-score": 0.6680614994085992, "support": 1898 }, "weighted avg": { "precision": 0.8067696081894694, "recall": 0.8187565858798735, "f1-score": 0.8085254141818569, "support": 1898 } }, "predictions": [ "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "education/python", "IMPORTANT", "CATEGORY_PROMOTIONS", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "education/python", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "education/python", "IMPORTANT", "IMPORTANT", "education/Linux", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "financial/debit", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "info@shorten.ch", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "education/Linux", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "financial/debit", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "financial/debit", "financial/debit", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "education/Linux", "IMPORTANT", "financial/debit", "IMPORTANT", "financial/debit", "financial/debit", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "education/python", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "financial/debit", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "financial/debit", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "education/Linux", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "financial/debit", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "education/python", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "education/Linux", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "education/Linux", "financial/debit", "info@shorten.ch", "financial/debit", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "education/python", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "education/Linux", "IMPORTANT", "financial/debit", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "info@shorten.ch", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "education/Linux", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "CATEGORY_PROMOTIONS", "IMPORTANT", "education/python", "IMPORTANT", "info@shorten.ch", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "financial/debit", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "education/python", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "financial/debit", "CATEGORY_PROMOTIONS", "financial/debit", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "education/python", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "education/python", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "info@shorten.ch", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "financial/debit", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "education/python", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "financial/debit", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "financial/debit", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "education/Linux", "info@shorten.ch", "CATEGORY_PROMOTIONS", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "info@shorten.ch", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "education/python", "info@shorten.ch", "financial/debit", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "financial/debit", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "financial/debit", "education/python", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "financial/debit", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "education/Linux", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "education/python", "financial/debit", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "education/Linux", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "financial/debit", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "education/Linux", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "financial/debit", "IMPORTANT", "info@shorten.ch", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "education/python", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "financial/debit", "info@shorten.ch", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "financial/debit", "financial/debit", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "CATEGORY_PROMOTIONS", "financial/debit", "IMPORTANT", "CATEGORY_PROMOTIONS", "financial/debit", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "education/python", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "IMPORTANT", "IMPORTANT", "IMPORTANT", "financial/debit", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "financial/debit", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "CATEGORY_PROMOTIONS", "IMPORTANT", "financial/debit", "financial/debit", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "info@shorten.ch", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT", "IMPORTANT" ] }, "result_subset": [ [ "Important information: fake e-mail messages", "IMPORTANT", "IMPORTANT" ], [ "AW: Anfrage....zwischendurch", "IMPORTANT", "IMPORTANT" ], [ "Tennis-Point: Re: Deine Bestellung bei www.tennis-point.ch (70436658)", "IMPORTANT", "IMPORTANT" ], [ "LastPass Security Notification : Login attempt from restricted device", "IMPORTANT", "IMPORTANT" ], [ "Logo Apollo", "IMPORTANT", "IMPORTANT" ], [ "Tobias, Alliance Club Exclusive Autumn Deals", "CATEGORY_PROMOTIONS", "CATEGORY_PROMOTIONS" ], [ "Aktiviere jetzt dein eBay Kleinanzeigen Konto", "IMPORTANT", "IMPORTANT" ], [ "Kita Telefon", "IMPORTANT", "IMPORTANT" ], [ "Last Chance: Stay in Touch with Magento", "info@shorten.ch", "info@shorten.ch" ], [ "Re: Zulassungsanfrage SL - MAS Data Science (T.MAS.DASC/26.17) - Wissenschaftliches Arbeiten", "IMPORTANT", "IMPORTANT" ] ] }

Name		Name	Last commit message	Last commit date
Latest commit History 35 Commits
alembic		alembic
app		app
experiments		experiments
scripts		scripts
.gitignore		.gitignore
Makefile		Makefile
README.md		README.md
alembic.ini		alembic.ini
main.py		main.py
requirements.txt		requirements.txt

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

Status

Scope

To Do Next

Open Tasks (beyond scope of CAS_MAIN project)

Installation & Setup

Python

venv

PostgreSQL

Installation

Configure the RDBMS (create user & allow it to create a db)

Create the database (obsolete due to the use of alembic?)

HBA alteration needed for access

Create / enable uuid-ossp extension for UUID generation

SQLAlchemy ORM (Object Relational Mapper) incl. alembic

Gmail Setup

Cron Job for running the sync hourly

Development Environment

Components

DB & Models (ORM)

About

Commands

Initial migration

Updates (How to handle future changes)

Run

Results

About

Uh oh!

Releases 1

Packages

Uh oh!

Contributors

Uh oh!

Languages

Folders and files

Latest commit

History

Repository files navigation

Status

Scope

To Do Next

Open Tasks (beyond scope of CAS_MAIN project)

Installation & Setup

Python

venv

PostgreSQL

Installation

Configure the RDBMS (create user & allow it to create a db)

Create the database (obsolete due to the use of alembic?)

HBA alteration needed for access

Create / enable uuid-ossp extension for UUID generation

SQLAlchemy ORM (Object Relational Mapper) incl. alembic

Gmail Setup

Cron Job for running the sync hourly

Development Environment

Components

DB & Models (ORM)

About

Commands

Initial migration

Updates (How to handle future changes)

Run

Results

About

Resources

Uh oh!

Stars

Watchers

Forks

Releases 1

Packages 0

Uh oh!

Contributors

Uh oh!

Languages

Packages