Skip to content

Instantly share code, notes, and snippets.

SELECT lists_spots.list_id,
lists.name AS list_name,
lists.tags AS list_tags,
users.name AS created_by,
spot_id,
spots.name,
spots.tags AS spots_tags,
spots.address,
spots.city,
spots.state,
should be:
liked | visits | id | ...
0 0 3
4 2 2
2 2 1
getting:
liked | visits | id | ...
0 0 3
8 8 2
return db.transaction(function (trx) {
return db('equipment_pack')
.transacting(trx)
.insert(epPayload)
.returning("*")
.then(response => {
return db('characters')
.transacting(trx)
.insert({
...newCharPayload,
@Brahyt
Brahyt / Spaces-Rep-Capstone-DanielB.md
Last active December 22, 2019 00:08
Spaces-Rep-Capstone-DanielB

Backend

Questions

  • Which database tables are created in the migrations?
    • Migrattion 1
      • Users table
    • Migration 2
      • Language table
    • Migration 3
      • Word table
  • What are the endpoints for user registration, login and refresh?
div {
background-image: url(something.jpg),
url(another-thing.jpg)
}
https://github.com/thinkful-ei-heron/thingful-server-danb
https://github.com/thinkful-ei-heron/thingful-client-danb
Name: Wyrn Alliance
User Flow: https://imgur.com/xl89PB9
Images: https://imgur.com/a/l7DRla2
LiveLink: https://weyr-alliance-site-1bwjikp0u.now.sh
database: https://app.sqldbm.com/PostgreSQL/Share/Mx-sZqEorPmOwT3SbzyW1UGFrngIE8md_DYjF4jNYw0
@Brahyt
Brahyt / .md
Created November 8, 2019 19:56
Wyrn-Alliance

dfsefsehttps://trello.com/b/fP2hf6PD/wyrn-alliance

@Brahyt
Brahyt / fasef
Created November 8, 2019 19:18
fasef
const STORE = {
characters: [
{
id: 1,
name: 'opha kit',
race: 'Human',
class: 'Arcane',
sub_class: 'Wizard',
xp: 3,
hand_size: 6,
DROP TYPE IF EXISTS race CASCADE;
CREATE TYPE race AS ENUM (
'Human',
'Shield Dwarf',
'Half-Orc',
'Half-Elf',
'Sun-Elf'
);
DROP TYPE IF EXISTS char_class CASCADE;