rs-saltly/models.py at main · mattsmida/rs-saltly · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
""" Models for saltly """

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()


class Photo(db.Model):
    """ Photos model """

    __tablename__ = 'photos'

    id = db.Column(
        db.Integer,
        primary_key=True,
        autoincrement=True)

    title = db.Column(
        db.String(300),
        nullable=False
    )

    caption = db.Column(
        db.String(700),
        nullable=False  # TODO: Add a default value of None?
    )

    s3_photo_url_orig = db.Column(
        db.String(700),
        nullable=False
    )

    s3_photo_url_display = db.Column(
        db.String(700),
        nullable=False
    )

    edited = db.Column(
        db.Boolean,
        nullable=False,
        default=False,
    )

    black_and_white = db.Column(
        db.Boolean,
        nullable=False,
        default=False,
    )

    active = db.Column(
        db.Boolean,
        nullable=False,
        default=True,
    )

    # s3_thumbnail_url = db.Column(
    #     db.String(700),
    #     nullable=False
    # )

    # exif_data = db.Column(
    #     db.String(1000)
    # )


def connect_db(app):
    """
    Connect this database to provided Flask app.
    """

    app.app_context().push()
    db.app = app
    db.init_app(app)