def test_fetch_all_data(self): with self.db as cur: cur.execute(insert("person", {"person_id": "mosky", "name": "Mosky Liu"})) cur.execute(select("person")) results = all_to_dicts(cur) self.db._conn.rollback()
def test_fetch_all_data(self): with self.db as cur: cur.execute(insert('person', { 'person_id': 'mosky', 'name' : 'Mosky Liu' })) cur.execute(select('person')) results = all_to_dicts(cur) self.db._conn.rollback()
def test_fetch_all_data(self): with self.db as cur: cur.execute( insert('person', { 'person_id': 'mosky', 'name': 'Mosky Liu' })) cur.execute(select('person')) results = all_to_dicts(cur) self.db._conn.rollback()
#!/usr/bin/env python # -*- coding: utf-8 -*- import psycopg2 from pprint import pprint from mosql.query import select, left_join from mosql.db import Database, all_to_dicts db = Database(psycopg2, host='127.0.0.1') with db as cur: cur.execute(select( 'person', {'person_id': 'mosky'}, # It is same as using keyword argument: #where = {'person_id': 'mosky'}, joins = left_join('detail', using='person_id'), # You can also use tuple to add multiple join statements: #joins = (left_join('detail', using='person_id'), ) )) pprint(all_to_dicts(cur))