Using Ruby Driver to create a complicated query in Rethinkdb's Reql -

-

i using ruby driver rethink db , running problem nested elements has arrays.

i have data structured this

[{"family_name"=>"adam"},  {"family_name"=>"bobby"},  {"family_name"=>"crissy",   "groups"=>    [{"logo_url"=>"https://www.logourl.com/1111.png",      "name"=>"sample name 1",      "profile_url"=>"https://www.profileurl.com/groups?gid=1111"},     {"logo_url"=>"https://www.logourl.com/2222.png",      "name"=>"sample name 2",      "profile_url"=>"https://www.profileurl.com/groups?gid=2222"},     {"logo_url"=>"https://www.logourl.com/3333.png",      "name"=>"sample name 3",      "profile_url"=>"https://www.profileurl.com/groups?gid=3333"},    ]},  {"family_name"=>"bobby"},  {"family_name"=>"hillton",   "groups"=>    [{"logo_url"=>"https://www.logourl.com/4444.png",      "name"=>"sample name 1",      "profile_url"=>"https://www.profileurl.com/groups?gid=4444"},     {"logo_url"=>"https://www.logourl.com/5555.png",      "name"=>"sample name 2",      "profile_url"=>"https://www.profileurl.com/groups?gid=55555"},     {"logo_url"=>"https://www.logourl.com/6666.png",      "name"=>"sample name 3",      "profile_url"=>"https://www.profileurl.com/groups?gid=12345"},     ]}]

the desired result return row has 'profile_url' link ends "12345". using mix of ruby , javascript, have attempted :

'r.table("profiles").filter{ |row| row['groups'].contains(r.js('function(group) { return group('profile_url').match("12345$") }'))}.run(conn)'

however, still not returning result, there clear way use ruby driver???

the desired result be

[{"family_name"=>"hillton",   "groups"=>    [{"logo_url"=>"https://www.logourl.com/4444.png",      "name"=>"sample name 1",      "profile_url"=>"https://www.profileurl.com/groups?gid=4444"},     {"logo_url"=>"https://www.logourl.com/5555.png",      "name"=>"sample name 2",      "profile_url"=>"https://www.profileurl.com/groups?gid=55555"},     {"logo_url"=>"https://www.logourl.com/6666.png",      "name"=>"sample name 3",      "profile_url"=>"https://www.profileurl.com/groups?gid=12345"},     ]}]

please , in advance!!! :d

i think want:

r.table('profiles').filter {|row|   row['groups'].contains {|group|     group['profile_url'].match('12345$')   } }

Comments

Post a Comment

Popular posts from this blog

html - Styling progress bar with inline style -

-
i trying set progress bar color red using inline style. need in way because have access <body> part of document. style need apply: progress { color: red } progress::-moz-progress-bar { background: red;} progress::-webkit-progress-value { background: red; } progress[aria-valuenow]:before { background: red; } i tried <progress style="background: red;"> incorrect effect, progress bar color turns blue red background. guide right direction desired style? thank in advance. here live example: https://jsfiddle.net/z36d3f6l/
Read more

java - Oracle Sql developer error: could not install some modules -

-
i have downloaded fresh copy of sqldeveloper ( sqldeveloper-4.1.3.20.78-no-jre ) oracle website. when unzip , lauch gui, keep getting following error message: warning - not install modules: dynamic module config - no module providing capability org.netbeans.netbinox found. my system: windows 7 32 bit hp probook. jdk 1.6 , 1.7, 1.8 available in java/jdk subdirectory. netbeans 8.0.2 installed finally got way out after dirty hours. extracted sqldeveloper zip in nested directory. i.e: e://a/b/c/sqldeveloper. starting sqldeveloper gui above directory threw erros. solution: go in c:\users**username**\appdata\roaming : delete sql developer , sqldeveloper folders extract sql developer zip in new non nested directory. i.e: e:// start , should work now reference: https://community.oracle.com/thread/3870680?start=0&tstart=0
Read more

How to use autoclose brackets in Jupyter notebook? -

-
this may sound silly question, how make use of autoclose brackets in jupyter notebook? example, when type print( jupyter notebook auto-closes brakets print() and places cursor inside. type argument, say print(1 + 1) now cursor between second 1 , right bracket ) . key navigate right of ) ? of course can press end or → or ) achieve this, not seem save time, purpose of brackets autoclose suppose? thanks in advance.
Read more