anke1460

anke1460 / rails-jsonb-queries

Created November 22, 2018 14:24 — forked from mankind/rails-jsonb-queries

Rails-5 postgresql-9.6 jsonb queries

	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")

anke1460 / client.rb

Created March 7, 2017 09:52

	require 'net/http'
	require 'drb'
	require 'json'
	DRb.start_service
	client = DRbObject.new_with_uri 'druby://120.27.139.130:9000'

	threads = []
	15.times do
	threads << Thread.new do
	1000.times do

anke1460 / gist:0785f9e18b8ebd34ff2de607178fa7b2

Created March 7, 2017 09:51

server.rb

anke1460 / _form.html.haml

Created July 25, 2014 02:27 — forked from stuartc/_form.html.haml

	form_for(@user, :validate=>true) do \|f\|
	= f.label :birthdate
	= f.date_select :birthdate
	= f.text_field :birthdate, :type=>"hidden", 'data-validate'=>true
	end