61_sqlalchemy_01.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# SQLAlchemy Beispiel\n",
    "* Modellieren der Klasse: `Country`\n",
    "* Verknüpfen/Abbilden der Elemente auf die DatenbankElemente\n",
    "* Wichtig: Besonderheiten mit Abbilden (z.B. `primary_key`)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Afghanistan\n",
      "Netherlands\n",
      "Netherlands Antilles\n",
      "Albania\n",
      "Algeria\n",
      "American Samoa\n",
      "Andorra\n",
      "Angola\n",
      "Anguilla\n",
      "Antigua and Barbuda\n",
      "United Arab Emirates\n",
      "Argentina\n",
      "Armenia\n",
      "Aruba\n",
      "Australia\n",
      "Azerbaijan\n",
      "Bahamas\n",
      "Bahrain\n",
      "Bangladesh\n",
      "Barbados\n",
      "Belgium\n",
      "Belize\n",
      "Benin\n",
      "Bermuda\n",
      "Bhutan\n",
      "Bolivia\n",
      "Bosnia and Herzegovina\n",
      "Botswana\n",
      "Brazil\n",
      "United Kingdom\n",
      "Virgin Islands, British\n",
      "Brunei\n",
      "Bulgaria\n",
      "Burkina Faso\n",
      "Burundi\n",
      "Cayman Islands\n",
      "Chile\n",
      "Cook Islands\n",
      "Costa Rica\n",
      "Djibouti\n",
      "Dominica\n",
      "Dominican Republic\n",
      "Ecuador\n",
      "Egypt\n",
      "El Salvador\n",
      "Eritrea\n",
      "Spain\n",
      "South Africa\n",
      "Ethiopia\n",
      "Falkland Islands\n",
      "Fiji Islands\n",
      "Philippines\n",
      "Faroe Islands\n",
      "Gabon\n",
      "Gambia\n",
      "Georgia\n",
      "Ghana\n",
      "Gibraltar\n",
      "Grenada\n",
      "Greenland\n",
      "Guadeloupe\n",
      "Guam\n",
      "Guatemala\n",
      "Guinea\n",
      "Guinea-Bissau\n",
      "Guyana\n",
      "Haiti\n",
      "Honduras\n",
      "Hong Kong\n",
      "Svalbard and Jan Mayen\n",
      "Indonesia\n",
      "India\n",
      "Iraq\n",
      "Iran\n",
      "Ireland\n",
      "Iceland\n",
      "Israel\n",
      "Italy\n",
      "East Timor\n",
      "Austria\n",
      "Jamaica\n",
      "Japan\n",
      "Yemen\n",
      "Jordan\n",
      "Christmas Island\n",
      "Yugoslavia\n",
      "Cambodia\n",
      "Cameroon\n",
      "Canada\n",
      "Cape Verde\n",
      "Kazakstan\n",
      "Kenya\n",
      "Central African Republic\n",
      "China\n",
      "Kyrgyzstan\n",
      "Kiribati\n",
      "Colombia\n",
      "Comoros\n",
      "Congo\n",
      "Congo, The Democratic Republic of the\n",
      "Cocos (Keeling) Islands\n",
      "North Korea\n",
      "South Korea\n",
      "Greece\n",
      "Croatia\n",
      "Cuba\n",
      "Kuwait\n",
      "Cyprus\n",
      "Laos\n",
      "Latvia\n",
      "Lesotho\n",
      "Lebanon\n",
      "Liberia\n",
      "Libyan Arab Jamahiriya\n",
      "Liechtenstein\n",
      "Lithuania\n",
      "Luxembourg\n",
      "Western Sahara\n",
      "Macao\n",
      "Madagascar\n",
      "Macedonia\n",
      "Malawi\n",
      "Maldives\n",
      "Malaysia\n",
      "Mali\n",
      "Malta\n",
      "Morocco\n",
      "Marshall Islands\n",
      "Martinique\n",
      "Mauritania\n",
      "Mauritius\n",
      "Mayotte\n",
      "Mexico\n",
      "Micronesia, Federated States of\n",
      "Moldova\n",
      "Monaco\n",
      "Mongolia\n",
      "Montserrat\n",
      "Mozambique\n",
      "Myanmar\n",
      "Namibia\n",
      "Nauru\n",
      "Nepal\n",
      "Nicaragua\n",
      "Niger\n",
      "Nigeria\n",
      "Niue\n",
      "Norfolk Island\n",
      "Norway\n",
      "Côte dIvoire\n",
      "Oman\n",
      "Pakistan\n",
      "Palau\n",
      "Panama\n",
      "Papua New Guinea\n",
      "Paraguay\n",
      "Peru\n",
      "Pitcairn\n",
      "Northern Mariana Islands\n",
      "Portugal\n",
      "Puerto Rico\n",
      "Poland\n",
      "Equatorial Guinea\n",
      "Qatar\n",
      "France\n",
      "French Guiana\n",
      "French Polynesia\n",
      "Réunion\n",
      "Romania\n",
      "Rwanda\n",
      "Sweden\n",
      "Saint Helena\n",
      "Saint Kitts and Nevis\n",
      "Saint Lucia\n",
      "Saint Vincent and the Grenadines\n",
      "Saint Pierre and Miquelon\n",
      "Germany\n",
      "Solomon Islands\n",
      "Zambia\n",
      "Samoa\n",
      "San Marino\n",
      "Sao Tome and Principe\n",
      "Saudi Arabia\n",
      "Senegal\n",
      "Seychelles\n",
      "Sierra Leone\n",
      "Singapore\n",
      "Slovakia\n",
      "Slovenia\n",
      "Somalia\n",
      "Sri Lanka\n",
      "Sudan\n",
      "Finland\n",
      "Suriname\n",
      "Swaziland\n",
      "Switzerland\n",
      "Syria\n",
      "Tajikistan\n",
      "Taiwan\n",
      "Tanzania\n",
      "Denmark\n",
      "Thailand\n",
      "Togo\n",
      "Tokelau\n",
      "Tonga\n",
      "Trinidad and Tobago\n",
      "Chad\n",
      "Czech Republic\n",
      "Tunisia\n",
      "Turkey\n",
      "Turkmenistan\n",
      "Turks and Caicos Islands\n",
      "Tuvalu\n",
      "Uganda\n",
      "Ukraine\n",
      "Hungary\n",
      "Uruguay\n",
      "New Caledonia\n",
      "New Zealand\n",
      "Uzbekistan\n",
      "Belarus\n",
      "Wallis and Futuna\n",
      "Vanuatu\n",
      "Holy See (Vatican City State)\n",
      "Venezuela\n",
      "Russian Federation\n",
      "Vietnam\n",
      "Estonia\n",
      "United States\n",
      "Virgin Islands, U.S.\n",
      "Zimbabwe\n",
      "Palestine\n",
      "Antarctica\n",
      "Bouvet Island\n",
      "British Indian Ocean Territory\n",
      "South Georgia and the South Sandwich Islands\n",
      "Heard Island and McDonald Islands\n",
      "French Southern territories\n",
      "United States Minor Outlying Islands\n"
     ]
    }
   ],
   "source": [
    "from sqlalchemy import (\n",
    "    Column,\n",
    "    String,\n",
    "    create_engine,\n",
    ")\n",
    "from sqlalchemy.orm import relationship, backref, sessionmaker\n",
    "from sqlalchemy.ext.declarative import declarative_base\n",
    "\n",
    "DB_NAME = \"world-db\"\n",
    "DB_USER = \"world\"\n",
    "DB_PASSWORD = \"world123\"\n",
    "DB_HOST = \"192.168.1.2\"\n",
    "DB_PORT = \"5432\"\n",
    "\n",
    "Base = declarative_base()\n",
    "\n",
    "\n",
    "class Country(Base):\n",
    "    __tablename__ = \"country\"\n",
    "    code = Column(String, primary_key=True)\n",
    "    name = Column(String)\n",
    "\n",
    "\n",
    "engine = create_engine(\n",
    "    f\"postgresql://{DB_USER}:{DB_PASSWORD}@{DB_HOST}:{DB_PORT}/{DB_NAME}\"\n",
    ")\n",
    "con = engine.connect()\n",
    "\n",
    "session = sessionmaker()\n",
    "session.configure(bind=engine)\n",
    "Base.metadata.create_all(engine)\n",
    "\n",
    "s = session()\n",
    "\n",
    "# Gebe alle Länder aus\n",
    "result = s.query(Country).all()\n",
    "for i in result:\n",
    "    print(i.name)"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "cba2c3b0abe14d5f4b67d1ebd150c45faff7bdaeb215f1ed57745464bd8675ff"
  },
  "kernelspec": {
   "display_name": "Python 3.10.1 64-bit",
   "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.1"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}