Python resourcePlanet示例

示例#1

文件： dbShared.py 项目： clreinki/GalaxyHarvester

def getSpawnPlanets(conn, spawnID, availableOnly):
	criteriaStr = ''
	planets = []
	cursor = conn.cursor()
	if (cursor):
		if availableOnly:
			criteriaStr = ' AND unavailable IS NULL'
		sqlStr = 'SELECT tPlanet.planetID, planetName, enteredBy FROM tPlanet LEFT JOIN (SELECT planetID, enteredBy FROM tResourcePlanet WHERE spawnID='+str(spawnID)+criteriaStr+') trp ON tPlanet.planetID=trp.planetID;'
		cursor.execute(sqlStr)
		row = cursor.fetchone()
		while (row != None):
			p = ghObjects.resourcePlanet(row[0], row[1], row[2])
			planets.append(p)
			row = cursor.fetchone()
	cursor.close()
	return planets

示例#2

def getSpawnPlanets(conn, spawnID, availableOnly, galaxy):
	criteriaStr = ''
	planets = []
	cursor = conn.cursor()
	if (cursor):
		if availableOnly:
			criteriaStr = ' AND unavailable IS NULL'
		sqlStr = 'SELECT DISTINCT tPlanet.planetID, planetName, enteredBy FROM tGalaxyPlanet, tPlanet LEFT JOIN (SELECT planetID, enteredBy FROM tResourcePlanet WHERE spawnID='+str(spawnID)+criteriaStr+') trp ON tPlanet.planetID=trp.planetID WHERE (tPlanet.planetID < 11) OR (tPlanet.planetID = tGalaxyPlanet.planetID AND tGalaxyPlanet.galaxyID = '+str(galaxy)+') ORDER BY planetName;'
		cursor.execute(sqlStr)
		row = cursor.fetchone()
		while (row != None):
			p = ghObjects.resourcePlanet(row[0], row[1], row[2])
			planets.append(p)
			row = cursor.fetchone()
	cursor.close()
	return planets