Re: [Health] Thalamus

[Luis Falcon]

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 :

http://hg.savannah.gnu.org/hgweb/health/rev/8e61ea5d325c

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
Luis