File size: 12,871 Bytes
ac8ab2c 440d1f1 ac8ab2c | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 | {
"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
}
|