def runUpdate():
xbmc.log('RCB: runUpdate')
gdb = GameDataBase(util.getAddonDataPath())
gdb.connect()
#create db if not existent and maybe update to new version
gdb.checkDBStructure()
configFile = config.Config(None)
configFile.readXml()
selectedRomCollection = ''
selectedScraper = ''
xbmc.log('RCB: parameters = %s' % sys.argv)
for arg in sys.argv:
param = str(arg)
xbmc.log('RCB: param = %s' % param)
if 'selectedRomCollection' in param:
selectedRomCollection = param.replace('selectedRomCollection=', '')
if 'selectedScraper' in param:
selectedScraper = param.replace('selectedScraper=', '')
romCollections = configFile.romCollections
if selectedRomCollection and selectedScraper:
romCollections = prepareRomCollections(configFile, selectedRomCollection, selectedScraper)
progress = ProgressDialogBk()
progress.create('Rom Collection Browser', 'Update DB')
with HandleAbort():
dbupdate.DBUpdate().updateDB(gdb, progress, romCollections, False)
progress.close()
def test_UpdateDB(self):
configFile = config.Config(None)
statusOk, errorMsg = configFile.readXml()
if (statusOk == False):
self.fail('Error reading config.xml')
dbupdate.DBUpdate().updateDB(self.gdb, RCBMock(), 0,
configFile.romCollections,
util.getSettings())
#test some filters
likeStmnt = '0 = 0'
#Amiga Action
gameRows = Game(self.gdb).getFilteredGames(1, 1, 0, 0, 0, likeStmnt)
self.assertTrue(gameRows != None)
self.assertEqual(len(gameRows), 2)
#Amiga 1994
gameRows = Game(self.gdb).getFilteredGames(2, 0, 10, 0, 0, likeStmnt)
self.assertTrue(gameRows != None)
self.assertEqual(len(gameRows), 2)
#Amiga Black Legend Ltd.
gameRows = Game(self.gdb).getFilteredGames(2, 0, 0, 12, 0, likeStmnt)
self.assertTrue(gameRows != None)
self.assertEqual(len(gameRows), 1)
#Amiga Sports, 1994, Black Legend Ltd.
gameRows = Game(self.gdb).getFilteredGames(2, 4, 10, 12, 0, likeStmnt)
self.assertTrue(gameRows != None)
self.assertEqual(len(gameRows), 1)
#SNES 1st person shooter
gameRows = Game(self.gdb).getFilteredGames(3, 6, 0, 0, 0, likeStmnt)
self.assertTrue(gameRows != None)
self.assertEqual(len(gameRows), 1)
#SNES 1992
gameRows = Game(self.gdb).getFilteredGames(3, 0, 5, 0, 0, likeStmnt)
self.assertTrue(gameRows != None)
self.assertEqual(len(gameRows), 3)
#SNES Nintendo
gameRows = Game(self.gdb).getFilteredGames(3, 0, 0, 9, 0, likeStmnt)
self.assertTrue(gameRows != None)
self.assertEqual(len(gameRows), 2)
#SNES 1992 Racing Nintendo
gameRows = Game(self.gdb).getFilteredGames(3, 10, 5, 9, 0, likeStmnt)
self.assertTrue(gameRows != None)
self.assertEqual(len(gameRows), 1)
gameRows = Game(self.gdb).getAllOrdered()
self.assertTrue(gameRows != None)
self.assertEqual(len(gameRows), 47)
self.gameTest(
gameRows[0], '007: Agent Under Fire',
'Get ready for the next generation of 007, as Her Majestys greatest secret agent embarks upon an all-new, action-packed adventure.',
None, None, 5, 14, 8, None, 11, '1-4', '', '', '', '', 'DVD', '',
'Xbox Controller', 0, 0, 1, 1, 0, 0, 0, 0)
self.gameTest(gameRows[1], 'After Burner', '', None, None, 6, 19, 21,
None, 10, '', '', '', '', 'United States', '', '', '', 0,
0, 1, 1, 0, 0, 0, 0)
self.gameTest(
gameRows[2], 'Airborne Ranger',
'In this action/simulation game by Microprose the player takes the role of an U.S. Army airborne ranger.',
None, None, 1, 1, 1, None, 1, '????', '', '',
'http://www.mobygames.com/game/amiga/airborne-ranger', '', '', '',
'', 0, 0, 1, 1, 1, 0, 0, 0)
self.gameTest(
gameRows[3], 'AMF Bowling 2004',
'Experience the excitement of a night at the lanes with AMF Xtreme Bowling 2006.',
None, None, 5, 15, 15, None, 12, '1-2', '', '', '', '', 'DVD', '',
'Xbox Controller', 0, 0, 1, 1, 0, 0, 0, 0)
self.gameTest(gameRows[4], 'Antz Extreme Racing',
'Handling dirt is not a rewarding career', None, None, 5,
16, 16, None, 11, '1-4', '', '', '', '', 'DVD', '',
'Xbox Controller', 0, 0, 1, 1, 0, 0, 0, 0)
self.gameTest(gameRows[5], 'Area 51',
'No synopsis information for this game.', None, None, 5,
None, None, None, None, '', '', '', '', '', 'DVD', '',
'Xbox Controller', 0, 0, 1, 1, 0, 0, 0, 0)
self.gameTest(gameRows[6], 'BC Racers', '', None, None, 6, 20, 22,
None, 6, '', '', '', '', 'United States', '', '', '', 0,
0, 1, 1, 0, 0, 0, 0)
self.gameTest(
gameRows[7], 'Blackthorne',
'Blackthorne is an action-adventure game that takes place on the planet Tuul.',
None, None, 7, 17, 17, None, 6, '1 Player', '', '', '', '', '', '',
'', 0, 0, 1, 1, 0, 0, 0, 0)
self.gameTest(
gameRows[8], 'Brutal: Above the Claw',
'As with the original Brutal: Paws of Fury, the game involves a martial arts tournament set up by the Dalai Llama.',
None, None, 7, 18, 18, None, 6, '1-2 Players', '', '', '', '', '',
'', '', 0, 0, 1, 1, 0, 0, 0, 0)
self.gameTest(gameRows[9], 'California Games II',
'"At least it ends..."', None, None, 3, 5, 5, None, 5,
'', '', '', '', 'USA', 'Cartridge', '', 'Gamepad', 0, 0,
1, 1, 1, 1, 1, 1)
self.gameTest(
gameRows[10], 'Cosmic Carnage',
'Cosmic Carnage is a one-on-one fighting game set in outer space.',
None, None, 7, 19, 19, None, 10, '1-2 Players', '', '', '', '', '',
'', '', 0, 0, 1, 1, 0, 0, 0, 0)
self.gameTest(
gameRows[11], 'Demolition Man',
'Demolition Man is a multiplatform, run and gun action game based on the film of the same name.',
None, None, 3, 6, 6, None, 6, '', '', '', '', 'USA', 'Cartridge',
'', 'Gamepad', 0, 0, 1, 1, 1, 1, 1, 1)
self.gameTest(
gameRows[12], 'Dogfight',
'Dogfight is a two-player game with roots in the same primordial soup as Ataris Combat and other basic dogfighting games.',
None, None, 2, 11, 12, None, 9, '2 Players', '', '',
'http://www.mobygames.com/game/amiga/dogfight', '', '', '', '', 0,
0, 3, 1, 2, 0, 0, 0)
self.gameTest(
gameRows[13], 'Doom',
'Doom on the PC was without a doubt my favorite first person shooter "back in the day',
None, None, 3, 7, 7, None, 7, '1', '', '', '', 'USA', 'Cartridge',
'', 'Gamepad', 0, 0, 1, 1, 1, 1, 1, 1)
self.gameTest(
gameRows[14], 'Eliminator',
'A shoot em up set on a patchwork-quilt coloured road, Eliminator puts you in control of a ship with a basic weapon, flying along at breakneck speed.',
None, None, 1, 2, 2, None, 2, '????', '', '',
'http://www.mobygames.com/game/amiga/eliminator-', '', '', '', '',
0, 0, 1, 1, 1, 0, 0, 0)
self.gameTest(
gameRows[15], 'Football Glory',
'From Croatia came this overhead view football game resembling Sensible Soccer.',
None, None, 2, 12, 13, None, 10, '1-2 Players', '', '',
'http://www.mobygames.com/game/amiga/football-glory', '', '', '',
'', 0, 0, 3, 1, 1, 0, 0, 0)
self.gameTest(gameRows[16], 'Formula One Grand Prix',
'F1 is an Official Formula One Racing Game.', None, None,
1, 3, 3, None, 3, '????', '', '',
'http://www.mobygames.com/game/amiga/formula-one_', '',
'', '', '', 0, 0, 4, 1, 1, 0, 0, 0)
self.gameTest(gameRows[17], 'Game without Desc', '', None, None, 2,
None, None, None, None, '', '', '', '', '', '', '', '',
0, 0, 1, 0, 0, 0, 0, 0)
self.gameTest(
gameRows[18],
'Golf Magazine Presents 36 Great Holes Starring Fred Couples', '',
None, None, 6, 19, 20, None, 10, '', '', '', '', 'United States',
'', '', '', 0, 0, 1, 1, 0, 0, 0, 0)
self.gameTest(
gameRows[19], 'Hanse - Die Expedition',
'Hanse makes you a trader in the 13th Century.', None, None, 2, 13,
14, None, 10, '????', '', '',
'http://www.mobygames.com/game/amiga/hanse-die-expedition', '', '',
'', '', 0, 0, 3, 1, 1, 0, 0, 0)
self.gameTest(gameRows[20], 'Madden NFL \'98',
'Madden NFL 98 is a football video game.', None, None, 3,
8, 8, None, 8, '', '', '', '', 'USA', 'Cartridge', '',
'Gamepad', 0, 0, 1, 1, 1, 1, 1, 0)
self.gameTest(
gameRows[21], 'NBA Live 98',
'NBA Live 98 offers the player all teams, players and stadiums of the 1998 NBA season.',
None, None, 9, 21, 23, None, 8, '', '', '', '', '', '', '', '', 0,
0, 1, 1, 0, 0, 1, 0)
self.gameTest(gameRows[24], 'NHL 97',
"1997 edition of EA's NHL sport simulation series.",
None, None, 8, 22, 24, None, 7, '', '', '', '', '', '',
'', '', 0, 0, 1, 1, 0, 0, 1, 0)
self.gameTest(
gameRows[28], 'Plok',
"At one day, Plok awakes to find out that his flag has been stolen.",
None, None, 8, 23, 26, None, 3, '', '', '', '', '', '', '', '', 0,
0, 1, 1, 0, 0, 1, 0)
self.gameTest(gameRows[29], 'Ports Of Call [Test]',
'Ports of Call gives you the job of a shipowner.', None,
None, 1, 4, 4, None, 4, '4', '', '',
'http://www.mobygames.com/game/amiga/ports-of-call',
'USA', 'Disk', '', 'Joystick', 0, 0, 1, 1, 1, 0, 0, 0)
self.gameTest(
gameRows[30], 'Prince of Persia',
"While the Sultan of Persia is fighting a war in a foreign country, his Grand Vizier Jaffar orchestrates a coup",
None, None, 9, 24, 27, None, 5, '', '', '', '', '', '', '', '', 0,
0, 1, 1, 0, 0, 1, 0)
#TODO: developerId must be 27 (instead of 33)! Wrong interpretation of xml encoding!
self.gameTest(
gameRows[31], 'Prince of Persia',
"The Grand Vizier Jaffar has thrown you into a dark dungeon and plans to marry the girl of your dreams in an hour.",
None, None, 8, 24, 33, None, 5, '', '', '', '', '', '', '', '', 0,
0, 1, 1, 0, 0, 1, 0)
self.gameTest(
gameRows[38], 'Space Invaders',
'Taito and Nintendo have brought back the classic Space Invaders game, with very little modification.',
None, None, 3, 9, 9, None, 7, '', '', '', '', 'USA', 'Cartridge',
'', 'Gamepad', 0, 0, 1, 1, 1, 1, 1, 0)
self.gameTest(
gameRows[39], 'Space Invaders',
'Taito and Nintendo have brought back the classic Space Invaders game, with very little modification.',
None, None, 4, 9, 9, None, 7, '', '', '', '', 'USA', 'Cartridge',
'', 'Gamepad', 0, 0, 1, 1, 1, 1, 1, 0)
self.gameTest(
gameRows[40], 'Street Fighter II - The World Warrior',
'Eight fighters from across the globe have come together to see which of them has the strength, skill and courage to challenge the mysterious Grand Masters.',
None, None, 3, 10, 10, None, 5, '1 or 2 VS', '', '', '', 'USA',
'Cartridge', '', 'Gamepad', 0, 0, 1, 1, 1, 1, 1, 0)
self.gameTest(
gameRows[43], 'Super Mario Kart',
'Hi everybody! Thanks for dropping to by the Super Mario Kart race track.',
None, None, 3, 9, 11, None, 5, '1 to 4 VS', '', '', '', 'USA',
'Cartridge', '', 'Gamepad', 0, 0, 1, 1, 1, 1, 1, 0)
self.gameTest(gameRows[46], 'The Legend of Zelda: A Link to the Past',
'This installment in the Zelda series was my favorite.',
None, None, 4, 9, 11, None, 5, '1', '', '', '', 'USA',
'Cartridge', '', 'Gamepad', 0, 0, 1, 1, 1, 1, 1, 1)
#test additional file types
self.fileTypeTest(7, 1, gameRows[2][7])
self.fileTypeTest(8, 1, gameRows[2][6])
self.fileTypeTest(7, 1, gameRows[19][7])
self.fileTypeTest(8, 1, gameRows[19][6])
Logutil.currentLogLevel = util.LOG_LEVEL_INFO
#Init database
databasedir = os.path.join( os.getcwd())
gdb = GameDataBase(databasedir)
gdb.connect()
gdb.dropTables()
gdb.createTables()
util.ISTESTRUN = True
configFile = config.Config(None)
statusOk, errorMsg = configFile.readXml()
newRCs = {}
newRCs[1] = configFile.romCollections['3']
"""
from guppy import hpy
h = hpy()
h.setref()
"""
if(statusOk == True):
dbupdate.DBUpdate().updateDB(gdb, RCBMock(), 0, newRCs, util.getSettings(), False)
#print h.heap()