1 import { db } from './lib/db';
2 import {Player, maxHp} from "../shared/player";
3 import { random } from 'lodash';
4 import { Skills } from '../shared/skills';
5 import {Profession} from 'shared/profession';
6 import {logger} from './lib/logger';
8 export async function loadPlayer(authToken: string): Promise<Player> {
9 const res = await db.first()
12 'profession_levels.level',
13 'profession_levels.exp',
14 db.raw(`coalesce(pp.permissions, '[]'::json) as permissions`)
16 .from<Player>('players')
17 .join('profession_levels', function() {
19 this.on('profession_levels.player_id', '=', 'players.id')
20 this.andOn('profession_levels.profession', '=', 'players.profession')
24 db.raw(`(select json_agg(pp.permission) as permissions, pp.player_id from player_permissions pp group by pp.player_id) pp`),
25 'pp.player_id','=', 'players.id'
28 'players.id': authToken
34 export async function createPlayer(): Promise<Player> {
35 const raw: Partial<Player> = {
36 username: `Player${Date.now().toString().substr(-7)}`,
37 strength: random(3, 5),
38 constitution: random(3, 5),
39 dexterity: random(3, 5),
40 intelligence: random(3, 5),
43 raw.hp = maxHp(raw.constitution, 1);
45 const res = await db('players').insert(raw).returning<Player[]>('*');
46 const player = res.pop();
48 logger.log(`Created player [${player.id}]`);
53 const sql = `insert into player_skills (id, player_id) values `;
55 logger.log(`Inserted base skills for [${player.id}]`)
57 Skills.forEach(skill => {
59 values.push(skill.id, player.id);
62 await db.raw(sql + pairs.join(','), values);
64 // create the profession level
65 await db('profession_levels').insert({
67 profession: 'Wanderer',
72 logger.log(`Inserted base profession level [${player.id}]`);
78 export async function updatePlayer(player: Player) {
85 strength: player.strength,
86 constitution: player.constitution,
87 dexterity: player.dexterity,
88 intelligence: player.intelligence,
89 stat_points: player.stat_points,
92 db('profession_levels').where({
94 profession: player.profession
102 export async function movePlayer(cityId: number, playerId: string) {
103 return db('players').where({
105 }).update({city_id: cityId})
108 export async function changeProfession(player_id: string, newProfession: Profession): Promise<{level: number, exp: number}> {
112 await db('profession_levels').insert({
114 profession: newProfession,
121 const res = await db.first().select('*').from('profession_levels').where({
123 profession: newProfession
128 // profession already exists, wahtever yo!
131 await db('players').where({
133 }).update({ profession: newProfession });