[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Health] Thalamus

From: Luis Falcon
Subject: Re: [Health] Thalamus
Date: Fri, 24 May 2019 14:40:37 +0100

Dear Bahaa

On Wed, 22 May 2019 13:55:48 -0400
Bahaa Alamood <address@hidden> wrote:

> Dear Luis,
> Thanks for taken your time to explain the below to me. I am making
> some progress and here is what I have so far:

Wonderful !

> I was able to load the database using the populate script and I have
> added a record with a root role, but now when I go to the federation
> queue and try to send the changes like creating new patient record or
> just a person I get this
> [2019-05-22 17:38:41 +0000] [30800] [DEBUG] GET /people/IRQVSQ827RFZ
> [2019-05-22 17:39:47 +0000] [30800] [DEBUG] POST /people/IRQYPS253LUG
> [2019-05-22 17:39:49 +0000] [30800] [ERROR] Exception
> on /people/IRQYPS253LUG [POST] Traceback (most recent call last):
> where id = %s limit(1)', (table, resid)) psycopg2.errors.SyntaxError:
> syntax error at or near "'people'" LINE 1: SELECT id from
> 'people'         where id = 'IRQYPS253LUG' li...

Thanks for the feedback ! Great ! In fact the problem comes from porting
MongoDB to PostgreSQL.  We need special syntax when passing the table
name as an argument in psycopg2.

I have fixed on the development branch of thalamus. You can see the
patch here :

I should release a new Thalamus version with this patch when coming
back from openSUSE conference, where I am right now :)

Please test the development version and let me know 

All the best

reply via email to

[Prev in Thread] Current Thread [Next in Thread]