evalbench/databases/sqlserver.py [245:276]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
                )

        try:
            self.batch_execute(insertion_statements)
        except RuntimeError as error:
            raise RuntimeError(f"Could not insert data into database: {error}")

    #####################################################
    #####################################################
    # Database User Management
    #####################################################
    #####################################################

    def create_tmp_users(self, dql_user: str, dml_user: str, tmp_password: str):
        try:
            self.batch_execute(
                CREATE_USERS_QUERY.format(
                    DQL_USERNAME=dql_user,
                    DML_USERNAME=dml_user,
                    PASSWORD=tmp_password,
                    DATABASE=self.db_name,
                ).split(";")
            )
        except RuntimeError as error:
            raise RuntimeError(f"Could not setup users. {error}")

    def delete_tmp_user(self, username: str):
        if username in self.tmp_users:
            self.tmp_users.remove(username)
        _, _, error = self.execute(DELETE_USER_QUERY.format(USERNAME=username))
        if error:
            logging.info(f"Could not delete tmp user due to {error}")
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -