Tanmai Gopal coco98
coco98
/ func-conf.js
Created
December 14, 2018 05:26
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Boolean expression for a column | |
| "column": { | |
| "_eq": "value", | |
| "_gt": "value" | |
| } | |
| // AND expression | |
| "and": { | |
| "column1": {...}, |
coco98
/ func-conf.hs
Created
December 14, 2018 06:13
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- AST1 | |
| data ColExpression = ColE ColName [OperationExpression] | |
| data BoolExpression = BECol ColExpression | |
| data BoolExpression | |
| = BEAnd [BoolExpression] | |
| | BEOr [BoolExpression] | |
| | BENot BoolExpression | |
| | BECol ColExpression |
coco98
/ camecase.graphql
Created
December 17, 2018 09:14
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| query { | |
| users { | |
| firstName | |
| } | |
| } |
coco98
/ elgordino-hasura.tf
Created
December 19, 2018 08:31
Terraform spec for Hasura on Fargate and RDS
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| provider "aws" { | |
| region = "${var.region}" | |
| } | |
| ### VPC | |
| # Fetch AZs in the current region | |
| data "aws_availability_zones" "available" {} | |
| resource "aws_vpc" "datastore" { | |
| cidr_block = "172.17.0.0/16" |
coco98
/ insert-message.graphql
Created
January 11, 2019 20:35
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mutation($message: messages_insert_input!) { | |
| insert_messages(objects:[$message]) { | |
| returning { | |
| id | |
| sender_id | |
| message | |
| } | |
| } | |
| } |
coco98
/ insert-message.graphql
Created
January 11, 2019 20:37
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mutation($message: messages_insert_input!) { | |
| insert_messages(objects:[$message]) { | |
| returning { | |
| id | |
| sender_id | |
| message | |
| } | |
| } | |
| } |
coco98
/ sample.json
Created
January 14, 2019 12:05
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "user": [ | |
| { | |
| "id": 456, | |
| "name": "Sita K", | |
| "address": { | |
| "country": "India" | |
| } | |
| }, | |
| { |
coco98
/ chinook_hasura_postgres_db.sql
Created
January 15, 2019 14:03
Chinook dataset to be imported into postgres - ideal for hasura demo
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- -- /******************************************************************************* | |
| -- -- Chinook Database - Version 1.4 | |
| -- -- Script: Chinook_PostgreSql.sql | |
| -- -- Description: Creates and populates the Chinook database. | |
| -- -- DB Server: PostgreSql | |
| -- -- Author: Luis Rocha | |
| -- -- License: http://www.codeplex.com/ChinookDatabase/license | |
| -- -- Modified By: John Atten |
coco98
/ update-relationships.graphql
Last active
March 13, 2019 06:34
single mutation to update relationships
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #Without query variables | |
| mutation updateChildren { | |
| delete_children(where: {parent_id: {_eq: 1}}) { | |
| affected_rows | |
| } | |
| insert_children(objects: [{name: "child1", parent_id: 1}, {name: "child2", parent_id: 1}]) { | |
| affected_rows | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import requests | |
| #Fetch existing tables | |
| tables = requests.post('http://localhost:8080/v1/query', json={ | |
| "type":"select", | |
| "args":{ | |
| "table": {"schema": "information_schema", "name": "tables"}, | |
| "columns": ["table_name"], | |
| "where": {"table_schema": {"$eq": "public"}} | |
| } |