def selectAllLocations(self, accountId):
conn = sqlite3.connect(self.dbName)
locationCursor = conn.cursor()
data = locationCursor.execute(
"select * from Location where AccountId = %d" % accountId
).fetchall()
locationCursor.close()
locations = []
for ldata in data:
location = Location(ldata[0], ldata[1], ldata[2], ldata[3], ldata[4])
growCursor = conn.cursor()
growData = growCursor.execute(
"select * from Grow, FruitCrop where (Grow.FC_Id) = FruitCrop.Id and Grow.L_Id = %d" % ldata[0]
).fetchall()
for g in growData:
FC = FruitCrop(g[4], g[5], g[6], g[7])
grow = Grow(g[0], g[1], FC, g[2], g[3])
location.appendGrow(grow)
growCursor.close()
locations.append(location)
conn.close()
return locations
