def create_app(): """ Flask application factory """ # Create Flask app load app.config app = Flask(__name__) app.config.from_object(__name__ + '.ConfigClass') db = SQLAlchemy(app) class Kullanici(db.Model): __tablename__ = 'Kullanici' id = db.Column(db.Integer, primary_key=True) tarih = db.Column(db.DateTime()) email = db.Column(db.String(80), unique=True) sifre = db.Column(db.String(80)) rolId = db.Column(db.Integer, db.ForeignKey('rol.rolId', ondelete='CASCADE')) active = db.Column('is_active', db.Boolean(), nullable=False, server_default='1') def __init__(self, email, sifre): self.email = email self.sifre = sifre self.rolId = 0
# TODO: implement any missing fields, as a database migration using Flask-Migrate class Artist(db.Model): __tablename__ = 'Artist' vbfbvb id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String) city = db.Column(db.String(120)) state = db.Column(db.String(120)) phone = db.Column(db.String(120)) genres = db.Column(db.String(120)) image_link = db.Column(db.String(500)) facebook_link = db.Column(db.String(120)) website = db.Column(db.String(120)) seeking_venue = db.Column(db.Boolean(), nullable = False, default = False) seeking_description = db.Column(db.String(500)) shows = db.relationship('Show', backref='artist', lazy=True) # TODO: implement any missing fields, as a database migration using Flask-Migrate class Show(db.Model): __tablename__ = 'Show' id = db.Column(db.Integer, primary_key=True) venue_id = db.Column(db.Integer, db.ForeignKey('Venue.id'), nullable = False) artist_id = db.Column(db.Integer, db.ForeignKey('Artist.id'), nullable = False) start_time = db.Column(db.DateTime, nullable = False) venues = db.relationship('Show', backref='shows', lazy=True) # TODO Implement Show and Artist models, and complete all model relationships and properties, as a database migration. #----------------------------------------------------------------------------#
from flask_sqlalchemy import SQLAlchemy from sqlalchemy import cast, select, String, Text from flask_login import UserMixin import bcrypt db = SQLAlchemy() association_table = db.Table('association', db.Model.metadata, db.Column('user_id', db.Integer, db.ForeignKey("user.id")), db.Column('widget_id', db.Integer, db.ForeignKey("widget.id")), db.Column('status', db.Boolean(), nullable=False), db.Column('position', db.Integer, nullable=False) ) class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(25), unique=True, nullable=False) password = db.Column(db.String(250), unique=False, nullable=True) fullname = db.Column(db.String(50), unique=False, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) gender = db.Column(db.String(30), unique=False, nullable=True) twitter = db.Column(db.String(30), unique=True, nullable=True) country = db.Column(db.String(50), unique=False, nullable=True) city = db.Column(db.String(50), unique=False, nullable=True) is_active = db.Column(db.Boolean(), unique=False, nullable=True) # ASSOCIATION widgets = db.relationship("Widget", secondary=association_table, back_populates="users"
admin.add_view(ModelView(Violin, db.session)) admin.add_view(ModelView(ShoppingOrder, db.session)) class UserView(ModelView): def is_accessible(self): return (login.current_user.is_authenticated and current_user.AdminUser) def inaccessible_callback(self, username, **kwargs): return redirect(url_for('login', next=request.url)) column_exclude_list = ('password') isSuperUser = db.Column(db.Boolean(), default=False) from app import routes, db @manager.command def admin_create(): username = prompt('admin_username') email_address = prompt('admin_email') password = prompt_pass('admin_password') confirm_password = prompt_pass('confrim_admin_password') if not password == confirm_password: sys.exit('\n sorry password is not correct!!!!!!')
name = db.Column(db.String(250)) avatar_url = db.Column(db.String(500)) class ProjectsModel(db.Model): project_name = db.Column(db.String(250), primary_key=True) project_url = db.Column(db.String(500)) history_push = db.Table('history_push', db.Column('updated_on', db.DateTime(), primary_key=True), # updated_on db.Column('username', db.String(250), db.ForeignKey('users_model.username'), primary_key=True), # username FKdb.relationship('Tag', secondary=tags, lazy='subquery', db.Column('project_name', db.String(250), db.ForeignKey('projects_model.project_name'), nullable=False), # project_name FK db.Column('build_passed', db.Boolean(), nullable=True) # build_passed ) # ============ END Models ============ @app.route("/java/maven", methods=["POST"]) def java_maven(): repository_details = request.get_json()["repository"] full_name, clone_url = repository_details["full_name"], repository_details["clone_url"] handler_test.handle_java_maven(full_name, clone_url) return jsonify(repository_details) @app.route("/npm", methods=["POST"])