Public | Automated Build

Last pushed: 2 years ago
Short Description
Thesis database
Full Description

database

<<<<<<< 682da9f7a2ec82ed02470fe36d7dc628d96ddb14

schema: halcyon

\d+ halcyon

Tables

halcyon."Test_Hourly_Watches"

  • repo_id INTEGER,
  • repo_name TEXT,
  • star_count SMALLINT,
  • date DATE, <sub> (date is of form YYYY-MM-DD)
  • hour SMALLINT

halcyon."Test_Repos"

  • id INTEGER,
  • repo_name TEXT, <sub> (repo_name is of form login_of_owner/name_of_repository. So owner name can be generated from the field)
  • description TEXT,
  • language CHARACTER VARYING(40),
  • num_stars INTEGER,
  • org INTEGER <sub> (org is 0 if there is no org associated with repo)

Queries

select * from halcyon."Test_Hourly_Watches" limit 5
select * from halcyon."Test_Repos" limit 5
select repo_id, repo_name, language, num_stars, count(*) AS stars from halcyon."Test_Hourly_Watches" 
Inner Join halcyon."Test_Repos" On repo_id = id
where num_stars > 0 
  AND date >= current_date - 47
  AND date <=  current_date - 40
group by repo_id, repo_name, language, num_stars order by num_stars desc

Docker Container

SQL database container

Build Image:

docker build -t custom_psql .

Run Container:

docker run -d --name custom_psql_running -p 5432:5432 custom_psql

Exec into container: docker

exec -it custom_psql_running psql -U postgres
docker run -it --link custom_psql:postgres --rm postgres sh -c 'exec psql -h "$POSTGRES_PORT_5432_TCP_ADDR" -p "$POSTGRES_PORT_5432_TCP_PORT" -U postgres'
Docker Pull Command
Owner
bbalaran
Source Repository

Comments (0)