Python control.makeFile函数代码示例

def inserttvdbseries(meta):

    try:

        control.makeFile(control.dataPath);
        dbcon = database.connect(control.synchFile);
        dbcur = dbcon.cursor();

        dbcur.execute("CREATE TABLE IF NOT EXISTS tvdb_series_info (""show_id TEXT, ""tvdbid TEXT, ""imdbid TEXT, ""seriesid TEXT, ""traktid TEXT, ""lastUpdated TEXT, ""seriesName TEXT, ""status TEXT, ""firstAired TEXT, ""firstEpisode TEXT, ""genre TEXT, ""network TEXT, ""siteRating TEXT, ""siteRatingCount TEXT, ""images TEXT, ""UNIQUE(show_id, tvdbid)"");")

        try:

            try: 
                dbcur.execute("DELETE FROM tvdb_series_info WHERE (show_id = '%s' and tvdbid = '%s')" % (meta['show_id'], meta['tvdbid']));

            except Exception as inst:
                #logger.error(inst);

                pass;

            dbcur.execute("INSERT INTO tvdb_series_info Values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", (meta['show_id'], meta['tvdbid'], meta['imdbid'], meta['seriesid'], meta['traktid'], meta['lastUpdated'], meta['seriesName'], meta['status'], meta['firstAired'], meta['firstEpisode'], meta['genre'], meta['network'], meta['siteRating'], meta['siteRatingCount'], meta['images']));

            #dbcur.execute("INSERT INTO tvdb_series_info Values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", meta.values()); #We like this idea but the values seem to have random placement due to restrictions on the dictionary

        except Exception as inst:
            #logger.error(inst);

            pass;

        dbcon.commit();

    except:
        return;

    def add_progress_movies(self, meta):
		try:
			
			item = dict()
			typeofcontent = 'movies'
			print ("META DUMP FAVOURITES 3" , meta, typeofcontent)

			try: id = meta['imdb']
			except: id = meta['tvdb']
			
			if 'title' in meta: title = item['title'] = meta['title']
			if 'tvshowtitle' in meta: title = item['title'] = meta['tvshowtitle']
			if 'year' in meta: item['year'] = meta['year']
			if 'poster' in meta: item['poster'] = meta['poster']
			if 'fanart' in meta: item['fanart'] = meta['fanart']
			if 'imdb' in meta: item['imdb'] = meta['imdb']
			if 'tmdb' in meta: item['tmdb'] = meta['tmdb']
			if 'tvdb' in meta: item['tvdb'] = meta['tvdb']
			if 'tvrage' in meta: item['tvrage'] = meta['tvrage']
			
			

			control.makeFile(dataPath)
			dbcon = database.connect(progressFile)
			dbcur = dbcon.cursor()
			dbcur.execute("CREATE TABLE IF NOT EXISTS %s (""id TEXT, ""items TEXT, ""UNIQUE(id)"");" % typeofcontent)
			dbcur.execute("DELETE FROM %s WHERE id = '%s'" % (typeofcontent, id))
			dbcur.execute("INSERT INTO %s Values (?, ?)" % typeofcontent, (id, repr(item)))
			dbcon.commit()

			# control.refresh()
			# control.infoDialog('Added to Watchlist', heading=title)
		except:
			return

def fetchtraktprogresslastupdated():

    try:

        control.makeFile(control.dataPath);
        dbcon = database.connect(control.synchFile);
        dbcur = dbcon.cursor();

        dbcur.execute("CREATE TABLE IF NOT EXISTS trakt_progress_info (""trakt_series_id TEXT, ""trakt_episode_id TEXT, ""tvdbid TEXT, ""tvdbeid TEXT, ""season TEXT, ""episode TEXT, ""trakt_progress TEXT, ""lastupdated TEXT, ""UNIQUE(trakt_series_id, trakt_episode_id, tvdbid, tvdbeid)"");");

    except:
        return None;

    try:

        sql_stmt = """
            SELECT lastupdated
            FROM trakt_progress_info
        """;

        dbcur.execute(sql_stmt);

        match = dbcur.fetchall();
        
        if match is not None:
            return match[0][0];

        else:
            return None;


    except Exception as inst:
        #logger.error(inst);

        return None;

    def add_progress_episodes(self, meta):
		try:

			item = dict()
			typeofcontent = 'episode'

			id = meta['tvdb']
			
			if 'title' in meta: title = item['title'] = meta['title']
			if 'tvshowtitle' in meta: item['tvshowtitle'] = meta['tvshowtitle']
			if 'year' in meta: item['year'] = meta['year']
			if 'poster' in meta: item['poster'] = meta['poster']
			if 'fanart' in meta: item['fanart'] = meta['fanart']
			if 'imdb' in meta: item['imdb'] = meta['imdb']
			if 'tmdb' in meta: item['tmdb'] = meta['tmdb']
			if 'tvdb' in meta: item['tvdb'] = meta['tvdb']
			if 'tvrage' in meta: item['tvrage'] = meta['tvrage']
			if 'episode' in meta: item['episode'] = meta['episode']
			if 'season' in meta: item['season'] = meta['season']
			if 'premiered' in meta: item['premiered'] = meta['premiered']
			if 'original_year' in meta: item['original_year'] = meta['original_year']


			control.makeFile(dataPath)
			dbcon = database.connect(progressFile)
			dbcur = dbcon.cursor()
			dbcur.execute("CREATE TABLE IF NOT EXISTS %s (""id TEXT, ""items TEXT, ""UNIQUE(id)"");" % typeofcontent)
			dbcur.execute("DELETE FROM %s WHERE id = '%s'" % (typeofcontent, id))
			dbcur.execute("INSERT INTO %s Values (?, ?)" % typeofcontent, (id, repr(item)))
			dbcon.commit()

		except:
			return

def timeout(function, *args, **table):
    try:
        response = None

        f = repr(function)
        f = re.sub('.+\smethod\s|.+function\s|\sat\s.+|\sof\s.+', '', f)

        a = hashlib.md5()
        for i in args: a.update(str(i))
        a = str(a.hexdigest())
    except:
        pass

    try:
        table = table['table']
    except:
        table = 'rel_list'

    try:
        control.makeFile(control.dataPath)
        dbcon = database.connect(control.cacheFile)
        dbcur = dbcon.cursor()
        dbcur.execute("SELECT * FROM %s WHERE func = '%s' AND args = '%s'" % (table, f, a))
        match = dbcur.fetchone()
        return int(match[3])
    except:
        return

def get_favorites(fav_type, url):
    try:
        import resources.lib.indexers.bob
        indexer = resources.lib.indexers.bob.Indexer()
        control.makeFile(control.dataPath)
        dbcon = database.connect(control.cacheFile)
        dbcur = dbcon.cursor()
        dbcur.execute("SELECT * FROM %s WHERE fav_type = '%s'" % (table, fav_type))
        import xbmc
        for match in dbcur:
            name = match[0].encode("utf-8")
            link = match[2].encode("utf-8")
            poster = match[3]
            fanart = match[4]
            if match[2].endswith('.xml'):
                item = {'name': name, 'url': urllib.quote(link).replace("http%3A", "http:"), 'action': 'directory', 'folder': True,
                        'content': '%s-favs' % fav_type, 'poster': poster, 'fanart': fanart}
            else:
                year = indexer.bob_get_tag_content(link, "year", "")
                imdb = indexer.bob_get_tag_content(link, "imdb", "")
                title = indexer.bob_get_tag_content(link, "title", "")
                item = {'name': name, 'vip': "", 'url': link, 'action': "play", 'folder': False, 'poster': poster,
                        'banner': '0', 'fanart': fanart, 'content': '%s-favs' % fav_type, 'imdb': imdb, 'tvdb': '0',
                        'tmdb': '0', 'title': title, 'originaltitle': title, 'tvshowtitle': '', 'year': year,
                        'premiered': '', 'season': '', 'episode': ''}
            indexer.list.append(item)
        if indexer.list == []:
            item = {'name': '..', 'url': 'plugin://plugin.video.bob', 'action': 'plugin', 'folder': False,
                        'content': '', 'poster': '0', 'fanart': '0'}
            indexer.list.append(item)
        indexer.worker()
        indexer.add_directory(indexer.list, parent_url=url)

    except:
        pass

def inserttraktwatchedcheck(showid, rdate):

    try:

        control.makeFile(control.dataPath);
        dbcon = database.connect(control.synchFile);
        dbcur = dbcon.cursor();

        dbcur.execute("CREATE TABLE IF NOT EXISTS trakt_watched_check (""show_id TEXT, ""lastupdated TEXT, ""UNIQUE(show_id)"");")

        try:

            try: 
                dbcur.execute("DELETE FROM trakt_watched_check WHERE show_id = %s" % showid);

            except Exception as inst:
                #logger.error(inst);

                pass;

            dbcur.execute("INSERT INTO trakt_watched_check Values (?, ?)", (showid, rdate));

        except Exception as inst:
            #logger.error(inst);

            pass;

        dbcon.commit();

    except:
        return;

def get_favorites_menu(url):
    import resources.lib.indexers.bob
    indexer = resources.lib.indexers.bob.Indexer()
    try:
        control.makeFile(control.dataPath)
        dbcon = database.connect(control.cacheFile)
        dbcur = dbcon.cursor()
        dbcur.execute("SELECT DISTINCT(fav_type) from %s" % table)
        for row in dbcur:
            fav_type = row[0]
            if fav_type == "movie":
                poster = "http://norestrictions.club/norestrictions.club/main/icons/my_movies.jpg"
            elif fav_type == "tv show":
                poster = "http://norestrictions.club/norestrictions.club/main/icons/my_tv_shows.jpg"
            else:
                poster = "http://norestrictions.club/norestrictions.club/main/icons/my_blank.jpg"
            indexer.list.append({'name': fav_type.title(), 'url': url, 'action': 'getfavorites_%s' % fav_type, 'folder': True,
                                 'poster': poster})
        if indexer.list == []:
            import xbmcgui
            xbmcgui.Dialog().ok("Bob's Faves", "Add Your Bob Faves Here")
        indexer.worker()
        indexer.add_directory(indexer.list, parent_url=url)
    except:
        pass

    def strmFile(self, i):
        try:
            name, title, year, imdb, tmdb = i["title"], i["title"], i["year"], i["imdb"]

            sysname, systitle = urllib.quote_plus(name), urllib.quote_plus(title)

            transname = name.translate(None, '\/:*?"<>|').strip(".")

            content = "%s?action=play&name=%s&title=%s&year=%s&imdb=%s" % (sys.argv[0], sysname, systitle, year, imdb)

            control.makeFile(self.library_folder)
            folder = os.path.join(self.library_folder, transname)
            control.makeFile(folder)

            try:
                if not "ftp://" in folder:
                    raise Exception()
                from ftplib import FTP

                ftparg = re.compile("ftp://(.+?):(.+?)@(.+?):?(\d+)?/(.+/?)").findall(folder)
                ftp = FTP(ftparg[0][2], ftparg[0][0], ftparg[0][1])
                try:
                    ftp.cwd(ftparg[0][4])
                except:
                    ftp.mkd(ftparg[0][4])
                ftp.quit()
            except:
                pass

            stream = os.path.join(folder, transname + ".strm")
            file = control.openFile(stream, "w")
            file.write(str(content))
            file.close()
        except:
            pass

def addView(content):
    try:
        skin = control.skin
        skinPath = control.skinPath
        xml = os.path.join(skinPath,'addon.xml')
        file = control.openFile(xml)
        read = file.read().replace('\n','')
        file.close()
        try: src = re.compile('defaultresolution="(.+?)"').findall(read)[0]
        except: src = re.compile('<res.+?folder="(.+?)"').findall(read)[0]
        src = os.path.join(skinPath, src)
        src = os.path.join(src, 'MyVideoNav.xml')
        file = control.openFile(src)
        read = file.read().replace('\n','')
        file.close()
        views = re.compile('<views>(.+?)</views>').findall(read)[0]
        views = [int(x) for x in views.split(',')]
        for view in views:
            label = control.infoLabel('Control.GetLabel(%s)' % (view))
            if not (label == '' or label == None): break
        record = (skin, content, str(view))
        control.makeFile(control.dataPath)
        dbcon = database.connect(control.viewsFile)
        dbcur = dbcon.cursor()
        dbcur.execute("CREATE TABLE IF NOT EXISTS views (""skin TEXT, ""view_type TEXT, ""view_id TEXT, ""UNIQUE(skin, view_type)"");")
        dbcur.execute("DELETE FROM views WHERE skin = '%s' AND view_type = '%s'" % (record[0], record[1]))
        dbcur.execute("INSERT INTO views Values (?, ?, ?)", record)
        dbcon.commit()
        viewName = control.infoLabel('Container.Viewmode')

        control.infoDialog(control.lang(30491).encode('utf-8'), heading=viewName)
    except:
        return

def addFavourite(meta, content, query):
    try:
        item = dict()
        meta = json.loads(meta)
        try: id = meta['imdb']
        except: id = meta['tvdb']

        if 'title' in meta: title = item['title'] = meta['title']
        if 'tvshowtitle' in meta: title = item['title'] = meta['tvshowtitle']
        if 'year' in meta: item['year'] = meta['year']
        if 'poster' in meta: item['poster'] = meta['poster']
        if 'fanart' in meta: item['fanart'] = meta['fanart']
        if 'imdb' in meta: item['imdb'] = meta['imdb']
        if 'tmdb' in meta: item['tmdb'] = meta['tmdb']
        if 'tvdb' in meta: item['tvdb'] = meta['tvdb']
        if 'tvrage' in meta: item['tvrage'] = meta['tvrage']

        control.makeFile(control.dataPath)
        dbcon = database.connect(control.favouritesFile)
        dbcur = dbcon.cursor()
        dbcur.execute("CREATE TABLE IF NOT EXISTS %s (""id TEXT, ""items TEXT, ""UNIQUE(id)"");" % content)
        dbcur.execute("DELETE FROM %s WHERE id = '%s'" % (content, id))
        dbcur.execute("INSERT INTO %s Values (?, ?)" % content, (id, repr(item)))
        dbcon.commit()

        if query == None: control.refresh()
        control.infoDialog(control.lang(30411).encode('utf-8'), heading=title)
    except:
        return

def insert(meta):
    try:
        control.makeFile(control.dataPath)
        dbcon = database.connect(control.metacacheFile)
        dbcur = dbcon.cursor()
        dbcur.execute(
            "CREATE TABLE IF NOT EXISTS meta (""imdb TEXT, ""tmdb TEXT, ""tvdb TEXT, ""lang TEXT, ""item TEXT, ""time TEXT, ""UNIQUE(imdb, tmdb, tvdb, lang)"");")
        t = int(time.time())
        for m in meta:
            try:
                i = repr(m['item'])
                try:
                    dbcur.execute(
                        "DELETE FROM meta WHERE (imdb = '%s' and lang = '%s' and not imdb = '0') or (tmdb = '%s' and lang = '%s' and not tmdb = '0') or (tvdb = '%s' and lang = '%s' and not tvdb = '0')" % (
                            m['imdb'], m['lang'], m['tmdb'], m['lang'], m['tvdb'], m['lang']))
                except:
                    pass
                dbcur.execute("INSERT INTO meta Values (?, ?, ?, ?, ?, ?)",
                              (m['imdb'], m['tmdb'], m['tvdb'], m['lang'], i, t))
            except:
                pass

        dbcon.commit()
    except:
        return

def addFavourite(meta, content):
    try:
        item = dict()
        meta = json.loads(meta)
        # print "META DUMP FAVOURITES %s" % meta
        try: id = meta['imdb']
        except: id = meta['tvdb']
        
        if 'title' in meta: title = item['title'] = meta['title']
        if 'tvshowtitle' in meta: title = item['title'] = meta['tvshowtitle']
        if 'year' in meta: item['year'] = meta['year']
        if 'poster' in meta: item['poster'] = meta['poster']
        if 'fanart' in meta: item['fanart'] = meta['fanart']
        if 'imdb' in meta: item['imdb'] = meta['imdb']
        if 'tmdb' in meta: item['tmdb'] = meta['tmdb']
        if 'tvdb' in meta: item['tvdb'] = meta['tvdb']
        if 'tvrage' in meta: item['tvrage'] = meta['tvrage']

        control.makeFile(dataPath)
        dbcon = database.connect(favouritesFile)
        dbcur = dbcon.cursor()
        dbcur.execute("CREATE TABLE IF NOT EXISTS %s (""id TEXT, ""items TEXT, ""UNIQUE(id)"");" % content)
        dbcur.execute("DELETE FROM %s WHERE id = '%s'" % (content, id))
        dbcur.execute("INSERT INTO %s Values (?, ?)" % content, (id, repr(item)))
        dbcon.commit()

        control.refresh()
        control.infoDialog('Added to Watchlist', heading=title)
    except:
        return

def updatefnqueue(meta, queuestate=0):

    try:

        control.makeFile(control.dataPath);
        dbcon = database.connect(control.synchFile);
        dbcur = dbcon.cursor();

        dbcur.execute("CREATE TABLE IF NOT EXISTS fn_queue_info (""asset_id TEXT, ""inqueue TEXT, ""UNIQUE(asset_id)"");");

        for m in meta:

            try:

                dbcur.execute("INSERT OR IGNORE INTO fn_queue_info (asset_id, inqueue) VALUES ('%s', %s)" % (m['asset_id'], queuestate));
                dbcur.execute("UPDATE fn_queue_info SET inqueue = %s WHERE asset_id = %s" % (queuestate, m['asset_id']));

            except Exception as inst:
                #logger.error(inst);

                pass;

        dbcon.commit();

    except Exception as inst:
        #logger.error(inst);

        return None;

 def __init__(self):
     try:
         control.makeFile(control.dataPath)
         self.dbcon = database.connect(control.favoriteFile)
         self.dbcur = self.dbcon.cursor()
         self.dbcur.execute("CREATE TABLE IF NOT EXISTS favorites (""anime_id INTEGER, UNIQUE(anime_id) "");")
     except:
         pass