Ggtcf

Why don't electromagnetic waves interact with each other?

Why did the Germans forbid the possession of pet pigeons in Rostov-on-Don in 1941?

Why CLRS example on residual networks does not follows its formula?

What are these boxed doors outside store fronts in New York?

Why don't electron-positron collisions release infinite energy?

What do the dots in this tr command do: tr .............A-Z A-ZA-Z <<< "JVPQBOV" (with 13 dots)

How do I create uniquely male characters?

What defenses are there against being summoned by the Gate spell?

Writing rule which states that two causes for the same superpower is bad writing

Shell script not opening as desktop application

Why are only specific transaction types accepted into the mempool?

Infinite past with a beginning?

How is this relation reflexive?

Why can't I see bouncing of a switch on an oscilloscope?

Why Is Death Allowed In the Matrix?

Why was the small council so happy for Tyrion to become the Master of Coin?

Can I interfere when another PC is about to be attacked?

Can an x86 CPU running in real mode be considered to be basically an 8086 CPU?

What is the offset in a seaplane's hull?

Is there a familial term for apples and pears?

declaring a variable twice in IIFE

A function which translates a sentence to title-case

Proof for divisibility of polynomials.

Why doesn't Newton's third law mean a person bounces back to where they started when they hit the ground?

In Python Flask, how to get the role name by the current logged in user?

How do I copy a file in Python?How can I safely create a nested directory in Python?How to get the current time in PythonHow can I make a time delay in Python?Getting the class name of an instance?Getting the last element of a list in PythonHow do I get the number of elements in a list in Python?How do I concatenate two lists in Python?How do I lowercase a string in Python?SQLAlchemy relationships, when to use which relationship?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have 3 tables for user-role many-to-many relationship in Flask. How should I get the role name from the current user?

In my models.py

class User(db.Model, UserMixin):
 __tablename__ = "Users"
 id = db.Column(db.Integer, primary_key=True)
 username = db.Column(db.String(100), nullable=False, unique=True)
 password = db.Column(db.String(255), nullable=False, server_default='')

 # Define the relationship to Role via UserRoles
 roles = db.relationship('Role', secondary='UserRoles', backref=db.backref("user", lazy="dynamic"))


# Define the Role data-model
class Role(db.Model):
 __tablename__ = 'Roles'
 id = db.Column(db.Integer(), primary_key=True)
 name = db.Column(db.String(50), unique=True)
 users = db.relationship('User', secondary='UserRoles', backref=db.backref("role", lazy="dynamic"))


# # Define the UserRoles association table
class UserRole(db.Model):
 __tablename__ = 'UserRoles'
 id = db.Column(db.Integer(), primary_key=True)
 user_id = db.Column(db.Integer(), db.ForeignKey('Users.id', ondelete='CASCADE'))
 role_id = db.Column(db.Integer(), db.ForeignKey('Roles.id', ondelete='CASCADE'))

In my views.py:

from flask_user import current_user

@app.route("/TestUserRole")
def user_role():
 role = current_user.role
 return str(role)

On the browser, it shows me the returned result:

SELECT [Roles].id AS [Roles_id], [Roles].name AS [Roles_name] FROM [Roles], [UserRoles] WHERE [UserRoles].user_id = ? AND [Roles].id = [UserRoles].role_id

Is there a possible way to show the role name of the current user, something like the following (bad example, though, since it will pop out error)?

role = current_user.role.name

python flask flask-sqlalchemy flask-login

share|improve this question

asked Mar 9 at 3:35

D EmmaD Emma

62

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Try user_roles = [role.name for role in current_user.roles]
  
  – tntxtnt
  Mar 9 at 4:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you not do something like Role.query.get(**current users role id**) and add this as an extra column? I'm new too :)
  
  – Andrew Allen
  Mar 11 at 16:19
  

  
  
  
  

add a comment | 

0

I have 3 tables for user-role many-to-many relationship in Flask. How should I get the role name from the current user?

In my models.py

class User(db.Model, UserMixin):
 __tablename__ = "Users"
 id = db.Column(db.Integer, primary_key=True)
 username = db.Column(db.String(100), nullable=False, unique=True)
 password = db.Column(db.String(255), nullable=False, server_default='')

 # Define the relationship to Role via UserRoles
 roles = db.relationship('Role', secondary='UserRoles', backref=db.backref("user", lazy="dynamic"))


# Define the Role data-model
class Role(db.Model):
 __tablename__ = 'Roles'
 id = db.Column(db.Integer(), primary_key=True)
 name = db.Column(db.String(50), unique=True)
 users = db.relationship('User', secondary='UserRoles', backref=db.backref("role", lazy="dynamic"))


# # Define the UserRoles association table
class UserRole(db.Model):
 __tablename__ = 'UserRoles'
 id = db.Column(db.Integer(), primary_key=True)
 user_id = db.Column(db.Integer(), db.ForeignKey('Users.id', ondelete='CASCADE'))
 role_id = db.Column(db.Integer(), db.ForeignKey('Roles.id', ondelete='CASCADE'))

In my views.py:

from flask_user import current_user

@app.route("/TestUserRole")
def user_role():
 role = current_user.role
 return str(role)

On the browser, it shows me the returned result:

SELECT [Roles].id AS [Roles_id], [Roles].name AS [Roles_name] FROM [Roles], [UserRoles] WHERE [UserRoles].user_id = ? AND [Roles].id = [UserRoles].role_id

Is there a possible way to show the role name of the current user, something like the following (bad example, though, since it will pop out error)?

role = current_user.role.name

python flask flask-sqlalchemy flask-login

share|improve this question

asked Mar 9 at 3:35

D EmmaD Emma

62

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Try user_roles = [role.name for role in current_user.roles]
  
  – tntxtnt
  Mar 9 at 4:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you not do something like Role.query.get(**current users role id**) and add this as an extra column? I'm new too :)
  
  – Andrew Allen
  Mar 11 at 16:19
  

  
  
  
  

add a comment | 

I have 3 tables for user-role many-to-many relationship in Flask. How should I get the role name from the current user?

In my models.py

class User(db.Model, UserMixin):
 __tablename__ = "Users"
 id = db.Column(db.Integer, primary_key=True)
 username = db.Column(db.String(100), nullable=False, unique=True)
 password = db.Column(db.String(255), nullable=False, server_default='')

 # Define the relationship to Role via UserRoles
 roles = db.relationship('Role', secondary='UserRoles', backref=db.backref("user", lazy="dynamic"))


# Define the Role data-model
class Role(db.Model):
 __tablename__ = 'Roles'
 id = db.Column(db.Integer(), primary_key=True)
 name = db.Column(db.String(50), unique=True)
 users = db.relationship('User', secondary='UserRoles', backref=db.backref("role", lazy="dynamic"))


# # Define the UserRoles association table
class UserRole(db.Model):
 __tablename__ = 'UserRoles'
 id = db.Column(db.Integer(), primary_key=True)
 user_id = db.Column(db.Integer(), db.ForeignKey('Users.id', ondelete='CASCADE'))
 role_id = db.Column(db.Integer(), db.ForeignKey('Roles.id', ondelete='CASCADE'))

In my views.py:

from flask_user import current_user

@app.route("/TestUserRole")
def user_role():
 role = current_user.role
 return str(role)

On the browser, it shows me the returned result:

SELECT [Roles].id AS [Roles_id], [Roles].name AS [Roles_name] FROM [Roles], [UserRoles] WHERE [UserRoles].user_id = ? AND [Roles].id = [UserRoles].role_id

Is there a possible way to show the role name of the current user, something like the following (bad example, though, since it will pop out error)?

role = current_user.role.name

python flask flask-sqlalchemy flask-login

share|improve this question

asked Mar 9 at 3:35

D EmmaD Emma

62

class User(db.Model, UserMixin):
 __tablename__ = "Users"
 id = db.Column(db.Integer, primary_key=True)
 username = db.Column(db.String(100), nullable=False, unique=True)
 password = db.Column(db.String(255), nullable=False, server_default='')

 # Define the relationship to Role via UserRoles
 roles = db.relationship('Role', secondary='UserRoles', backref=db.backref("user", lazy="dynamic"))


# Define the Role data-model
class Role(db.Model):
 __tablename__ = 'Roles'
 id = db.Column(db.Integer(), primary_key=True)
 name = db.Column(db.String(50), unique=True)
 users = db.relationship('User', secondary='UserRoles', backref=db.backref("role", lazy="dynamic"))


# # Define the UserRoles association table
class UserRole(db.Model):
 __tablename__ = 'UserRoles'
 id = db.Column(db.Integer(), primary_key=True)
 user_id = db.Column(db.Integer(), db.ForeignKey('Users.id', ondelete='CASCADE'))
 role_id = db.Column(db.Integer(), db.ForeignKey('Roles.id', ondelete='CASCADE'))

from flask_user import current_user

@app.route("/TestUserRole")
def user_role():
 role = current_user.role
 return str(role)

SELECT [Roles].id AS [Roles_id], [Roles].name AS [Roles_name] FROM [Roles], [UserRoles] WHERE [UserRoles].user_id = ? AND [Roles].id = [UserRoles].role_id

role = current_user.role.name

share|improve this question

asked Mar 9 at 3:35

D EmmaD Emma

62

share|improve this question

asked Mar 9 at 3:35

D EmmaD Emma

62

asked Mar 9 at 3:35

D EmmaD Emma

62

asked Mar 9 at 3:35

D EmmaD Emma

62