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