test.ts

import {OpR} from "./types"
import {PlayId} from "@honest-news/data-types/gameplay"
import {logDescriptor} from "./logTable"
import {nSQL} from "@nano-sql/core"

const TABLE_NAME = 'descriptor'
export const TABLE_DESCRIPTOR = {
    name: TABLE_NAME,
    model: {
        'id:uuid': {pk: true},
        'playId:string': {notNull: true},
        'descriptor:string': {notNull: true},
        'timestamp:int': {notNull: true}
    },
    indexes: {
        'playId:string': {}
    }
}

// @ts-ignore
export function insertDescriptor(playId: PlayId, descriptor: string): OpR<any> {
    // noinspection JSIgnoredPromiseFromCall
    logDescriptor(playId, descriptor)
    return nSQL(TABLE_NAME).query('upsert', {playId, descriptor, timestamp: Date.now()}).exec()
}

export function getPlayDescriptors(playId: PlayId): OpR<string[]> {
    console.log(playId)
    return nSQL(TABLE_NAME).query('select')
        .where(['playId', '=', playId])
        .exec().then(res => {
            console.log(res)
            return res.map(d => d.descriptor)
        })
}