Galen Weber galenweber

## database_design_question.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                galenweber
                / database_design_question.md
            
            
              Last active
              June 14, 2019 18:58
            
          
    Have a data modeling question I'd be interested in your take on (if you have time):
One of the entities in our database is the Case (as in, legal case). We send a Case to a lawyer, and they can indicate if they are interested in talking to the case or not (we call this "precleared").
Then the lawyer reaches out to the client, and the lawyer can decide if they want to represent the Case or not. (we refer to this as "referred" (or not))
Then the lawyer sends a retainer agreement to the client, and the client signs that agreement (or not). (we refer to this as the Case is "retained" (or not))
If a Case is rejected at any stage, we want to capture why the Case was rejected.

  
## trigger-circle.js
/**
 * Responds to any HTTP request.
 *
 * @param {!express:Request} req HTTP request context.
 * @param {!express:Response} res HTTP response context.
 */

const https = require('https');

exports.triggerCircle = (req, res) => {

## server-with-page-based-prismic-call-with-stubbed.ts
server.get('/*', (req, res) => {
  const component = router(req.url);
  const prismicFetch = component.PRISMIC_FETCH_REQUEST
    ? component.PRISMIC_FETCH_REQUEST()
    : (() => Promise.resolve());
  prismicFetch(res.locals.ctx)
    .then((document) => {
      const element = React.createElement(component, { document });
      const page = renderToString(element);


## server-with-page-based-prismic-call.ts
server.get('/*', (req, res) => {
  const component = router(req.url);
  const prismicFetch = component.PRISMIC_FETCH_REQUEST();
  prismicFetch(res.locals.ctx)
    .then((document) => {
      const element = React.createElement(component, { document });
      const page = renderToString(element);

      // inject React page (as a string) into an HTML template
      const html = template(page);

## Terms.tsx
export default class Terms extends React.Component<Props, State> {
  constructor(props: Props) {
    super(props);
  }

  static PRISMIC_FETCH_REQUEST() {
    return (ctx: any) => ctx.api.getByUID(
      // page type
      'page',
      // uid

## server-with-basic-prismic.ts
server.get('/*', (req, res) => {
  const component = router(req.url);
  res.locals.ctx.api.getByUID('page', 'my-content')
    .then((document) => {
      const element = React.createElement(component, { document });
      const page = renderToString(element);

      // inject React page (as a string) into an HTML template
      const html = template(page);

## middleware.ts
import express from 'express';
import Prismic from 'prismic-javascript';
import PrismicDOM from 'prismic-dom';


// Middleware to inject prismic context
const injectContext: express.RequestHandler = function (req, res, next) {
  res.locals.ctx = {
    endpoint: process.env.PRISMIC_URL,
  };

## server.ts
server.get('/*', (req, res) => {
  const component = router(req.url);
  const element = React.createElement(component);
  const page = renderToString(element);

  // inject React page (as a string) into an HTML template
  const html = template(page);

  res.send(html);
});

## html.ts
const html = ({ body }: { body: string }) => `
  <!DOCTYPE html>
  <html>
    <head>
    </head>
    <body style="margin:0">
      <div id="app">${body}</div>
    </body>
    <script src="js/client.js" defer></script>
  </html>

## index.ts
import React from 'react';
import express from 'express';
import { renderToString } from 'react-dom/server';
import Counter from '../containers/Counter';
import html from '../html';

const port = 3000;
const server = express();

server.use(express.static('dist'));
	/**
	* Responds to any HTTP request.
	*
	* @param {!express:Request} req HTTP request context.
	* @param {!express:Response} res HTTP response context.
	*/

	const https = require('https');

	exports.triggerCircle = (req, res) => {
	server.get('/*', (req, res) => {
	const component = router(req.url);
	const prismicFetch = component.PRISMIC_FETCH_REQUEST
	? component.PRISMIC_FETCH_REQUEST()
	: (() => Promise.resolve());
	prismicFetch(res.locals.ctx)
	.then((document) => {
	const element = React.createElement(component, { document });
	const page = renderToString(element);
	export default class Terms extends React.Component<Props, State> {
	constructor(props: Props) {
	super(props);
	}

	static PRISMIC_FETCH_REQUEST() {
	return (ctx: any) => ctx.api.getByUID(
	// page type
	'page',
	// uid
	server.get('/*', (req, res) => {
	const component = router(req.url);
	res.locals.ctx.api.getByUID('page', 'my-content')
	.then((document) => {
	const element = React.createElement(component, { document });
	const page = renderToString(element);

	// inject React page (as a string) into an HTML template
	const html = template(page);
	import express from 'express';
	import Prismic from 'prismic-javascript';
	import PrismicDOM from 'prismic-dom';


	// Middleware to inject prismic context
	const injectContext: express.RequestHandler = function (req, res, next) {
	res.locals.ctx = {
	endpoint: process.env.PRISMIC_URL,
	};
	const html = ({ body }: { body: string }) => `
	<!DOCTYPE html>
	<html>
	<head>
	</head>
	<body style="margin:0">
	<div id="app">${body}</div>
	</body>
	<script src="js/client.js" defer></script>
	</html>
	import React from 'react';
	import express from 'express';
	import { renderToString } from 'react-dom/server';
	import Counter from '../containers/Counter';
	import html from '../html';

	const port = 3000;
	const server = express();

	server.use(express.static('dist'));