Augusto Stroligo ggstroligo

Pretende usar `UUID` como PK em vez de `Int/BigInt` no seu banco de dados? Pense novamente...

Não use UUID como PK nas tabelas do seu banco de dados.

The goal of this cheatsheet is to make it easy to add hand-rolled authentication to any rails app in a series of layers.

First the simplest/core layers, then optional layers depending on which features/functionality you want.

`Specs`
AUTHOR	Ira Herman
LANGUAGE/STACK	Ruby on Rails Version 4, 5, or 6

First, add pry-rails to your Gemfile:
https://github.com/rweng/pry-rails

gem 'pry-rails', group: :development

Then you'll want to rebuild your Docker container to install the gems

This list is based on aliases_spec.rb.

	# rails console

	ActiveRecord::Base.connection.tables.each do \|table\|
	indexes = ActiveRecord::Base.connection.indexes(table)
	if indexes.length > 0
	puts "====> #{table} <===="
	indexes.each do \|index\|
	puts "----> #{index.name}"
	end
	puts "====> #{table} <===="

	Warden::Manager.before_failure do \|env, opts\|
	# Sinatra/Padrino is very sensitive to the request method and
	# since authentication could fail on any type of method, we need
	# to set it for the failure app so it is routed to the correct block.
	env['REQUEST_METHOD'] = "POST"
	end

	Warden::Strategies.add(:basic_http) do
	def valid?
	# Check if valid and store an instance var

	http://stackoverflow.com/questions/22667401/postgres-json-data-type-rails-query
	http://stackoverflow.com/questions/40702813/query-on-postgres-json-array-field-in-rails

	#payload: [{"kind"=>"person"}]
	Segment.where("payload @> ?", [{kind: "person"}].to_json)

	#data: {"interest"=>["music", "movies", "programming"]}
	Segment.where("data @> ?", {"interest": ["music", "movies", "programming"]}.to_json)
	Segment.where("data #>> '{interest, 1}' = 'movies' ")
	Segment.where("jsonb_array_length(data->'interest') > 1")