Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

categories #19

Closed
yegor256 opened this issue May 1, 2019 · 9 comments
Closed

categories #19

yegor256 opened this issue May 1, 2019 · 9 comments
Labels
enhancement New feature or request

Comments

@yegor256
Copy link
Owner

yegor256 commented May 1, 2019

Let's add categories to causes. Each cause should be attached to some category, like:

money, people, assets, heritage, legal, etc
@yegor256 yegor256 added the enhancement New feature or request label May 1, 2019
yegor256 added a commit that referenced this issue May 13, 2019
@yegor256
#19 paging
03de0a3
yegor256 added a commit that referenced this issue May 13, 2019
@yegor256
#19 emoji for cause
1d8be13
yegor256 added a commit that referenced this issue May 13, 2019
@yegor256
#19 emojis in ui
8358125
yegor256 added a commit that referenced this issue May 13, 2019
@yegor256
#19 ui
1c50ffe
yegor256 added a commit that referenced this issue May 13, 2019
@yegor256
#19 shut up liquibase
aa93292
@yegor256
Copy link
Owner Author

@rultor release, tag is 0.6.0

@rultor
Copy link
Collaborator

rultor commented May 13, 2019

@rultor release, tag is 0.6.0

@yegor256 OK, I will release it now. Please check the progress here

@rultor
Copy link
Collaborator

rultor commented May 13, 2019

@rultor release, tag is 0.6.0

@yegor256 Oops, I failed. You can see the full log here (spent 4min)

SELECT cause.*, part.text,   SUM(risk.probability * effect.impact) / COUNT(risk.id) AS rank,   COUNT(risk.id) AS risks FROM cause JOIN part ON part.id = cause.id LEFT JOIN triple ON triple.cause = cause.id LEFT JOIN risk ON triple.risk = risk.id LEFT JOIN effect ON triple.effect = effect.id WHERE project = $1 AND (LOWER(text) LIKE $2 OR emoji LIKE $2) GROUP BY cause.id, part.id ORDER BY rank DESC OFFSET $3 LIMIT $4: 0ms
\u001b[32m.\u001b[0m\u001b[32m.\u001b[0mINSERT INTO project (login, title) VALUES ($1, $2) RETURNING id: 0ms
\u001b[32m.\u001b[0mINSERT INTO project (login, title) VALUES ($1, $2) RETURNING id: 0ms
\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0mINSERT INTO project (login, title) VALUES ($1, $2) RETURNING id: 0ms
INSERT INTO part (project, text, type) VALUES ($1, $2, $3) RETURNING id: 0ms
INSERT INTO risk (id) VALUES ($1): 0ms
SELECT text FROM part WHERE id = $1: 0ms
UPDATE part SET text = $2 WHERE id = $1: 0ms
UPDATE part SET text = $2 WHERE id = $1: 0ms
SELECT text FROM part WHERE id = $1: 0ms
\u001b[32m.\u001b[0m\u001b[32m.\u001b[0mINSERT INTO project (login, title) VALUES ($1, $2) RETURNING id: 0ms
INSERT INTO part (project, text, type) VALUES ($1, $2, $3) RETURNING id: 0ms
INSERT INTO risk (id) VALUES ($1): 0ms
UPDATE risk SET probability = $2 WHERE id = $1: 0ms
UPDATE risk SET probability = $2 WHERE id = $1: 0ms
SELECT probability FROM risk WHERE id = $1: 0ms
\u001b[32m.\u001b[0mINSERT INTO project (login, title) VALUES ($1, $2) RETURNING id: 0ms
INSERT INTO part (project, text, type) VALUES ($1, $2, $3) RETURNING id: 0ms
INSERT INTO risk (id) VALUES ($1): 0ms
SELECT COUNT(risk.id) FROM risk JOIN part ON part.id = risk.id WHERE project = $1 and LOWER(text) LIKE $2: 0ms
SELECT risk.*, part.text AS text,   SUM(effect.impact) AS impact,   risk.probability * SUM(effect.impact) / COUNT(effect.id) AS rank,   COUNT(effect.id) AS effects FROM risk JOIN part ON part.id = risk.id LEFT JOIN triple ON triple.risk = risk.id LEFT JOIN effect ON triple.effect = effect.id WHERE project = $1 AND LOWER(text) LIKE $2 GROUP BY risk.id, part.id ORDER BY rank DESC OFFSET $3 LIMIT $4: 0ms
SELECT risk.*, part.text AS text,   SUM(effect.impact) AS impact,   risk.probability * SUM(effect.impact) / COUNT(effect.id) AS rank,   COUNT(effect.id) AS effects FROM risk JOIN part ON part.id = risk.id LEFT JOIN triple ON triple.risk = risk.id LEFT JOIN effect ON triple.effect = effect.id WHERE project = $1 AND LOWER(text) LIKE $2 GROUP BY risk.id, part.id ORDER BY rank DESC OFFSET $3 LIMIT $4: 0ms
SELECT risk.*, part.text AS text,   SUM(effect.impact) AS impact,   risk.probability * SUM(effect.impact) / COUNT(effect.id) AS rank,   COUNT(effect.id) AS effects FROM risk JOIN part ON part.id = risk.id LEFT JOIN triple ON triple.risk = risk.id LEFT JOIN effect ON triple.effect = effect.id WHERE project = $1 AND LOWER(text) LIKE $2 GROUP BY risk.id, part.id ORDER BY rank DESC OFFSET $3 LIMIT $4: 0ms
\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m

Finished in 3.265083s, 11.0258 runs/s, 23.5829 assertions/s.
36 runs, 77 assertions, 0 failures, 0 errors, 0 skips
Running RuboCop...
Inspecting 43 files
\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m

43 files inspected, \u001b[32mno offenses\u001b[0m detected
Running xcop...
Inspecting 10 files...
\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m
10 files checked, everything looks \u001b[32mpretty\u001b[0m
grep -q -r '2019'     --include '*.rb'     --include '*.txt'     --include 'Rakefile'     .
2019-05-13 07:48:52.457 UTC [24550] LOG:  received smart shutdown request
PostgreSQL killed in PID 24550
+ git remote add heroku git@heroku.com:zerorsk.git
+ rm -rf /home/r/.ssh
+ mkdir /home/r/.ssh
+ mv ../id_rsa ../id_rsa.pub /home/r/.ssh
+ chmod -R 600 /home/r/.ssh/id_rsa /home/r/.ssh/id_rsa.pub
+ echo -e 'Host *\n  StrictHostKeyChecking no\n  UserKnownHostsFile=/dev/null'
+ git fetch
2019-05-13 07:48:52.508 UTC [24550] LOG:  worker process: logical replication launcher (PID 24557) exited with exit code 1
2019-05-13 07:48:52.509 UTC [24552] LOG:  shutting down
Warning: Permanently added 'github.com,140.82.118.4' (RSA) to the list of known hosts.

2019-05-13 07:48:53.172 UTC [24550] LOG:  database system is shut down
+ sed -i 's/0\.0\.0/0.6.0/g' ./version.rb
+ git add ./version.rb
+ git commit -m 'build number set'
[__rultor e4b8ab1] build number set
 1 file changed, 1 insertion(+), 1 deletion(-)
+ cp ../config.yml config.yml
+ bundle exec rake config --no-color
invalid option: --no-color
container 1e5a840881a6944aa75419d24d8f411e573501138caf0fe0fdc9471358b801d1 is dead
Mon May 13 09:49:44 CEST 2019

yegor256 added a commit that referenced this issue May 13, 2019
@yegor256
#19 rultor
bdf5975
@yegor256
Copy link
Owner Author

@rultor release, tag is 0.6.0

@rultor
Copy link
Collaborator

rultor commented May 13, 2019

@rultor release, tag is 0.6.0

@yegor256 OK, I will release it now. Please check the progress here

@rultor
Copy link
Collaborator

rultor commented May 13, 2019

@rultor release, tag is 0.6.0

@yegor256 Oops, I failed. You can see the full log here (spent 4min)

\u001b[32m.\u001b[0mINSERT INTO project (login, title) VALUES ($1, $2) RETURNING id: 0ms
INSERT INTO part (project, text, type) VALUES ($1, $2, $3) RETURNING id: 0ms
INSERT INTO cause (id) VALUES ($1): 0ms
INSERT INTO part (project, text, type) VALUES ($1, $2, $3) RETURNING id: 0ms
INSERT INTO risk (id) VALUES ($1): 0ms
INSERT INTO part (project, text, type) VALUES ($1, $2, $3) RETURNING id: 0ms
INSERT INTO effect (id) VALUES ($1): 0ms
INSERT INTO triple (cause, risk, effect) VALUES ($1, $2, $3) ON CONFLICT(cause, risk, effect) DO UPDATE SET cause = $1 RETURNING id: 0ms
INSERT INTO part (project, text, type) VALUES ($1, $2, $3) RETURNING id: 0ms
INSERT INTO plan (id, part) VALUES ($1, $2): 0ms
UPDATE plan SET schedule = $3 WHERE id = $1 AND part = $2: 0ms
SELECT plan.* FROM plan JOIN part ON part.id = plan.part JOIN project ON part.project = project.id LEFT JOIN task ON task.plan = plan.id WHERE project.login = $1 AND task.id IS NULL: 0ms
INSERT INTO task (plan) VALUES ($1): 0ms
SELECT * FROM (SELECT DISTINCT ON (task.id) task.id, task.plan,   plan.schedule AS schedule, plan.part AS part,   emoji,   part.text AS text, t.text AS ptext,   project.id AS pid, project.title AS title,   triple.id AS tid,   risk.probability * effect.impact AS rank,   effect.positive AS positive,   cpart.text AS ctext, rpart.text AS rtext, epart.text AS etext,   CASE WHEN t.type = 'Cause' THEN 'C' WHEN t.type = 'Risk' THEN 'R' ELSE 'E' END AS prefix FROM task JOIN plan ON plan.id = task.plan JOIN part ON plan.id = part.id JOIN triple ON risk = plan.part OR cause = plan.part OR effect = plan.part JOIN cause ON cause.id = triple.cause JOIN part AS cpart ON cause.id = cpart.id JOIN risk ON risk.id = triple.risk JOIN part AS rpart ON risk.id = rpart.id JOIN effect ON effect.id = triple.effect JOIN part AS epart ON effect.id = epart.id JOIN project ON part.project = project.id JOIN part AS t ON plan.part = t.id WHERE project.login = $1 AND (emoji LIKE $2 OR LOWER(part.text) LIKE $2 OR LOWER(cpart.text) LIKE $2 OR LOWER(rpart.text) LIKE $2 OR LOWER(epart.text) LIKE $2) ORDER BY task.id ASC) x ORDER BY rank DESC OFFSET $3 LIMIT $4: 0ms
INSERT INTO telechat (id, login) VALUES ($1, $2): 0ms
SELECT * FROM (SELECT DISTINCT ON (task.id) task.id, task.plan,   plan.schedule AS schedule, plan.part AS part,   emoji,   part.text AS text, t.text AS ptext,   project.id AS pid, project.title AS title,   triple.id AS tid,   risk.probability * effect.impact AS rank,   effect.positive AS positive,   cpart.text AS ctext, rpart.text AS rtext, epart.text AS etext,   CASE WHEN t.type = 'Cause' THEN 'C' WHEN t.type = 'Risk' THEN 'R' ELSE 'E' END AS prefix FROM task JOIN plan ON plan.id = task.plan JOIN part ON plan.id = part.id JOIN triple ON risk = plan.part OR cause = plan.part OR effect = plan.part JOIN cause ON cause.id = triple.cause JOIN part AS cpart ON cause.id = cpart.id JOIN risk ON risk.id = triple.risk JOIN part AS rpart ON risk.id = rpart.id JOIN effect ON effect.id = triple.effect JOIN part AS epart ON effect.id = epart.id JOIN project ON part.project = project.id JOIN part AS t ON plan.part = t.id WHERE project.login = $1 AND (emoji LIKE $2 OR LOWER(part.text) LIKE $2 OR LOWER(cpart.text) LIKE $2 OR LOWER(rpart.text) LIKE $2 OR LOWER(epart.text) LIKE $2) ORDER BY task.id ASC) x ORDER BY rank DESC OFFSET $3 LIMIT $4: 0ms
INSERT INTO teleping (task, telechat) VALUES ($1, $2): 0ms
\u001b[32m.\u001b[0m

Finished in 2.754088s, 13.0715 runs/s, 27.9584 assertions/s.
36 runs, 77 assertions, 0 failures, 0 errors, 0 skips
Running RuboCop...
Inspecting 43 files
\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m

43 files inspected, \u001b[32mno offenses\u001b[0m detected
Running xcop...
Inspecting 10 files...
\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m\u001b[32m.\u001b[0m
10 files checked, everything looks \u001b[32mpretty\u001b[0m
grep -q -r '2019'     --include '*.rb'     --include '*.txt'     --include 'Rakefile'     .
2019-05-13 08:00:16.800 UTC [24549] LOG:  received smart shutdown request
PostgreSQL killed in PID 24549
+ git remote add heroku git@heroku.com:zerorsk.git
+ rm -rf /home/r/.ssh
+ mkdir /home/r/.ssh
+ mv ../id_rsa ../id_rsa.pub /home/r/.ssh
+ chmod -R 600 /home/r/.ssh/id_rsa /home/r/.ssh/id_rsa.pub
+ echo -e 'Host *\n  StrictHostKeyChecking no\n  UserKnownHostsFile=/dev/null'
+ git fetch
2019-05-13 08:00:16.857 UTC [24549] LOG:  worker process: logical replication launcher (PID 24556) exited with exit code 1
2019-05-13 08:00:16.857 UTC [24551] LOG:  shutting down
2019-05-13 08:00:17.429 UTC [24549] LOG:  database system is shut down
Warning: Permanently added 'github.com,140.82.118.3' (RSA) to the list of known hosts.

+ sed -i 's/0\.0\.0/0.6.0/g' ./version.rb
+ git add ./version.rb
+ git commit -m 'build number set'
[__rultor dee55a7] build number set
 1 file changed, 1 insertion(+), 1 deletion(-)
+ cp ../config.yml config.yml
+ bundle exec rake config
rake aborted!
Invalid encoding "US-ASCII"
/home/r/repo/Rakefile:28:in `<top (required)>'
/home/r/.ruby/gems/rake-12.3.1/exe/rake:27:in `<top (required)>'
/home/r/.ruby/bin/ruby_executable_hooks:24:in `eval'
/home/r/.ruby/bin/ruby_executable_hooks:24:in `<main>'
(See full trace by running task with --trace)
container 92d87257cb35413792fa34aa3cde6c6481342df20d21202627f963151baf5d35 is dead
Mon May 13 10:00:32 CEST 2019

yegor256 added a commit that referenced this issue May 13, 2019
@yegor256
#19 no check for encoding
113f81f
yegor256 added a commit that referenced this issue May 13, 2019
@yegor256
#19 emoji
9c3f6c6
@yegor256
Copy link
Owner Author

@rultor release, tag is 0.6.0

@rultor
Copy link
Collaborator

rultor commented May 13, 2019

@rultor release, tag is 0.6.0

@yegor256 OK, I will release it now. Please check the progress here

@rultor
Copy link
Collaborator

rultor commented May 13, 2019

@rultor release, tag is 0.6.0

@yegor256 Done! FYI, the full log is here (took me 4min)

yegor256 added a commit that referenced this issue May 13, 2019
@yegor256
#19 typo
f110441
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@yegor256 @rultor