Torquent turpis non a quisque vehicula ullamcorper fusce a a condimentum scelerisque velit a semper a netus per blandit ullamcorper turpis ultrices erat adipiscing sit sit curabitur. Vehicula suspendisse vestibulum consectetur nec et tortor a magna suscipit quis curae elementum netus id ad lobortis adipiscing scelerisque vestibulum dui elit vestibulum a. Blandit ligula orci nibh ullamcorper facilisis egestas in convallis scelerisque ad nibh parturient tincidunt ullamcorper. Potenti ornare venenatis natoque velit parturient curae ridiculus mus vestibulum leo parturient dictum inceptos viverra. Vestibulum at suspendisse pharetra nostra sociis enim mi sagittis porta mattis facilisi suspendisse auctor curabitur at fringilla a integer magnis venenatis.

• Bullet 1

• Bullet 2

Heading 2 content

Heading 3 content

This is blockquote (Test 8 MB Without Cover) Neque per hac imperdiet adipiscing litora nascetur volutpat mi adipiscing ultrices a tincidunt parturient purus.

https://opensea.io/assets/0xb85f68fc777904be4A91A12d41795007dbe4bCA0/1

from flask_restful import Resource, Api, request
from package.model import conn

class Appointments(Resource):
    """API untuk menampilkan seluruh data rujukan"""

    def get(self):
        """API untuk mengambil data rujukan"""

        appointment = conn.execute("SELECT p.*,d.*,a.* from appointment a LEFT JOIN patient p ON a.pat_id = p.pat_id LEFT JOIN doctor d ON a.doc_id = d.doc_id ORDER BY appointment_date DESC").fetchall()
        return appointment

    def post(self):
        """API untuk menambahkan data rujukan dengan ID pasien dan ID dokter"""

        appointment = request.get_json(force=True)
        pat_id = appointment['pat_id']
        doc_id = appointment['doc_id']
        appointment_date = appointment['appointment_date']
        appointment['app_id'] = conn.execute('''INSERT INTO appointment(pat_id,doc_id,appointment_date)
            VALUES(?,?,?)''', (pat_id, doc_id,appointment_date)).lastrowid
        conn.commit()
        return appointment


class Appointment(Resource):
    """API yang mengatur data tunggal rujukan"""

    def get(self,id):
        """API data tunggal rujukan lewat ID"""

        appointment = conn.execute("SELECT * FROM appointment WHERE app_id=?",(id,)).fetchall()
        return appointment


    def delete(self,id):
        """API menghapus data pasien lewat ID"""

        conn.execute("DELETE FROM appointment WHERE app_id=?",(id,))
        conn.commit()
        return {'msg': 'sucessfully deleted'}

    def put(self,id):
        """API untuk update data rujukan lewat ID"""

        appointment = request.get_json(force=True)
        pat_id = appointment['pat_id']
        doc_id = appointment['doc_id']
        conn.execute("UPDATE appointment SET pat_id=?,doc_id=? WHERE app_id=?",
                     (pat_id, doc_id, id))
        conn.commit()
        return appointment