Repository pattern example for Postgres-py

gistfile1.py

from postgres.orm import Model
from postgres import Postgres

class Foo(Model):
	typname = "foo"

class FooRepository(connection_string):
    def __init__(self):
		self.db = Postgres(connection_string)
        self.db.register_model(Foo)
        
    def get_all(self):
		return self.db.all("SELECT foo.*::foo FROM foo")


repo = FooRepository("<connection-string>")

foos = repo.get_all()