Multimedika/Bot_Development

1{2 "cells": [3  {4   "cell_type": "code",5   "execution_count": 2,6   "metadata": {},7   "outputs": [],8   "source": [9    "import os\n",10    "work_directory = r\"D:\\Project_Multimedika\\Projek_2\\fullstack_summarizer_and_bot_development\\backend\"\n",11    "os.chdir(work_directory)"12   ]13  },14  {15   "cell_type": "code",16   "execution_count": 3,17   "metadata": {},18   "outputs": [19    {20     "name": "stdout",21     "output_type": "stream",22     "text": [23      "2024-10-02 10:13:26,616 DEBUG sqlalchemy.pool.impl.QueuePool Created new connection <_mysql.connection open to 'mysql-1034fd4a-hamzahibnuarman-ad3d.e.aivencloud.com' at 0000014BA7A87210>\n",24      "2024-10-02 10:13:26,782 INFO sqlalchemy.engine.Engine SELECT DATABASE()\n",25      "2024-10-02 10:13:26,782 INFO sqlalchemy.engine.Engine [raw sql] ()\n",26      "2024-10-02 10:13:26,960 INFO sqlalchemy.engine.Engine SELECT @@sql_mode\n",27      "2024-10-02 10:13:26,974 INFO sqlalchemy.engine.Engine [raw sql] ()\n",28      "2024-10-02 10:13:27,059 INFO sqlalchemy.engine.Engine SELECT @@lower_case_table_names\n",29      "2024-10-02 10:13:27,060 INFO sqlalchemy.engine.Engine [raw sql] ()\n",30      "2024-10-02 10:13:27,235 DEBUG sqlalchemy.pool.impl.QueuePool Connection <_mysql.connection open to 'mysql-1034fd4a-hamzahibnuarman-ad3d.e.aivencloud.com' at 0000014BA7A87210> checked out from pool\n",31      "Connection successful!\n",32      "2024-10-02 10:13:27,235 DEBUG sqlalchemy.pool.impl.QueuePool Connection <_mysql.connection open to 'mysql-1034fd4a-hamzahibnuarman-ad3d.e.aivencloud.com' at 0000014BA7A87210> being returned to pool\n",33      "2024-10-02 10:13:27,238 DEBUG sqlalchemy.pool.impl.QueuePool Connection <_mysql.connection open to 'mysql-1034fd4a-hamzahibnuarman-ad3d.e.aivencloud.com' at 0000014BA7A87210> rollback-on-return\n"34     ]35    }36   ],37   "source": [38    "from sqlalchemy import create_engine\n",39    "\n",40    "SQLALCHEMY_DATABASE_URL = (\n",41    "    \"mysql://avnadmin:AVNS_St9zLKGWwfGKvC2yMCz@mysql-1034fd4a-hamzahibnuarman-ad3d.e.aivencloud.com:10707/summarizer\"\n",42    ")\n",43    "engine = create_engine(\n",44    "    SQLALCHEMY_DATABASE_URL,\n",45    "    echo=True,\n",46    "    echo_pool=\"debug\",\n",47    "    connect_args={\n",48    "        \"ssl\": {\n",49    "            'sslmode': \"REQUIRED\",\n",50    "            \"ca\": \"ca.pem\",  # Update this path to your CA certificate\n",51    "            # Other SSL options can be added here\n",52    "        }\n",53    "    }\n",54    ")\n",55    "\n",56    "# Test connection\n",57    "try:\n",58    "    with engine.connect() as connection:\n",59    "        print(\"Connection successful!\")\n",60    "except Exception as e:\n",61    "    print(\"Error connecting to the database:\", str(e))"62   ]63  }64 ],65 "metadata": {66  "kernelspec": {67   "display_name": "fullstack",68   "language": "python",69   "name": "python3"70  },71  "language_info": {72   "codemirror_mode": {73    "name": "ipython",74    "version": 375   },76   "file_extension": ".py",77   "mimetype": "text/x-python",78   "name": "python",79   "nbconvert_exporter": "python",80   "pygments_lexer": "ipython3",81   "version": "3.11.9"82  }83 },84 "nbformat": 4,85 "nbformat_minor": 286}87