Styjun

How is character development a major role in the plot of a story

Windows 10 Programs start without visual Interface

Uses of T extends U?

Is this story about US tax office reasonable?

How to return && object from function?

File globbing pattern, !(*example), behaves differently in bash script than it does in bash shell

What caused the tendency for conservatives to not support climate change reform?

How does an ARM MCU run faster than the external crystal?

Plot exactly N bounce of a ball

What problems does SciDraw still solve?

What is the best linguistic term for describing the kw > p / gw > b change, and its usual companion s > h

What is the 中 in ダウンロード中？

How do I subvert the tropes of a train heist?

Looking after a wayward brother in mother's will

Infinitely many hats

Why do Russians call their women expensive ("дорогая")?

Inverter Power draw from 12V battery

Draw a checker pattern with a black X in the center

What F1 in name of seeds/varieties means?

What does uniform continuity mean exactly?

Tic-Tac-Toe for the terminal

Pattern matching repeated arguments of Times

What does the behaviour of water on the skin of an aircraft in flight tell us?

Can a wire having a 610-670 THz (frequency of blue light) AC frequency supply, generate blue light?

ReQL : Filtering Documents from Python List of Strings

RethinkDB: multiple comparisons filteringHow to remove a key from a RethinkDB document?Rethinkdb, Python, and FilterHow to apply filter on array in ReQL in ReThinkDB using JavaScriptREQL to match string expressionRethinkDB Python Recursive Document FilterREQL - Using Filter with (regex) Match, and then Pluck from a list in a nested hashUse result from another query in filter in RethinkDB/ReQLHow can I upsert a document in rethinkdb (reql) by an arbitrary property?How to use ReQL filter and match command on arraysFilter documents based on value of an attribute inside an array of objects

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I'd to like to filter a table with ReQL using a (Python) list of strings (variable number of values) applied on several fields, ie in the logic of more strings in the list more result is accurate. Ideally the filtering should be case incensitive.

SQL equivalent could be something close to :

select * from mytable
where (field1 like '%AA%' and field1 like '%BB%'...)
or (field2 like '%AA%' and field2 like '%BB%'...)
or (field3 like '%AA%' and field3 like '%BB%'...)
...

I tested lot of solutions without success, for intance the one described here :

selection = list(r.table("mytable").filter(lambda d: 
 r.expr(searchWords).contains(d["field"]) 
).run(g.rdb_conn))

But 0 doc is returned (?).

rethinkdb rethinkdb-python reql

share|improve this question

edited Mar 24 at 8:09

Tom

asked Mar 23 at 23:40

TomTom

185

add a comment | 

0

I'd to like to filter a table with ReQL using a (Python) list of strings (variable number of values) applied on several fields, ie in the logic of more strings in the list more result is accurate. Ideally the filtering should be case incensitive.

SQL equivalent could be something close to :

select * from mytable
where (field1 like '%AA%' and field1 like '%BB%'...)
or (field2 like '%AA%' and field2 like '%BB%'...)
or (field3 like '%AA%' and field3 like '%BB%'...)
...

I tested lot of solutions without success, for intance the one described here :

selection = list(r.table("mytable").filter(lambda d: 
 r.expr(searchWords).contains(d["field"]) 
).run(g.rdb_conn))

But 0 doc is returned (?).

rethinkdb rethinkdb-python reql

share|improve this question

edited Mar 24 at 8:09

Tom

asked Mar 23 at 23:40

TomTom

185

add a comment | 

I'd to like to filter a table with ReQL using a (Python) list of strings (variable number of values) applied on several fields, ie in the logic of more strings in the list more result is accurate. Ideally the filtering should be case incensitive.

SQL equivalent could be something close to :

select * from mytable
where (field1 like '%AA%' and field1 like '%BB%'...)
or (field2 like '%AA%' and field2 like '%BB%'...)
or (field3 like '%AA%' and field3 like '%BB%'...)
...

I tested lot of solutions without success, for intance the one described here :

selection = list(r.table("mytable").filter(lambda d: 
 r.expr(searchWords).contains(d["field"]) 
).run(g.rdb_conn))

But 0 doc is returned (?).

rethinkdb rethinkdb-python reql

share|improve this question

edited Mar 24 at 8:09

Tom

asked Mar 23 at 23:40

TomTom

185

select * from mytable
where (field1 like '%AA%' and field1 like '%BB%'...)
or (field2 like '%AA%' and field2 like '%BB%'...)
or (field3 like '%AA%' and field3 like '%BB%'...)
...

selection = list(r.table("mytable").filter(lambda d: 
 r.expr(searchWords).contains(d["field"]) 
).run(g.rdb_conn))

share|improve this question

edited Mar 24 at 8:09

Tom

asked Mar 23 at 23:40

TomTom

185

share|improve this question

edited Mar 24 at 8:09

Tom

asked Mar 23 at 23:40

TomTom

185

asked Mar 23 at 23:40

TomTom

185

asked Mar 23 at 23:40

TomTom

185

1 Answer
1

active

oldest

votes

0

Answering my own question. For those who could be interested I finally workarounded the problem by :

1. Iterating on all search words of input string




2. Searching and grabbing all DocIDs matching each word using :

 selectionDict = list(r.table('mytable').filter( 
 ( r.row["field1"].match("(?i)"+searchWord)) 
 | (r.row["field2"]["body"].match("(?i)"+searchWord) ) ) 
 .pluck("id") 
 .run(g.rdb_conn))

3. Building a dict for each DocID (key) with a "weight" as value. On each word found for a DocID the "weight" value is incremented by 1.




4. Once iteration is over all the DocIDs getting the same "weight" as number of words are relevant to be returned, meaning they match all search words. For instance with a 3 words string all DocIDs getting a 3 as "weight" (at the end) means that all words have been found for them.




5. get_all with DocIDs is then used to retrieve and return them.

Note the search is case insensitive, on multiple fields and can use partial words as I wanted initially.
Likely not the best and cleanest way but works at least on not-too-large database.

share|improve this answer

answered Mar 25 at 20:50

TomTom

185

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55319399%2freql-filtering-documents-from-python-list-of-strings%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Answering my own question. For those who could be interested I finally workarounded the problem by :

1. Iterating on all search words of input string




2. Searching and grabbing all DocIDs matching each word using :

 selectionDict = list(r.table('mytable').filter( 
 ( r.row["field1"].match("(?i)"+searchWord)) 
 | (r.row["field2"]["body"].match("(?i)"+searchWord) ) ) 
 .pluck("id") 
 .run(g.rdb_conn))

3. Building a dict for each DocID (key) with a "weight" as value. On each word found for a DocID the "weight" value is incremented by 1.




4. Once iteration is over all the DocIDs getting the same "weight" as number of words are relevant to be returned, meaning they match all search words. For instance with a 3 words string all DocIDs getting a 3 as "weight" (at the end) means that all words have been found for them.




5. get_all with DocIDs is then used to retrieve and return them.

Note the search is case insensitive, on multiple fields and can use partial words as I wanted initially.
Likely not the best and cleanest way but works at least on not-too-large database.

share|improve this answer

answered Mar 25 at 20:50

TomTom

185

add a comment | 

0

Answering my own question. For those who could be interested I finally workarounded the problem by :

1. Iterating on all search words of input string




2. Searching and grabbing all DocIDs matching each word using :

 selectionDict = list(r.table('mytable').filter( 
 ( r.row["field1"].match("(?i)"+searchWord)) 
 | (r.row["field2"]["body"].match("(?i)"+searchWord) ) ) 
 .pluck("id") 
 .run(g.rdb_conn))

3. Building a dict for each DocID (key) with a "weight" as value. On each word found for a DocID the "weight" value is incremented by 1.




4. Once iteration is over all the DocIDs getting the same "weight" as number of words are relevant to be returned, meaning they match all search words. For instance with a 3 words string all DocIDs getting a 3 as "weight" (at the end) means that all words have been found for them.




5. get_all with DocIDs is then used to retrieve and return them.

Note the search is case insensitive, on multiple fields and can use partial words as I wanted initially.
Likely not the best and cleanest way but works at least on not-too-large database.

share|improve this answer

answered Mar 25 at 20:50

TomTom

185

add a comment | 

Answering my own question. For those who could be interested I finally workarounded the problem by :

1. Iterating on all search words of input string




2. Searching and grabbing all DocIDs matching each word using :

 selectionDict = list(r.table('mytable').filter( 
 ( r.row["field1"].match("(?i)"+searchWord)) 
 | (r.row["field2"]["body"].match("(?i)"+searchWord) ) ) 
 .pluck("id") 
 .run(g.rdb_conn))

3. Building a dict for each DocID (key) with a "weight" as value. On each word found for a DocID the "weight" value is incremented by 1.




4. Once iteration is over all the DocIDs getting the same "weight" as number of words are relevant to be returned, meaning they match all search words. For instance with a 3 words string all DocIDs getting a 3 as "weight" (at the end) means that all words have been found for them.




5. get_all with DocIDs is then used to retrieve and return them.

Note the search is case insensitive, on multiple fields and can use partial words as I wanted initially.
Likely not the best and cleanest way but works at least on not-too-large database.

share|improve this answer

answered Mar 25 at 20:50

TomTom

185

 selectionDict = list(r.table('mytable').filter( 
 ( r.row["field1"].match("(?i)"+searchWord)) 
 | (r.row["field2"]["body"].match("(?i)"+searchWord) ) ) 
 .pluck("id") 
 .run(g.rdb_conn))

share|improve this answer

answered Mar 25 at 20:50

TomTom

185

answered Mar 25 at 20:50

TomTom

185

answered Mar 25 at 20:50

TomTom

185