dorkness-io

#!/bin/sh

# This script automates most the dirty work in configuring new Python virtual
# environments. It requires that you've installed pyenv and pyenv-virtualenv.

display_usage() {
  echo "\nThis script creates and activates pyenv-virtualenv environments."
  echo "It requires that you have pyenv and pyenv-virtualenv installed."
  echo "\nUsage: $0 <project_name> <python_version>\n"
  echo "Example: $0 new_project 3.8.2\n"

dorkness-io

/* Let's create a table */
create table some_table (
  id integer unique
  ,some_column text
  ,other_column numeric
);

/* Let's add a column */
alter table some_table
add column another_column text;

dorkness-io

select
  p.pkey || '-' || ji.issuenum AS issue_key
  ,ja.actionbody
from jiraaction ja
full outer join jiraissue ji
  on ja.issueid = ji.id
join project p
  on p.id = ji.project
where p.pkey = 'TP';

dorkness-io

select
  p.pkey || '-' || ji.issuenum AS issue_key
  ,ja.actionbody
from jiraaction ja
right join jiraissue ji
  on ja.issueid = ji.id
join project p
  on p.id = ji.project
where p.pkey = 'TP';

dorkness-io

select
  p.pkey || '-' || ji.issuenum AS issue_key
  ,ja.actionbody
from jiraissue ji
inner join project p
  on ji.project = p.id
inner join jiraaction ja
  on ji.id = ja.issueid
  and actiontype = 'comment'
where p.pkey = 'TP';

dorkness-io

select
  p.pkey || '-' || ji.issuenum AS issue_key
  ,ja.actionbody
from jiraissue ji
inner join project p
  on ji.project = p.id
left join jiraaction ja
  on ji.id = ja.issueid
  and actiontype = 'comment'
where p.pkey = 'TP';

dorkness-io

drop table if exists weekly_issues;

select 
  p.pkey || '-' || ji.issuenum AS issue_key
  ,ji.summary
  ,ji.reporter
  ,ji.created
into temp weekly_issues
from jiraissue ji
join project p

dorkness-io

select
  p.pkey || '-' || ji.issuenum AS issue_key
from jiraissue ji
join project p
  on ji.project = p.id
join jiraaction ja
  on ji.id = ja.issueid
  and actiontype = 'comment'
group by 1
having count(ja.id) >= 10;

dorkness-io

select
  ss.pname
  ,sum(ss.comment_count) as sum_comments
from (
select
  p.pname
  ,p.pkey || '-' || ji.issuenum AS issue_key
  ,count(distinct ja.id) as comment_count
from jiraissue ji
join project p

dorkness-io

select
  p.pkey || '-' || ji.issuenum AS issue_key
  ,cs.start_date
from jiraissue ji
join project p
  on ji.project = p.id
join os_currentstep cs
  on ji.workflow_id = cs.entry_id

union