xxxxxxxxxx
from sqlalchemy.sql.expression import func
session.query(Table.column1, Table.column2, func.max(Table.column3)).group_by(Table.column1)
xxxxxxxxxx
Added_user = Instagram_Users(user_name, user_password)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
SQLAlchemy (Python code that represents an SQL query)
xxxxxxxxxx
class Contact(db.Model):
__tablename__ = 'contacts'
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(100))
last_name = db.Column(db.String(100))
phone_number = db.Column(db.String(32))
def __repr__(self):
return '<Contact {0} {1}: {2}>'.format(self.first_name,
self.last_name,
self.phone_number)