def create_user(DBSession, user, password):
from gengine.app.model import (AuthUser, Subject, AuthRole,
AuthRolePermission, SubjectType,
t_auth_roles_permissions)
with transaction.manager:
subjecttype_user = DBSession.query(SubjectType).filter_by(
name="User").first()
if not subjecttype_user:
subjecttype_user = SubjectType(name="User")
DBSession.add(subjecttype_user)
existing = DBSession.query(AuthUser).filter_by(email=user).first()
DBSession.flush()
if not existing:
user1 = Subject(lat=10,
lng=50,
timezone="Europe/Berlin",
subjecttype_id=subjecttype_user.id)
DBSession.add(user1)
DBSession.flush()
auth_user = AuthUser(subject=user1,
email=user,
password=password,
active=True)
DBSession.add(auth_user)
auth_role = get_or_create_role(DBSession=DBSession,
name="Global Admin")
for perm in yield_all_perms():
if not exists_by_expr(
t_auth_roles_permissions,
and_(
t_auth_roles_permissions.c.auth_role_id
== auth_role.id, t_auth_roles_permissions.c.name
== perm[0])):
DBSession.add(
AuthRolePermission(role=auth_role, name=perm[0]))
auth_user.roles.append(auth_role)
DBSession.add(auth_user)
DBSession.flush()
def register_device(request):
try:
doc = request.json_body
except:
raise APIError(400, "invalid_json", "no valid json body")
subject_id = int(request.matchdict["subject_id"])
device_id = doc.get("device_id")
push_id = doc.get("push_id")
device_os = doc.get("device_os")
app_version = doc.get("app_version")
if not device_id \
or not push_id \
or not subject_id \
or not device_os \
or not app_version:
raise APIError(
400, "register_device.required_fields",
"Required fields: device_id, push_id, device_os, app_version")
if asbool(get_settings().get("enable_user_authentication", False)):
may_register = request.has_perm(
perm_global_register_device
) or request.has_perm(perm_own_register_device) and str(
request.subject.id) == str(subject_id)
if not may_register:
raise APIError(403, "forbidden",
"You may not register devices for this subject.")
if not exists_by_expr(t_subjects, t_subjects.c.id == subject_id):
raise APIError(404, "register_device.subject_not_found",
"There is no subject with this id.")
SubjectDevice.add_or_update_device(subject_id=subject_id,
device_id=device_id,
push_id=push_id,
device_os=device_os,
app_version=app_version)
return {"status": "ok"}
def set_messages_read(request):
try:
doc = request.json_body
except:
raise APIError(400, "invalid_json", "no valid json body")
subject_id = int(request.matchdict["subject_id"])
if asbool(get_settings().get("enable_user_authentication", False)):
may_read_messages = request.has_perm(
perm_global_read_messages
) or request.has_perm(perm_own_read_messages) and str(
request.subject.id) == str(subject_id)
if not may_read_messages:
raise APIError(403, "forbidden",
"You may not read the messages of this subject.")
if not exists_by_expr(t_subjects, t_subjects.c.id == subject_id):
raise APIError(404, "set_messages_read.subject_not_found",
"There is no subject with this id.")
message_id = doc.get("message_id")
q = select([t_subject_messages.c.id, t_subject_messages.c.created_at],
from_obj=t_subject_messages).where(
and_(t_subject_messages.c.id == message_id,
t_subject_messages.c.subject_id == subject_id))
msg = DBSession.execute(q).fetchone()
if not msg:
raise APIError(404, "set_messages_read.message_not_found",
"There is no message with this id.")
uS = update_connection()
uS.execute(t_subject_messages.update().values({
"is_read": True
}).where(
and_(t_subject_messages.c.subject_id == subject_id,
t_subject_messages.c.created_at <= msg["created_at"])))
return {"status": "ok"}
def get_messages(request):
try:
subject_id = int(request.matchdict["subject_id"])
except:
subject_id = None
try:
offset = int(request.GET.get("offset", 0))
except:
offset = 0
limit = 100
if asbool(get_settings().get("enable_user_authentication", False)):
may_read_messages = request.has_perm(
perm_global_read_messages
) or request.has_perm(perm_own_read_messages) and str(
request.subject.id) == str(subject_id)
if not may_read_messages:
raise APIError(403, "forbidden",
"You may not read the messages of this subject.")
if not exists_by_expr(t_subjects, t_subjects.c.id == subject_id):
raise APIError(404, "get_messages.subject_not_found",
"There is no subject with this id.")
q = t_subject_messages.select().where(
t_subject_messages.c.subject_id == subject_id).order_by(
t_subject_messages.c.created_at.desc()).limit(limit).offset(offset)
rows = DBSession.execute(q).fetchall()
return {
"messages": [{
"id": message["id"],
"text": SubjectMessage.get_text(message),
"is_read": message["is_read"],
"created_at": message["created_at"]
} for message in rows]
}
def populate_demo(DBSession):
from gengine.app.model import (
Achievement,
AchievementCategory,
Variable,
Subject,
Language,
TranslationVariable,
Translation,
Reward,
AchievementProperty,
AchievementAchievementProperty,
AchievementReward,
AuthUser,
AuthRole,
AuthRolePermission,
SubjectType,
t_auth_roles_permissions
)
def add_translation_variable(name):
t = TranslationVariable(name=name)
DBSession.add(t)
return t
def add_translation(variable, lang, text):
tr = Translation(translationvariable=variable, text=text, language=lang)
DBSession.add(tr)
return tr
with transaction.manager:
subjecttype_country = SubjectType(name="Country")
DBSession.add(subjecttype_country)
subjecttype_region = SubjectType(name="Region")
subjecttype_region.part_of_types.append(subjecttype_country)
DBSession.add(subjecttype_region)
subjecttype_city = SubjectType(name="City")
subjecttype_city.part_of_types.append(subjecttype_region)
DBSession.add(subjecttype_city)
subjecttype_position = SubjectType(name="Position")
DBSession.add(subjecttype_position)
subjecttype_team = SubjectType(name="Team")
DBSession.add(subjecttype_team)
subjecttype_user = DBSession.query(SubjectType).filter_by(name="User").first()
if not subjecttype_user:
subjecttype_user = SubjectType(name="User")
DBSession.add(subjecttype_user)
subjecttype_user.part_of_types.append(subjecttype_city)
subjecttype_user.part_of_types.append(subjecttype_team)
subjecttype_user.part_of_types.append(subjecttype_position)
DBSession.add(subjecttype_user)
subject_germany = Subject(type=subjecttype_country, name="Germany")
DBSession.add(subject_germany)
subject_france = Subject(type=subjecttype_country, name="France")
DBSession.add(subject_france)
subject_india = Subject(type=subjecttype_country, name="India")
DBSession.add(subject_india)
subject_germany_north = Subject(type=subjecttype_region, name="Germany-North")
DBSession.add(subject_germany_north)
subject_germany_west = Subject(type=subjecttype_region, name="Germany-West")
DBSession.add(subject_germany_west)
subject_germany_east = Subject(type=subjecttype_region, name="Germany-East")
DBSession.add(subject_germany_east)
subject_germany_south = Subject(type=subjecttype_region, name="Germany-South")
DBSession.add(subject_germany_south)
subject_paderborn = Subject(type=subjecttype_city, name="Paderborn")
DBSession.add(subject_paderborn)
subject_bielefeld = Subject(type=subjecttype_city, name="Bielefeld")
DBSession.add(subject_bielefeld)
subject_detmold = Subject(type=subjecttype_city, name="Detmold")
DBSession.add(subject_detmold)
subject_berlin = Subject(type=subjecttype_city, name="Berlin")
DBSession.add(subject_berlin)
subject_sales = Subject(type=subjecttype_team, name="Sales")
DBSession.add(subject_sales)
subject_tech = Subject(type=subjecttype_team, name="Tech")
DBSession.add(subject_tech)
subject_junior_developer = Subject(type=subjecttype_position, name="Junior Developer")
DBSession.add(subject_junior_developer)
subject_senior_developer = Subject(type=subjecttype_position, name="Senior Developer")
DBSession.add(subject_senior_developer)
subject_manager = Subject(type=subjecttype_position, name="Manager")
DBSession.add(subject_manager)
subject_promoter = Subject(type=subjecttype_position, name="Promoter")
DBSession.add(subject_promoter)
DBSession.flush()
lang_de = Language(name="de")
lang_en = Language(name="en")
DBSession.add(lang_de)
DBSession.add(lang_en)
var_invited_users = Variable(name="invite_users")
DBSession.add(var_invited_users)
var_invited_users = Variable(name="participate",
group="none")
DBSession.add(var_invited_users)
achievementcategory_community = AchievementCategory(name="community")
DBSession.add(achievementcategory_community)
achievement_invite = Achievement(name='invite_users',
evaluation="immediately",
maxtimes=20,
achievementcategory=achievementcategory_community,
condition='{"term": {"type": "literal", "variable": "invite_users"}}',
goal="5*level",
operator="geq",
player_subjecttype=subjecttype_user
)
DBSession.add(achievement_invite)
achievementcategory_sports = AchievementCategory(name="sports")
DBSession.add(achievementcategory_sports)
achievement_fittest = Achievement(name='fittest',
relevance="friends",
maxlevel=100,
achievementcategory=achievementcategory_sports,
condition='{"term": {"key": ["5","7","9"], "type": "literal", "key_operator": "IN", "variable": "participate"}}',
evaluation="weekly",
goal="5*level",
player_subjecttype=subjecttype_user
)
DBSession.add(achievement_fittest)
property_name = AchievementProperty(name='name')
DBSession.add(property_name)
property_xp = AchievementProperty(name='xp')
DBSession.add(property_xp)
property_icon = AchievementProperty(name='icon')
DBSession.add(property_icon)
reward_badge = Reward(name='badge', rewarded_subjecttype=subjecttype_user)
DBSession.add(reward_badge)
reward_image = Reward(name='backgroud_image', rewarded_subjecttype=subjecttype_user)
DBSession.add(reward_image)
transvar_invite_name = add_translation_variable(name="invite_users_achievement_name")
add_translation(transvar_invite_name, lang_en, 'Invite ${5*level} Users')
add_translation(transvar_invite_name, lang_de, 'Lade ${5*level} Freunde ein')
DBSession.add(AchievementAchievementProperty(achievement=achievement_invite, property=property_name,
value_translation=transvar_invite_name))
DBSession.add(AchievementAchievementProperty(achievement=achievement_invite, property=property_xp,
value='${100 * level}'))
DBSession.add(AchievementAchievementProperty(achievement=achievement_invite, property=property_icon,
value="https://www.gamification-software.com/img/running.png"))
DBSession.add(AchievementReward(achievement=achievement_invite, reward=reward_badge,
value="https://www.gamification-software.com/img/trophy.png", from_level=5))
DBSession.add(AchievementReward(achievement=achievement_invite, reward=reward_image,
value="https://www.gamification-software.com/img/video-controller-336657_1920.jpg",
from_level=5))
transvar_fittest_name = add_translation_variable(name="fittest_achievement_name")
add_translation(transvar_fittest_name, lang_en, 'Do the most sport activities among your friends')
add_translation(transvar_fittest_name, lang_de, 'Mache unter deinen Freunden am meisten Sportaktivitäten')
DBSession.add(AchievementAchievementProperty(achievement=achievement_fittest, property=property_name,
value_translation=transvar_fittest_name))
DBSession.add(AchievementAchievementProperty(achievement=achievement_fittest, property=property_xp,
value='${50 + (200 * level)}'))
DBSession.add(AchievementAchievementProperty(achievement=achievement_fittest, property=property_icon,
value="https://www.gamification-software.com/img/colorwheel.png"))
DBSession.add(AchievementReward(achievement=achievement_fittest, reward=reward_badge,
value="https://www.gamification-software.com/img/easel.png", from_level=1))
DBSession.add(AchievementReward(achievement=achievement_fittest, reward=reward_image,
value="https://www.gamification-software.com/img/game-characters-622654.jpg",
from_level=1))
DBSession.flush()
user1 = Subject(lat=10, lng=50, timezone="Europe/Berlin", name="Fritz", type=subjecttype_user)
user2 = Subject(lat=10, lng=50, timezone="US/Eastern", name="Ludwig", type=subjecttype_user)
user3 = Subject(lat=10, lng=50, name="Helene", type=subjecttype_user)
user1.friends.append(user2)
user1.friends.append(user3)
user2.friends.append(user1)
user2.friends.append(user3)
user3.friends.append(user1)
user3.friends.append(user2)
user1.part_of_subjects.append(subject_bielefeld)
user1.part_of_subjects.append(subject_sales)
user1.part_of_subjects.append(subject_manager)
user2.part_of_subjects.append(subject_bielefeld)
user2.part_of_subjects.append(subject_sales)
user2.part_of_subjects.append(subject_promoter)
user3.part_of_subjects.append(subject_paderborn)
user3.part_of_subjects.append(subject_sales)
user3.part_of_subjects.append(subject_promoter)
DBSession.add(user2)
DBSession.add(user3)
DBSession.flush()
try:
auth_user = DBSession.query(AuthUser).filter_by(email="*****@*****.**").first()
if not auth_user:
auth_user = AuthUser(subject=user1, email="*****@*****.**", password="******",
active=True)
DBSession.add(auth_user)
auth_role = DBSession.query(AuthRole).filter_by(name="Global Admin").first()
if not auth_role:
auth_role = AuthRole(name="Global Admin")
DBSession.add(auth_role)
DBSession.flush()
for perm in yield_all_perms():
if not exists_by_expr(t_auth_roles_permissions, and_(
t_auth_roles_permissions.c.auth_role_id == auth_role.id,
t_auth_roles_permissions.c.name == perm[0]
)):
DBSession.add(AuthRolePermission(role=auth_role, name=perm[0]))
auth_user.roles.append(auth_role)
DBSession.add(auth_user)
except ImportError as e:
print("[auth] feature not installed - not importing auth demo data")