def __init__(self):
''' Initialize interface and create singleton instance '''
if Interface._instance_:
raise Interface._instance_
Interface._instance_ = self
Interface.user = User()
Interface.search = Search()
self.db = DatabaseConnection()
def __init__(self):
''' Initialize interface and create singleton instance '''
if Interface._instance_:
raise Interface._instance_
Interface._instance_ = self
Interface.user = User()
Interface.search = Search()
self.db = DatabaseConnection()
class Interface():
''' Singleton class to manage shared components '''
_instance_ = None
def __init__(self):
''' Initialize interface and create singleton instance '''
if Interface._instance_:
raise Interface._instance_
Interface._instance_ = self
Interface.user = User()
Interface.search = Search()
self.db = DatabaseConnection()
def login(self):
''' User login, save to interface '''
u = Interface.user
result = self.db.execute(u.query())
dat = result.fetchone()
u.set(dat)
def search_species(self):
''' Save species to interface '''
s = Interface.search
result = self.db.execute(s.query())
dat = result.fetchall()
s.set_species(dat)
def search_observations(self):
''' Save observations to interface '''
s = Interface.search
result = self.db.execute(s.query_observations())
dat = result.fetchall()
s.set_observations(dat)
class Interface():
''' Singleton class to manage shared components '''
_instance_ = None
def __init__(self):
''' Initialize interface and create singleton instance '''
if Interface._instance_:
raise Interface._instance_
Interface._instance_ = self
Interface.user = User()
Interface.search = Search()
self.db = DatabaseConnection()
def login(self):
''' User login, save to interface '''
u = Interface.user
result = self.db.execute(u.query())
dat = result.fetchone()
u.set(dat)
def search_species(self):
''' Save species to interface '''
s = Interface.search
result = self.db.execute(s.query())
dat = result.fetchall()
s.set_species(dat)
def search_observations(self):
''' Save observations to interface '''
s = Interface.search
result = self.db.execute(s.query_observations())
dat = result.fetchall()
s.set_observations(dat)
#!/usr/bin/env python
# (c)2015 John Strickler
from databaseconnection import DatabaseConnection
from builddb import build_database
build_database()
db_conn = DatabaseConnection()
db_conn.cursor.execute(
'''
select first_name, last_name
from computer_people
'''
)
for row in db_conn.cursor.fetchall():
print(' '.join(row))
