X-Git-Url: http://gitweb.michael.orlitzky.com/?a=blobdiff_plain;f=src%2FCensus.py;h=0f8d23473144d38602e3094797de3f44cd9b05fb;hb=cdf201cdec6ddcca1dc801f9ae3ae85c7c9d0637;hp=da9283d2efb20c4c7d1f8896b120fad8f98b3815;hpb=0e8428f00f565a3e1791e19098ab59442972fa09;p=dead%2Fcensus-tools.git diff --git a/src/Census.py b/src/Census.py index da9283d..0f8d234 100644 --- a/src/Census.py +++ b/src/Census.py @@ -1,5 +1,6 @@ import pgdb +import Configuration.Defaults import GPS import SummaryFile1 @@ -11,11 +12,16 @@ class Database: one or two methods from within this class. """ - def __init__(self, _host, _database, _username, _srid): - self.connection = pgdb.connect(host=_host, - database=_database, - user=_username) - self.srid = _srid + def __init__(self, + initial_host=Configuration.Defaults.DATABASE_HOST, + initial_database=Configuration.Defaults.DATABASE_NAME, + initial_username=Configuration.Defaults.DATABASE_USERNAME, + initial_srid=Configuration.Defaults.SRID): + + self.connection = pgdb.connect(host=initial_host, + database=initial_database, + user=initial_username) + self.srid = initial_srid def __del__(self): @@ -40,11 +46,12 @@ class Database: cursor.execute(query, sql_params) rows = cursor.fetchall() cursor.close() - - if len(rows) > 0: + + # SQL queries that return no results get returned as [[None]]. + if rows[0][0] != None: return rows[0][0] else: - return None + return 0 def find_contained_population(self, well_known_text): @@ -106,10 +113,11 @@ class Database: rows = cursor.fetchall() cursor.close() - if (len(rows) > 0): + # SQL queries that return no results get returned as [[None]]. + if rows[0][0] != None: return rows[0][0] else: - return None + return 0 @@ -131,8 +139,7 @@ class Database: rows = cursor.fetchall() cursor.close() - if len(rows) > 0: - return rows[0][0] - else: - return None + # Just pass on the None if that's what we got from the + # database. + return rows[0][0]