Thien dwthien
dwthien
/ rails-jsonb-queries
Created
October 10, 2021 12:32
— forked from mankind/rails-jsonb-queries
Ruby on Rails-5 postgresql-9.6 jsonb queries
This file contains hidden or 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
| 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") |
dwthien
/ Francebilletnew.rb
Created
November 14, 2017 02:56
This file contains hidden or 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
| ======================================================= | |
| Begin Review | |
| ======================================================= | |
| Count Summary | |
| Valid Event Count: 7114 | |
| Invalid Event Count: 0 | |
| ======================================================= |
dwthien
/ ResidentAdvisor::Parser.rb
Created
November 13, 2017 03:00
This file contains hidden or 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
| ======================================================= | |
| Begin Review | |
| ======================================================= | |
| Count Summary | |
| Valid Event Count: 8240 | |
| Invalid Event Count: 0 |
This file contains hidden or 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
| ======================================================= | |
| Begin Review | |
| ======================================================= | |
| Count Summary | |
| Valid Event Count: 2219 | |
| Invalid Event Count: 0 |
This file contains hidden or 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
| ======================================================= | |
| Begin Review | |
| ======================================================= | |
| Count Summary | |
| Valid Event Count: 2221 | |
| Invalid Event Count: 0 |
dwthien
/ Jazzcaen.rb
Last active
November 9, 2017 11:01
This file contains hidden or 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
| ======================================================= | |
| Begin Review | |
| ======================================================= | |
| Count Summary | |
| Valid Event Count: 118 | |
| Invalid Event Count: 0 | |
| ======================================================= |
dwthien
/ Ticketmaster::Apiv1::GB.rb
Last active
November 9, 2017 02:49
This file contains hidden or 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
| ======================================================= | |
| Begin Review | |
| ======================================================= | |
| Count Summary | |
| Valid Event Count: 32063 | |
| Invalid Event Count: 0 |
dwthien
/ Ticketmaster::Apiv1::IE.rb
Last active
November 10, 2017 04:19
This file contains hidden or 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
| ======================================================= | |
| Begin Review | |
| ======================================================= | |
| Count Summary | |
| Valid Event Count: 1960 | |
| Invalid Event Count: 0 |
dwthien
/ Ticketmaster::Apiv1::FR.rb
Last active
November 7, 2017 10:34
This file contains hidden or 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
| ======================================================= | |
| Begin Review | |
| ======================================================= | |
| Count Summary | |
| Valid Event Count: 55866 | |
| Invalid Event Count: 0 |
dwthien
/ Ticketmaster::Apiv1::FR.rb
Created
November 6, 2017 10:27
This file has been truncated, but you can view the full file.
This file contains hidden or 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
| ======================================================= | |
| Begin Review | |
| ======================================================= | |
| Count Summary | |
| Valid Event Count: 55714 | |
| Invalid Event Count: 0 |
NewerOlder