Method updateCategoryTable

persepolis/scripts/data_base.py:972–1015

(self, list_)

    # this method updates category_db_table
    def updateCategoryTable(self, list_):
        # lock data base
        self.lockCursor()

        keys_list = ['category',
                     'start_time_enable',
                     'start_time',
                     'end_time_enable',
                     'end_time',
                     'reverse',
                     'limit_enable',
                     'limit_value',
                     'after_download',
                     'gid_list']

        for dict_ in list_:

            # format of gid_list is list and must be converted to string for sqlite3
            if 'gid_list' in dict_.keys():
                dict_['gid_list'] = str(dict_['gid_list'])

            for key in keys_list:
                # if a key is missed in dict_,
                # then add this key to the dict_ and assign None value for the key.
                if key not in dict_.keys():
                    dict_[key] = None

            # update data base if value for the keys is not None
            self.persepolis_db_cursor.execute("""UPDATE category_db_table SET   start_time_enable = coalesce(:start_time_enable, start_time_enable),
                                                                                    start_time = coalesce(:start_time, start_time),
                                                                                    end_time_enable = coalesce(:end_time_enable, end_time_enable),
                                                                                    end_time = coalesce(:end_time, end_time),
                                                                                    reverse = coalesce(:reverse, reverse),
                                                                                    limit_enable = coalesce(:limit_enable, limit_enable),
                                                                                    limit_value = coalesce(:limit_value, limit_value),
                                                                                    after_download = coalesce(:after_download, after_download),
                                                                                    gid_list = coalesce(:gid_list, gid_list)
                                                                                    WHERE category = :category""", dict_)

        # commit changes
        self.persepolis_db_connection.commit()

        # job is done! open the lock
        self.lock = False

    # this method updates addlink_db_table
    def updateAddLinkTable(self, list_):