From 839aa71278e749d3475bd8f586d65a4cd1d7c213 Mon Sep 17 00:00:00 2001 From: schneefux Date: Mon, 23 Jan 2017 20:04:49 +0100 Subject: api: use jsonb instead of json --- database.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'database.py') diff --git a/database.py b/database.py index 5119899..41f4328 100644 --- a/database.py +++ b/database.py @@ -42,7 +42,7 @@ class Database(object): async with self._pool.acquire() as conn: async with conn.transaction(): await conn.execute("CREATE TABLE IF NOT EXISTS " + objtype + - " (id TEXT PRIMARY KEY, data json)") + " (id TEXT PRIMARY KEY, data jsonb)") await conn.executemany("INSERT INTO " + objtype + " " + "VALUES ($1, $2) " + "ON CONFLICT (id) DO " + @@ -92,7 +92,7 @@ class Database(object): async with self._pool.acquire() as conn: async with conn.transaction(): await conn.execute("CREATE TABLE IF NOT EXISTS meta " + - "(key TEXT PRIMARY KEY, value json)") + "(key TEXT PRIMARY KEY, value jsonb)") if value is not None: value = json.dumps(value) await conn.execute("INSERT INTO meta(key, value) " + -- cgit v1.3.1