Advertisement
Guest User

Untitled

a guest
Sep 2nd, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.36 KB | None | 0 0
  1. CREATE TABLE Users (
  2. UserID int AUTO_INCREMENT,
  3. Name varchar(200) NOT NULL,
  4. Email varchar(200),
  5. Username varchar(200) NOT NULL,
  6. Password text NOT NULL,
  7. Created datetime,
  8. Updated datetime,
  9. PRIMARY KEY (UserID)
  10. );
  11.  
  12. CREATE TABLE UsersAccessLevels (
  13. UsersAccessLevelID int AUTO_INCREMENT,
  14. LevelName varchar(100) NOT NULL,
  15. AccessDescription text,
  16. PRIMARY KEY (UsersAccessLevelID)
  17. );
  18.  
  19. CREATE TABLE UsersAccessMapping (
  20. UsersAccessMappingID int AUTO_INCREMENT,
  21. UserID int NOT NULL,
  22. UsersAccessLevelID int NOT NULL,
  23. PRIMARY KEY (UsersAccessMappingID)
  24. CONSTRAINT fk_useraccess FOREIGN KEY (UserID)
  25. REFERENCES Users(UserID) ON DELETE CASCADE
  26. CONSTRAINT fk_useraccess_level FOREIGN KEY (UsersAccessLevelID)
  27. REFERENCES UsersAccessLevels(UsersAccessLevelID) ON DELETE CASCADE
  28. );
  29.  
  30. from app import db
  31.  
  32.  
  33. class Users(db.Model):
  34. """All users' information is stored here"""
  35. __tablename__ = "Users"
  36. UserID = db.Column(db.Integer(), primary_key=True)
  37. Name = db.Column(db.String(200), nullable=False)
  38. Email = db.Column(db.String(200))
  39. Username = db.Column(db.String(200), nullable=False)
  40. Password = db.Column(db.Text, nullable=False)
  41. Created = db.Column(db.DateTime)
  42. Updated = db.Column(db.DateTime)
  43.  
  44.  
  45. class UsersAccessLevels(db.Model):
  46. """This defines the various access levels users can have"""
  47. __tablename__ = "UsersAccessLevels"
  48. UsersAccessLevelID = db.Column(db.Integer, primary_key=True)
  49. LevelName = db.Column(db.String(100), nullable=False)
  50. AccessDescription = db.Column(db.Text)
  51.  
  52.  
  53. class UsersAccessMapping(db.Model):
  54. """Each users' access level is defined here"""
  55. __tablename__ = "UsersAccessMapping"
  56. UsersAccessMappingID = db.Column(db.Integer, primary_key=True)
  57. UserID = db.Column(db.Integer, nullable=False)
  58. UsersAccessLevelID = db.Column(db.Integer, nullable=False)
  59. __table_args__ = (
  60. db.ForeignKeyConstraint(
  61. ["fk_useraccess", "fk_useraccess_level"],
  62. ["Users.UserID", "UsersAccessLevels.UsersAccessLevelID"],
  63. ondelete="CASCADE"
  64. )
  65. )
  66.  
  67. File "/srv/vortech-backend/venv/lib/python3.5/site-packages/sqlalchemy/ext/declarative/base.py", line 196, in _scan_attributes
  68. "__table_args__ value must be a tuple, "
  69. sqlalchemy.exc.ArgumentError: __table_args__ value must be a tuple, dict, or None
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement