{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "5cbff6ce",
   "metadata": {},
   "outputs": [],
   "source": [
    "import aiosqlite, json\n",
    "async with aiosqlite.connect('core/daa.db') as conn:\n",
    "    doctors_data = [\n",
    "        ('Dr. Ahmed Hasan', 'Cardiologist', json.dumps(['Saturday', 'Monday', 'Thursday']), '5 PM - 9 PM', 1200),\n",
    "        ('Dr. Nusrat Jahan', 'Neurologist', json.dumps(['Sunday', 'Tuesday', 'Wednesday']), '4 PM - 8 PM', 1500),\n",
    "        ('Dr. Tanvir Islam', 'Orthopedics', json.dumps(['Saturday', 'Tuesday', 'Friday']), '6 PM - 10 PM', 1000),\n",
    "        ('Dr. Farzana Rahman', 'Gastrologist', json.dumps(['Sunday', 'Monday', 'Thursday']), '10 AM - 2 PM', 900),\n",
    "        ('Dr. Mahmudul Karim', 'Cardiologist', json.dumps(['Monday', 'Wednesday', 'Saturday']), '3 PM - 7 PM', 800),\n",
    "\n",
    "        ('Dr. Sabiha Noor', 'Neurologist', json.dumps(['Saturday', 'Sunday', 'Tuesday']), '9 AM - 1 PM', 700),\n",
    "        ('Dr. Rakib Hossain', 'Orthopedics', json.dumps(['Sunday', 'Wednesday', 'Thursday']), '5 PM - 9 PM', 850),\n",
    "        ('Dr. Imran Kabir', 'Gastrologist', json.dumps(['Saturday', 'Monday', 'Tuesday']), '7 PM - 10 PM', 1300),\n",
    "        ('Dr. Tania Sultana', 'Cardiologist', json.dumps(['Monday', 'Thursday', 'Friday']), '11 AM - 3 PM', 950),\n",
    "        ('Dr. Faisal Ahmed', 'Neurologist', json.dumps(['Saturday', 'Wednesday', 'Thursday']), '6 PM - 9 PM', 600),\n",
    "\n",
    "        ('Dr. Sharmin Akter', 'Orthopedics', json.dumps(['Sunday', 'Tuesday', 'Friday']), '2 PM - 6 PM', 1400),\n",
    "        ('Dr. Rezaul Karim', 'Gastrologist', json.dumps(['Monday', 'Wednesday', 'Thursday']), '5 PM - 8 PM', 1600),\n",
    "        ('Dr. Jannatul Ferdous', 'Cardiologist', json.dumps(['Saturday', 'Tuesday', 'Wednesday']), '4 PM - 7 PM', 1100),\n",
    "        ('Dr. Arif Hossain', 'Neurologist', json.dumps(['Sunday', 'Thursday', 'Monday']), '5 PM - 9 PM', 1000),\n",
    "        ('Dr. Sadia Islam', 'Orthopedics', json.dumps(['Saturday', 'Wednesday', 'Tuesday']), '10 AM - 1 PM', 500),\n",
    "\n",
    "        ('Dr. Kamrul Hasan', 'Gastrologist', json.dumps(['Monday', 'Thursday', 'Saturday']), '6 PM - 10 PM', 1700),\n",
    "        ('Dr. Mehnaz Chowdhury', 'Cardiologist', json.dumps(['Sunday', 'Tuesday', 'Thursday']), '9 AM - 12 PM', 650),\n",
    "        ('Dr. Shahriar Alam', 'Neurologist', json.dumps(['Saturday', 'Monday', 'Wednesday']), '3 PM - 7 PM', 1450),\n",
    "        ('Dr. Tamanna Rahim', 'Orthopedics', json.dumps(['Tuesday', 'Thursday', 'Friday']), '4 PM - 8 PM', 900),\n",
    "        ('Dr. Nayeem Islam', 'Gastrologist', json.dumps(['Sunday', 'Wednesday', 'Saturday']), '5 PM - 8 PM', 2000),\n",
    "\n",
    "        ('Dr. Arafat Hossain', 'Cardiologist', json.dumps(['Saturday', 'Monday', 'Tuesday']), '5 PM - 9 PM', 1200),\n",
    "        ('Dr. Hridoy Islam', 'Neurologist', json.dumps(['Sunday', 'Thursday', 'Wednesday']), '4 PM - 8 PM', 1500),\n",
    "        ('Dr. Mahin Rahman', 'Orthopedics', json.dumps(['Saturday', 'Wednesday', 'Friday']), '6 PM - 10 PM', 1000),\n",
    "        ('Dr. Sazzad Hossain', 'Gastrologist', json.dumps(['Sunday', 'Tuesday', 'Thursday']), '10 AM - 2 PM', 900),\n",
    "        ('Dr. Iftekhar Alam', 'Cardiologist', json.dumps(['Monday', 'Thursday', 'Saturday']), '3 PM - 7 PM', 800),\n",
    "\n",
    "        ('Dr. Tanvir Mahmud', 'Neurologist', json.dumps(['Saturday', 'Tuesday', 'Wednesday']), '9 AM - 1 PM', 700),\n",
    "        ('Dr. Omar Faruk', 'Orthopedics', json.dumps(['Sunday', 'Wednesday', 'Thursday']), '5 PM - 9 PM', 850),\n",
    "        ('Dr. Abdullah Al Mamun', 'Gastrologist', json.dumps(['Saturday', 'Monday', 'Friday']), '7 PM - 10 PM', 1300),\n",
    "        ('Dr. Shahadat Hossain', 'Cardiologist', json.dumps(['Monday', 'Thursday', 'Tuesday']), '11 AM - 3 PM', 950),\n",
    "        ('Dr. Mahfuzur Rahman', 'Neurologist', json.dumps(['Saturday', 'Thursday', 'Sunday']), '6 PM - 9 PM', 600),\n",
    "\n",
    "        ('Dr. Alif Islam', 'Orthopedics', json.dumps(['Sunday', 'Tuesday', 'Wednesday']), '2 PM - 6 PM', 1400),\n",
    "        ('Dr. Nabil Ahmed', 'Gastrologist', json.dumps(['Monday', 'Wednesday', 'Thursday']), '5 PM - 8 PM', 1600),\n",
    "        ('Dr. Rafiq Hasan', 'Cardiologist', json.dumps(['Saturday', 'Tuesday', 'Friday']), '4 PM - 7 PM', 1100),\n",
    "        ('Dr. Samiul Islam', 'Neurologist', json.dumps(['Sunday', 'Thursday', 'Monday']), '5 PM - 9 PM', 1000),\n",
    "        ('Dr. Towhidur Rahman', 'Orthopedics', json.dumps(['Saturday', 'Wednesday', 'Tuesday']), '10 AM - 1 PM', 500),\n",
    "\n",
    "        ('Dr. Kawsar Ahmed', 'Gastrologist', json.dumps(['Monday', 'Thursday', 'Saturday']), '6 PM - 10 PM', 1700),\n",
    "        ('Dr. Imtiaz Hossain', 'Cardiologist', json.dumps(['Sunday', 'Tuesday', 'Wednesday']), '9 AM - 12 PM', 650),\n",
    "        ('Dr. Masud Rana', 'Neurologist', json.dumps(['Saturday', 'Monday', 'Thursday']), '3 PM - 7 PM', 1450),\n",
    "        ('Dr. Nazmul Hasan', 'Orthopedics', json.dumps(['Tuesday', 'Thursday', 'Friday']), '4 PM - 8 PM', 900),\n",
    "        ('Dr. Sajib Islam', 'Gastrologist', json.dumps(['Sunday', 'Wednesday', 'Monday']), '5 PM - 8 PM', 2000),\n",
    "\n",
    "        ('Dr. Rakib Uddin', 'Cardiologist', json.dumps(['Saturday', 'Monday', 'Thursday']), '5 PM - 9 PM', 1200),\n",
    "        ('Dr. Jewel Rana', 'Neurologist', json.dumps(['Sunday', 'Thursday', 'Tuesday']), '4 PM - 8 PM', 1500),\n",
    "        ('Dr. Arman Hossain', 'Orthopedics', json.dumps(['Saturday', 'Wednesday', 'Friday']), '6 PM - 10 PM', 1000),\n",
    "        ('Dr. Tanmoy Islam', 'Gastrologist', json.dumps(['Sunday', 'Tuesday', 'Thursday']), '10 AM - 2 PM', 900),\n",
    "        ('Dr. Saiful Islam', 'Cardiologist', json.dumps(['Monday', 'Thursday', 'Wednesday']), '3 PM - 7 PM', 800),\n",
    "\n",
    "        ('Dr. Mithun Hasan', 'Neurologist', json.dumps(['Saturday', 'Tuesday', 'Friday']), '9 AM - 1 PM', 700),\n",
    "        ('Dr. Shuvo Ahmed', 'Orthopedics', json.dumps(['Sunday', 'Wednesday', 'Thursday']), '5 PM - 9 PM', 850),\n",
    "        ('Dr. Farid Hasan', 'Gastrologist', json.dumps(['Saturday', 'Monday', 'Tuesday']), '7 PM - 10 PM', 1300),\n",
    "        ('Dr. Al Amin', 'Cardiologist', json.dumps(['Monday', 'Thursday', 'Friday']), '11 AM - 3 PM', 950),\n",
    "        ('Dr. Rashedul Islam', 'Neurologist', json.dumps(['Saturday', 'Thursday', 'Wednesday']), '6 PM - 9 PM', 600),\n",
    "\n",
    "        ('Dr. Ayaan Rahman', 'Dentist', json.dumps(['Sunday', 'Tuesday']), '10:00 AM - 02:00 PM', 800),\n",
    "        ('Dr. Meher Islam', 'Eye Specialist', json.dumps(['Monday', 'Wednesday']), '11:00 AM - 03:00 PM', 1200),\n",
    "        ('Dr. Samiul Karim', 'Child Specialist', json.dumps(['Friday', 'Saturday']), '09:00 AM - 01:00 PM', 1000),\n",
    "        ('Dr. Nabila Ahmed', 'Dentist', json.dumps(['Sunday', 'Thursday']), '04:00 PM - 08:00 PM', 900),\n",
    "        ('Dr. Tanvir Hossain', 'Eye Specialist', json.dumps(['Tuesday', 'Thursday']), '10:00 AM - 01:00 PM', 1100),\n",
    "        ('Dr. Farzana Chowdhury', 'Child Specialist', json.dumps(['Monday', 'Friday']), '02:00 PM - 06:00 PM', 950),\n",
    "        ('Dr. Rafiq Hasan', 'Dentist', json.dumps(['Wednesday', 'Saturday']), '12:00 PM - 04:00 PM', 850),\n",
    "        ('Dr. Jannat Karim', 'Eye Specialist', json.dumps(['Sunday', 'Monday']), '09:00 AM - 12:00 PM', 1300),\n",
    "        ('Dr. Imran Ali', 'Child Specialist', json.dumps(['Tuesday', 'Friday']), '03:00 PM - 07:00 PM', 1000),\n",
    "        ('Dr. Sumaiya Noor', 'Dentist', json.dumps(['Thursday', 'Saturday']), '10:00 AM - 02:00 PM', 800),\n",
    "\n",
    "        ('Dr. Arif Uddin', 'Eye Specialist', json.dumps(['Monday', 'Thursday']), '11:00 AM - 03:00 PM', 1250),\n",
    "        ('Dr. Nadia Sultana', 'Child Specialist', json.dumps(['Sunday', 'Wednesday']), '09:00 AM - 01:00 PM', 980),\n",
    "        ('Dr. Mahmud Rahman', 'Dentist', json.dumps(['Tuesday', 'Friday']), '04:00 PM - 08:00 PM', 870),\n",
    "        ('Dr. Laila Akter', 'Eye Specialist', json.dumps(['Wednesday', 'Saturday']), '10:00 AM - 02:00 PM', 1150),\n",
    "        ('Dr. Shafiq Hasan', 'Child Specialist', json.dumps(['Monday', 'Thursday']), '02:00 PM - 06:00 PM', 1020),\n",
    "        ('Dr. Nayeem Islam', 'Dentist', json.dumps(['Sunday', 'Tuesday']), '09:00 AM - 12:00 PM', 820),\n",
    "        ('Dr. Amina Rahman', 'Eye Specialist', json.dumps(['Friday', 'Saturday']), '12:00 PM - 04:00 PM', 1400),\n",
    "        ('Dr. Rakib Hossain', 'Child Specialist', json.dumps(['Tuesday', 'Wednesday']), '10:00 AM - 01:00 PM', 990),\n",
    "        ('Dr. Tania Sultana', 'Dentist', json.dumps(['Thursday', 'Friday']), '03:00 PM - 07:00 PM', 860),\n",
    "        ('Dr. Anik Das', 'Eye Specialist', json.dumps(['Sunday', 'Wednesday']), '11:00 AM - 03:00 PM', 1200),\n",
    "\n",
    "        ('Dr. Priya Roy', 'Child Specialist', json.dumps(['Monday', 'Saturday']), '09:00 AM - 01:00 PM', 1050),\n",
    "        ('Dr. Kamal Uddin', 'Dentist', json.dumps(['Tuesday', 'Thursday']), '02:00 PM - 06:00 PM', 780),\n",
    "        ('Dr. Sabina Yasmin', 'Eye Specialist', json.dumps(['Wednesday', 'Friday']), '10:00 AM - 02:00 PM', 1350),\n",
    "        ('Dr. Sohel Rana', 'Child Specialist', json.dumps(['Sunday', 'Tuesday']), '04:00 PM - 08:00 PM', 970),\n",
    "        ('Dr. Nusrat Jahan', 'Dentist', json.dumps(['Monday', 'Friday']), '11:00 AM - 03:00 PM', 890),\n",
    "\n",
    "        ('Dr. Mahfuz Alam', 'Eye Specialist', json.dumps(['Thursday', 'Saturday']), '09:00 AM - 12:00 PM', 1250),\n",
    "        ('Dr. Shanta Akter', 'Child Specialist', json.dumps(['Tuesday', 'Friday']), '01:00 PM - 05:00 PM', 1000),\n",
    "        ('Dr. Imtiaz Khan', 'Dentist', json.dumps(['Sunday', 'Wednesday']), '10:00 AM - 02:00 PM', 840),\n",
    "        ('Dr. Farid Hasan', 'Eye Specialist', json.dumps(['Monday', 'Thursday']), '03:00 PM - 07:00 PM', 1180),\n",
    "        ('Dr. Rina Begum', 'Child Specialist', json.dumps(['Wednesday', 'Saturday']), '09:00 AM - 01:00 PM', 990),\n",
    "\n",
    "        ('Dr. Ashikur Rahman', 'Dentist', json.dumps(['Tuesday', 'Friday']), '12:00 PM - 04:00 PM', 870),\n",
    "        ('Dr. Monira Sultana', 'Eye Specialist', json.dumps(['Sunday', 'Thursday']), '10:00 AM - 02:00 PM', 1300),\n",
    "        ('Dr. Hasan Mahmud', 'Child Specialist', json.dumps(['Monday', 'Wednesday']), '02:00 PM - 06:00 PM', 1010),\n",
    "        ('Dr. Shakil Ahmed', 'Dentist', json.dumps(['Friday', 'Saturday']), '09:00 AM - 12:00 PM', 800),\n",
    "        ('Dr. Tahmina Akhter', 'Eye Specialist', json.dumps(['Tuesday', 'Thursday']), '04:00 PM - 08:00 PM', 1250),\n",
    "\n",
    "        ('Dr. Rifat Hossain', 'Child Specialist', json.dumps(['Sunday', 'Monday']), '11:00 AM - 03:00 PM', 980),\n",
    "        ('Dr. Sadiya Islam', 'Dentist', json.dumps(['Wednesday', 'Friday']), '10:00 AM - 02:00 PM', 860),\n",
    "        ('Dr. Farhan Karim', 'Eye Specialist', json.dumps(['Saturday', 'Tuesday']), '01:00 PM - 05:00 PM', 1400),\n",
    "        ('Dr. Nargis Begum', 'Child Specialist', json.dumps(['Thursday', 'Friday']), '09:00 AM - 12:00 PM', 990),\n",
    "        ('Dr. Zubair Rahman', 'Dentist', json.dumps(['Monday', 'Saturday']), '03:00 PM - 07:00 PM', 900),\n",
    "\n",
    "        ('Dr. Iftekhar Alam', 'Eye Specialist', json.dumps(['Sunday', 'Tuesday']), '10:00 AM - 01:00 PM', 1200),\n",
    "        ('Dr. Shabnam Akter', 'Child Specialist', json.dumps(['Wednesday', 'Thursday']), '02:00 PM - 06:00 PM', 970),\n",
    "        ('Dr. Arman Hossain', 'Dentist', json.dumps(['Friday', 'Monday']), '11:00 AM - 03:00 PM', 830),\n",
    "        ('Dr. Mehzabin Noor', 'Eye Specialist', json.dumps(['Tuesday', 'Saturday']), '09:00 AM - 01:00 PM', 1350),\n",
    "        ('Dr. Rakib Hasan', 'Child Specialist', json.dumps(['Sunday', 'Friday']), '04:00 PM - 08:00 PM', 1000)\n",
    "        ]\n",
    "\n",
    "    await conn.executemany(\"\"\"\n",
    "    INSERT INTO doctors (doctor_name, category, visiting_days, visiting_time, visiting_money)\n",
    "    VALUES (?, ?, ?, ?, ?)\n",
    "    \"\"\", doctors_data)\n",
    "\n",
    "    await conn.commit()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "444a1052",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "langgraph",
   "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.13.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}