prispevky.ipynb

{
 "cells": [
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-10-02T21:41:46.105837Z",
     "start_time": "2024-10-02T21:41:46.090099Z"
    }
   },
   "cell_type": "code",
   "source": [
    "%load_ext autoreload\n",
    "%autoreload 2"
   ],
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The autoreload extension is already loaded. To reload it, use:\n",
      "  %reload_ext autoreload\n"
     ]
    }
   ],
   "execution_count": 2
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-10-02T21:41:47.639022Z",
     "start_time": "2024-10-02T21:41:46.962752Z"
    }
   },
   "cell_type": "code",
   "source": [
    "import logging\n",
    "from gsheet import *\n",
    "from mailer import *\n",
    "from qr_code import *\n",
    "from payment_data import *\n",
    "\n",
    "\n",
    "\"\"\"\n",
    "If logging in results in an error, delete the 'token.json' to re-authenticate.\n",
    "\"\"\";"
   ],
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Succesfully read config from: ['./config_prispevky.cfg']\n"
     ]
    }
   ],
   "execution_count": 3
  },
  {
   "cell_type": "code",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-10-02T21:41:48.647022Z",
     "start_time": "2024-10-02T21:41:48.624468Z"
    }
   },
   "source": [
    "logging.basicConfig(\n",
    "    format=\"[%(levelname)s] %(message)s\",\n",
    "    level=logging.INFO\n",
    ")"
   ],
   "outputs": [],
   "execution_count": 4
  },
  {
   "cell_type": "code",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-10-02T21:41:49.433175Z",
     "start_time": "2024-10-02T21:41:49.400315Z"
    }
   },
   "source": [
    "sheet = Sheets(SPREADSHEET_ID)"
   ],
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[INFO] file_cache is only supported with oauth2client<4.0.0\n"
     ]
    }
   ],
   "execution_count": 5
  },
  {
   "cell_type": "code",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-10-02T21:41:51.444709Z",
     "start_time": "2024-10-02T21:41:50.088879Z"
    }
   },
   "source": [
    "# sheet_names = sheet.get_sheet_names()\n",
    "# sheet_name = '4pvs_all'\n",
    "# sheet_name = 'PLATBY_PODZIM_2022_filtered'\n",
    "# sheet_name=\"ExportNoFormulas\"\n",
    "# sheet_name=\"SkautisExport20231107\"\n",
    "sheet_name=\"PlatbyPodzim2024\"\n",
    "# sheet_name = 'TESTv2'\n",
    "if 'TEST' in sheet_name:\n",
    "    testmode=True\n",
    "else:\n",
    "    testmode=False\n",
    "df = sheet.get_dataframe(sheet_name)"
   ],
   "outputs": [],
   "execution_count": 6
  },
  {
   "cell_type": "code",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-10-02T21:41:51.510758Z",
     "start_time": "2024-10-02T21:41:51.461815Z"
    }
   },
   "source": [
    "df"
   ],
   "outputs": [
    {
     "data": {
      "text/plain": [
       "        Jméno     Příjmení     Příjmení jméno                   Osoba  \\\n",
       "0       Karel       Dvořák       Dvořák Karel    Dvořák Karel (Šárlí)   \n",
       "1       David      Svoboda      Svoboda David  Svoboda David (Cedník)   \n",
       "2         Jan        Mrkos          Mrkos Jan     Mrkos Jan (Hondzik)   \n",
       "3     Oldřich        Milec      Milec Oldřich    Milec Oldřich (Olda)   \n",
       "4       Tomáš        Kopal        Kopal Tomáš      Kopal Tomáš (Kohn)   \n",
       "..        ...          ...                ...                     ...   \n",
       "224      Lada  Zámečníková   Zámečníková Lada        Zámečníková Lada   \n",
       "225     Luisa  Šilingerová  Šilingerová Luisa       Šilingerová Luisa   \n",
       "226       Ema  Brücklerová    Brücklerová Ema         Brücklerová Ema   \n",
       "227  Marianna     Fenclová  Fenclová Marianna       Fenclová Marianna   \n",
       "228    Myrrha   Srovnalová  Srovnalová Myrrha       Srovnalová Myrrha   \n",
       "\n",
       "    Poplatek Zaplaceno Registrační číslo     Jednotka Přezdívka              \\\n",
       "0       1000         0             10001  Albatrosové     Šárlí     (Šárlí)   \n",
       "1       1000         0             10010  Albatrosové    Cedník    (Cedník)   \n",
       "2       1000         0             10015  Albatrosové   Hondzik   (Hondzik)   \n",
       "3       1000         0             10017  Albatrosové      Olda      (Olda)   \n",
       "4       1000         0             10020  Albatrosové      Kohn      (Kohn)   \n",
       "..       ...       ...               ...          ...       ...         ...   \n",
       "224     1000         0             60006        Želvy                         \n",
       "225     1000         0             60009        Želvy                         \n",
       "226     1000         0             40429        Želvy                         \n",
       "227     1000         0             40430        Želvy                         \n",
       "228     1000         0             40431        Želvy                         \n",
       "\n",
       "     ...                Otec: mail                    Matka: mail  \\\n",
       "0    ...                                                            \n",
       "1    ...                                                            \n",
       "2    ...                                                            \n",
       "3    ...                                                            \n",
       "4    ...                                                            \n",
       "..   ...                       ...                            ...   \n",
       "224  ...     martinz6492@seznam.cz  veronika.zamecnikova@omska.cz   \n",
       "225  ...  frantisek.pekar@email.cz      linda.silingerova@jsns.cz   \n",
       "226  ...    bruckler-jiri@volny.cz           barborabr@centrum.cz   \n",
       "227  ...         dalifen@gmail.com    annamariefenclova@gmail.com   \n",
       "228  ...    filipsrovnal@gmail.com             meludp30@orange.fr   \n",
       "\n",
       "    Ostatní: mail Mobil (další) Telefon (další) Telefon / mobil (hlavní)  \\\n",
       "0                                                              721978545   \n",
       "1                                                              732131483   \n",
       "2                                                              720411622   \n",
       "3                                                              732598732   \n",
       "4                                                              731229603   \n",
       "..            ...           ...             ...                      ...   \n",
       "224                                                                        \n",
       "225                                                                        \n",
       "226                                                            776048148   \n",
       "227                                                            604970901   \n",
       "228                                                                        \n",
       "\n",
       "    Telefon do práce Otec: telefon Matka: telefon Ostatní: telefon  \n",
       "0               None          None           None             None  \n",
       "1               None          None           None             None  \n",
       "2               None          None           None             None  \n",
       "3               None          None           None             None  \n",
       "4               None          None           None             None  \n",
       "..               ...           ...            ...              ...  \n",
       "224                      737859247      724028382             None  \n",
       "225                      603157305      603290152             None  \n",
       "226                      608979018      776048148             None  \n",
       "227                      603202327      736751580             None  \n",
       "228                      602215517      773072031             None  \n",
       "\n",
       "[229 rows x 30 columns]"
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Jméno</th>\n",
       "      <th>Příjmení</th>\n",
       "      <th>Příjmení jméno</th>\n",
       "      <th>Osoba</th>\n",
       "      <th>Poplatek</th>\n",
       "      <th>Zaplaceno</th>\n",
       "      <th>Registrační číslo</th>\n",
       "      <th>Jednotka</th>\n",
       "      <th>Přezdívka</th>\n",
       "      <th></th>\n",
       "      <th>...</th>\n",
       "      <th>Otec: mail</th>\n",
       "      <th>Matka: mail</th>\n",
       "      <th>Ostatní: mail</th>\n",
       "      <th>Mobil (další)</th>\n",
       "      <th>Telefon (další)</th>\n",
       "      <th>Telefon / mobil (hlavní)</th>\n",
       "      <th>Telefon do práce</th>\n",
       "      <th>Otec: telefon</th>\n",
       "      <th>Matka: telefon</th>\n",
       "      <th>Ostatní: telefon</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Karel</td>\n",
       "      <td>Dvořák</td>\n",
       "      <td>Dvořák Karel</td>\n",
       "      <td>Dvořák Karel (Šárlí)</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>10001</td>\n",
       "      <td>Albatrosové</td>\n",
       "      <td>Šárlí</td>\n",
       "      <td>(Šárlí)</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>721978545</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>David</td>\n",
       "      <td>Svoboda</td>\n",
       "      <td>Svoboda David</td>\n",
       "      <td>Svoboda David (Cedník)</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>10010</td>\n",
       "      <td>Albatrosové</td>\n",
       "      <td>Cedník</td>\n",
       "      <td>(Cedník)</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>732131483</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jan</td>\n",
       "      <td>Mrkos</td>\n",
       "      <td>Mrkos Jan</td>\n",
       "      <td>Mrkos Jan (Hondzik)</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>10015</td>\n",
       "      <td>Albatrosové</td>\n",
       "      <td>Hondzik</td>\n",
       "      <td>(Hondzik)</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>720411622</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Oldřich</td>\n",
       "      <td>Milec</td>\n",
       "      <td>Milec Oldřich</td>\n",
       "      <td>Milec Oldřich (Olda)</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>10017</td>\n",
       "      <td>Albatrosové</td>\n",
       "      <td>Olda</td>\n",
       "      <td>(Olda)</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>732598732</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Tomáš</td>\n",
       "      <td>Kopal</td>\n",
       "      <td>Kopal Tomáš</td>\n",
       "      <td>Kopal Tomáš (Kohn)</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>10020</td>\n",
       "      <td>Albatrosové</td>\n",
       "      <td>Kohn</td>\n",
       "      <td>(Kohn)</td>\n",
       "      <td>...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>731229603</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>Lada</td>\n",
       "      <td>Zámečníková</td>\n",
       "      <td>Zámečníková Lada</td>\n",
       "      <td>Zámečníková Lada</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>60006</td>\n",
       "      <td>Želvy</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>martinz6492@seznam.cz</td>\n",
       "      <td>veronika.zamecnikova@omska.cz</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>737859247</td>\n",
       "      <td>724028382</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>Luisa</td>\n",
       "      <td>Šilingerová</td>\n",
       "      <td>Šilingerová Luisa</td>\n",
       "      <td>Šilingerová Luisa</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>60009</td>\n",
       "      <td>Želvy</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>frantisek.pekar@email.cz</td>\n",
       "      <td>linda.silingerova@jsns.cz</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>603157305</td>\n",
       "      <td>603290152</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>Ema</td>\n",
       "      <td>Brücklerová</td>\n",
       "      <td>Brücklerová Ema</td>\n",
       "      <td>Brücklerová Ema</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>40429</td>\n",
       "      <td>Želvy</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>bruckler-jiri@volny.cz</td>\n",
       "      <td>barborabr@centrum.cz</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>776048148</td>\n",
       "      <td></td>\n",
       "      <td>608979018</td>\n",
       "      <td>776048148</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>Marianna</td>\n",
       "      <td>Fenclová</td>\n",
       "      <td>Fenclová Marianna</td>\n",
       "      <td>Fenclová Marianna</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>40430</td>\n",
       "      <td>Želvy</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>dalifen@gmail.com</td>\n",
       "      <td>annamariefenclova@gmail.com</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>604970901</td>\n",
       "      <td></td>\n",
       "      <td>603202327</td>\n",
       "      <td>736751580</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>Myrrha</td>\n",
       "      <td>Srovnalová</td>\n",
       "      <td>Srovnalová Myrrha</td>\n",
       "      <td>Srovnalová Myrrha</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>40431</td>\n",
       "      <td>Želvy</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>filipsrovnal@gmail.com</td>\n",
       "      <td>meludp30@orange.fr</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>602215517</td>\n",
       "      <td>773072031</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>229 rows × 30 columns</p>\n",
       "</div>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 7
  },
  {
   "cell_type": "code",
   "metadata": {
    "scrolled": false,
    "ExecuteTime": {
     "end_time": "2024-10-02T21:41:53.989074Z",
     "start_time": "2024-10-02T21:41:53.790935Z"
    }
   },
   "source": [
    "NEEDED_COLS = NeededColumns()\n",
    "pdf=PaymentsDataFrame(df, NEEDED_COLS)"
   ],
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/mnt/c/Users/mrkos/scth/projects/4pvs_prispevky_qr_kod/payment_data.py:114: FutureWarning: In a future version, `df.iloc[:, i] = newvals` will attempt to set the values inplace instead of always setting a new array. To retain the old behavior, use either `df[df.columns[i]] = newvals` or, if columns are non-unique, `df.isetitem(i, newvals)`\n",
      "  df_fixed.loc[:, col] = pd.to_numeric(payments.loc[:, col])\n",
      "[INFO] Of 229 people, missing email: 2,\n",
      "\temailable paid: 0\n",
      "\temailable unpaid: 227.\n",
      " Also there were 0 invalid emails.\n"
     ]
    }
   ],
   "execution_count": 8
  },
  {
   "cell_type": "code",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-10-02T21:41:55.906310Z",
     "start_time": "2024-10-02T21:41:55.876862Z"
    }
   },
   "source": [
    "pdf.df_missing_email"
   ],
   "outputs": [
    {
     "data": {
      "text/plain": [
       "                  Osoba     Jednotka Registrační číslo E-mail (hlavní)  \\\n",
       "22  Makhov Iurii (Jura)  Albatrosové             10063            None   \n",
       "23         Makhov Roman  Albatrosové             10064            None   \n",
       "\n",
       "   Otec: mail Matka: mail E-mail (další) Ostatní: mail Poplatek Zaplaceno  \\\n",
       "22       None        None           None          None     1000         0   \n",
       "23       None        None           None          None     1000         0   \n",
       "\n",
       "   valid_addresses invalid_addresses  \n",
       "22              ()                ()  \n",
       "23              ()                ()  "
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Osoba</th>\n",
       "      <th>Jednotka</th>\n",
       "      <th>Registrační číslo</th>\n",
       "      <th>E-mail (hlavní)</th>\n",
       "      <th>Otec: mail</th>\n",
       "      <th>Matka: mail</th>\n",
       "      <th>E-mail (další)</th>\n",
       "      <th>Ostatní: mail</th>\n",
       "      <th>Poplatek</th>\n",
       "      <th>Zaplaceno</th>\n",
       "      <th>valid_addresses</th>\n",
       "      <th>invalid_addresses</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Makhov Iurii (Jura)</td>\n",
       "      <td>Albatrosové</td>\n",
       "      <td>10063</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>()</td>\n",
       "      <td>()</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Makhov Roman</td>\n",
       "      <td>Albatrosové</td>\n",
       "      <td>10064</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>()</td>\n",
       "      <td>()</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 9
  },
  {
   "cell_type": "code",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-10-02T21:42:06.528950Z",
     "start_time": "2024-10-02T21:41:56.966325Z"
    }
   },
   "source": [
    "emails = []\n",
    "\n",
    "\"\"\"\n",
    "!!!!!WARNING! CURRENTLY SET TO EMAIL ALL AVAILABLE EMAIL ADDRESSES!!!!!\n",
    "\n",
    "Modify this setting on second line:\n",
    "    recepient_addresses = row.valid_addresses\n",
    "    \n",
    "Modify order in in class NeededColumns\n",
    "\"\"\"\n",
    "\n",
    "for i, row in pdf.df_emailable_unpaid.iterrows():\n",
    "    recepient_addresses = row.valid_addresses[:4]\n",
    "    pi = PaymentInfo.from_df_row(row, NEEDED_COLS)\n",
    "    email = PaymentEmail(pi, recepient_addresses, testmode=testmode)\n",
    "    emails.append(email.msg)"
   ],
   "outputs": [],
   "execution_count": 10
  },
  {
   "cell_type": "code",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-10-02T21:42:06.565817Z",
     "start_time": "2024-10-02T21:42:06.535441Z"
    }
   },
   "source": [
    "pdf.df_emailable_unpaid"
   ],
   "outputs": [
    {
     "data": {
      "text/plain": [
       "                      Osoba     Jednotka Registrační číslo  \\\n",
       "0      Dvořák Karel (Šárlí)  Albatrosové             10001   \n",
       "1    Svoboda David (Cedník)  Albatrosové             10010   \n",
       "2       Mrkos Jan (Hondzik)  Albatrosové             10015   \n",
       "3      Milec Oldřich (Olda)  Albatrosové             10017   \n",
       "4        Kopal Tomáš (Kohn)  Albatrosové             10020   \n",
       "..                      ...          ...               ...   \n",
       "224        Zámečníková Lada        Želvy             60006   \n",
       "225       Šilingerová Luisa        Želvy             60009   \n",
       "226         Brücklerová Ema        Želvy             40429   \n",
       "227       Fenclová Marianna        Želvy             40430   \n",
       "228       Srovnalová Myrrha        Želvy             40431   \n",
       "\n",
       "            E-mail (hlavní)                Otec: mail  \\\n",
       "0    kareldvorak@centrum.cz                      None   \n",
       "1           cednik@email.cz                      None   \n",
       "2          hondzik@skaut.cz                      None   \n",
       "3       oldamilec@seznam.cz                      None   \n",
       "4    kopalektomas@seznam.cz                      None   \n",
       "..                      ...                       ...   \n",
       "224                    None     martinz6492@seznam.cz   \n",
       "225                    None  frantisek.pekar@email.cz   \n",
       "226    barborabr@centrum.cz    bruckler-jiri@volny.cz   \n",
       "227                    None         dalifen@gmail.com   \n",
       "228                    None    filipsrovnal@gmail.com   \n",
       "\n",
       "                       Matka: mail  \\\n",
       "0                             None   \n",
       "1                             None   \n",
       "2                             None   \n",
       "3                             None   \n",
       "4                             None   \n",
       "..                             ...   \n",
       "224  veronika.zamecnikova@omska.cz   \n",
       "225      linda.silingerova@jsns.cz   \n",
       "226           barborabr@centrum.cz   \n",
       "227    annamariefenclova@gmail.com   \n",
       "228             meludp30@orange.fr   \n",
       "\n",
       "                                        E-mail (další) Ostatní: mail  \\\n",
       "0                                                 None          None   \n",
       "1                                                 None          None   \n",
       "2    hondzik@skautka.cz, jan.mrkos@skaut.cz, mrkos....          None   \n",
       "3                                     trallda@skaut.cz          None   \n",
       "4                                        kohn@skaut.cz          None   \n",
       "..                                                 ...           ...   \n",
       "224                                               None          None   \n",
       "225                                               None          None   \n",
       "226                                               None          None   \n",
       "227                                               None          None   \n",
       "228                                               None          None   \n",
       "\n",
       "     Poplatek  Zaplaceno                                    valid_addresses  \\\n",
       "0        1000          0      (\"E-mail (hlavní)\" <kareldvorak@centrum.cz>,)   \n",
       "1        1000          0             (\"E-mail (hlavní)\" <cednik@email.cz>,)   \n",
       "2        1000          0  (\"E-mail (hlavní)\" <hondzik@skaut.cz>, \"E-mail...   \n",
       "3        1000          0  (\"E-mail (hlavní)\" <oldamilec@seznam.cz>, \"E-m...   \n",
       "4        1000          0  (\"E-mail (hlavní)\" <kopalektomas@seznam.cz>, \"...   \n",
       "..        ...        ...                                                ...   \n",
       "224      1000          0  (\"Matka: mail\" <veronika.zamecnikova@omska.cz>...   \n",
       "225      1000          0  (\"Matka: mail\" <linda.silingerova@jsns.cz>, \"O...   \n",
       "226      1000          0  (\"E-mail (hlavní)\" <barborabr@centrum.cz>, \"Ot...   \n",
       "227      1000          0  (\"Matka: mail\" <annamariefenclova@gmail.com>, ...   \n",
       "228      1000          0  (\"Matka: mail\" <meludp30@orange.fr>, \"Otec: ma...   \n",
       "\n",
       "    invalid_addresses  \n",
       "0                  ()  \n",
       "1                  ()  \n",
       "2                  ()  \n",
       "3                  ()  \n",
       "4                  ()  \n",
       "..                ...  \n",
       "224                ()  \n",
       "225                ()  \n",
       "226                ()  \n",
       "227                ()  \n",
       "228                ()  \n",
       "\n",
       "[227 rows x 12 columns]"
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Osoba</th>\n",
       "      <th>Jednotka</th>\n",
       "      <th>Registrační číslo</th>\n",
       "      <th>E-mail (hlavní)</th>\n",
       "      <th>Otec: mail</th>\n",
       "      <th>Matka: mail</th>\n",
       "      <th>E-mail (další)</th>\n",
       "      <th>Ostatní: mail</th>\n",
       "      <th>Poplatek</th>\n",
       "      <th>Zaplaceno</th>\n",
       "      <th>valid_addresses</th>\n",
       "      <th>invalid_addresses</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Dvořák Karel (Šárlí)</td>\n",
       "      <td>Albatrosové</td>\n",
       "      <td>10001</td>\n",
       "      <td>kareldvorak@centrum.cz</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>(\"E-mail (hlavní)\" &lt;kareldvorak@centrum.cz&gt;,)</td>\n",
       "      <td>()</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Svoboda David (Cedník)</td>\n",
       "      <td>Albatrosové</td>\n",
       "      <td>10010</td>\n",
       "      <td>cednik@email.cz</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>(\"E-mail (hlavní)\" &lt;cednik@email.cz&gt;,)</td>\n",
       "      <td>()</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mrkos Jan (Hondzik)</td>\n",
       "      <td>Albatrosové</td>\n",
       "      <td>10015</td>\n",
       "      <td>hondzik@skaut.cz</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>hondzik@skautka.cz, jan.mrkos@skaut.cz, mrkos....</td>\n",
       "      <td>None</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>(\"E-mail (hlavní)\" &lt;hondzik@skaut.cz&gt;, \"E-mail...</td>\n",
       "      <td>()</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Milec Oldřich (Olda)</td>\n",
       "      <td>Albatrosové</td>\n",
       "      <td>10017</td>\n",
       "      <td>oldamilec@seznam.cz</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>trallda@skaut.cz</td>\n",
       "      <td>None</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>(\"E-mail (hlavní)\" &lt;oldamilec@seznam.cz&gt;, \"E-m...</td>\n",
       "      <td>()</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Kopal Tomáš (Kohn)</td>\n",
       "      <td>Albatrosové</td>\n",
       "      <td>10020</td>\n",
       "      <td>kopalektomas@seznam.cz</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>kohn@skaut.cz</td>\n",
       "      <td>None</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>(\"E-mail (hlavní)\" &lt;kopalektomas@seznam.cz&gt;, \"...</td>\n",
       "      <td>()</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>Zámečníková Lada</td>\n",
       "      <td>Želvy</td>\n",
       "      <td>60006</td>\n",
       "      <td>None</td>\n",
       "      <td>martinz6492@seznam.cz</td>\n",
       "      <td>veronika.zamecnikova@omska.cz</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>(\"Matka: mail\" &lt;veronika.zamecnikova@omska.cz&gt;...</td>\n",
       "      <td>()</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>Šilingerová Luisa</td>\n",
       "      <td>Želvy</td>\n",
       "      <td>60009</td>\n",
       "      <td>None</td>\n",
       "      <td>frantisek.pekar@email.cz</td>\n",
       "      <td>linda.silingerova@jsns.cz</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>(\"Matka: mail\" &lt;linda.silingerova@jsns.cz&gt;, \"O...</td>\n",
       "      <td>()</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>Brücklerová Ema</td>\n",
       "      <td>Želvy</td>\n",
       "      <td>40429</td>\n",
       "      <td>barborabr@centrum.cz</td>\n",
       "      <td>bruckler-jiri@volny.cz</td>\n",
       "      <td>barborabr@centrum.cz</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>(\"E-mail (hlavní)\" &lt;barborabr@centrum.cz&gt;, \"Ot...</td>\n",
       "      <td>()</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>Fenclová Marianna</td>\n",
       "      <td>Želvy</td>\n",
       "      <td>40430</td>\n",
       "      <td>None</td>\n",
       "      <td>dalifen@gmail.com</td>\n",
       "      <td>annamariefenclova@gmail.com</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>(\"Matka: mail\" &lt;annamariefenclova@gmail.com&gt;, ...</td>\n",
       "      <td>()</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>Srovnalová Myrrha</td>\n",
       "      <td>Želvy</td>\n",
       "      <td>40431</td>\n",
       "      <td>None</td>\n",
       "      <td>filipsrovnal@gmail.com</td>\n",
       "      <td>meludp30@orange.fr</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1000</td>\n",
       "      <td>0</td>\n",
       "      <td>(\"Matka: mail\" &lt;meludp30@orange.fr&gt;, \"Otec: ma...</td>\n",
       "      <td>()</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>227 rows × 12 columns</p>\n",
       "</div>"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 11
  },
  {
   "cell_type": "code",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-10-02T21:42:06.660452Z",
     "start_time": "2024-10-02T21:42:06.628474Z"
    }
   },
   "source": [
    "with open(f'./test.eml', 'wb') as f:\n",
    "    f.write(bytes(emails[0]))"
   ],
   "outputs": [],
   "execution_count": 12
  },
  {
   "cell_type": "markdown",
   "source": [
    "## ⚡ Danger Zone ⚡"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-10-02T21:43:32.978633Z",
     "start_time": "2024-10-02T21:43:32.944259Z"
    }
   },
   "source": [
    "mailer = Mailer()\n",
    "sent = []"
   ],
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[INFO] file_cache is only supported with oauth2client<4.0.0\n"
     ]
    }
   ],
   "execution_count": 13
  },
  {
   "cell_type": "code",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-10-02T21:46:12.561634Z",
     "start_time": "2024-10-02T21:43:41.687765Z"
    }
   },
   "source": [
    "for i, email in enumerate(emails[:]):\n",
    "    print(f'Sending email {i+1}/{len(emails)}:')\n",
    "    sent_msg = mailer.send_message(email)\n",
    "    sent.append((email, sent_msg))"
   ],
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[INFO] Message Id: 1924f30615c9bc8e sent.\n",
      "[INFO] Message Id: 1924f306255945d5 sent.\n",
      "[INFO] Message Id: 1924f3065b9e768a sent.\n",
      "[INFO] Message Id: 1924f3067e5513d1 sent.\n",
      "[INFO] Message Id: 1924f3068bd5e050 sent.\n",
      "[INFO] Message Id: 1924f306c82139b0 sent.\n",
      "[INFO] Message Id: 1924f306fa0be0bf sent.\n",
      "[INFO] Message Id: 1924f30729b8c7a5 sent.\n",
      "[INFO] Message Id: 1924f30742ad3d3a sent.\n",
      "[INFO] Message Id: 1924f3077c6c9ff1 sent.\n",
      "[INFO] Message Id: 1924f3079ed60c48 sent.\n",
      "[INFO] Message Id: 1924f307dee8e95e sent.\n",
      "[INFO] Message Id: 1924f307e158d0ed sent.\n",
      "[INFO] Message Id: 1924f3083bfc7287 sent.\n",
      "[INFO] Message Id: 1924f30855a309a7 sent.\n",
      "[INFO] Message Id: 1924f30867d976ab sent.\n",
      "[INFO] Message Id: 1924f308abf52f5a sent.\n",
      "[INFO] Message Id: 1924f308ceb0b561 sent.\n",
      "[INFO] Message Id: 1924f308ea6c4db7 sent.\n",
      "[INFO] Message Id: 1924f3090244d3f0 sent.\n",
      "[INFO] Message Id: 1924f309429b9607 sent.\n",
      "[INFO] Message Id: 1924f3097b66935a sent.\n",
      "[INFO] Message Id: 1924f30983a36bef sent.\n",
      "[INFO] Message Id: 1924f309bd7f61ef sent.\n",
      "[INFO] Message Id: 1924f309e058a8e1 sent.\n",
      "[INFO] Message Id: 1924f30a0eba2142 sent.\n",
      "[INFO] Message Id: 1924f30a3bff27d7 sent.\n",
      "[INFO] Message Id: 1924f30a5d6969fe sent.\n",
      "[INFO] Message Id: 1924f30a87caf69e sent.\n",
      "[INFO] Message Id: 1924f30aa44379f4 sent.\n",
      "[INFO] Message Id: 1924f30ad1c3e82e sent.\n",
      "[INFO] Message Id: 1924f30b097b4d90 sent.\n",
      "[INFO] Message Id: 1924f30b2c01497f sent.\n",
      "[INFO] Message Id: 1924f30b5d8df28e sent.\n",
      "[INFO] Message Id: 1924f30b96c721a7 sent.\n",
      "[INFO] Message Id: 1924f30bb6456956 sent.\n",
      "[INFO] Message Id: 1924f30bdc8545d1 sent.\n",
      "[INFO] Message Id: 1924f30c009e04da sent.\n",
      "[INFO] Message Id: 1924f30c213e874f sent.\n",
      "[INFO] Message Id: 1924f30c43135fb8 sent.\n",
      "[INFO] Message Id: 1924f30c73d8f6a5 sent.\n",
      "[INFO] Message Id: 1924f30cb183ab9f sent.\n",
      "[INFO] Message Id: 1924f30cde260345 sent.\n",
      "[INFO] Message Id: 1924f30cf6d69009 sent.\n",
      "[INFO] Message Id: 1924f30d3b3a3244 sent.\n",
      "[INFO] Message Id: 1924f30d664e5759 sent.\n",
      "[INFO] Message Id: 1924f30d91f204f4 sent.\n",
      "[INFO] Message Id: 1924f30db49d1ab3 sent.\n",
      "[INFO] Message Id: 1924f30dda61f2dd sent.\n",
      "[INFO] Message Id: 1924f30dfa0282df sent.\n",
      "[INFO] Message Id: 1924f30e08cd68fa sent.\n",
      "[INFO] Message Id: 1924f30e4a75dac7 sent.\n",
      "[INFO] Message Id: 1924f30e6f648437 sent.\n",
      "[INFO] Message Id: 1924f30e946370c9 sent.\n",
      "[INFO] Message Id: 1924f30eae2cab39 sent.\n",
      "[INFO] Message Id: 1924f30ee531e215 sent.\n",
      "[INFO] Message Id: 1924f30f2efae3c1 sent.\n",
      "[INFO] Message Id: 1924f30f575f4125 sent.\n",
      "[INFO] Message Id: 1924f30f674eb10c sent.\n",
      "[INFO] Message Id: 1924f30fb0db0e99 sent.\n",
      "[INFO] Message Id: 1924f30fc280f1ef sent.\n",
      "[INFO] Message Id: 1924f31013c6f05f sent.\n",
      "[INFO] Message Id: 1924f31020fc0fba sent.\n",
      "[INFO] Message Id: 1924f3105941109b sent.\n",
      "[INFO] Message Id: 1924f3106f520577 sent.\n",
      "[INFO] Message Id: 1924f310bb9960f1 sent.\n",
      "[INFO] Message Id: 1924f310cccfa0f0 sent.\n",
      "[INFO] Message Id: 1924f310f916bb34 sent.\n",
      "[INFO] Message Id: 1924f3111976cda4 sent.\n",
      "[INFO] Message Id: 1924f311324d36a7 sent.\n",
      "[INFO] Message Id: 1924f31162713120 sent.\n",
      "[INFO] Message Id: 1924f311bda7d539 sent.\n",
      "[INFO] Message Id: 1924f311d7597c91 sent.\n",
      "[INFO] Message Id: 1924f311f6ce9a8e sent.\n",
      "[INFO] Message Id: 1924f312d0d0eb0f sent.\n",
      "[INFO] Message Id: 1924f312f0f9f33d sent.\n",
      "[INFO] Message Id: 1924f313130fc5d7 sent.\n",
      "[INFO] Message Id: 1924f31350a3b4b4 sent.\n",
      "[INFO] Message Id: 1924f31370e42556 sent.\n",
      "[INFO] Message Id: 1924f31392953da5 sent.\n",
      "[INFO] Message Id: 1924f313a3e78c4f sent.\n",
      "[INFO] Message Id: 1924f313e72beb56 sent.\n",
      "[INFO] Message Id: 1924f3140bf7f399 sent.\n",
      "[INFO] Message Id: 1924f3143fc6a42b sent.\n",
      "[INFO] Message Id: 1924f31454ce4b6e sent.\n",
      "[INFO] Message Id: 1924f3147b76cbd7 sent.\n",
      "[INFO] Message Id: 1924f314918b3525 sent.\n",
      "[INFO] Message Id: 1924f314cff567d1 sent.\n",
      "[INFO] Message Id: 1924f314e4d9bb49 sent.\n",
      "[INFO] Message Id: 1924f3150c41c8f7 sent.\n",
      "[INFO] Message Id: 1924f31556cd64a8 sent.\n",
      "[INFO] Message Id: 1924f3156f55a76e sent.\n",
      "[INFO] Message Id: 1924f3159c30d53e sent.\n",
      "[INFO] Message Id: 1924f315b15803ba sent.\n",
      "[INFO] Message Id: 1924f315c9b949bf sent.\n",
      "[INFO] Message Id: 1924f315e9be1130 sent.\n",
      "[INFO] Message Id: 1924f31616c2f800 sent.\n",
      "[INFO] Message Id: 1924f3163c101c15 sent.\n",
      "[INFO] Message Id: 1924f3167eb372c4 sent.\n",
      "[INFO] Message Id: 1924f3169d71b6ee sent.\n",
      "[INFO] Message Id: 1924f316bc373639 sent.\n",
      "[INFO] Message Id: 1924f316d4b57382 sent.\n",
      "[INFO] Message Id: 1924f3170c86bb35 sent.\n",
      "[INFO] Message Id: 1924f3173a6fd99d sent.\n",
      "[INFO] Message Id: 1924f3174cff3d1d sent.\n",
      "[INFO] Message Id: 1924f317665e764c sent.\n",
      "[INFO] Message Id: 1924f31792b619b8 sent.\n",
      "[INFO] Message Id: 1924f317d1f51f30 sent.\n",
      "[INFO] Message Id: 1924f317fac08365 sent.\n",
      "[INFO] Message Id: 1924f318027e8ebd sent.\n",
      "[INFO] Message Id: 1924f31822ab823f sent.\n",
      "[INFO] Message Id: 1924f3185e1e6861 sent.\n",
      "[INFO] Message Id: 1924f31877926f48 sent.\n",
      "[INFO] Message Id: 1924f318a9713581 sent.\n",
      "[INFO] Message Id: 1924f318d92efdfb sent.\n",
      "[INFO] Message Id: 1924f318f2cc6d9c sent.\n",
      "[INFO] Message Id: 1924f31907171871 sent.\n",
      "[INFO] Message Id: 1924f3195f96f241 sent.\n",
      "[INFO] Message Id: 1924f319adec36f7 sent.\n",
      "[INFO] Message Id: 1924f319c5ed75ef sent.\n",
      "[INFO] Message Id: 1924f319ffb7de59 sent.\n",
      "[INFO] Message Id: 1924f31a11461212 sent.\n",
      "[INFO] Message Id: 1924f31a34e8ce45 sent.\n",
      "[INFO] Message Id: 1924f31a563c552c sent.\n",
      "[INFO] Message Id: 1924f31a97ca8963 sent.\n",
      "[INFO] Message Id: 1924f31ab993410a sent.\n",
      "[INFO] Message Id: 1924f31add65bb99 sent.\n",
      "[INFO] Message Id: 1924f31af4f65d88 sent.\n",
      "[INFO] Message Id: 1924f31b27a92dcd sent.\n",
      "[INFO] Message Id: 1924f31b41567c15 sent.\n",
      "[INFO] Message Id: 1924f31b688fe26f sent.\n",
      "[INFO] Message Id: 1924f31b8707f49b sent.\n",
      "[INFO] Message Id: 1924f31bbaee82c6 sent.\n",
      "[INFO] Message Id: 1924f31bf08f49fa sent.\n",
      "[INFO] Message Id: 1924f31c06bba2c9 sent.\n",
      "[INFO] Message Id: 1924f31c4b3b0e5d sent.\n",
      "[INFO] Message Id: 1924f31c6f81f663 sent.\n",
      "[INFO] Message Id: 1924f31c9dfbc2b6 sent.\n",
      "[INFO] Message Id: 1924f31cad45db06 sent.\n",
      "[INFO] Message Id: 1924f31ccfa2a157 sent.\n",
      "[INFO] Message Id: 1924f31d130f57d0 sent.\n",
      "[INFO] Message Id: 1924f31d2a52cf90 sent.\n",
      "[INFO] Message Id: 1924f31d55fa9c58 sent.\n",
      "[INFO] Message Id: 1924f31d7af30d42 sent.\n",
      "[INFO] Message Id: 1924f31d881c30e6 sent.\n",
      "[INFO] Message Id: 1924f31dde319fad sent.\n",
      "[INFO] Message Id: 1924f31dfa352ba3 sent.\n",
      "[INFO] Message Id: 1924f31e0b7736d2 sent.\n",
      "[INFO] Message Id: 1924f31e55f1d41f sent.\n",
      "[INFO] Message Id: 1924f31e65ed4f1d sent.\n",
      "[INFO] Message Id: 1924f31e9d37d62d sent.\n",
      "[INFO] Message Id: 1924f31ea58294d0 sent.\n",
      "[INFO] Message Id: 1924f31ece40704b sent.\n",
      "[INFO] Message Id: 1924f31f1ce89173 sent.\n",
      "[INFO] Message Id: 1924f31f39fad388 sent.\n",
      "[INFO] Message Id: 1924f31f59cdcc4c sent.\n",
      "[INFO] Message Id: 1924f31f6c6fd8d6 sent.\n",
      "[INFO] Message Id: 1924f31fb1b72933 sent.\n",
      "[INFO] Message Id: 1924f31fce0eba8c sent.\n",
      "[INFO] Message Id: 1924f31fe2002483 sent.\n",
      "[INFO] Message Id: 1924f3203a9b393f sent.\n",
      "[INFO] Message Id: 1924f3206591ceca sent.\n",
      "[INFO] Message Id: 1924f3208d778b4c sent.\n",
      "[INFO] Message Id: 1924f320a6b01996 sent.\n",
      "[INFO] Message Id: 1924f320c15329c2 sent.\n",
      "[INFO] Message Id: 1924f320eadbb7a7 sent.\n",
      "[INFO] Message Id: 1924f3212caed271 sent.\n",
      "[INFO] Message Id: 1924f3214e87beb9 sent.\n",
      "[INFO] Message Id: 1924f321658a52c4 sent.\n",
      "[INFO] Message Id: 1924f32195aaeb1d sent.\n",
      "[INFO] Message Id: 1924f321d6056fb6 sent.\n",
      "[INFO] Message Id: 1924f321f2f27881 sent.\n",
      "[INFO] Message Id: 1924f32213ca6d34 sent.\n",
      "[INFO] Message Id: 1924f3223ae47dcc sent.\n",
      "[INFO] Message Id: 1924f3226f24ffcb sent.\n",
      "[INFO] Message Id: 1924f322979c3b5e sent.\n",
      "[INFO] Message Id: 1924f322a26096d8 sent.\n",
      "[INFO] Message Id: 1924f322c782df62 sent.\n",
      "[INFO] Message Id: 1924f322e77f76cc sent.\n",
      "[INFO] Message Id: 1924f3230fcea234 sent.\n",
      "[INFO] Message Id: 1924f3235ac6f594 sent.\n",
      "[INFO] Message Id: 1924f3237cb76167 sent.\n",
      "[INFO] Message Id: 1924f323abf0a8b4 sent.\n",
      "[INFO] Message Id: 1924f323c233664e sent.\n",
      "[INFO] Message Id: 1924f323e0529540 sent.\n",
      "[INFO] Message Id: 1924f32410a8cdf9 sent.\n",
      "[INFO] Message Id: 1924f3245821f665 sent.\n",
      "[INFO] Message Id: 1924f3246494e6fd sent.\n",
      "[INFO] Message Id: 1924f32491116b61 sent.\n",
      "[INFO] Message Id: 1924f324af29dd34 sent.\n",
      "[INFO] Message Id: 1924f324c6d11190 sent.\n",
      "[INFO] Message Id: 1924f32513579b5d sent.\n",
      "[INFO] Message Id: 1924f32558f3ed29 sent.\n",
      "[INFO] Message Id: 1924f325723e8d8e sent.\n",
      "[INFO] Message Id: 1924f3258c4ddc52 sent.\n",
      "[INFO] Message Id: 1924f325a6bbfb93 sent.\n",
      "[INFO] Message Id: 1924f325c69da3c9 sent.\n",
      "[INFO] Message Id: 1924f325e7d35a22 sent.\n",
      "[INFO] Message Id: 1924f32603a28426 sent.\n",
      "[INFO] Message Id: 1924f3264a8de618 sent.\n",
      "[INFO] Message Id: 1924f32670f4ac87 sent.\n",
      "[INFO] Message Id: 1924f326809b238a sent.\n",
      "[INFO] Message Id: 1924f326ce708c4c sent.\n",
      "[INFO] Message Id: 1924f326eed591db sent.\n",
      "[INFO] Message Id: 1924f3271991533f sent.\n",
      "[INFO] Message Id: 1924f32732601d42 sent.\n",
      "[INFO] Message Id: 1924f3276084f766 sent.\n",
      "[INFO] Message Id: 1924f3279612bb89 sent.\n",
      "[INFO] Message Id: 1924f327a47ab272 sent.\n",
      "[INFO] Message Id: 1924f327cf1ae42e sent.\n",
      "[INFO] Message Id: 1924f32813aedbfb sent.\n",
      "[INFO] Message Id: 1924f32833283d9b sent.\n",
      "[INFO] Message Id: 1924f32852c9b4c2 sent.\n",
      "[INFO] Message Id: 1924f3287ef257ae sent.\n",
      "[INFO] Message Id: 1924f328a77b8539 sent.\n",
      "[INFO] Message Id: 1924f328ce01c6f1 sent.\n",
      "[INFO] Message Id: 1924f328e9b482fe sent.\n",
      "[INFO] Message Id: 1924f32910228c8e sent.\n",
      "[INFO] Message Id: 1924f32948333f07 sent.\n",
      "[INFO] Message Id: 1924f32965f25a3a sent.\n",
      "[INFO] Message Id: 1924f3298814ae36 sent.\n",
      "[INFO] Message Id: 1924f329ae4fa709 sent.\n",
      "[INFO] Message Id: 1924f329cccd77e8 sent.\n",
      "[INFO] Message Id: 1924f329ea32c70d sent.\n",
      "[INFO] Message Id: 1924f32a1cc469c2 sent.\n",
      "[INFO] Message Id: 1924f32a492756f7 sent.\n",
      "[INFO] Message Id: 1924f32a6af56f52 sent.\n"
     ]
    }
   ],
   "execution_count": 14
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}