kmacgugan

CREATE TABLE IF NOT EXISTS supervisor (
  id           SERIAL PRIMARY KEY,
  Application  TEXT NOT NULL DEFAULT '',
  Environment  TEXT NOT NULL DEFAULT ''
);

CREATE TABLE IF NOT EXISTS service_group (
  id     SERIAL PRIMARY KEY,
  name  TEXT    NOT NULL
);

kmacgugan

In the converge-service you can use mocked data as the backend by passing in a config flag --elasticsearch or --mock

https://github.com/chef/converge-service/blob/master/cmd/converge-service/converge-service.go#L37

If mock is passed in the server starts the mock backend when starting up: 
https://github.com/chef/converge-service/blob/master/cmd/converge-service/converge-service.go#L82

This sets up which backend the backend package interface is using. 
Interface defined here: 
https://github.com/chef/converge-service/blob/master/backend/client.go#L18

kmacgugan

select * from changes join pipelines on changes.pipeline_id = pipelines.id join projects on projects.id = pipelines.project_Id where merge_sha is null and project_id = 1;
-[ RECORD 1 ]-------------+----------------------------------------------------------------------------------------------------------------------------------------
id                        | 3dc4a095-87e8-4419-96f3-6bd2dc50d6f0
pipeline_id               | 2
feature_branch            | BAT-161/search-bar
merge_sha                 |
title                     | [BAT-161] Add the search bar to workflow screens
description               |
approved_by               |
changeset_id              |

kmacgugan

--Questions for customer:
--- How many client nodes are you running?
--- Are they windows, linux or mixed?

-- Oldest data in activities
select min(recorded_at) from public.activities;

--how many rows over the past week per day
select count(*), date_part('day', recorded_at) from public.activities where recorded_at > now() - INTERVAL '7 days' group by 2;

kmacgugan

Expediters international. Older version in use. 
-	Had chef for 3 years
-	10.16 in prod currently, hiring chef to do upgrade. 
-	Clients 11.6 in production
-	Seen demos of analytics and delivery but have not used
-	
Team is composed of “Configuration engineers” and a dev. 

Sysadmins install packages, not these guys. SA would set up server and then give it to them. SA have seen chef and are not interested in it. 
-	As a dev, use chef for porting to linux activities