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
示例#2
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.

#----------------------------------------------------------------------------#
示例#3
0
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"
示例#4
0
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!!!!!!')
示例#5
0
    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"])