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))