Questions tagged [rethinkdb-python]

Python driver for RethinkDB

140 questions
0
votes
1 answer

Is there a way to do wj with aggration on columns from the left table?

I have below code. weight is from the right table, and the aggregation works. weightLeft is from the left table, and the aggregation doesn't work. Is it possible to make weightLeft works? t:([]sym:3#`ibm;time:10:01:01 10:01:04 10:01:08;price:200 201…
H42
  • 725
  • 2
  • 9
  • 28
0
votes
1 answer

wj failed for columns' sum product

I have below code and I want to do sumproduct. When I do sum(weight) at wj, it works. But if I do sum(weight*price) at wj, it failed. How can I do the sumproduct? Thanks!! t:([]sym:3#`ibm;time:10:01:01 10:01:04 10:01:08;price:100 101…
H42
  • 725
  • 2
  • 9
  • 28
0
votes
0 answers

Query RethinkDB - Python

I'm having a complication in consulting my database RethinkDB with python. When I query as below with get_all, I have the correct return from the database. QUERY = r.db("REPO").table("TABLE").get_all('X', 'Y')\ .pluck({'CURRENT': {'CONFIG':…
0
votes
1 answer

How to delete a set of data based on group in RethinkDB with Python

I have a table with musical instruments and I want to split them by category count their number and if a category groups is larger than a number delete all the instruments in that group. My code currently is: from rethinkdb import RethinkDB from…
KZiovas
  • 3,491
  • 3
  • 26
  • 47
0
votes
1 answer

How to check if table exists in RethinkDB with Python

I wish to check if a table already exists in RethinkDB with the python client before trying to create the table. If you try to create the table and it exists it throws an error. So how can I check that? My code looks like this : from rethinkdb…
KZiovas
  • 3,491
  • 3
  • 26
  • 47
0
votes
1 answer

How to check the type of a document element (sub document vs list)? "ReqlServerCompileError: Variable name not found in: var_1"

I extend the RethinkDb API by providing some extra functions. For example I simplify the expression site_ids = r.table('periods')\ ['regions']\ .concat_map(lambda row: row['sites'])\ ['id'] to site_ids =…
Stefan
  • 10,010
  • 7
  • 61
  • 117
0
votes
1 answer

rethinkdb python eqJoin with filter not working

I have two tables records [ { "payload": { "uuid": "123", "version": "1.0.0" }, "record_id":"rec-123" }, { "payload": { "uuid": "456", "version": "1.0.1" }, "record_id":"rec-456" } ] and…
Dibshare
  • 95
  • 2
  • 13
0
votes
1 answer

Rethinkbd changefeeds for flutter dart

I am using rethinkdb in my app. I can insert and retrieve data using the "rethink_db_ns" package. But I need to get data in real-time. for that, I am using This method Future getData(RethinkDb r, Connection connection) async { var data =…
0
votes
1 answer

Fetch records by multiple indexes

What is the most efficient way to get all records by two indexes? Lets say we have two secondary indexes, end_block_num and public_key and the values bellow: end_block_num = 1000 public_key = "AABBCC" I have already tried two different queries (i…
Charalarg
  • 75
  • 1
  • 9
0
votes
1 answer

How to connect rethinkdb in Openshift using rethinkdbdash

Could someone help to connect to rethinkdb in openshift using rethinkdbdash I have deployed rethinkdb in openshift & create 3 clusterIP services 1.8080 - admin 2.29015 - intracluster communicated 3.28015 - client connection I have created a route…
0
votes
2 answers

Problem getting data from a Rethinkdb table in a specific order

The command "rdb.table('newnmeadata').orderBy('nos')" works fine in the RethinkDB data explorer. 'Nos' is the primary key. There are no problems with getting data (for a socket feed) using ".with_fields" but the RethinkDB serves the data in any…
0
votes
0 answers

Password hashing function in Flask with rethinkDB

I'm having trouble implementing hash/check_hash functions in flask with rethinkDB (using remodel ORM). What I have coded I know can't work, but I'm not sure how to implement this, so that it will work. Should I just hash/check hash the password when…
0
votes
1 answer

AttributeError: module 'rethinkdb' has no attribute 'connect'

I am using the RethinkDB in my Jupyter Python Notebook. I have installed the RethinkDB server for my Windows setup. And server version is C:\Users\rethinkdb-2.3.6>rethinkdb --version rethinkdb 2.3.6-windows (MSC 190024215) On the client side, I…
dola
  • 1
  • 1
0
votes
1 answer

ReQL : Filtering Documents from Python List of Strings

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…
Tom
  • 63
  • 1
  • 8
0
votes
0 answers

Access RethinkDB database from LAN

I have 3 machines connected via LAN. I want to create RethinkDB database in one machine and access it from the other two machines via LAN. I am running Ubuntu Server 16.04 in a virtual machine in which I have created the database, and I am running…
Shaheer Akram
  • 765
  • 6
  • 13