def movieExists(title, path): dbMovieID = None try: con, cursor = openDB(MODBPATH, 'Movies') title = stringUtils.invCommas(title) cursor.execute( "SELECT id, title FROM movies WHERE title LIKE '{}';".format( title)) dbMovie = cursor.fetchone() if dbMovie is None: path = fileSys.completePath( path) if DATABASE_MYSQL == "false" else fileSys.completePath( path).replace('\\', '\\\\') path = stringUtils.invCommas(path) cursor.execute( "INSERT INTO movies (title, filePath) VALUES ('{}', '{}');". format(title, path)) con.commit() dbMovieID = cursor.lastrowid else: dbMovieID = dbMovie[0] finally: cursor.close() con.close() return dbMovieID
def showExists(title, path): dbShowID = None try: con, cursor = openDB(SHDBPATH, 'TVShows') title = stringUtils.invCommas(title) cursor.execute( "SELECT id, showTitle FROM shows WHERE showTitle LIKE '{}';". format(title)) dbShow = cursor.fetchone() if dbShow is None: path = fileSys.completePath( path) if DATABASE_MYSQL == "false" else fileSys.completePath( path).replace('\\', '\\\\') path = stringUtils.invCommas(path) cursor.execute( "INSERT INTO shows (showTitle, filePath) VALUES ('{}', '{}');". format(title, path)) con.commit() dbShowID = cursor.lastrowid else: dbShowID = dbShow[0] finally: cursor.close() con.close() return dbShowID
def musicDatabase(strAlbumName, strArtistName, strSongTitle, strPath, strURL, iTrack, iDuration, strArtPath, tFileModTime=None): strPath = fileSys.completePath(os.path.join(STRM_LOC, strPath)) # Write to music db and get id's iRoleID = writeRole("Artist") iPathID = writePath(strPath) iArtistID = writeArtist(strArtistName) iGenreID = writeGenre('osmosis') iAlbumID = writeAlbums(strAlbumName, strArtistName) iSongID = writeSong(iPathID, iAlbumID, strArtistName, strSongTitle, iDuration, iTrack, tFileModTime) iSongArtistID = writeSongArtist(iArtistID, iSongID, 1, strArtistName, 0) writeSongGenre(iGenreID, iSongID) writeAlbumArtist(iArtistID, iAlbumID, strArtistName) writeThump(iArtistID, "artist", "thumb", strArtPath) writeThump(iAlbumID, "album", "thumb", strArtPath) if DATABASE_MYSQL == "false": if not xbmcvfs.exists(MusicDB_LOC): createMusicDB() elif not valDB('Music'): createMusicDB() writeIntoSongTable(strSongTitle, iSongID, strArtistName, strAlbumName, iAlbumID, strPath, iPathID, strURL, iRoleID, iArtistID, iSongArtistID, "F")