aboutsummaryrefslogtreecommitdiff
path: root/wqflask/wqflask/model.py
diff options
context:
space:
mode:
authorSam2013-09-27 00:24:38 -0500
committerSam2013-09-27 00:24:38 -0500
commitfaaa4f0a7b08d5a07c2a5a403774942e374ce0a3 (patch)
treeb4f827c4c7e1aa1dd972e2316debafe1ba1aadcb /wqflask/wqflask/model.py
parent63c691fb11a33ac70c831f5651d284f38dc27b5b (diff)
downloadgenenetwork2-faaa4f0a7b08d5a07c2a5a403774942e374ce0a3.tar.gz
Before fixing an issue in pbkdf2
Diffstat (limited to 'wqflask/wqflask/model.py')
-rw-r--r--wqflask/wqflask/model.py55
1 files changed, 30 insertions, 25 deletions
diff --git a/wqflask/wqflask/model.py b/wqflask/wqflask/model.py
index b3dfe746..603cfbc4 100644
--- a/wqflask/wqflask/model.py
+++ b/wqflask/wqflask/model.py
@@ -1,10 +1,12 @@
from __future__ import print_function, division, absolute_import
+import uuid
+
from flask.ext.sqlalchemy import SQLAlchemy
-from flask.ext.security import Security, SQLAlchemyUserDatastore, UserMixin, RoleMixin
+#from flask.ext.security import Security, SQLAlchemyUserDatastore, UserMixin, RoleMixin
-from flask_security.forms import TextField
-from flask_security.forms import RegisterForm
+#from flask_security.forms import TextField
+#from flask_security.forms import RegisterForm
from wqflask import app
@@ -37,18 +39,21 @@ db = SQLAlchemy(app)
# Define models
roles_users = db.Table('roles_users',
- db.Column('user_id', db.Integer(), db.ForeignKey('user.id')),
- db.Column('role_id', db.Integer(), db.ForeignKey('role.id')))
-
-class Role(db.Model, RoleMixin):
- id = db.Column(db.Integer(), primary_key=True)
- name = db.Column(db.String(80), unique=True)
- description = db.Column(db.String(255))
-
-class User(db.Model, UserMixin):
- id = db.Column(db.Integer(), primary_key=True)
- email = db.Column(db.String(50), unique=True)
- password = db.Column(db.String(50))
+ db.Column('user_id', db.Integer(), db.ForeignKey('user.the_id')),
+ db.Column('role_id', db.Integer(), db.ForeignKey('role.the_id')))
+
+class Role(db.Model):
+ the_id = db.Column(db.Unicode(36), primary_key=True, default=lambda: unicode(uuid.uuid4()))
+ name = db.Column(db.Unicode(80), unique=True, nullable=False)
+ description = db.Column(db.Unicode(255))
+
+class User(db.Model):
+ the_id = db.Column(db.Unicode(36), primary_key=True, default=lambda: unicode(uuid.uuid4()))
+ email_address = db.Column(db.Unicode(50), unique=True, nullable=False)
+
+ password = db.Column(db.Unicode(24), nullable=False)
+ salt = db.Column(db.Unicode(32), nullable=False)
+ password_info = db.Column(db.Unicode(50))
full_name = db.Column(db.Unicode(50))
organization = db.Column(db.Unicode(50))
@@ -58,23 +63,23 @@ class User(db.Model, UserMixin):
last_login_at = db.Column(db.DateTime())
current_login_at = db.Column(db.DateTime())
- last_login_ip = db.Column(db.String(39))
- current_login_ip = db.Column(db.String(39))
+ last_login_ip = db.Column(db.Unicode(39))
+ current_login_ip = db.Column(db.Unicode(39))
login_count = db.Column(db.Integer())
roles = db.relationship('Role', secondary=roles_users,
backref=db.backref('users', lazy='dynamic'))
# Setup Flask-Security
-user_datastore = SQLAlchemyUserDatastore(db, User, Role)
-
-class ExtendedRegisterForm(RegisterForm):
- name = TextField('name')
- #print("name is:", name['_name'], vars(name))
- organization = TextField('organization')
+#user_datastore = SQLAlchemyUserDatastore(db, User, Role)
-security = Security(app, user_datastore, register_form=ExtendedRegisterForm)
+#class ExtendedRegisterForm(RegisterForm):
+# name = TextField('name')
+# #print("name is:", name['_name'], vars(name))
+# organization = TextField('organization')
+#
+#security = Security(app, user_datastore, register_form=ExtendedRegisterForm)
db.metadata.create_all(db.engine)
-user_datastore.create_role(name="Genentech", description="Genentech Beta Project(testing)")
+#user_datastore.create_role(name="Genentech", description="Genentech Beta Project(testing)")