peewee_example.py

from peewee import *

DATABASE = SqliteDatabase("hosts.db")

class BaseModel(Model):
    class Meta:
        database = DATABASE

class Hosts(BaseModel):
    name = CharField(max_length=256)
    jump = CharField(max_length=256)
    jenkins = CharField(max_length=256)
    nexus = CharField(max_length=256)
    domain = CharField(max_length=256)
    role = CharField(max_length=256)
    env = CharField(max_length=256)
    cpu = IntegerField()

    def fqdn(self):
        return "{n}.{d}".format(n=self.name, d=self.domain)

if __name__ == "__main__":
    DATABASE.connect()
    for host in Hosts.select().where(Hosts.env == "preview"):
        print host.fqdn()