Skip to content

Instantly share code, notes, and snippets.

View Epigene's full-sized avatar

Augusts Bautra Epigene

View GitHub Profile
SELECT `applications`.* FROM `applications` LEFT OUTER JOIN `agreements` `agreements_f0` ON `applications`.`id` = `agreements_f0`.`application_id` WHERE ((`applications`.`hidden` = ? OR `applications`.`hidden` IS ?)) AND ((LOWER(`applications`.`client_name`) LIKE LOWER(?)) OR (LOWER(`applications`.`client_email`) LIKE LOWER(?)) OR (LOWER(`applications`.`client_identification_no`) LIKE LOWER(?)) OR (LOWER(`applications`.`client_phone`) LIKE LOWER(?)) OR (LOWER(`applications`.`client_phone2`) LIKE LOWER(?)) OR (LOWER(`applications`.`client_phone3`) LIKE LOWER(?)) OR (LOWER(`applications`.`client_phone4`) LIKE LOWER(?)) OR (LOWER(`applications`.`vehicle_no`) LIKE LOWER(?)) OR (LOWER(`applications`.`vehicle_vin`) LIKE LOWER(?)) OR (LOWER(`applications`.`vehicle_no2`) LIKE LOWER(?)) OR (LOWER(`applications`.`vehicle_technical_certificate_no`) LIKE LOWER(?)) OR (LOWER(`applications`.`vehicle_technical_certificate_no2`) LIKE LOWER(?)) OR (LOWER(`applications`.`number`) LIKE LOWER(?)) OR (LOWER(`applications`.`reque
@Epigene
Epigene / ruby.json
Last active August 31, 2018 12:38
Ruby (predominantly RSpec) snippets for VSC.
{
"scope spec template": {
"prefix": "scope_spec",
"body": [
"describe \".SCOPE_NAME\" do",
" subject(:collection) { described_class.SCOPE_NAME }",
"",
" context \"when instantiating actual records\", :slow do",
" let!(:match) { create(:FACTORY, :TRAIT) }",
" let!(:counter) { create(:FACTORY) }",
@Epigene
Epigene / Nim Spells.md
Created July 17, 2018 20:16
Some know-how and cheats for Nim programming languages

Compiling with the -d:release flag will turn the bounds checks off. This will result in higher performance but less safety.

{
"workbench.colorTheme": "Solarized Dark",
"editor.minimap.enabled": false,
"explorer.fontFamily": "DejaVu Sans Mono",
"explorer.autoReveal": false,
"editor.fontFamily": "DejaVu Sans Mono, 'Courier New', monospace, 'Droid Sans Fallback'",
"editor.tabSize": 2,
"editor.fontSize": 12.5,
"window.zoomLevel": 1,
"editor.rulers": [80, 120],
@Epigene
Epigene / test_service.rb
Created February 23, 2018 09:53
An example of a service class code created by a rails service generator
module V1
module Api
class TestService
# This service TODO
def initialize
end
def call
end
@Epigene
Epigene / bundler.config
Last active December 24, 2019 11:19
Make bundler always use some pg_config
# single install
gem install pg -v 1.1.4 -- --with-pg-config=/Applications/Postgres.app/Contents/Versions/12/bin/pg_config
# permanent config, troublesome
bundle config build.pg --with-pg-config=/Applications/Postgres.app/Contents/Versions/9.6/bin/pg_config
{"lastUpload":"2021-06-15T07:37:30.093Z","extensionVersion":"v3.4.3"}
@Epigene
Epigene / bench_data.csv
Created October 14, 2017 17:13
Raw data for setup strategy comparison
file line_number group time
./spec/setup_benchmark.rb 9 SetupBenchmark::NewVSAllOthersWhenTestingBookVampireTitle::WhenSettingUpWithNew 0.198
./spec/setup_benchmark.rb 17 SetupBenchmark::NewVSAllOthersWhenTestingBookVampireTitle::WhenSettingUpWithInstanceDouble 0.173
./spec/setup_benchmark.rb 25 SetupBenchmark::NewVSAllOthersWhenTestingBookVampireTitle::WhenSettingUpWithFactoryGirlBuildStubbed 0.396
./spec/setup_benchmark.rb 33 SetupBenchmark::NewVSAllOthersWhenTestingBookVampireTitle::WhenSettingUpWithFactoryGirlBuild 0.916
./spec/setup_benchmark.rb 41 SetupBenchmark::NewVSAllOthersWhenTestingBookVampireTitle::WhenSettingUpWithFactoryGirlCreate 1.155
./spec/setup_benchmark.rb 55 SetupBenchmark::InstanceDoubleVSFactoryGirlBuildStubbedFactoryGirlBuildAndFactoryGirlCreate::WhenSettingUpWithInstanceDouble 0.443
@Epigene
Epigene / book.rb
Created October 14, 2017 17:00
complete mock
after_save :do_something
private
def do_something
ApplicationRecord.class
end
@Epigene
Epigene / bout4.rb
Created October 14, 2017 16:58
Build VS create
describe "FactoryGirl.build VS FactoryGirl.create" do
subject { book.save! }
bout4_number_of = 200
context "when setting up with FactoryGirl.build" do
let(:book) { build(:book) }
bout4_number_of.times do
it "triggers ApplicationRecord.class in callback" do