Archive-Database.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "The default Firebase app already exists. This means you called initialize_app() more than once without providing an app name as the second argument. In most cases you only need to call initialize_app() once. But if you do want to initialize multiple apps, pass a second argument to initialize_app() to give each app a unique name.",
     "output_type": "error",
     "traceback": [
      "\u001B[0;31m---------------------------------------------------------------------------\u001B[0m",
      "\u001B[0;31mValueError\u001B[0m                                Traceback (most recent call last)",
      "Cell \u001B[0;32mIn[6], line 7\u001B[0m\n\u001B[1;32m      5\u001B[0m \u001B[38;5;66;03m# Use the application default credentials\u001B[39;00m\n\u001B[1;32m      6\u001B[0m cred \u001B[38;5;241m=\u001B[39m credentials\u001B[38;5;241m.\u001B[39mCertificate(\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mkeys/finanzaktion-db-key.json\u001B[39m\u001B[38;5;124m'\u001B[39m)\n\u001B[0;32m----> 7\u001B[0m \u001B[43mfirebase_admin\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43minitialize_app\u001B[49m\u001B[43m(\u001B[49m\u001B[43mcred\u001B[49m\u001B[43m)\u001B[49m\n\u001B[1;32m      8\u001B[0m db \u001B[38;5;241m=\u001B[39m firestore\u001B[38;5;241m.\u001B[39mclient()\n",
      "File \u001B[0;32m~/.local/lib/python3.10/site-packages/firebase_admin/__init__.py:71\u001B[0m, in \u001B[0;36minitialize_app\u001B[0;34m(credential, options, name)\u001B[0m\n\u001B[1;32m     68\u001B[0m         \u001B[38;5;28;01mreturn\u001B[39;00m app\n\u001B[1;32m     70\u001B[0m \u001B[38;5;28;01mif\u001B[39;00m name \u001B[38;5;241m==\u001B[39m _DEFAULT_APP_NAME:\n\u001B[0;32m---> 71\u001B[0m     \u001B[38;5;28;01mraise\u001B[39;00m \u001B[38;5;167;01mValueError\u001B[39;00m((\n\u001B[1;32m     72\u001B[0m         \u001B[38;5;124m'\u001B[39m\u001B[38;5;124mThe default Firebase app already exists. This means you called \u001B[39m\u001B[38;5;124m'\u001B[39m\n\u001B[1;32m     73\u001B[0m         \u001B[38;5;124m'\u001B[39m\u001B[38;5;124minitialize_app() more than once without providing an app name as \u001B[39m\u001B[38;5;124m'\u001B[39m\n\u001B[1;32m     74\u001B[0m         \u001B[38;5;124m'\u001B[39m\u001B[38;5;124mthe second argument. In most cases you only need to call \u001B[39m\u001B[38;5;124m'\u001B[39m\n\u001B[1;32m     75\u001B[0m         \u001B[38;5;124m'\u001B[39m\u001B[38;5;124minitialize_app() once. But if you do want to initialize multiple \u001B[39m\u001B[38;5;124m'\u001B[39m\n\u001B[1;32m     76\u001B[0m         \u001B[38;5;124m'\u001B[39m\u001B[38;5;124mapps, pass a second argument to initialize_app() to give each app \u001B[39m\u001B[38;5;124m'\u001B[39m\n\u001B[1;32m     77\u001B[0m         \u001B[38;5;124m'\u001B[39m\u001B[38;5;124ma unique name.\u001B[39m\u001B[38;5;124m'\u001B[39m))\n\u001B[1;32m     79\u001B[0m \u001B[38;5;28;01mraise\u001B[39;00m \u001B[38;5;167;01mValueError\u001B[39;00m((\n\u001B[1;32m     80\u001B[0m     \u001B[38;5;124m'\u001B[39m\u001B[38;5;124mFirebase app named \u001B[39m\u001B[38;5;124m\"\u001B[39m\u001B[38;5;132;01m{0}\u001B[39;00m\u001B[38;5;124m\"\u001B[39m\u001B[38;5;124m already exists. This means you called \u001B[39m\u001B[38;5;124m'\u001B[39m\n\u001B[1;32m     81\u001B[0m     \u001B[38;5;124m'\u001B[39m\u001B[38;5;124minitialize_app() more than once with the same app name as the \u001B[39m\u001B[38;5;124m'\u001B[39m\n\u001B[1;32m     82\u001B[0m     \u001B[38;5;124m'\u001B[39m\u001B[38;5;124msecond argument. Make sure you provide a unique name every time \u001B[39m\u001B[38;5;124m'\u001B[39m\n\u001B[1;32m     83\u001B[0m     \u001B[38;5;124m'\u001B[39m\u001B[38;5;124myou call initialize_app().\u001B[39m\u001B[38;5;124m'\u001B[39m)\u001B[38;5;241m.\u001B[39mformat(name))\n",
      "\u001B[0;31mValueError\u001B[0m: The default Firebase app already exists. This means you called initialize_app() more than once without providing an app name as the second argument. In most cases you only need to call initialize_app() once. But if you do want to initialize multiple apps, pass a second argument to initialize_app() to give each app a unique name."
     ]
    }
   ],
   "source": [
    "import firebase_admin\n",
    "from firebase_admin import credentials, firestore\n",
    "\n",
    "\n",
    "# Use the application default credentials\n",
    "cred = credentials.Certificate('keys/finanzaktion-db-key.json')\n",
    "firebase_admin.initialize_app(cred)\n",
    "db = firestore.client()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "ExecuteTime": {
     "start_time": "2023-04-22T18:11:03.904338Z",
     "end_time": "2023-04-22T18:11:03.948001Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": "<generator object Query.stream at 0x7fc3e08b2420>"
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sponsoren_ref = db.collection(u'sponsoren').stream()\n",
    "sponsoren_ref"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "ExecuteTime": {
     "start_time": "2023-04-22T18:11:04.954471Z",
     "end_time": "2023-04-22T18:11:05.176345Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": "[{'notes': '',\n  'sponsor_of': 'LtlIx1m3Kt2kJCZIlUKO',\n  'address_street': 'Kanzleistr. 215',\n  'id': '5WzLkPypS2H5eR9dWGFs',\n  'delivery_method': 'mail',\n  'first_name': 'Daniel',\n  'donation_type': 'per_goal',\n  'access': {'a7eareIp7vN2PlQMUXvPP8uQmku2': 'owner'},\n  'email': 'dnl.luethi@gmail.ch',\n  'address_plz': '8004',\n  'address_city': 'Zürich',\n  'amount': '2',\n  'last_name': 'Lüthi'},\n {'notes': '',\n  'sponsor_of': '5ty99yTbZrrhDp2SRcFe',\n  'address_street': 'Regensbergrtasse 160',\n  'id': 'exgBm9LNxIjvapljQcnm',\n  'delivery_method': 'mail',\n  'first_name': 'Veragioia',\n  'donation_type': 'per_goal',\n  'access': {'uhlIGGtXD2etqx4Y9uTIxAJEcRJ2': 'owner'},\n  'email': 'gioiapan@hotmail.com',\n  'address_plz': '8050',\n  'address_city': 'Zürich',\n  'amount': '10',\n  'last_name': 'Pangrazzi '},\n {'last_name': 'Pfister',\n  'sponsor_of': '9diMwOzQ0DvQ5Ua1mmKk',\n  'address_street': 'Bodenacker 10',\n  'delivery_method': 'mail',\n  'first_name': 'Christoph',\n  'donation_type': 'per_goal',\n  'access': {'8mX4M5ckrVMQsmEVKJc1rjHZ7Np1': 'owner'},\n  'email': 'chrispfister@bluewin.ch',\n  'address_plz': '8046',\n  'address_city': 'Zürich',\n  'amount': '2',\n  'notes': ''},\n {'last_name': 'Strub',\n  'sponsor_of': 'sArbeCUonDNYVnVKvg8Z',\n  'address_street': 'Ulrichstr. 17',\n  'delivery_method': 'mail',\n  'first_name': 'Jean-Daniel',\n  'donation_type': 'per_goal',\n  'access': {'9u0djKaFZnOAZWR42Gw65yXVXXW2': 'owner'},\n  'email': 'jdstrub@gmx.net',\n  'address_plz': '8032',\n  'address_city': 'Zürich ',\n  'amount': '5',\n  'notes': 'MAXIMALBETRAG 100.-'},\n {'last_name': 'Fauster',\n  'sponsor_of': 'EjEhXkpDSkNjqtPhXsM5',\n  'address_street': 'Hirschgartnerweg 24',\n  'delivery_method': 'mail',\n  'first_name': 'Barbara',\n  'donation_type': 'per_goal',\n  'access': {'WqYIZwf9IGXA33WNdmtH2of19rn1': 'owner'},\n  'email': 'swift@cevi.ch',\n  'address_plz': '8057',\n  'address_city': 'Zürich',\n  'amount': '2',\n  'notes': ''},\n {'notes': '',\n  'sponsor_of': 'I06DH4bG9rMsYsrXNnFh',\n  'address_street': 'Zürichbergstrasse 46a',\n  'id': 'OKn5tU4pDttiesNJRTrH',\n  'delivery_method': 'mail',\n  'first_name': 'Conrad',\n  'donation_type': 'per_goal',\n  'access': {'uhlIGGtXD2etqx4Y9uTIxAJEcRJ2': 'owner'},\n  'email': 'vondercrone@cronwal.ch',\n  'address_plz': '8044',\n  'address_city': 'Zürich ',\n  'amount': '10',\n  'last_name': 'von der Crone'},\n {'notes': '',\n  'sponsor_of': '4VrFWnYZqJNd1Mh0twxC',\n  'address_street': 'Heusser-Staub-Strasse 37',\n  'id': '0zepjiNTjOLCJUyQiFAw',\n  'first_name': 'Philipp',\n  'delivery_method': 'mail',\n  'donation_type': 'per_goal',\n  'access': {'yD5GfoqboANlKbpmsOBIIm0pbAj1': 'owner'},\n  'email': 'philipp@cevi.ch',\n  'address_plz': '8610',\n  'address_city': 'Uster',\n  'amount': '3',\n  'last_name': 'Widmer'},\n {'last_name': 'Fauster',\n  'sponsor_of': 'FvCe7xpwdlawfQVsvUi6',\n  'address_street': 'Lerchenberg 43',\n  'delivery_method': 'post_participant',\n  'first_name': 'Hansruedi',\n  'donation_type': 'fixed',\n  'access': {'TWZr7WD8mzSZvIYco5ULB7tx7Up1': 'owner'},\n  'email': '',\n  'address_plz': '8047',\n  'address_city': 'Zürich',\n  'amount': '20',\n  'notes': ''},\n {'last_name': 'Fauster',\n  'sponsor_of': 'EjEhXkpDSkNjqtPhXsM5',\n  'address_street': 'Hirschgartnerweg 24',\n  'delivery_method': 'post_participant',\n  'first_name': 'Marcus',\n  'donation_type': 'per_goal',\n  'access': {'WqYIZwf9IGXA33WNdmtH2of19rn1': 'owner'},\n  'email': '',\n  'address_plz': '8057',\n  'address_city': 'Zürich',\n  'amount': '3',\n  'notes': ''},\n {'last_name': 'Weber-Ritter',\n  'sponsor_of': 'sArbeCUonDNYVnVKvg8Z',\n  'address_street': 'Chilegass 10',\n  'delivery_method': 'mail',\n  'first_name': 'Barbara',\n  'donation_type': 'per_goal',\n  'access': {'9u0djKaFZnOAZWR42Gw65yXVXXW2': 'owner'},\n  'email': 'blaliri@bluemail.ch',\n  'address_plz': '8193',\n  'address_city': 'Eglisau',\n  'amount': '2',\n  'notes': ''},\n {'last_name': 'Fauster',\n  'sponsor_of': 'EjEhXkpDSkNjqtPhXsM5',\n  'address_street': 'Lerchenberg 43',\n  'delivery_method': 'post_participant',\n  'first_name': 'Hansruedi',\n  'donation_type': 'fixed',\n  'access': {'WqYIZwf9IGXA33WNdmtH2of19rn1': 'owner'},\n  'email': '',\n  'address_plz': '8047',\n  'address_city': 'Zürich',\n  'amount': '20',\n  'notes': ''},\n {'last_name': 'Fauster',\n  'sponsor_of': 'FvCe7xpwdlawfQVsvUi6',\n  'address_street': 'Hirschgartnerweg 24',\n  'delivery_method': 'post_participant',\n  'first_name': 'Cedric',\n  'donation_type': 'per_goal',\n  'access': {'TWZr7WD8mzSZvIYco5ULB7tx7Up1': 'owner'},\n  'email': '',\n  'address_plz': '8057',\n  'address_city': 'Zürich',\n  'amount': '1',\n  'notes': ''},\n {'notes': '',\n  'sponsor_of': 'LtlIx1m3Kt2kJCZIlUKO',\n  'address_street': 'Lechenberg 43',\n  'id': 'BcWQz0Njw0LY4kiCuMqY',\n  'delivery_method': 'mail',\n  'first_name': 'Peter',\n  'donation_type': 'per_goal',\n  'access': {'a7eareIp7vN2PlQMUXvPP8uQmku2': 'owner'},\n  'email': 'Pegeluethi@bluewin.ch',\n  'address_plz': '8046',\n  'address_city': 'Zürich',\n  'amount': '2',\n  'last_name': 'Lüti'},\n {'last_name': 'Meier',\n  'sponsor_of': '4VrFWnYZqJNd1Mh0twxC',\n  'address_street': 'Malvenstrasse',\n  'first_name': 'Mara',\n  'delivery_method': 'mail',\n  'donation_type': 'per_goal',\n  'access': {'yD5GfoqboANlKbpmsOBIIm0pbAj1': 'owner'},\n  'email': 'meier.mara@icloud.com',\n  'address_plz': '8057',\n  'address_city': 'Zürich',\n  'amount': '0.50',\n  'notes': ''},\n {'last_name': 'Leonforte',\n  'sponsor_of': 'JaOmAN3hwcSHLOCkaPcn',\n  'address_street': 'Giebeleich 4',\n  'delivery_method': 'mail',\n  'first_name': 'Christina ',\n  'donation_type': 'fixed',\n  'access': {'HzRLiMySHEYIhl213GA6kwD11Sq2': 'owner'},\n  'email': 'c.leonforte@gmx.ch',\n  'address_plz': '8052',\n  'address_city': 'Zürich',\n  'amount': '10',\n  'notes': ''},\n {'last_name': 'Lienhard',\n  'sponsor_of': 'd59gBVvvNuZorzN1UzEy',\n  'address_street': 'Glärnischstr. 148',\n  'delivery_method': 'mail',\n  'first_name': 'Ernst',\n  'donation_type': 'fixed',\n  'access': {'9u0djKaFZnOAZWR42Gw65yXVXXW2': 'owner'},\n  'email': 'ernst.lienhard@hispeed.ch',\n  'address_plz': '8708',\n  'address_city': 'Männedorf',\n  'amount': '50',\n  'notes': ''},\n {'last_name': 'Strub-Jaccoud',\n  'sponsor_of': 'd59gBVvvNuZorzN1UzEy',\n  'address_street': 'Alte Landstraße 1',\n  'delivery_method': 'mail',\n  'first_name': 'Madeleine&Hans',\n  'donation_type': 'per_goal',\n  'access': {'9u0djKaFZnOAZWR42Gw65yXVXXW2': 'owner'},\n  'email': 'madeleine.strub@bluewin.ch',\n  'address_plz': '8708',\n  'address_city': 'Männedorf ',\n  'amount': '5',\n  'notes': 'MAXIMALBETRAG 100.-'},\n {'last_name': 'Hagymas',\n  'sponsor_of': 'SYjqw9yaTL3Te8R2ZSD9',\n  'address_street': 'Sandbüelstrasse 36',\n  'delivery_method': 'mail',\n  'first_name': 'Silvia ',\n  'donation_type': 'fixed',\n  'access': {'HzRLiMySHEYIhl213GA6kwD11Sq2': 'owner'},\n  'email': 'darudombi@ggaweb.ch',\n  'address_plz': '8052',\n  'address_city': 'Zürich',\n  'amount': '50',\n  'notes': ''},\n {'last_name': 'Fauster',\n  'sponsor_of': 'FvCe7xpwdlawfQVsvUi6',\n  'address_street': 'Hirschgartnerweg 24',\n  'delivery_method': 'mail',\n  'first_name': 'Barbara',\n  'donation_type': 'per_goal',\n  'access': {'TWZr7WD8mzSZvIYco5ULB7tx7Up1': 'owner'},\n  'email': 'swift@cevi.ch',\n  'address_plz': '8057',\n  'address_city': 'Zürich',\n  'amount': '2',\n  'notes': ''},\n {'notes': '',\n  'sponsor_of': 'I06DH4bG9rMsYsrXNnFh',\n  'address_street': 'Regensbergstrasse 160',\n  'id': 'EM3IgA0xqDUzrrvQgxxC',\n  'delivery_method': 'mail',\n  'first_name': 'Veragioia ',\n  'donation_type': 'per_goal',\n  'access': {'uhlIGGtXD2etqx4Y9uTIxAJEcRJ2': 'owner'},\n  'email': 'gioiapan@hotmail.com',\n  'address_plz': '8050',\n  'address_city': 'Zürich',\n  'amount': '10',\n  'last_name': 'Pangrazzi '},\n {'last_name': 'Fauster',\n  'sponsor_of': 'kxv1GGIvzjOlnhhn0rJI',\n  'address_street': 'Hirschgartnerweg 24',\n  'delivery_method': 'post_participant',\n  'first_name': 'Marcus',\n  'donation_type': 'per_goal',\n  'access': {'WygEF9tALcWEiFdwHxS7JeWmlbF3': 'owner'},\n  'email': '',\n  'address_plz': '8057',\n  'address_city': 'Zürich',\n  'amount': '3',\n  'notes': ''},\n {'last_name': 'Pfister',\n  'sponsor_of': '5qIl66ZoAbcYOTcJOvuS',\n  'address_street': 'Bodenacker 10',\n  'delivery_method': 'mail',\n  'first_name': 'Christoph',\n  'donation_type': 'per_goal',\n  'access': {'8mX4M5ckrVMQsmEVKJc1rjHZ7Np1': 'owner'},\n  'email': 'chrispfister@bluewin.ch',\n  'address_plz': '8046',\n  'address_city': 'Zürich',\n  'amount': '2',\n  'notes': ''},\n {'last_name': 'Hagymas',\n  'sponsor_of': 'JaOmAN3hwcSHLOCkaPcn',\n  'address_street': 'Sandbüelstrasse 36',\n  'delivery_method': 'mail',\n  'first_name': 'Elisabeth',\n  'donation_type': 'fixed',\n  'access': {'HzRLiMySHEYIhl213GA6kwD11Sq2': 'owner'},\n  'email': 'darudombi@ggaweb.ch',\n  'address_plz': '8606',\n  'address_city': 'Greifensee ',\n  'amount': '50.0',\n  'notes': ''},\n {'last_name': 'Hürlimann',\n  'sponsor_of': 'FvCe7xpwdlawfQVsvUi6',\n  'address_street': 'Linth-Escher-Strasse 6',\n  'delivery_method': 'post_participant',\n  'first_name': 'Hans',\n  'donation_type': 'fixed',\n  'access': {'TWZr7WD8mzSZvIYco5ULB7tx7Up1': 'owner'},\n  'email': '',\n  'address_plz': '8867',\n  'address_city': 'Niederurnen',\n  'amount': '50',\n  'notes': ''},\n {'notes': '',\n  'sponsor_of': 'qO7YbL5GM2KLlCGk1kmQ',\n  'address_street': 'Oberwiesenstrasse 72',\n  'id': 'vpsK71ZhtnrQ25i1n0R7',\n  'delivery_method': 'post_participant',\n  'first_name': 'Hedi',\n  'donation_type': 'per_goal',\n  'access': {'SQbdtfmTPmhjxHju5gP7VDIjg1q1': 'owner'},\n  'email': '',\n  'address_plz': '8046',\n  'address_city': 'Zürich ',\n  'amount': '1',\n  'last_name': 'Luterbach '},\n {'last_name': 'Schudel',\n  'sponsor_of': 'EjEhXkpDSkNjqtPhXsM5',\n  'address_street': 'Regina-Kägi-Hof 07',\n  'delivery_method': 'post_participant',\n  'first_name': 'Marius',\n  'donation_type': 'per_goal',\n  'access': {'WqYIZwf9IGXA33WNdmtH2of19rn1': 'owner'},\n  'email': '',\n  'address_plz': '8050',\n  'address_city': 'Zürich',\n  'amount': '2.50',\n  'notes': ''},\n {'last_name': 'Hürlimann',\n  'sponsor_of': 'EjEhXkpDSkNjqtPhXsM5',\n  'address_street': 'Rebhaldenstrasse 27',\n  'delivery_method': 'post_participant',\n  'first_name': 'Roger',\n  'donation_type': 'fixed',\n  'access': {'WqYIZwf9IGXA33WNdmtH2of19rn1': 'owner'},\n  'email': '',\n  'address_plz': '8340',\n  'address_city': 'Hinwil',\n  'amount': '40',\n  'notes': ''},\n {'last_name': 'Hürlimann',\n  'sponsor_of': 'kxv1GGIvzjOlnhhn0rJI',\n  'address_street': 'Linth-Escher-Strasse 6',\n  'delivery_method': 'post_participant',\n  'first_name': 'Hans',\n  'donation_type': 'fixed',\n  'access': {'WygEF9tALcWEiFdwHxS7JeWmlbF3': 'owner'},\n  'email': '',\n  'address_plz': '8867',\n  'address_city': 'Niederurnen',\n  'amount': '50',\n  'notes': ''},\n {'last_name': 'Bänninger',\n  'sponsor_of': 'hoJrBP4vxjXpo92LH5FX',\n  'address_street': 'Hirschgartnerweg 37',\n  'id': 'OUIwRVblzkthOViKQfTD',\n  'delivery_method': 'mail',\n  'first_name': 'Brigitte',\n  'donation_type': 'per_goal',\n  'access': {'yD5GfoqboANlKbpmsOBIIm0pbAj1': 'owner'},\n  'email': 'brigitte.baenninger@sunrise.ch',\n  'address_plz': '8057',\n  'address_city': 'Zürich',\n  'amount': '5',\n  'notes': ''},\n {'last_name': 'Ramoni',\n  'sponsor_of': 'iL4RifnFDMCP7HT4WXDC',\n  'address_street': 'Höhenring 20',\n  'delivery_method': 'mail',\n  'first_name': 'Marco',\n  'donation_type': 'fixed',\n  'access': {'4qStUvRYvTT5yG1VKNx1Gs4LsCs1': 'owner'},\n  'email': 'marco.ramoni@yahoo.de',\n  'address_plz': '8052',\n  'address_city': 'Zürich ',\n  'amount': '150',\n  'notes': 'Sammelspende ganzer Familie '},\n {'last_name': 'Pfister',\n  'sponsor_of': '4SvF1AyWS1OmHtIxhWZX',\n  'address_street': 'Bodenacker 10',\n  'delivery_method': 'mail',\n  'first_name': 'Christoph',\n  'donation_type': 'per_goal',\n  'access': {'8mX4M5ckrVMQsmEVKJc1rjHZ7Np1': 'owner'},\n  'email': 'chrispfister@bluewin.ch',\n  'address_plz': '8046',\n  'address_city': 'Zürich',\n  'amount': '2',\n  'notes': ''},\n {'last_name': 'Strub-Lienhard ',\n  'sponsor_of': 'd59gBVvvNuZorzN1UzEy',\n  'address_street': 'Oberwiesenstrasse 45',\n  'delivery_method': 'mail',\n  'first_name': 'Karin&Lukas',\n  'donation_type': 'fixed',\n  'access': {'9u0djKaFZnOAZWR42Gw65yXVXXW2': 'owner'},\n  'email': 'lukasstrub@hotmail.com',\n  'address_plz': '8050',\n  'address_city': 'Zürich ',\n  'amount': '150',\n  'notes': ''},\n {'notes': '',\n  'sponsor_of': 'petQRzPlJvSoRG0y2N4c',\n  'address_street': 'Erchenbühlstrasse 40',\n  'id': 'C9l9yxxbNYEfoI7iPm3j',\n  'delivery_method': 'mail',\n  'first_name': 'Oliver',\n  'access': {'4R9GoQtPxCPADDA8nwDc2IrcTB93': 'owner'},\n  'donation_type': 'fixed',\n  'email': 'jpg@zh11.ch',\n  'address_plz': '8046',\n  'address_city': 'Zürich',\n  'amount': '50',\n  'last_name': 'Hänsli'},\n {'last_name': 'Fauster',\n  'sponsor_of': 'EjEhXkpDSkNjqtPhXsM5',\n  'address_street': 'Hirschgartnerweg 24',\n  'delivery_method': 'post_participant',\n  'first_name': 'Lucien',\n  'donation_type': 'per_goal',\n  'access': {'WqYIZwf9IGXA33WNdmtH2of19rn1': 'owner'},\n  'email': '',\n  'address_plz': '8057',\n  'address_city': 'Zürich',\n  'amount': '1',\n  'notes': ''},\n {'last_name': 'Fauster',\n  'sponsor_of': 'kxv1GGIvzjOlnhhn0rJI',\n  'address_street': 'Hirschgartnerweg , 24',\n  'delivery_method': 'mail',\n  'first_name': 'Cedric',\n  'donation_type': 'per_goal',\n  'access': {'WygEF9tALcWEiFdwHxS7JeWmlbF3': 'owner'},\n  'email': 'chnobli@zh11.ch',\n  'address_plz': '8057',\n  'address_city': 'Zürich',\n  'amount': '1',\n  'notes': ''},\n {'last_name': 'Knecht',\n  'sponsor_of': 'FvCe7xpwdlawfQVsvUi6',\n  'address_street': 'Rebsteig 19',\n  'delivery_method': 'post_participant',\n  'first_name': 'Janine',\n  'donation_type': 'fixed',\n  'access': {'TWZr7WD8mzSZvIYco5ULB7tx7Up1': 'owner'},\n  'email': '',\n  'address_plz': '8154',\n  'address_city': 'Oberglatt',\n  'amount': '50',\n  'notes': ''},\n {'notes': '',\n  'sponsor_of': 'no3aXFPtHkqI8uCmoV3Z',\n  'address_street': 'Katzenbachstrasse 41',\n  'id': 'F9IL3honaOFX6fumxWyH',\n  'delivery_method': 'mail',\n  'first_name': 'Maya',\n  'donation_type': 'fixed',\n  'access': {'fv2t4wYv1aecqZrRPbtV4xrdqBw2': 'owner'},\n  'email': 'schaerermueller@bluewin.ch',\n  'address_plz': '8052',\n  'address_city': 'Zürich',\n  'amount': '60.00',\n  'last_name': 'Schärer'},\n {'last_name': 'Grunder',\n  'sponsor_of': '9diMwOzQ0DvQ5Ua1mmKk',\n  'address_street': 'Bodenacker 10',\n  'delivery_method': 'post_participant',\n  'first_name': 'Christoph',\n  'donation_type': 'per_goal',\n  'access': {'8mX4M5ckrVMQsmEVKJc1rjHZ7Np1': 'owner'},\n  'email': '',\n  'address_plz': '8046',\n  'address_city': 'Zürich',\n  'amount': '2',\n  'notes': ''},\n {'notes': '',\n  'sponsor_of': 'hoJrBP4vxjXpo92LH5FX',\n  'address_street': 'Hauptstrasse 7',\n  'id': 'rwyEi0pjJiNpRzoHSEoR',\n  'delivery_method': 'post_participant',\n  'first_name': 'Heidi',\n  'donation_type': 'per_goal',\n  'access': {'yD5GfoqboANlKbpmsOBIIm0pbAj1': 'owner'},\n  'email': '',\n  'address_plz': '8544',\n  'address_city': 'Attikon',\n  'amount': '5',\n  'last_name': 'Bänninger'},\n {'last_name': 'Guyer',\n  'sponsor_of': 'EjEhXkpDSkNjqtPhXsM5',\n  'address_street': 'Talgutstrasse 69',\n  'delivery_method': 'mail',\n  'first_name': 'Ann-Kathrin',\n  'donation_type': 'fixed',\n  'access': {'WqYIZwf9IGXA33WNdmtH2of19rn1': 'owner'},\n  'email': 'a.guyer@gmx.ch',\n  'address_plz': '8400',\n  'address_city': 'Winterthur',\n  'amount': '40',\n  'notes': ''},\n {'last_name': 'Santos Iglesias',\n  'sponsor_of': '0yw1KG8dHlVPEt131qXJ',\n  'address_street': 'Schaffhauserstrasse 50',\n  'delivery_method': 'post_participant',\n  'first_name': 'Barbara ',\n  'donation_type': 'per_goal',\n  'access': {'KjxNh3YWaqVDbw8n2CQVfSOns643': 'owner'},\n  'email': '',\n  'address_plz': '8152',\n  'address_city': 'Opfikon',\n  'amount': '2',\n  'notes': ''},\n {'last_name': 'Lienhard',\n  'sponsor_of': 'sArbeCUonDNYVnVKvg8Z',\n  'address_street': 'Glärnischstr. 148',\n  'delivery_method': 'mail',\n  'first_name': 'Ernst',\n  'donation_type': 'fixed',\n  'access': {'9u0djKaFZnOAZWR42Gw65yXVXXW2': 'owner'},\n  'email': 'ernst.lienhard@hispeed.ch',\n  'address_plz': '8708',\n  'address_city': 'Männedorf ',\n  'amount': '50',\n  'notes': ''},\n {'notes': '',\n  'sponsor_of': 'hoJrBP4vxjXpo92LH5FX',\n  'address_street': 'Limmattalstrasse 133',\n  'id': 'HtCHyqBu65ECm8I1ZRmH',\n  'delivery_method': 'post_participant',\n  'first_name': 'Urs',\n  'donation_type': 'per_goal',\n  'access': {'yD5GfoqboANlKbpmsOBIIm0pbAj1': 'owner'},\n  'email': '',\n  'address_plz': '8049',\n  'address_city': 'Zürich',\n  'amount': '6.50',\n  'last_name': 'Zweifel'},\n {'last_name': 'Bachmann ',\n  'sponsor_of': 'HbPKNXV7kKXUb45kObDA',\n  'address_street': 'Buchwiesen 104',\n  'delivery_method': 'post_participant',\n  'first_name': 'Silvia ',\n  'donation_type': 'fixed',\n  'access': {'79ECqCJnbjMtmQUTpTpuRpBAsF73': 'owner'},\n  'email': '',\n  'address_plz': '8052',\n  'address_city': 'Zürich ',\n  'amount': '250',\n  'notes': ''},\n {'notes': '',\n  'sponsor_of': '4VrFWnYZqJNd1Mh0twxC',\n  'address_street': 'Sonnenrain 10',\n  'id': 'Nw0b8RiJJXC6GCk1cudH',\n  'delivery_method': 'post_participant',\n  'first_name': 'Elsbeth',\n  'donation_type': 'per_goal',\n  'access': {'yD5GfoqboANlKbpmsOBIIm0pbAj1': 'owner'},\n  'email': '',\n  'address_plz': '8810',\n  'address_city': 'Horgen',\n  'amount': '3',\n  'last_name': 'Stoll'},\n {'last_name': 'Bewersdorff ',\n  'sponsor_of': 'RXzPU6IKmlgtVihkKANq',\n  'address_street': 'Fronwaldweg 20',\n  'delivery_method': 'post_participant',\n  'first_name': 'Rahel',\n  'donation_type': 'per_goal',\n  'access': {'6jj4cDZZs7TRmWCADCNsUQW8ttx2': 'owner'},\n  'email': 'alyv@bluewin.ch',\n  'address_plz': '8046',\n  'address_city': 'Zürich',\n  'amount': '5',\n  'notes': ''},\n {'last_name': 'Hagymas',\n  'sponsor_of': 'SYjqw9yaTL3Te8R2ZSD9',\n  'address_street': 'Burstwiesenstrasse 51',\n  'delivery_method': 'mail',\n  'first_name': 'Sandor',\n  'donation_type': 'fixed',\n  'access': {'HzRLiMySHEYIhl213GA6kwD11Sq2': 'owner'},\n  'email': 'has@ggaweb.ch',\n  'address_plz': '8606',\n  'address_city': 'Greifensee ',\n  'amount': '50',\n  'notes': ''},\n {'last_name': 'Tschabold ',\n  'sponsor_of': '0yw1KG8dHlVPEt131qXJ',\n  'address_street': 'Talackerstrasse 25',\n  'delivery_method': 'post_participant',\n  'first_name': 'Marianne ',\n  'donation_type': 'fixed',\n  'access': {'KjxNh3YWaqVDbw8n2CQVfSOns643': 'owner'},\n  'email': 'Matsch09@gmail.com',\n  'address_plz': '3604',\n  'address_city': 'Thun',\n  'amount': '20',\n  'notes': ''},\n {'last_name': 'Zwirner',\n  'sponsor_of': '4VrFWnYZqJNd1Mh0twxC',\n  'address_street': 'Rankstrasse 32',\n  'delivery_method': 'post_participant',\n  'first_name': 'Monika',\n  'donation_type': 'per_goal',\n  'access': {'yD5GfoqboANlKbpmsOBIIm0pbAj1': 'owner'},\n  'email': '',\n  'address_plz': '8645',\n  'address_city': 'Jona',\n  'amount': '2',\n  'notes': ''},\n {'last_name': 'Tuor',\n  'sponsor_of': 'd59gBVvvNuZorzN1UzEy',\n  'address_street': 'Glärnischstrasse 120',\n  'delivery_method': 'mail',\n  'first_name': 'Christoph ',\n  'donation_type': 'per_goal',\n  'access': {'9u0djKaFZnOAZWR42Gw65yXVXXW2': 'owner'},\n  'email': 'christoph.tuor@bluewin.ch',\n  'address_plz': '8708',\n  'address_city': 'Männedorf ',\n  'amount': '5',\n  'notes': 'MAXIMALBETRAG 100.-'},\n {'last_name': 'Leonforte ',\n  'sponsor_of': 'SYjqw9yaTL3Te8R2ZSD9',\n  'address_street': 'Giebeleich 4',\n  'delivery_method': 'mail',\n  'first_name': 'Christina ',\n  'donation_type': 'fixed',\n  'access': {'HzRLiMySHEYIhl213GA6kwD11Sq2': 'owner'},\n  'email': 'c.leonforte@gmx.ch',\n  'address_plz': '8052',\n  'address_city': 'Zürich',\n  'amount': '10',\n  'notes': ''},\n {'last_name': 'Hürlimann',\n  'sponsor_of': 'EjEhXkpDSkNjqtPhXsM5',\n  'address_street': 'Linth-Escher-Strasse 6',\n  'delivery_method': 'post_participant',\n  'first_name': 'Hans',\n  'donation_type': 'fixed',\n  'access': {'WqYIZwf9IGXA33WNdmtH2of19rn1': 'owner'},\n  'email': '',\n  'address_plz': '8867',\n  'address_city': 'Niederurnen',\n  'amount': '50',\n  'notes': ''},\n {'last_name': 'Fauster',\n  'sponsor_of': 'kxv1GGIvzjOlnhhn0rJI',\n  'address_street': 'Lerchenberg 43',\n  'delivery_method': 'post_participant',\n  'first_name': 'Hansruedi',\n  'donation_type': 'fixed',\n  'access': {'WygEF9tALcWEiFdwHxS7JeWmlbF3': 'owner'},\n  'email': '',\n  'address_plz': '8046',\n  'address_city': 'Zürich',\n  'amount': '20',\n  'notes': ''},\n {'last_name': 'Fauster',\n  'sponsor_of': 'kxv1GGIvzjOlnhhn0rJI',\n  'address_street': 'Hirschgartnerweg , 24',\n  'delivery_method': 'post_participant',\n  'first_name': 'Barbara',\n  'donation_type': 'per_goal',\n  'access': {'WygEF9tALcWEiFdwHxS7JeWmlbF3': 'owner'},\n  'email': '',\n  'address_plz': '8057',\n  'address_city': 'Zürich',\n  'amount': '2',\n  'notes': ''},\n {'last_name': 'Strub-Jaccoud',\n  'sponsor_of': 'sArbeCUonDNYVnVKvg8Z',\n  'address_street': 'Alte Landstrasse 1',\n  'delivery_method': 'mail',\n  'first_name': 'Madeleine&Hans',\n  'donation_type': 'per_goal',\n  'access': {'9u0djKaFZnOAZWR42Gw65yXVXXW2': 'owner'},\n  'email': 'madeleine.strub@bluewin.ch',\n  'address_plz': '8708',\n  'address_city': 'Männedorf ',\n  'amount': '5',\n  'notes': 'MAXIMALBETRAG 100.-'},\n {'last_name': 'Stoll',\n  'sponsor_of': '4VrFWnYZqJNd1Mh0twxC',\n  'address_street': 'Hirschgartnerweg 37',\n  'id': 'SwDQW5OJ52Hq0KWrytWE',\n  'delivery_method': 'mail',\n  'first_name': 'Andreas',\n  'donation_type': 'per_goal',\n  'access': {'yD5GfoqboANlKbpmsOBIIm0pbAj1': 'owner'},\n  'email': 'andreas.stoll@sunrise.ch',\n  'address_plz': '8057',\n  'address_city': 'Zürich',\n  'amount': '5',\n  'notes': ''},\n {'notes': '',\n  'sponsor_of': 'hoJrBP4vxjXpo92LH5FX',\n  'address_street': 'Krykkjeven 26',\n  'id': '0m2oxPSTzEU76GGJKKZZ',\n  'delivery_method': 'post_participant',\n  'first_name': 'Rahel',\n  'donation_type': 'per_goal',\n  'access': {'yD5GfoqboANlKbpmsOBIIm0pbAj1': 'owner'},\n  'email': '',\n  'address_plz': '4049',\n  'address_city': 'Hafrsfjord',\n  'amount': '3',\n  'last_name': 'Brändli'},\n {'notes': '',\n  'sponsor_of': 'LtlIx1m3Kt2kJCZIlUKO',\n  'address_street': 'Erchenbühlstrasse 40',\n  'id': 'oN5sfmNjkIqyIHJesXGC',\n  'delivery_method': 'mail',\n  'first_name': 'Claudia/Pascal ',\n  'donation_type': 'per_goal',\n  'access': {'a7eareIp7vN2PlQMUXvPP8uQmku2': 'owner'},\n  'email': 'pascal.puentener@gmx.ch',\n  'address_plz': '8046',\n  'address_city': 'Zürich',\n  'amount': '25',\n  'last_name': 'Püntener'},\n {'last_name': 'Strub-Lienhard ',\n  'sponsor_of': 'sArbeCUonDNYVnVKvg8Z',\n  'address_street': 'Oberwiesenstrasse 45',\n  'delivery_method': 'mail',\n  'first_name': 'Karin&Lukas ',\n  'donation_type': 'fixed',\n  'access': {'9u0djKaFZnOAZWR42Gw65yXVXXW2': 'owner'},\n  'email': 'lukasstrub@hotmail.com',\n  'address_plz': '8050',\n  'address_city': 'Zürich ',\n  'amount': '150',\n  'notes': ''},\n {'notes': '',\n  'sponsor_of': '5ty99yTbZrrhDp2SRcFe',\n  'address_street': 'Zürichbergstrasse 46a',\n  'id': 'f6gsFWftDPdIGCWSrZ8B',\n  'delivery_method': 'mail',\n  'first_name': 'Pamela',\n  'donation_type': 'per_goal',\n  'access': {'uhlIGGtXD2etqx4Y9uTIxAJEcRJ2': 'owner'},\n  'email': 'pamela.voegeli@irm.uzh.ch',\n  'address_plz': '8044',\n  'address_city': 'Zürich ',\n  'amount': '8',\n  'last_name': 'Voegeli '},\n {'last_name': 'Stückelberger ',\n  'sponsor_of': 'LtlIx1m3Kt2kJCZIlUKO',\n  'address_street': 'Weiherweg 3',\n  'delivery_method': 'mail',\n  'first_name': 'David',\n  'donation_type': 'per_goal',\n  'access': {'a7eareIp7vN2PlQMUXvPP8uQmku2': 'owner'},\n  'email': 'calimero@zh11.ch',\n  'address_plz': '8610',\n  'address_city': 'Uster',\n  'amount': '3',\n  'notes': ''},\n {'last_name': 'Püntener',\n  'sponsor_of': 'LtlIx1m3Kt2kJCZIlUKO',\n  'address_street': 'Bachstrasse 13',\n  'delivery_method': 'mail',\n  'first_name': 'Susanna',\n  'donation_type': 'fixed',\n  'access': {'a7eareIp7vN2PlQMUXvPP8uQmku2': 'owner'},\n  'email': 'susanna.puentener@swissonline.ch',\n  'address_plz': '8046',\n  'address_city': 'Urdorf',\n  'amount': '40',\n  'notes': ''},\n {'notes': '',\n  'sponsor_of': 'LtlIx1m3Kt2kJCZIlUKO',\n  'address_street': 'Obstgartenweg 2',\n  'id': 'FD6rMUYTa27CSRVU7JQJ',\n  'delivery_method': 'mail',\n  'first_name': 'Stefanie',\n  'access': {'a7eareIp7vN2PlQMUXvPP8uQmku2': 'owner'},\n  'donation_type': 'per_goal',\n  'email': 'h_wuergler@hotmail.com',\n  'address_plz': '8717',\n  'address_city': 'Mönchaltsdorf',\n  'amount': '0.75',\n  'last_name': 'Püntener'},\n {'notes': '',\n  'sponsor_of': 'qO7YbL5GM2KLlCGk1kmQ',\n  'address_street': 'Binzmühlestrasse 258',\n  'id': '7lNmWj0F92Mel10ZZB38',\n  'delivery_method': 'post_participant',\n  'first_name': 'Karin ',\n  'donation_type': 'per_goal',\n  'access': {'SQbdtfmTPmhjxHju5gP7VDIjg1q1': 'owner'},\n  'email': 'karin.luterbach@sunrise.ch',\n  'address_plz': '8046',\n  'address_city': 'Zürich ',\n  'amount': '1',\n  'last_name': 'Luterbach '},\n {'last_name': 'Fauster',\n  'sponsor_of': 'FvCe7xpwdlawfQVsvUi6',\n  'address_street': 'Hirschgartnerweg 24',\n  'delivery_method': 'mail',\n  'first_name': 'Marcus',\n  'donation_type': 'per_goal',\n  'access': {'TWZr7WD8mzSZvIYco5ULB7tx7Up1': 'owner'},\n  'email': 'fauster.bgh@gmx.ch',\n  'address_plz': '8057',\n  'address_city': 'Zürich',\n  'amount': '3',\n  'notes': ''},\n {'last_name': 'Leonforte',\n  'sponsor_of': 'JaOmAN3hwcSHLOCkaPcn',\n  'address_street': 'Im Sydefädeli',\n  'delivery_method': 'mail',\n  'first_name': 'Antonella ',\n  'donation_type': 'fixed',\n  'access': {'HzRLiMySHEYIhl213GA6kwD11Sq2': 'owner'},\n  'email': 'antonforte@hotmail.com',\n  'address_plz': '8037',\n  'address_city': 'Zürich',\n  'amount': '50',\n  'notes': ''},\n {'last_name': 'Voss',\n  'sponsor_of': 'EjEhXkpDSkNjqtPhXsM5',\n  'address_street': 'Seebacherstrasse 175',\n  'delivery_method': 'mail',\n  'first_name': 'Sven',\n  'donation_type': 'fixed',\n  'access': {'WqYIZwf9IGXA33WNdmtH2of19rn1': 'owner'},\n  'email': 'voss.sven@hispeed.ch',\n  'address_plz': '8052',\n  'address_city': 'Zürich',\n  'amount': '100',\n  'notes': ''},\n {'notes': '',\n  'sponsor_of': 'petQRzPlJvSoRG0y2N4c',\n  'address_street': 'Schwandenwiesen 19',\n  'id': 'zLGEYlXvNsdVp675zxsU',\n  'delivery_method': 'mail',\n  'first_name': 'Kathrin',\n  'access': {'4R9GoQtPxCPADDA8nwDc2IrcTB93': 'owner'},\n  'donation_type': 'fixed',\n  'email': 'jpg@zh11.ch',\n  'address_plz': '8052',\n  'address_city': 'Zürich',\n  'amount': '500',\n  'last_name': 'Aeberli'}]"
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "old_sponsoren = list(map(lambda doc: doc.to_dict(), sponsoren_ref))\n",
    "old_sponsoren"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "pycharm": {
     "is_executing": true
    }
   },
   "outputs": [],
   "source": [
    "for old_sponsor in old_sponsoren:\n",
    "    doc_ref = db.collection(u'old_sponsoren').document()\n",
    "    doc_ref.set(old_sponsor)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}