"title": "title2", "artist": "artist2", "album": "album2", "year": "year2", "genre": "genre2", "track": "track2", "format": "format2" } entry2DB = {"filename": SimpleDBValue("/filename2")} config = AudioConfig() db = DBInterface(config, dbfile) db.clear() # Call addEntry for an entry db.addEntries((entry1, ), config.mainTable.getName()) # Call getentry, ensure entry matches entry1 res = db.getEntries(entry1DB, entry1.keys()) if (verifyEntry(res[0], entry1)): print "-------> Initial add okay." # Call updateoraddEntries for the given entry db.updateOrAddEntries(table=config.mainTable.getName(), match_tag=entry1DB, entries=(entry15, )) # Call getEntry, ensure entry is updated res = db.getEntries(entry1DB, entry1.keys()) if (verifyEntry(res[0], entry15_full)): print "-------> Update existing okay."
#!/bin/env python from Config import * from DBInterface import * config = Config("InfoTable", Config.Audio) db = DBInterface(":memory:", config) db.clear() db.printStats() ### from TagLoader import * l = TagLoaderFactory.GetLoader("zztop.flac") entry = l.getTags("zztop.flac") db.addEntries((entry, )) ### db.printStats() db.dumpDB() print db.getEntries({}) fname = {} fname["filename"] = "zztop.flac" print db.getEntries(fname) print db.getEntries(fname, ["album"]) fname["filename"] = "fump.mp3" print db.getEntries(fname)
"artist":"artist2", "album":"album2", "year":"year2", "genre":"genre2", "track":"track2", "format":"format2"} entry2DB = {"filename":SimpleDBValue("/filename2")} config = AudioConfig() db = DBInterface(config,dbfile) db.clear() # Call addEntry for an entry db.addEntries( (entry1,), config.mainTable.getName() ) # Call getentry, ensure entry matches entry1 res = db.getEntries( entry1DB,entry1.keys() ) if (verifyEntry (res[0], entry1 )): print "-------> Initial add okay." # Call updateoraddEntries for the given entry db.updateOrAddEntries(table=config.mainTable.getName(), match_tag=entry1DB, entries=(entry15,)) # Call getEntry, ensure entry is updated res = db.getEntries( entry1DB, entry1.keys() ) if (verifyEntry (res[0], entry15_full )): print "-------> Update existing okay."
from Config import * from DBInterface import * config = Config("InfoTable", Config.Audio ) db = DBInterface(":memory:", config) db.clear() db.printStats() ### from TagLoader import * l = TagLoaderFactory.GetLoader("zztop.flac") entry = l.getTags("zztop.flac") db.addEntries( (entry,) ) ### db.printStats() db.dumpDB() print db.getEntries( {} ) fname = {} fname["filename"] = "zztop.flac" print db.getEntries(fname) print db.getEntries(fname, ["album"]) fname["filename"] = "fump.mp3" print db.getEntries(fname)