Getting_started_SQLite3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "1ead803d-d2f6-4133-8651-925bf84d0aac",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1, 'Alice', 30, 'alice@example.com')\n",
      "(2, 'Bob', 25, 'bob@example.com')\n",
      "(3, 'Charlie', 22, 'charlie@example.com')\n"
     ]
    }
   ],
   "source": [
    "import sqlite3\n",
    "\n",
    "# Connect to a database or create one if it doesn't exist\n",
    "conn = sqlite3.connect('example.db')\n",
    "\n",
    "# Create a cursor object to execute SQL commands\n",
    "c = conn.cursor()\n",
    "\n",
    "# Create a table\n",
    "c.execute('''\n",
    "CREATE TABLE IF NOT EXISTS users (\n",
    "    id INTEGER PRIMARY KEY,\n",
    "    name TEXT NOT NULL,\n",
    "    age INTEGER NOT NULL,\n",
    "    email TEXT UNIQUE NOT NULL\n",
    ")\n",
    "''')\n",
    "\n",
    "# Insert data into the table\n",
    "c.execute(\"INSERT INTO users (name, age, email) VALUES (?, ?, ?)\", (\"Alice\", 30, \"alice@example.com\"))\n",
    "c.execute(\"INSERT INTO users (name, age, email) VALUES (?, ?, ?)\", (\"Bob\", 25, \"bob@example.com\"))\n",
    "c.execute(\"INSERT INTO users (name, age, email) VALUES (?, ?, ?)\", (\"Charlie\", 22, \"charlie@example.com\"))\n",
    "\n",
    "# Commit the changes\n",
    "conn.commit()\n",
    "\n",
    "# Query the table\n",
    "c.execute(\"SELECT * FROM users\")\n",
    "rows = c.fetchall()\n",
    "for row in rows:\n",
    "    print(row)\n",
    "\n",
    "# Update a record\n",
    "c.execute(\"UPDATE users SET age = ? WHERE name = ?\", (31, \"Alice\"))\n",
    "conn.commit()\n",
    "\n",
    "# Delete a record\n",
    "c.execute(\"DELETE FROM users WHERE name = ?\", (\"Charlie\",))\n",
    "conn.commit()\n",
    "\n",
    "# Close the connection\n",
    "conn.close()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "699781c5-dc1b-42ae-a384-3f0b5e16354b",
   "metadata": {},
   "outputs": [],
   "source": [
    "def as_dataframe(\n",
    "        self,\n",
    "        teams: Optional[List[MyqosTeam]] = None,\n",
    "        experiments: Optional[List[MyqosExperiment]] = None,\n",
    "        experiment_name: Optional[str] = None,\n",
    "        ) -> \"DataFrame\":\n",
    "        \"\"\"\n",
    "        Converts to and displays lists of teams, experiments, or circuits for the current user\n",
    "        as a pandas DataFrame.\n",
    "\n",
    "        :returns: a list over the teams, experiments, or circuits that match the criteria\n",
    "        :rtype: List[MyqosTeam], List[MyqosExperiment], List[MyqosCircuit]\n",
    "        \"\"\"\n",
    "\n",
    "        try:\n",
    "            from pandas import DataFrame\n",
    "        except ImportError as err:\n",
    "            raise ImportError(\n",
    "                \"pandas is not installed.\"\n",
    "                \"Please install pandas for datascience conversions.\"\n",
    "                \"'pip install 'pytket-myqos[datascience]''\"\n",
    "            ) from err\n",
    "\n",
    "        def to_dataframe(self) -> DataFrame:\n",
    "            \"\"\"Converts the team to a pandas DataFrame.\"\"\"\n",
    "            try:\n",
    "                from pandas import DataFrame\n",
    "            except ImportError as err:\n",
    "                raise ImportError(\n",
    "                    \"pandas is not installed.\"\n",
    "                    \"Please install pandas for datascience conversions.\"\n",
    "                    \"'pip install 'pytket-myqos[datascience]''\"\n",
    "                ) from err\n",
    "            \n",
    "            if teams is not None:\n",
    "                return DataFrame(team.__dict__ for team in self.list_teams()) \n",
    "            elif experiments is not None:\n",
    "                return DataFrame(experiment.__dict__ for experiment in self.get_experiments())\n",
    "            elif experiment_name is not None:\n",
    "                return DataFrame(circuit.__dict__ for circuit in self.get_experiment_by_name(\n",
    "                    experiment_name).get_circuits()\n",
    "                    )\n",
    "            else:\n",
    "                return TypeError(\"Please specify a teams, experiments or circuits list.\")\n",
    "\n",
    "        return to_dataframe(self)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "70bfa2d5",
   "metadata": {},
   "outputs": [],
   "source": [
    "    def to_dataframe(self) -> DataFrame:\n",
    "        \"\"\"Converts the team to a pandas DataFrame.\"\"\"\n",
    "        try:\n",
    "            from pandas import DataFrame\n",
    "        except ImportError as err:\n",
    "            raise ImportError(\n",
    "                \"pandas is not installed.\"\n",
    "                \"Please install pandas for datascience conversions.\"\n",
    "                \"'pip install 'pytket-myqos[datascience]''\"\n",
    "            ) from err\n",
    "\n",
    "        if isinstance(MyqosTeam, list):\n",
    "            return DataFrame([team.to_dict() for team in self])\n",
    "        else:\n",
    "            return DataFrame(self.__dict__, index=[0])"
   ]
  }
 ],
 "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}