Skip to content

Instantly share code, notes, and snippets.

View wpride's full-sized avatar

William Pride wpride

View GitHub Profile
@wpride
wpride / get_user_netpolicy.js
Created August 9, 2022 16:33
Create Snowflake user network policies table
CREATE OR REPLACE PROCEDURE get_user_netpolicy()
RETURNS variant NOT null
LANGUAGE javascript
EXECUTE as CALLER
AS
$$
var METRICS_SCHEMA = 'SNOWFLAKE_METRICS';
var TABLE_NAME = 'NETWORK_POLICIES';
var SCHEMA_AND_TABLE = `${METRICS_SCHEMA}.${TABLE_NAME}`;
try {
{
"ipcMode": null,
"executionRoleArn": "arn:aws:iam::12345:role/ecsTaskExecutionRole",
"containerDefinitions": [
{
"dnsSearchDomains": null,
"environmentFiles": null,
"logConfiguration": {
"logDriver": "awslogs",
"secretOptions": null,
Backtrace:
__cxa_throw (in sorbet) + 113
std::__1::__throw_out_of_range(char const*) (in sorbet) + 56
sorbet::realmain::lsp::LSPLoop::localName2Remote(std::__1::basic_string_view<char, std::__1::char_traits<char> >) (in sorbet) + 407
sorbet::realmain::lsp::LSPLoop::pushDiagnostics(sorbet::realmain::lsp::LSPLoop::TypecheckRun) (in sorbet) + 3008
sorbet::realmain::lsp::LSPLoop::processRequestInternal(std::__1::unique_ptr<sorbet::core::GlobalState, std::__1::default_delete<sorbet::core::GlobalState> >, sorbet::realmain::lsp::LSPMessage const&) (in sorbet) + 403
sorbet::realmain::lsp::LSPLoop::processRequest(std::__1::unique_ptr<sorbet::core::GlobalState, std::__1::default_delete<sorbet::core::GlobalState> >, sorbet::realmain::lsp::LSPMessage const&) (in sorbet) + 87
sorbet::realmain::lsp::LSPLoop::runLSP() (in sorbet) + 1752
sorbet::realmain::realmain(int, char**) (in sorbet) + 5137
main (in sorbet) + 11
---------------------------------------------------------------------------
TypeError Traceback (most recent call last)
<ipython-input-11-2832d24508dc> in <module>()
1 lr = 5e-3
----> 2 learn.fit(lr, 3, cycle_len=1)
~/fastai/courses/dl1/fastai/learner.py in fit(self, lrs, n_cycle, wds, **kwargs)
212 self.sched = None
213 layer_opt = self.get_layer_opt(lrs, wds)
--> 214 return self.fit_gen(self.model, self.data, layer_opt, n_cycle, **kwargs)
@wpride
wpride / SMS err
Created January 11, 2018 20:35
SMS test error
2018-01-11 20:28:40,602 ERROR Internal Server Error: /a/test-domain/cloudcare/api/cases/
Traceback (most recent call last):
File "/Users/willpride/.virtualenvs/cchq/lib/python2.7/site-packages/django/core/handlers/exception.py", line 41, in inner
response = get_response(request)
File "/Users/willpride/.virtualenvs/cchq/lib/python2.7/site-packages/django/core/handlers/base.py", line 187, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/Users/willpride/.virtualenvs/cchq/lib/python2.7/site-packages/django/core/handlers/base.py", line 185, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/Users/willpride/Dimagi/commcare-hq/corehq/apps/domain/decorators.py", line 205, in safe_fn
return _inner(request, domain, *args, **kwargs)
Running migrations:
Applying sql_accessors.0056_add_hashlib_functions...Traceback (most recent call last):
File "./manage.py", line 133, in <module>
execute_from_command_line(sys.argv)
File "/Users/willpride/.virtualenvs/cchq/lib/python2.7/site-packages/django/core/management/__init__.py", line 364, in execute_from_command_line
utility.execute()
File "/Users/willpride/.virtualenvs/cchq/lib/python2.7/site-packages/django/core/management/__init__.py", line 356, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/Users/willpride/.virtualenvs/cchq/lib/python2.7/site-packages/django/core/management/base.py", line 283, in run_from_argv
self.execute(*args, **cmd_options)
(cchq)Wills-MacBook-Pro-4:commcare-hq willpride$ cat freeze.txt
alabaster==0.7.6
alembic==0.8.6
amqp==1.4.7
amqplib==1.0.2
ansible==2.4.1.0
anyjson==0.3.3
appdirs==1.4.3
appnope==0.1.0
architect==0.5.6
File "./manage.py", line 133, in <module>
execute_from_command_line(sys.argv)
File "/Users/willpride/.virtualenvs/cchq/lib/python2.7/site-packages/django/core/management/__init__.py", line 364, in execute_from_command_line
utility.execute()
File "/Users/willpride/.virtualenvs/cchq/lib/python2.7/site-packages/django/core/management/__init__.py", line 338, in execute
django.setup()
File "./manage.py", line 50, in _setup_once
_setup_once.setup(*args, **kw)
File "/Users/willpride/.virtualenvs/cchq/lib/python2.7/site-packages/django/__init__.py", line 27, in setup
apps.populate(settings.INSTALLED_APPS)
{
"notification":{
"message":null,
"error":false
},
"title":"Update a Case",
"clearSession":false,
"appId":"db7eb2096b5e4768a1dd1cd1c3adc39a",
"appVersion":"Formplayer Version: 2.39, App Version: 1392",
"selections":null,
Then (/^I see one item from the list "([^\"]*)"$/) do |items|
saw_item = false
for item in items.split(",")
if element_exists("* {text CONTAINS[c] '#{item}'}")
saw_item = true
end
end
if !saw_item
fail("Did not see item from list \"#{items}\".")
end