jjn1056

--
-- For all faculty (active and inactive) give them a grandfather license
-- and assign them as the owner. Basically the grandfather license is a license
-- to just keep doing what they already can do.  It however has an expiration
-- date 

/* 'faculty' is a set of everyone in the person table that is type faculty */
with faculty as (
  select person_id
  from person

jjn1056

             with students_in_license as (
                  select
                    p.person_id, p.first_name, p.last_name, p.email, s.license_id
                  from person p
                  join team t on t.person_id=p.person_id
                  join class c on c.class_id=t.class_id
                  left join license_person ls on ls.person_id=p.person_id
                  left join license l on l.license_id=ls.license_id
                  left join survey s on s.class_id=c.class_id and s.survey_id=t.survey_id
                  where s.license_id=?

jjn1056

CREATE TABLE employees (
    emp_no INTEGER PRIMARY KEY NOT NULL,                                            
    record_no integer NOT NULL,                                                     
    birth_date date NOT NULL,                                                       
    first_name varchar(14) NOT NULL,                                                
    last_name varchar(16) NOT NULL,                                                 
    hire_date date NOT NULL
);

jjn1056

input EmployeeMutateInput {
  birth_date: DateTime
  emp_no: Int!
  first_name: String
  gender: EmployeeGender
  hire_date: DateTime
  last_name: String
  record_no: Int
}

jjn1056

package MyApp;

use Catalyst 'OpenAPI';

__PACKAGE__->config(
  'Plugin::OpenAPI' => {
    # global settings;
  },
);

jjn1056

mm-mac-7425:Catalyst-Runtime jnapiorkowski$ make release
"/Users/jnapiorkowski/perl5/perlbrew/perls/perl-5.28.1/bin/perl" 'Distar/lib/../helpers'/check-version 5.90124 lib/.DS_Store lib/Catalyst.pm lib/Catalyst/.DS_Store lib/Catalyst/Action.pm lib/Catalyst/ActionChain.pm lib/Catalyst/ActionContainer.pm lib/Catalyst/ActionRole/.DS_Store lib/Catalyst/ActionRole/ConsumesContent.pm lib/Catalyst/ActionRole/HTTPMethods.pm lib/Catalyst/ActionRole/QueryMatching.pm lib/Catalyst/ActionRole/Scheme.pm lib/Catalyst/Base.pm lib/Catalyst/ClassData.pm lib/Catalyst/Component.pm lib/Catalyst/Component/.DS_Store lib/Catalyst/Component/ApplicationAttribute.pm lib/Catalyst/Component/ContextClosure.pm lib/Catalyst/Contributing.pod lib/Catalyst/Controller.pm lib/Catalyst/Delta.pod lib/Catalyst/DispatchType.pm lib/Catalyst/DispatchType/Chained.pm lib/Catalyst/DispatchType/Default.pm lib/Catalyst/DispatchType/Index.pm lib/Catalyst/DispatchType/Path.pm lib/Catalyst/Dispatcher.pm lib/Catalyst/Engine.pm lib/Catalyst/Engine/HTTP.pm lib/C

jjn1056

mm-mac-7425:Catalyst-Runtime jnapiorkowski$ make preflight
"/Users/jnapiorkowski/perl5/perlbrew/perls/perl-5.28.1/bin/perl" 'Distar/lib/../helpers'/check-version 5.90124 lib/.DS_Store lib/Catalyst.pm lib/Catalyst/.DS_Store lib/Catalyst/Action.pm lib/Catalyst/ActionChain.pm lib/Catalyst/ActionContainer.pm lib/Catalyst/ActionRole/.DS_Store lib/Catalyst/ActionRole/ConsumesContent.pm lib/Catalyst/ActionRole/HTTPMethods.pm lib/Catalyst/ActionRole/QueryMatching.pm lib/Catalyst/ActionRole/Scheme.pm lib/Catalyst/Base.pm lib/Catalyst/ClassData.pm lib/Catalyst/Component.pm lib/Catalyst/Component/.DS_Store lib/Catalyst/Component/ApplicationAttribute.pm lib/Catalyst/Component/ContextClosure.pm lib/Catalyst/Contributing.pod lib/Catalyst/Controller.pm lib/Catalyst/Delta.pod lib/Catalyst/DispatchType.pm lib/Catalyst/DispatchType/Chained.pm lib/Catalyst/DispatchType/Default.pm lib/Catalyst/DispatchType/Index.pm lib/Catalyst/DispatchType/Path.pm lib/Catalyst/Dispatcher.pm lib/Catalyst/Engine.pm lib/Catalyst/Engine/HTTP.pm lib

jjn1056

mm-mac-7425:Catalyst-Runtime jnapiorkowski$ make preflight
"/Users/jnapiorkowski/perl5/perlbrew/perls/perl-5.28.1/bin/perl" 'Distar/lib/../helpers'/check-version 5.90124 lib/.DS_Store lib/Catalyst.pm lib/Catalyst/.DS_Store lib/Catalyst/Action.pm lib/Catalyst/ActionChain.pm lib/Catalyst/ActionContainer.pm lib/Catalyst/ActionRole/.DS_Store lib/Catalyst/ActionRole/ConsumesContent.pm lib/Catalyst/ActionRole/HTTPMethods.pm lib/Catalyst/ActionRole/QueryMatching.pm lib/Catalyst/ActionRole/Scheme.pm lib/Catalyst/Base.pm lib/Catalyst/ClassData.pm lib/Catalyst/Component.pm lib/Catalyst/Component/.DS_Store lib/Catalyst/Component/ApplicationAttribute.pm lib/Catalyst/Component/ContextClosure.pm lib/Catalyst/Contributing.pod lib/Catalyst/Controller.pm lib/Catalyst/Delta.pod lib/Catalyst/DispatchType.pm lib/Catalyst/DispatchType/Chained.pm lib/Catalyst/DispatchType/Default.pm lib/Catalyst/DispatchType/Index.pm lib/Catalyst/DispatchType/Path.pm lib/Catalyst/Dispatcher.pm lib/Catalyst/Engine.pm lib/Catalyst/Engine/HTTP.pm lib

jjn1056

Vagrant.configure(2) do |config|
  config.vm.box = "bento/ubuntu-18.04"
  config.vm.box_check_update = true
  config.ssh.password = 'vagrant'
  config.vm.synced_folder '.', '/vagrant', disabled: true

  if Vagrant.has_plugin?("vagrant-sshfs")
    if File.exists? File.expand_path('~/src')
      config.vm.synced_folder "~/src", "/home/vagrant",

jjn1056

<List items=self.names />
  <PersonItem name=parent.name 
    age=parent.age />
</List>

<List items=self.names />
  <PersonItem @id=myItems
    name=parent.name 
    age=parent.age />
</List>