from minibase.blueprints.user.models import Users, User_Roles
import minibase.blueprints.database.utils as dbUtils
from sqlalchemy import case


def dbGetMailFirst(mail):
    return Users.query.filter_by(email_account=mail).first()

def queryMailById(id):
    return (Users.query.filter_by(id=id).first()).email_comm

def queryRoleById(id):
    return User_Roles.query.get_or_404(id)


def queryUserNamesWithDefault(defId):
    choices = Users.query.order_by(case((Users.id == defId, 0),else_=1),Users.username.asc())
    return choices;