Fetching data from multiple tables in a single request.

[swaroop]

I am unable to get all the data from multiple tables in a single request.
Here this is my code.

class maindevotee(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(225)) phonenumber = db.Column(db.String(225)) gothram = db.Column(db.String(225)) date = db.Column(db.String(50)) address = db.Column(db.String(250)) def json(self): return {'id': self.id, 'name':self.name, 'phonenumber': self.phonenumber, 'gothram': self.gothram, 'date': self.date, 'address': self.address} class relatives(db.Model): id = db.Column(db.Integer, primary_key=True) main_id = db.Column(db.Integer, db.ForeignKey('maindevotee.id'), nullable=False) name = db.Column(db.String(225)) star = db.Column(db.String(225)) gender = db.Column(db.String(45)) relation = db.Column(db.String(45)) def json(self): return {'main_id': self.main_id, 'name': self.name, 'star':self.star, 'gender': self.gender, 'relation': self.relation} class services(db.Model): id = db.Column(db.Integer, primary_key=True) main_id = db.Column(db.Integer, db.ForeignKey('maindevotee.id'), nullable=False) pooja = db.Column(db.String(225)) god = db.Column(db.String(225)) price = db.Column(db.Float) donation = db.Column(db.String(225)) booking_fromdate = db.Column(db.String(50)) booking_todate = db.Column(db.String(50)) prasadam = db.Column(db.String(225)) def json(self): return {'main_id': self.main_id, 'pooja': self.pooja, 'god': self.god, 'price': self.price, 'donation': self.donation, 'booking_fromdate': self.booking_fromdate, 'booking_todate': self.booking_todate, 'prasadam': self.prasadam}

These are all my tables in a database.
and how to fetch all my data from multiple tables.
can i use foreign key to fetch data from multiple tables in a database.
Here this is what i am use this code to fetch data from multiple tables.

data = db.session.query(maindevotee, relatives, services)\ .filter( (maindevotee.phonenumber == '3251469870') & (maindevotee.id == relatives.main_id) & (maindevotee.id == services.main_id) ).first() def get_data(): return [data.json(get) for get in data.query.all()] @app.route('/getdata',methods=['GET']) def getdata(): return jsonify({'Devotee list': data.get_data()})

If i run this code it will raise an error

Error:
AttributeError: 'result' object has no attribute 'get_data'

Please help me to give your reply !