Skip to content

Instantly share code, notes, and snippets.

View AparnaKarve's full-sized avatar

Aparna Karve AparnaKarve

View GitHub Profile
WITH high_impact_hosts AS (
SELECT
host_id,
template_id,
status,
SUM(q.duration) / SUM(q.host_task_count) AS average_duration_per_task,
MAX(created_date) AS created_date,
MAX(task_timestamp_max) AS task_timestamp_max
FROM "monthly_host_explorer_rollup" q
$ ocdeployer deploy -s automation-analytics -t templates --secrets-local-dir ./e2esecrets/local-secrets -e dev ak-aa-ci
Deploying service sets 'automation-analytics' to project 'ak-aa-ci'. Continue? [Y/n] Y
Traceback (most recent call last):
File "/Library/Frameworks/Python.framework/Versions/3.6/bin/ocdeployer", line 11, in <module>
sys.exit(main())
File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/click/core.py", line 764, in __call__
return self.main(*args, **kwargs)
File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/click/core.py", line 717, in main
rv = self.invoke(ctx)
File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/click/core.py", line 1137, in invoke
```
$ ocdeployer deploy -s automation-analytics -t templates --secrets-local-dir ./e2esecrets/local-secrets/ ak-aa-ci
Deploying service sets 'automation-analytics' to project 'ak-aa-ci'. Continue? [Y/n] Y
INFO:ocdeployer.utils:Running command: oc get project ak-aa-ci
INFO:ocdeployer.utils: |stdout| NAME DISPLAY NAME STATUS
INFO:ocdeployer.utils: |stdout| ak-aa-ci Active
INFO:ocdeployer.utils:Running command: oc project ak-aa-ci
INFO:ocdeployer.utils: |stdout| Already on project "ak-aa-ci" on server "https://api.insights-dev.openshift.com:443".
INFO:ocdeployer.secrets:Loaded secrets from file './e2esecrets/local-secrets/cloudwatch.yaml
INFO:ocdeployer.secrets:Loaded secrets from file './e2esecrets/local-secrets/nachobot.yml
from urllib.request import urlopen
from bs4 import BeautifulSoup
CLOUD_URL = 'https://docs.ansible.com/ansible/latest/modules/list_of_cloud_modules.html'
CLOUD_CSV = './CSV/cloudscrape.csv'
CLOUD_LABEL = 'Cloud Management'
CLUSTER_URL = 'https://docs.ansible.com/ansible/latest/modules/list_of_clustering_modules.html'
CLUSTER_CSV = './CSV/clusterscrape.csv'
CLUSTER_LABEL = 'Cluster Management'
{
"href": "https://10.8.197.180/api/requests/7",
"id": "7",
"description": "plan2-playbook",
"approval_state": "approved",
"type": "ServiceTemplateTransformationPlanRequest",
"created_on": "2018-07-23T18:46:41Z",
"updated_on": "2018-07-23T18:57:13Z",
"fulfilled_on": "2018-07-23T18:57:13Z",
"requester_id": "1",
[----] I, [2016-03-10T16:44:39.244534 #34321:3fc7e92da2d0] INFO -- : Started GET "/assets/dialog_import_export.self-a4895d9642cd4e6db8a376ff7621b7eddeb80676c1ccc6596e70746be4ab309b.css?body=1" for ::1 at 2016-03-10 16:44:39 -0800
[----] I, [2016-03-10T16:44:39.345227 #34321:3fc7fc315d04] INFO -- : Started GET "/assets/main.self-a729695707dc57001481aa758ca434e7820e73ee19d9363c9a4756a7bf1f04c4.css?body=1" for ::1 at 2016-03-10 16:44:39 -0800
[----] I, [2016-03-10T16:44:39.553498 #34321:3fc7e92da104] INFO -- : Started GET "/assets/dialog_fields.self-09a529fc59266edb881a5b300a2c1ba60d54c6c556ffd0ddfe58af6c545a1587.css?body=1" for ::1 at 2016-03-10 16:44:39 -0800
[----] I, [2016-03-10T16:44:39.657268 #34321:3fc7ea19c368] INFO -- : Started GET "/assets/slickgrid/slick.grid.self-d9105bc6204f160393a5ecb463ed91f47f35b34aada522a8c6a674c52965ac1e.css?body=1" for ::1 at 2016-03-10 16:44:39 -0800
[----] I, [2016-03-10T16:44:39.657617 #34321:3fc7e966e20c] INFO -- : Started GET "/assets/jquery.jqplot.self-2bcee146ce6dd
0> Thread.list.map(&:backtrace)
=> [["/Users/aparnakarve/.rvm/gems/ruby-2.2.3/gems/puma-2.16.0/lib/rack/handler/puma.rb:43:in `join'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/gems/puma-2.16.0/lib/rack/handler/puma.rb:43:in `run'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/gems/rack-2.0.0.alpha/lib/rack/server.rb:296:in `start'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/bundler/gems/rails-b785064958f9/railties/lib/rails/commands/server.rb:78:in `start'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/bundler/gems/rails-b785064958f9/railties/lib/rails/commands/commands_tasks.rb:90:in `block in server'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/bundler/gems/rails-b785064958f9/railties/lib/rails/commands/commands_tasks.rb:85:in `tap'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/bundler/gems/rails-b785064958f9/railties/lib/rails/commands/commands_tasks.rb:85:in `server'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/bundler/gems/rails-b785064958f9/railties/lib/rails/commands/commands_tasks.rb:49:in `run_command!'", "/Users/ap
0> Thread.list.map(&:backtrace)
=> [["/Users/aparnakarve/.rvm/gems/ruby-2.2.3/gems/puma-2.16.0/lib/rack/handler/puma.rb:43:in `join'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/gems/puma-2.16.0/lib/rack/handler/puma.rb:43:in `run'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/gems/rack-2.0.0.alpha/lib/rack/server.rb:296:in `start'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/bundler/gems/rails-b785064958f9/railties/lib/rails/commands/server.rb:78:in `start'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/bundler/gems/rails-b785064958f9/railties/lib/rails/commands/commands_tasks.rb:90:in `block in server'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/bundler/gems/rails-b785064958f9/railties/lib/rails/commands/commands_tasks.rb:85:in `tap'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/bundler/gems/rails-b785064958f9/railties/lib/rails/commands/commands_tasks.rb:85:in `server'", "/Users/aparnakarve/.rvm/gems/ruby-2.2.3/bundler/gems/rails-b785064958f9/railties/lib/rails/commands/commands_tasks.rb:49:in `run_command!'", "/Users/ap
$userid = $post['Post']['user_id'];
$userDetails = withConsole(function () use ($userid) {
$queryOpts = new Serv_QueryOptions();
$queryOpts->limit = 1;
$user = withSecurityGateway(function($gw) use ($queryOpts, $userid) {
return thriftUser2phpArray($gw->findById($userid));
});
}