TASK_5.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "xYSHGxcx6hgP"
      },
      "outputs": [],
      "source": [
        "from faker import Faker\n",
        "from sqlalchemy import create_engine\n",
        "from sqlalchemy import Column,Integer,String\n",
        "from sqlalchemy.ext.declarative import declarative_base\n",
        "from sqlalchemy.orm import sessionmaker\n",
        "import time\n",
        "start_time=time.time()\n",
        "Base = declarative_base()\n",
        "engine = create_engine('postgresql://postgres:korhanakc@localhost:5432/postgres', echo = True)\n",
        "Session = sessionmaker(bind = engine)\n",
        "session = Session()\n",
        "\n",
        "class login(Base):\n",
        "    __tablename__ = 'login_table'\n",
        "    id = Column(Integer, primary_key=True)\n",
        "    email = Column(String(100))\n",
        "    password = Column(String(100), nullable=False)\n",
        "\n",
        "class finding(Base):\n",
        "    __tablename__=\"finding_table\"\n",
        "    id = Column(Integer, primary_key=True)\n",
        "    email = Column(String(100))\n",
        "    password = Column(String(100), nullable=False)\n",
        "\n",
        "def Generator(i):\n",
        "  list1 = []\n",
        "  for i in range(i):\n",
        "    fake=Faker()\n",
        "    list2=[]\n",
        "    list2.append(fake.email())\n",
        "    list2.append(fake.password())\n",
        "    list1.append(list2)\n",
        "  return list1\n",
        "Base.metadata.create_all(engine)\n",
        "Generator(1000)\n",
        "\n",
        "session.commit()\n",
        "\n",
        "end_time=time.time()\n",
        "print(end_time-start_time)"
      ]
    }
  ]
}