Re: [sqlalchemy] How to query postgresql JSONB columns?

2015-04-04 Thread Daniel Kerkow
Am 05.04.2015 01:58 schrieb Mike Bayer mike...@zzzcomputing.com: On 4/4/15 7:47 PM, Daniel Kerkow wrote: 2015-04-05 1:29 GMT+02:00 Mike Bayer mike...@zzzcomputing.com: On 4/4/15 7:22 PM, Daniel Kerkow wrote: Hi, I am new to SQLAlchemy, doing my first steps with Flask. I have the

[sqlalchemy] How to query postgresql JSONB columns?

2015-04-04 Thread Daniel Kerkow
Hi, I am new to SQLAlchemy, doing my first steps with Flask. I have the following model using JSONB data type in PostgreSQL. The JSON data looks like {'key1': 'value1', 'key2': 'value2'} The Docs are relatively sparse regarding this topic. How can I query the properties column for containing

Re: [sqlalchemy] How to query postgresql JSONB columns?

2015-04-04 Thread Mike Bayer
On 4/4/15 7:22 PM, Daniel Kerkow wrote: Hi, I am new to SQLAlchemy, doing my first steps with Flask. I have the following model using JSONB data type in PostgreSQL. The JSON data looks like | {'key1':'value1','key2':'value2'} | The Docs are relatively sparse regarding this topic. the

Re: [sqlalchemy] How to query postgresql JSONB columns?

2015-04-04 Thread Daniel Kerkow
2015-04-05 1:29 GMT+02:00 Mike Bayer mike...@zzzcomputing.com: On 4/4/15 7:22 PM, Daniel Kerkow wrote: Hi, I am new to SQLAlchemy, doing my first steps with Flask. I have the following model using JSONB data type in PostgreSQL. The JSON data looks like {'key1': 'value1', 'key2':

Re: [sqlalchemy] How to query postgresql JSONB columns?

2015-04-04 Thread Mike Bayer
On 4/4/15 7:29 PM, Mike Bayer wrote: On 4/4/15 7:22 PM, Daniel Kerkow wrote: Hi, I am new to SQLAlchemy, doing my first steps with Flask. I have the following model using JSONB data type in PostgreSQL. The JSON data looks like | {'key1':'value1','key2':'value2'} | The Docs are

Re: [sqlalchemy] How to query postgresql JSONB columns?

2015-04-04 Thread Mike Bayer
On 4/4/15 7:47 PM, Daniel Kerkow wrote: 2015-04-05 1:29 GMT+02:00 Mike Bayer mike...@zzzcomputing.com mailto:mike...@zzzcomputing.com: On 4/4/15 7:22 PM, Daniel Kerkow wrote: Hi, I am new to SQLAlchemy, doing my first steps with Flask. I have the following model using