This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
class Array | |
def to_csv(csv_filename="hash.csv") | |
require 'csv' | |
CSV.open(csv_filename, "wb") do |csv| | |
csv << first.keys # adds the attributes name on the first line | |
self.each do |hash| | |
csv << hash.values | |
end | |
end | |
end |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
```ruby | |
record = Model.where("data->'$.somearray[0].email' = ?", email).first | |
``` |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
TABLE_NAME AS `Table`, | |
ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)` | |
FROM | |
information_schema.TABLES | |
WHERE | |
TABLE_SCHEMA = "mydatabase" | |
ORDER BY | |
(DATA_LENGTH + INDEX_LENGTH) | |
DESC; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
sudo amazon-linux-extras install postgresql12 | |
pg_dump -Fc -O -h yyy-production.xxx.region.rds.amazonaws.com -p 5432 -U yyy yyy_production -f yyy.dump | |
# TRUNCATE TABLE tables ... RESTART IDENTITY | |
# rails db:migrate | |
pg_restore -Fc -O --disable-triggers --data-only -h yyy-staging.xxx.region.rds.amazonaws.com -d yyy_staging -U yyy yyy.dump | |
# both commands accept the --table option to specify which table to dump/restore | |
# select setval('TABLE_NAME_id_seq', (select max(id) from TABLE_NAME)); may be required after RESTART IDENTITY, +1 | |
# In case of version mismatch between the server and pg_dump, add pgdgXX repo and install XX client | |
[pgdg14] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DROP extension postgis CASCADE; | |
/* | |
drop cascades to column shape of table MYTABLE_points | |
drop cascades to column shape of table MYTABLE_areas | |
*/ | |
/* Upgrade PostgreSQL */ | |
CREATE extension postgis; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Currently (2017/2018) it's not possible to change the Ruby 'minor' version (eg. 2.3 => 2.4) using the web console | |
# However, it's possible using the 'awscli' tool. | |
brew install awscli # pip install awscli | |
aws elasticbeanstalk update-environment \ | |
--solution-stack-name "64bit Amazon Linux 2017.09 v2.6.1 running Ruby 2.4 (Puma)" \ | |
--environment-name "myappenv1" --region "us-east-2" \ | |
--version-label "app-1234-210000_120123" | |
# For Amazon Linux 2 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_DEFAULT | |
FROM | |
INFORMATION_SCHEMA.COLUMNS | |
WHERE | |
TABLE_NAME='Xxx'; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# -d for no data, just structure | |
# -t for no create, just data | |
# --ignore-table=name1 --ignore-table=name2 | |
# --skip-comments | |
# include table names after DATABASE | |
mysqldump -u USER -h HOST -p DATABASE | gzip > DATABASE.sql.gz | |
# load |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
rails_version = '6.1.3' | |
# Include rails specific gems | |
# We need this until https://github.com/rails/rails/issues/41750 is resolved | |
gem 'actioncable', rails_version | |
gem 'actionmailer', rails_version | |
gem 'actionpack', rails_version | |
gem 'actionview', rails_version | |
gem 'activejob', rails_version | |
gem 'activemodel', rails_version | |
gem 'activerecord', rails_version |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# first, backup running config | |
docker exec -it -u 0 grafana bash | |
cat /etc/grafana/grafana.ini | |
# copy output and paste to backup file somewhere or use docker cp | |
docker cp grafana:/etc/grafana/grafana.ini grafana.ini.bak | |
docker pull grafana/grafana:latest | |
docker stop grafana | |
docker rm grafana | |
docker run --name grafana --detach=true --publish 80:3000 --link graphite:graphite --volumes-from grafana-storage grafana/grafana |
NewerOlder