drexel-ue

{
  'user' : {
              'id' : 2,
              'name' : 'taco',
              'likes' : [
                          {
                            'id' : 3,
                            'video_id' : 23,
                            'liker_id' : 3,
                            'likee_id' : 2,

drexel-ue

QUERY:

final alertQuery = Query<User>(context)
      ..join(set: (User user) => user.likes).returningProperties(
          (Like like) => [like.createdAt, like.liker.displayName])
      ..join(set: (User user) => user.shares).returningProperties(
          (Share share) => [share.createdAt, share.sharer.displayName]);
          
RESPONSE:

drexel-ue

QUERY:

final alertQuery = Query<User>(context)
      ..where((User user) => user.id).equalTo(id)
      ..join(set: (User user) => user.likes)
          .join(object: (Like like) => like.liker)
          .returningProperties((User user) => [user.displayName])
      ..join(set: (User user) => user.shares)
          .join(object: (Share share) => share.sharer)
          .returningProperties((User user) => [user.displayName]);

drexel-ue

create table user_mapper (id serial, user_id int);

 create index on user_mapper (id);

create index on user_mapper (user_id);

create or replace function user_mapper_insert()                                                                       
Returns trigger as                                                                                                                    
$body$                                                                                                                               
begin                                                                                                                                

drexel-ue

import 'dart:async';
import 'package:aqueduct/aqueduct.dart';
import 'package:faker/faker.dart';
import 'package:uuid/uuid.dart';

class Migration9 extends Migration {
  @override
  Future upgrade() async {}

  @override

drexel-ue

error: 

*** There was an issue. Reason: there is no unique constraint matching given keys for referenced table "_video". Table: null Column: null

_hashtag:

import 'package:vw_serv/model/hashtagging.dart';
import 'package:vw_serv/vw_serv.dart';

class HashTag extends ManagedObject<_HashTag> implements _HashTag {}

drexel-ue

error: 
2019-07-19 10:13:28.664850
[WARNING] aqueduct: PostgreSQLSeverity.error 42703: column t1.video_identifier does not exist  PostgreSQLSeverity.error 42703: column t1.video_identifier does not exist 

query:
..route('/authVids').linkFunction((Request request) async {
        final query = Query<Video>(context)
          ..join(set: (Video vid) => vid.hashtaggings)
              .join(object: (HashTagging tagging) => tagging.hashTag)
              .returningProperties((HashTag tag) => [tag.tag])

drexel-ue

import 'dart:convert';

import 'package:flutter/material.dart';
import 'package:rxdart/rxdart.dart';
import 'package:trivia_black/events/game_event.dart';
import 'package:trivia_black/models/answer.dart';
import 'package:trivia_black/models/game.dart';
import 'package:trivia_black/models/point.dart';
import 'package:trivia_black/models/question.dart';
import 'package:trivia_black/models/user.dart';

drexel-ue

import 'package:flutter/cupertino.dart';
import 'package:meta/meta.dart';
import 'package:trivia_black/models/point.dart';
import 'package:trivia_black/models/user.dart';

class Game {
  Game({
    @required User turnPlayer,
    @required User waitPlayer,
    @required String challengerIdentifier,

drexel-ue

const state = {
    entities: {
        routes: {
            1: {
                id: 1,
                map: 'Uptown',
                activity: 'Walk',
                description: 'left foot right foot...',
                directions: [
                    'hop',