Skip to content

Instantly share code, notes, and snippets.

View drexel-ue's full-sized avatar

IKesh Pack drexel-ue

  • Ohio
View GitHub Profile
{
'user' : {
'id' : 2,
'name' : 'taco',
'likes' : [
{
'id' : 3,
'video_id' : 23,
'liker_id' : 3,
'likee_id' : 2,
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:
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
drexel-ue / user_mapper
Last active July 15, 2019 14:24
basically, the user_mapper maps ids from _user, so that if a user is deleted, random user can still be picked without worrying about a number being generated that doesnt match an existing user
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
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
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 {}
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])
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';
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,
const state = {
entities: {
routes: {
1: {
id: 1,
map: 'Uptown',
activity: 'Walk',
description: 'left foot right foot...',
directions: [
'hop',