DanC5

import React from "react";
import { View, Text } from "react-native";

import { BranchConsumer } from "./BranchContext";

let DataConsumer = ({ deeplinkContent }) => {
  /* 
    at this point, all key/value pairs embedded in the deeplink 
    may be pulled off the `deeplinkContent` object for in-app use
  */

DanC5

import React, { useEffect } from "react";
import { View, Text } from "react-native";
import branch from "react-native-branch";

import BranchProvider, { BranchConsumer } from "./BranchContext";

let App = ({ setContextData }) => {
  // run code in useEffect callback on App load
  useEffect(() => {
    // branch's subscribe method listens for deeplink activity

DanC5

import React, { createContext, useState } from "react";

// create a React context for managing global state
const BranchContext = createContext();

// access context value through a consumer component
export const BranchConsumer = BranchContext.Consumer;

// save data and share with children through provider component
const BranchProvider = ({ children }) => {

DanC5

No Optimiztion:
  - time to create CSV file with ten million entries: 15 seconds
  - time to seed pricing table with CSV file: 78 seconds
  - time to run a 'SELECT * FROM pricing;' query: 110 seconds
  
 Single 'SELECT *' query:
  - Pre-indexed query by ‘day’:
	    Pre-cached speed: 5901 ms
	    Post-cashed speed: 965 ms
      

DanC5

const fs = require('fs');

const createRandomPrice = () => Math.floor(Math.random() * 100) + 100;

const columnNames = ['day', 'roomAvail', 'Priceline', 'Booking', 'Hotels',
  'OfficialHotelSite', 'Expedia', 'TripAdvisor', 'Orbitz', 'Hotwire', 'Agoda', 'CheapTickets'];

const createDailyPrices = () => {
  fs.writeFileSync('./data.csv', `${columnNames.join(',')}\n`);
  for (let j = 0; j < 1000; j += 1) {

DanC5

// GET Request

app.get('/data/toptracks', (req, res) => {
  db.getTopTracks()
    .then(results => res.json(results))
    .catch(console.log)
});


// Database Schema and Query Function