def main():
# add user
user = models.User(uuid='aaabbbcccddd', email='*****@*****.**')
db.session.add(user)
music_category = models.Category(category_name='Music',
is_archived=False,
user_id='aaabbbcccddd')
tech_category = models.Category(category_name='Tech',
is_archived=False,
user_id='aaabbbcccddd')
db.session.add(music_category)
db.session.add(tech_category)
db.session.commit()
# keywords for music
drum_keyword = models.Keyword(category_id=music_category.id,
keyword="drum")
bass_keyword = models.Keyword(category_id=music_category.id,
keyword="bass")
db.session.add(drum_keyword)
db.session.add(bass_keyword)
js_keyword = models.Keyword(category_id=tech_category.id,
keyword='javascript')
sql_keyword = models.Keyword(category_id=tech_category.id, keyword='SQL')
web_keyword = models.Keyword(category_id=tech_category.id, keyword='web')
db.session.add(js_keyword)
db.session.add(sql_keyword)
db.session.add(web_keyword)
db.session.commit()
def create_stuff():
db.create_all()
if models.Category.query.count() == 0:
prog = models.Category()
prog.name = 'Programming'
db.session.add(prog)
os = models.Category()
os.name = 'Operating Systems'
db.session.add(os)
db.session.commit()
if models.Position.query.count() == 0:
m = models.Position()
m.mnemonic = 'mensolone'
m.description = 'quello grosso, dai!'
m2 = models.Position()
m2.mnemonic = 'scaffaluccio'
m2.description = "piccino piccio'"
aut_k = models.Author()
aut_k.name = 'Kernighan'
aut_r = models.Author()
aut_r.name = 'Ritchie'
op = models.Opera()
op.title = 'Linguaggio C'
op.authors = [aut_k, aut_r]
es = models.Esemplare()
es.opera = op
es.position = m
db.session.add(es)
es = models.Esemplare()
es.opera = op
es.position = m2
db.session.add(es)
op = models.Opera()
op.title = 'The UNIX programming environment'
op.authors = [aut_k]
es = models.Esemplare()
es.opera = op
es.position = m
db.session.add(es)
db.session.commit()
if models.Role.query.count() == 0:
supa = user_datastore.create_role(name='super',
description='Will do ANYTHING')
user_datastore.create_role(name='librarian',
description='Can manage books')
db.session.commit()
if models.User.query.count() == 0:
adm = user_datastore.create_user(email='admin@test',
password=encrypt_password('password'))
user_datastore.add_role_to_user(adm, supa)
db.session.commit()
return 'created'
else:
return "C'hai provato, furbettino!"
def main():
cats = [models.Category("Transportation", "transportation", "transportation.png"),
models.Category("Maps", "maps", "map.jpg"),
models.Category("Places of Interest", "places", "poi.png"),
models.CategoryURL("Weather", app.config["WEATHER_URL"],
"weather.png", new_tab=True),
models.Category("Emergency", "emergency", "hospital.png"),
models.Category("Useful phones", "phones", "phone.png")]
return flask.render_template("home.html", categories=cats,
show_home_button=False, page_title="Home")
def insert_categories(categories):
"""insert all categories to sqlite"""
for category in categories:
current_category = models.Category(
id=category['id'],
name=category['name'],
average_rank=category['average_rank'])
DB.session.add(current_category)
def post(self):
'''
method to add a category
'''
args = self.reqparse.parse_args()
category = models.Category(args["name"], args["description"])
db.session.add(category)
db.session.commit()
return {"category": marshal(category, CATEGORY_FIELDS)}, 201
def create_category(db: Session, category: schemas.CategoryBase):
db_category = models.Category(
title = category.title,
description = category.description
)
db.add(db_category)
db.commit()
db.refresh(db_category)
return db_category
def tag_add():
form = forms.Add_Tag()
if form.validate_on_submit():
Tag = models.Category(title=form.data['title'])
mysql_db.session.add(Tag)
mysql_db.session.commit()
flash('添加成功', category='add')
AddLog.add_oplog('添加标签')
return redirect(url_for('admin.tag_add'))
return render_template('admin/add_tag.html', form=form)
def add_categories():
request_data = request.get_json()
category_store.delete()
new_categories = []
for category_row in request_data:
new_category = models.Category(id=category_row['id'],
category=category_row['category'])
category_store.add(new_category)
new_categories.append(new_category.as_dict())
result = jsonify(new_categories)
return result
def generate_exercises(users, amount=1000):
categories = [
models.Category(name=name) for name in
'relaxatie concentratie associatie confrontatie overig'.split()
]
ranges = [NumericRange(0, 5), NumericRange(5, 15), NumericRange(15, None)]
exercises = [models.Exercise(title='title%s' % i,
description='desc%s' % i,
author=random.choice(users),
category=random.choice(categories),
duration=random.choice(ranges),
difficulty=random.choice([0, 1, 2]),
) for i in xrange(amount)]
db_.session.add_all(exercises)
return exercises
#-*- coding: UTF-8-*-
from app import models, db
#Add categories
cat1 = models.Category(category_name="Arab Crossroads")
cat2 = models.Category(category_name="Film and New Media")
cat3 = models.Category(category_name="Chemistry")
cat4 = models.Category(category_name="Computer Science")
cat5 = models.Category(category_name="Core")
cat6 = models.Category(category_name="Economics")
cat7 = models.Category(category_name="Engineering")
cat8 = models.Category(category_name="History")
cat9 = models.Category(category_name="Mathematics")
cat10 = models.Category(category_name="Music")
cat11 = models.Category(category_name="Philosophy")
cat12 = models.Category(category_name="Physics")
cat13 = models.Category(category_name="Political")
cat14 = models.Category(category_name="Psychology")
cat15 = models.Category(category_name="Social Research and Public Policy")
cat16 = models.Category(category_name="Theater")
cat17 = models.Category(category_name="Visual Arts")
cat18 = models.Category(category_name="Litterature and Creative Writing")
cat19 = models.Category(category_name="Biology")
cat20 = models.Category(category_name="Language")
db.session.add_all([cat1, cat2, cat3, cat4, cat5, cat6, cat7, cat8, cat9, cat10,\
cat11, cat12, cat13, cat14, cat15, cat16, cat17, cat18, cat19, cat20])
db.session.commit()
def add():
try:
print('Adding')
print('Categorys...')
category1 = models.Category(
name='Температура',
description='Первая категория',
measure='C',
last_change=datetime.now())
category2 = models.Category(
name='Энергопотребление',
description='Вторая категория',
measure='Вт',
last_change=datetime.now())
db.session.add(category1)
db.session.add(category2)
db.session.commit()
print('Sensors...')
sens1 = models.Sensor(
code='0001',
name='First',
description='First sensor',
category_id=category1.id,
last_change=datetime.now()
)
sens2 = models.Sensor(
code='0002',
name='Second',
description='Second sensor',
category_id=category2.id,
last_change=datetime.now()
)
db.session.add(sens1)
db.session.add(sens2)
db.session.commit()
print('Dates...')
today = models.Date(
value=date.today())
db.session.add(today)
db.session.commit()
print('Datas...')
data1 = models.Data(
date_id=today.id,
time=datetime.now().time(),
value=25,
sensor_id=sens1.id
)
data2 = models.Data(
date_id=today.id,
time=datetime.now().time(),
value=23,
sensor_id=sens1.id
)
data3 = models.Data(
date_id=today.id,
time=datetime.now().time(),
value=21,
sensor_id=sens2.id
)
db.session.add(data1)
db.session.add(data2)
db.session.add(data3)
db.session.commit()
print('Compleate')
except Exception as e: # pylint: disable=W0703
print('Fail')
print(e)
db.session.rollback()
def add_data(self):
"""Add data into db."""
try:
self.datetime = datetime.utcnow()
datepoint1 = models.DatePoint(id=self.datetime.date())
datepoint2 = models.DatePoint(id=self.datetime.date() -
timedelta(days=1))
datepoint3 = models.DatePoint(id=self.datetime.date() -
timedelta(days=2))
db.session.add(datepoint1)
db.session.add(datepoint2)
db.session.add(datepoint3)
db.session.commit()
timepoint1 = models.TimePoint(id=self.datetime,
date_id=datepoint1.id)
timepoint2 = models.TimePoint(id=self.datetime -
timedelta(days=1, hours=2),
date_id=datepoint2.id)
timepoint3 = models.TimePoint(id=self.datetime -
timedelta(days=2, hours=5),
date_id=datepoint3.id)
db.session.add(timepoint1)
db.session.add(timepoint2)
db.session.add(timepoint3)
db.session.commit()
node1 = models.Node(name='Node 1',
ref='node1.com',
description='Empty',
enabled=True,
time_id=timepoint1.id)
node2 = models.Node(name='Node 2',
ref='node2.com',
description='Empty',
enabled=True,
time_id=timepoint1.id)
db.session.add(node1)
db.session.add(node2)
db.session.commit()
cat1 = models.Category(name='Cat 1',
measure='AAA',
description='Empty',
enabled=True,
time_id=timepoint1.id)
cat2 = models.Category(name='Cat 2',
measure='AAA',
description='Empty',
enabled=True,
time_id=timepoint1.id)
db.session.add(cat1)
db.session.add(cat2)
db.session.commit()
sens1 = models.Sensor(name='Sens 1',
code='0001',
description='Empty',
enabled=True,
category_id=cat1.id,
node_id=node1.id,
time_id=timepoint1.id)
sens2 = models.Sensor(name='Sens 2',
code='0002',
description='Empty',
enabled=True,
category_id=cat1.id,
node_id=node2.id,
time_id=timepoint2.id)
sens3 = models.Sensor(name='Sens 3',
code='0003',
description='Empty',
enabled=True,
category_id=cat2.id,
node_id=node1.id,
time_id=timepoint1.id)
db.session.add(sens1)
db.session.add(sens2)
db.session.add(sens3)
db.session.commit()
data1 = models.Data(value=17,
sensor_id=sens1.id,
time_id=timepoint3.id)
data2 = models.Data(value=14,
sensor_id=sens1.id,
time_id=timepoint2.id)
data3 = models.Data(value=15,
sensor_id=sens2.id,
time_id=timepoint2.id)
data4 = models.Data(value=13,
sensor_id=sens3.id,
time_id=timepoint1.id)
data5 = models.Data(value=12,
sensor_id=sens2.id,
time_id=timepoint1.id)
data6 = models.Data(value=11,
sensor_id=sens1.id,
time_id=timepoint1.id)
db.session.add(data1)
db.session.add(data2)
db.session.add(data3)
db.session.add(data4)
db.session.add(data5)
db.session.add(data6)
db.session.commit()
except Exception as e: # pylint: disable=W0703
print('Fail add data.')
print(e)
db.session.rollback()
def create(self, args):
category = m.Category(**args)
db.session.add(category)
db.session.commit()
return category
from app import db, models
cat = models.Category(name="Politics")
db.session.add(cat)
cat = models.Category(name="Entertainment")
db.session.add(cat)
cat = models.Category(name="Sports")
db.session.add(cat)
cat = models.Category(name="Education")
db.session.add(cat)
cat = models.Category(name="Spiritual")
db.session.add(cat)
cat = models.Category(name="Mythological")
db.session.add(cat)
cat = models.Category(name="Books")
db.session.add(cat)
cat = models.Category(name="Web Technology")
db.session.add(cat)
db.session.commit()
u = models.User(name="Animesh Kumar",
email="*****@*****.**",
password_hash="qwe123")
db.session.add(u)
u = models.User(name="Utkarsh Bansal",
email="*****@*****.**",
password_hash="rty456")
db.session.add(u)
p = models.Poll(body="Which party should win the upcoming Delhi elections?",
user_id=1,
cat_id=1,
anonymous=False)
db.session.add(p)
from app import models, db, stores
dummy_courses = [
models.Course(id=1, category=1, course='Aqua Dive'),
models.Course(id=2, category=2, course='First Aids'),
models.Course(id=3, category=2, course='Walid'),
]
dummy_instructor = [
models.Instructor(id=1, instructor='renzo'),
models.Instructor(id=2, instructor='walid'),
]
dummy_categories = [
models.Category(id=1, category='prof'),
models.Category(id=2, category='aqua'),
]
dummy_places = [
models.Place(id=1, place='f place'),
models.Place(id=2, place='s place')
]
dummy_points = [
models.Point(id=1, point='f point'),
models.Point(id=2, point='s point'),
]
def seed_courses(course_store, instructor_store, category_store, place_store,
point_store):
def add_category():
c = models.Category(name='Auto & Transport')
db.session.add(c)
c = models.Category(name='Bills & Utilities')
db.session.add(c)
c = models.Category(name='Business Services')
db.session.add(c)
c = models.Category(name='Education')
db.session.add(c)
c = models.Category(name='Entertainment')
db.session.add(c)
c = models.Category(name='Fees & Charges')
db.session.add(c)
c = models.Category(name='Financial')
db.session.add(c)
c = models.Category(name='Food & Dining')
db.session.add(c)
c = models.Category(name='Gifts & Donations')
db.session.add(c)
c = models.Category(name='Health & Fitness')
db.session.add(c)
c = models.Category(name='Home')
db.session.add(c)
c = models.Category(name='Income')
db.session.add(c)
c = models.Category(name='Kids')
db.session.add(c)
c = models.Category(name='Misc Expenses')
db.session.add(c)
c = models.Category(name='Personal Care')
db.session.add(c)
c = models.Category(name='Pets')
db.session.add(c)
c = models.Category(name='Shopping')
db.session.add(c)
c = models.Category(name='Taxes')
db.session.add(c)
c = models.Category(name='Transfer')
db.session.add(c)
c = models.Category(name='Travel')
db.session.add(c)
c = models.Category(name='Uncategorized')
db.session.add(c)
db.session.commit()
from app import models, db
from app import stores
db.drop_all()
db.create_all()
user = models.User(username='******', email='*****@*****.**')
user.hash_password('wwzzaa')
user_store = stores.UserStore()
user_store.add(user)
cat1 = models.Category(name='Sports', user_id=user.id)
cat2 = models.Category(name='Music', user_id=user.id)
cat3 = models.Category(name='Art', user_id=user.id)
cat_store = stores.CategoryStore()
cat_store.add(cat1)
cat_store.add(cat2)
cat_store.add(cat3)
dummy_items = {
models.Item(name='Football',
description="It's the most popular sport in the world!",
category_id=cat1.id,
user_id=user.id),
models.Item(name='Basketball',
description="It's the most amusing for many Americans!",
category_id=cat1.id,
user_id=user.id),
models.Item(name='Karate',
def fill(obj):
# useramount = 5
# exerciseamount = 25
# users = generate_users(amount=useramount)
# exercises = generate_exercises(users, amount=exerciseamount)
# generate_ratings(users, exercises[:exerciseamount / 2])
# users[0].favorite_exercises = exercises[:8]
categories = [
models.Category(name=name) for name in
'relaxatie concentratie associatie confrontatie overig'.split()
]
db_.session.add_all(categories)
ranges = [NumericRange(0, 5), NumericRange(5, 15), NumericRange(15, None)]
amc = models.User(username='******', password='******')
db_.session.add(amc)
ex1 = models.Exercise(title='2-minuten aandacht oefening',
author=amc,
category=categories[0],
duration=ranges[0],
difficulty=0,
default=True,
description=('Ga op een plek zitten waar u rustig de oefening kunt doen. Zit rechtop, schouders en buik ontspannen, hoofd rechtop. Zet een timer op 2 minuten en sluit uw ogen.'
'\n'
'\n'
'Merk op of en waar u spanning en ontspanning voelt en wat de hoogte van de spanning is. U kunt een cijfer tussen 0 en 100 geven als indicatie. Ga met uw aandacht naar de ademhaling.'
'Merk op waar u de beweging voelt, wat het tempo is van de ademhaling en hoeveel ruimte u hebt om te ademen. Als u een gedachte hebt, merk hem op en ga rustig en zonder oordeel terug naar de oefening.'
'\n'
'\n'
'Blijf dit herhalen totdat u merkt dat u met uw aandacht bij u ademhaling kunt blijven. Merk na 2 minuten wederom op hoe hoog de spanning in uw lichaam is. Doe rustig uw ogen open en merk op hoe u zich voelt. Geef uzelf wederom een cijfer voor de hoogte van de spanning.')
)
db_.session.add(ex1)
ex2 = models.Exercise(title='Oefening Jacobsen',
author=amc,
category=categories[0],
duration=ranges[0],
difficulty=0,
default=True,
description=('Tijdens deze ontspanningsoefening span je je spieren stevig aan, waarna je ze weer ontspant. Door het aan- en ontspannen krijg je een zwaar ontspannen gevoel in je spieren. Door regelmatig deze oefening met aandacht te herhalen leer je spanning, zowel lichamelijk als geestelijk vroegtijdig herkennen zodat je deze actief kan loslaten.'
'\n'
'\n'
'Als u het prettig vindt om thuis te oefenen met een stem erbij kunt u op internet verschillende Jacobson-oefeningen vinden op [ioconsult](http://www.ioconsult.nl/audio/)')
)
db_.session.add(ex2)
ex3 = models.Exercise(title='Moodboard',
author=amc,
category=categories[2],
duration=ranges[0],
difficulty=0,
default=True,
description=('Met deze techniek brengt u de associaties in beeld die u met het geluid heeft. Maak uw hoofd leeg. Concentreer u op uw misofoniegeluid. Probeer een paar minuten alleen daaraan te denken. Registreer welk emotie, beeld, kleur, vorm, associatie dat bij u oproept. Deze [video](https://www.youtube.com/watch?v=uJWqhQQLJ1Y) laat zien hoe je een moodboard kan maken.'
'\n'
'\n'
'Maak ook een positief moodboard over uw misofoniegeluiden. Welke positieve associaties zou u met het geluid willen hebben?'
'\n'
'\n'
'Maak nog een tweede positief moodboard, vol associaties die u een positief gevoel geven: blijdschap, trots, vreugde, geluk, feestelijk, geroerd, ontspannen, etc. In dit moodboard komen de associaties die u bij deze positieve emoties heeft.')
)
db_.session.add(ex3)
ex4 = models.Exercise(title='Lage ademhaling',
author=amc,
category=categories[0],
duration=ranges[1],
difficulty=0,
default=True,
description=('Ga op uw rug liggen met de benen gestrekt en de armen langs uw lichaam. Handpalmen wijzen omhoog. Doe uw ogen dicht en richt uw aandacht op uw adem. Leg een hand op de plek van de romp die beweegt bij de in- en uitademing. Leg zachtjes beide handen of een voorwerp op uw buik en volg uw adem. Voel hoe uw buik met elke inademing omhoog komt en bij elke uitademing zakt. Adem door uw neus.'
'\n'
'\n'
'Als u het lastig vindt om met uw buik te ademen, oefen dan druk uit met uw hand op de buik tijdens de uitademing en laat uw buik uw hand weer omhoog duwen terwijl u diep inademt. Beweegt uw borst mee met de buik of blijft uw borst onbeweeglijk? Laat een paar minuten uw borst de beweging van de buik volgen. Vindt u de buikademhaling nog steeds moeilijk ga dan op uw buik liggen met u hoofd op uw gevouwen handen en duw uzelf omhoog vanuit uw buik.')
)
db_.session.add(ex4)
ex5 = models.Exercise(title='Diepe ademhaling',
author=amc,
category=categories[0],
duration=ranges[-1],
difficulty=0,
default=True,
description=('Ga op uw rug liggen met de benen gebogen en uw voeten plat op de grond. Scan uw lichaam om erachter te komen waar spanning zit. Leg een hand op uw borst en op uw buik. Adem langzaam en diep in door uw neus tot in uw buik en duw uw hand zo ver mogelijk omhoog. Zorg ervoor dat u borst licht meebeweegt, maar alleen samen met de buik.'
'\n'
'\n'
'Als dit goed gaat ademt u in door uw neus en uit door uw mond, waarbij u een ontspannen zacht blaasgeluid produceert zoals het suizen van de wind. Uw mond, tong en kaak zijn ontspannen. Adem langzaam en diep in zodat uw buik goed omhoog komt. Concentreer u op het geluid en het gevoel van ademhalen terwijl u zich steeds meer ontspant. Doe deze oefening dagelijks 5-10 minuten achter elkaar. Als u wilt kan u de duur geleidelijk opvoeren tot 20 minuten.'
'\n'
'\n'
'Maak aan het einde van de sessie tijd om nogmaals de bodyscan te doen om op zoek te gaan naar spanningen. Vergelijk deze spanning met die van voor de oefening. Wanneer u vertrouwd bent met deze oefening kunt u deze op elk moment van de dag doen, in elke liggende of staande houding.'
'')
)
db_.session.add(ex5)
basedir = os.path.abspath(os.path.dirname(__file__))
with open(os.path.join(basedir, 'amisos.json')) as amisos_json:
data = json.load(amisos_json)
amisos = models.Questionnaire.create(db_.session, data)
db_.session.add(amisos)
basedir = os.path.abspath(os.path.dirname(__file__))
with open(os.path.join(basedir, 'stress.json')) as stress_json:
data = json.load(stress_json)
stress = models.Questionnaire.create(db_.session, data)
db_.session.add(stress)
db_.session.commit()
username=user.username,
email=user.email,
password_hash=user.password_hash,
))
destination_session.add_all(users)
destination_session.flush()
categories = []
category_parent_ids = {}
for category in source_session.query(m.Category):
category_parent_ids[category.id] = category.parent_id
categories.append(
m.Category(
id=category.id,
name=category.name,
# parent_id=category.parent_id,
rank=category.rank,
category_type=category.category_type,
))
destination_session.add_all(categories)
destination_session.flush()
# add parent_ids after flushing to prevent foreign key contraint failures
# sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError)
# (1452, 'Cannot add or update a child row: a foreign key constraint fails
for category in categories:
category.parent_id = category_parent_ids.get(category.id)
destination_session.flush()
accounts = []
for account in source_session.query(m.Account):
def create_category(category: schemas.CategoryBase):
db_category = models.Category(title=category.title,
description=category.description)
db_category.save()
return db_category