Tycholiz

This file contains snippets of code that you can execute in a postgres client in order to carry out certain user stories at the database-level

Running the below commands assumes that you have taken the 2 steps (in order):

1. seed the database
2. run latest database migrations (ie. the ones provided by the db--payment_model_changes branch of the Legible Monorepo)

Purchase a book

-- user signals intent to buy
begin;

Tycholiz

-- The enum way
create type app_public.role_types as enum (
  'READER',
  'PUBLISHER'
);

create table app_public.roles (
  id uuid primary key,
  title app_public.role_types
);

Tycholiz

#! /usr/bin/python3
import os, json, sys, xlwt, time, datetime, argparse
from datetime import timedelta, datetime
from docx import Document
from docx.shared import Inches

def parseArguments():
	parser = argparse.ArgumentParser()
	parser.add_argument("projectName", help="name of client")
	parser.add_argument("-i", "--invoice", help="include the invoice section or not?", action='store_true')