Models#

Creating a model#

Here is a sample model which uses sqlalchemy

 1from init import db
 2from modules.box__default.i18n.models import LangRecord
 3
 4from shopyo.api.models import PkModel
 5
 6
 7class Page(PkModel):
 8    __tablename__ = "pages"
 9
10    created_date = db.Column(db.DateTime, default=datetime.now())
11    title = db.Column(db.String(100))
12    slug = db.Column(db.String(100))
13
14    def insert_lang(self, lang, content):
15        record = LangRecord(strid=self.get_strid(), lang=lang, string=content)
16        record.save(commit=False)
17
18    def set_lang(self, lang, content, commit=False):
19        record = LangRecord.query.filter(
20            LangRecord.strid == self.get_strid(), LangRecord.lang == lang

🔩 Migrations#

Note

You can run

shopyo <command>

or

python manage.py <command>

In case of change to models, do

python manage.py db migrate
python manage.py db upgrade