Python DBSession.execute方法代码示例

# 需要导入模块: from mediacore.model import DBSession [as 别名]
# 或者: from mediacore.model.DBSession import execute [as 别名]
 def inject_in_db(cls, enable_player=False):
     from mediacore.model import DBSession
     from mediacore.model.players import players as players_table, PlayerPrefs
     
     prefs = PlayerPrefs()
     prefs.name = cls.name
     prefs.enabled = enable_player
     # didn't get direct SQL expression to work with SQLAlchemy
     # player_table = sql.func.max(player_table.c.priority)
     query = sql.select([sql.func.max(players_table.c.priority)])
     max_priority = DBSession.execute(query).first()[0]
     if max_priority is None:
         max_priority = -1
     prefs.priority = max_priority + 1
     prefs.created_on = datetime.now()
     prefs.modified_on = datetime.now()
     prefs.data = cls.default_data
     DBSession.add(prefs)
     DBSession.commit()

# 需要导入模块: from mediacore.model import DBSession [as 别名]
# 或者: from mediacore.model.DBSession import execute [as 别名]
 def map_migrate_version(self):
     migrate_version_query = migrate_table.select(
         migrate_table.c.repository_id == u'MediaCore Migrations'
     )
     result = DBSession.execute(migrate_version_query).fetchone()
     db_migrate_version = result.version
     if db_migrate_version in migrate_to_alembic_mapping:
         return migrate_to_alembic_mapping[db_migrate_version]
     
     earliest_upgradable_version = sorted(migrate_to_alembic_mapping)[0]
     if db_migrate_version < earliest_upgradable_version:
         error_msg = ('Upgrading from such an old version of MediaCore is not '
             'supported. Your database is at version %d but upgrades are only '
             'supported from MediaCore CE 0.9.0 (DB version %d). Please upgrade '
             '0.9.0 first.')
         self.log.error(error_msg % (db_migrate_version, earliest_upgradable_version))
     else:
         self.log.error('Unknown DB version %s. Can not upgrade to alembic' % db_migrate_version)
     raise AssertionError('unsupported DB migration version.')

# 需要导入模块: from mediacore.model import DBSession [as 别名]
# 或者: from mediacore.model.DBSession import execute [as 别名]
    def reposition_file(self, file, budge_infront=None):
        """Position the first file after the second or last file.

        If only one file is specified, we move it to the last position (the end).

        If two files are specified, the first takes the seconds position, and the
        positions of the second file and those that follow it are incremented.

        This increments MediaFile.position such that gaps in the sequence occur.

        When the primary_file is changed by this operation, we ensure that the
        Media.type matches the type of the new primary_file.

        Depending on the situation, we manipulate the DBSession, rather than our
        usual practice of simply modifying the object and leaving DBSession work
        to the controller. This is necessary because we run a query on the DB
        without using the ORM in some cases.

        :param file: The file to move
        :type file: :class:`MediaFile` or int
        :param budge_infront: The file to position after.
        :type budge_infront: :class:`MediaFile` or int or None
        """
        if not isinstance(file, MediaFile):
            file = [f for f in self.files if f.id == file][0]

        if budge_infront:
            # The first file is going to move in front of the second
            if not isinstance(budge_infront, MediaFile):
                budge_infront = [f for f in self.files if f.id == budge_infront][0]

            pos = budge_infront.position
            is_first = budge_infront is self.primary_file

            # Update the moved row, the budge_infront file, and those after it.
            # When we reach the moved row, the new position is simply set,
            # otherwise the position is incremented 1.
            update = media_files.update()\
                .where(sql.and_(
                    media_files.c.media_id == self.id,
                    sql.or_(
                        media_files.c.position >= pos,
                        media_files.c.id == file.id
                    )
                ))\
                .values({
                    media_files.c.position: sql.case(
                        [(media_files.c.id == file.id, pos)],
                        else_=media_files.c.position + 1
                    )
                })

            DBSession.execute(update)
            datamanager.mark_changed(DBSession())

        else:
            # No budging, so if there any other files we'll have to go after them...
            pos = 0
            is_first = True

            if self.files:
                pos += self.files[-1].position
                is_first = False

            file.position = pos
            DBSession.add(file)

        # Making an audio file primary over a video file changes the media type
        if is_first and file.medium is not None:
            self.type = file.medium

        return pos