# Pastebin eXJq1i1B
use Cro::HTTP::Router;
use Cro::HTTP::Server;
use JSON::Class;
use Red;
use UUID;

model Character is table<pfapi_characters> does JSON::Class {
    has Int $.id is id;
    has Int $.tier is column;
    has Str $.comment is column;
    has DateTime $.date-added is column{ :type<timestamptz> } = DateTime.now;
    has Int $.author is column{ :type<bigint> };
}

model User is table<pfapi_users> {
    has UUID $.uuid is id;
    has Str $.username is id;
    has Int $.discord-id is column{ :type<bigint> };
    has DateTime $.date-added is column{ :type<timestamptz> } = DateTime.now;
}

my $application = route {
    get -> 'character', $id {
        request-body -> %request {
            if %request<auth> {
                my $user = User.^load(uuid => %request<auth>);
                if $user {
                    my $character = Character.^load($id);
                    note "[{DateTime.now}] Performing lookup on $id";
                    if $character {
                        content 'application/json', $character.to-json;
                    } else {
                        not-found;
                    }
                    } else {
                        forbidden;
                    }
                } else {
                    forbidden;
                }
        }
    }
}