Skip to content

Instantly share code, notes, and snippets.

View unicef_metrics.rb
start_time = Time.new(2020, 10, 1).beginning_of_day
end_time = Time.new(2020, 12, 31).end_of_day
completed_calls = PhoneCall.completed.where(created_at: start_time..end_time).joins(:call_data_record)
number_of_unpaid_users = User.count # SCFM only for now
number_of_calls = completed_calls.count
number_of_minutes = completed_calls.sum("call_data_records.bill_sec") / 60
number_of_users = (completed_calls.pluck(:to) + completed_calls.pluck(:from)).uniq.count
@dwilkie
dwilkie / migrate_from_refile_to_activestorage.rb
Last active Oct 15, 2020
Migrate from Refile to ActiveStorage
View migrate_from_refile_to_activestorage.rb
CallDataRecord.find_each do |cdr|
next if cdr.file.attached?
cdr_url = "https://s3-ap-southeast-1.amazonaws.com/cdr.somleng.org/store/#{cdr.file_id}"
cdr.file.attach(
io: open(cdr_url),
filename: cdr.file_filename,
content_type: cdr.file_content_type
)
end
@dwilkie
dwilkie / elastic_beanstalk_db_backup.sh
Last active Oct 15, 2020
Elastic Beanstalk pg_dump
View elastic_beanstalk_db_backup.sh
# On Elastic Beanstalk machine
yum install -y https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-6-x86_64/postgresql11-libs-11.4-1PGDG.rhel6.x86_64.rpm
yum install -y https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-6-x86_64/postgresql11-11.4-1PGDG.rhel6.x86_64.rpm
yum install -y https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-6-x86_64/postgresql11-server-11.4-1PGDG.rhel6.x86_64.rpm
pg_dump --version
EB_SUPPORT_DIR=$(/opt/elasticbeanstalk/bin/get-config container -k support_dir)
EB_SCRIPT_DIR=$(/opt/elasticbeanstalk/bin/get-config container -k script_dir)
@dwilkie
dwilkie / scfm_paginate_contacts_example.rb
Created Feb 21, 2020
SCFM Paginate Contacts Example
View scfm_paginate_contacts_example.rb
require "net/http"
require "uri"
require "pry"
require "link-header-parser" # https://github.com/jgarber623/link-header-parser-ruby
require "time"
SOURCE_HOST = "https://dashboard.ews1294.info"
SOURCE_API_KEY = "[your API key]"
DESTINATION_HOST = "https://scfm.somleng.org"
View modify_contacts_metadata.rb
require "csv"
require "httparty"
DATA_FILE = "tmp/phone_test.csv".freeze
API_ENDPOINT = "https://scfm.somleng.org/api/contact_data".freeze
API_KEY = "REPLACE_ME".freeze
def update_contact!(row)
response = HTTParty.post(
API_ENDPOINT,
View test_tts.xml
<?xml version="1.0" encoding="UTF-8"?>
<Response>
<Say voice="Polly.Ricardo" language="pt-BR">Hello World</Say>
<Say voice="Polly.Vitoria" language="pt-BR">Hello World</Say>
</Response>
@dwilkie
dwilkie / import_avf.rb
Created Nov 10, 2018
SCFM contact import (Africa's Voices)
View import_avf.rb
require "csv"
require "httparty"
DATA_FILE = "tmp/maap_numbers.csv".freeze
API_ENDPOINT = "https://scfm.somleng.org/api/contact_data".freeze
API_KEY = "REPLACE_ME_WITH_SCFM_API_KEY".freeze
def create_contact!(row)
response = HTTParty.post(
API_ENDPOINT,
View cleanup_sensor_events.rb
p SensorEvent.where("payload->>'created_at' = '0000-00-00 00:00:00 UTC+7'").delete_all
p SensorEvent.where("payload->'created_at' is not null").update_all("created_at = (payload->>'created_at')::timestamp without time zone")
View gist:50fe6b5478776154aabd6d562a7020e9
<?xml version="1.0" encoding="UTF-8"?>
<Response>
<Play>https://s3.ap-southeast-1.amazonaws.com/audio.ews1294.info/9a7fee16-9d09-48fd-a25e-d0ade953d947-SampleAudio.mp3</Play>
</Response>
@dwilkie
dwilkie / somleng_io_example.rb
Last active Jul 25, 2017
somleng_example.rb
View somleng_io_example.rb
#!/usr/bin/env ruby
RESULTS_FILE = "test_mt_results.json"
ACCOUNT_SID = "REPLACE_ME"
AUTH_TOKEN = "REPLACE ME"
CALLER_ID = "345"
require 'httparty'
results = {}