Hi all, I am new here and also quite new to python, so I apologize in advance for any errors I may make, just let me know any I will prevent it in the future, thank you.
So My current function is using flask, having a form to book an appointment, so far in my template for the time part is:
I receive the following:
Also another thing, I am working on linking up my database so that a Doctor will be linked with an appointment time with a patients email, any guide on how to do that would also be appreciated,
Thank you!!!
So My current function is using flask, having a form to book an appointment, so far in my template for the time part is:
<form action="/patient/patientbook" method="POST" role="form"> <label for="name">Start Time:</label> <input type="datetime-local" class="form-control" id="starttime" name="starttime" required> <br> </form>And inside my python script:
# Databse model for a Booking
class Book(db.Model):
__tablename__ = 'booking'
bid = db.Column(db.Integer, primary_key=True)
starttime = db.Column(db.DateTime(), nullable=False)
count = 1
def __init__(self, starttime):
self.starttime = Book.starttime
Book.count += 1
class BookSchema(ma.Schema):
class Meta:
# Fields to expose
fields = ('bid', 'starttime')
book_schema = BookSchema()
books_schema = BookSchema(many=True)
# Route for a patient to make a booking
@app.route("/patient/patientbook", methods=["POST", "GET"])
def patientBook():
if request.method == 'POST':
pemail = (request.form.get('email'))
pname = (request.form.get('pname'))
starttime = request.form['starttime']
print(starttime)
starttime = "{}:00".format(starttime)
print(starttime)
if pemail and pname and starttime:
new_booking = Patient(pemail, pname)
new_bookingtwo = Book(starttime)
db.session.add(new_booking)
db.session.add(new_bookingtwo)
db.session.commit()
return render_template('patient/patientbook.html')And After I have completed the process and view the results in the database (google cloud db),I receive the following:
Output:MySQL [crud]> select * from booking;
+-----+---------------------+
| bid | starttime |
+-----+---------------------+
| 1 | 0000-00-00 00:00:00 |
| 2 | 0000-00-00 00:00:00 |
| 3 | 0000-00-00 00:00:00 |
+-----+---------------------+
3 rows in set (0.11 sec)Any help appreciated!Also another thing, I am working on linking up my database so that a Doctor will be linked with an appointment time with a patients email, any guide on how to do that would also be appreciated,
Thank you!!!
