Skip to content
Snippets Groups Projects
Select Git revision
  • 5a59dc3afaca48b8158d77b22f9c49debd2ba03d
  • main default protected
  • dev protected
  • f-linkahead-rename
  • f-real-id
  • f-filesystem-import
  • f-filesystem-link
  • f-filesystem-directory
  • f-filesystem-core
  • f-filesystem-cleanup
  • f-filesystem-main
  • f-name
  • keep_changes
  • f-permission-checks-2
  • f-mysql8-tests
  • f-retrieve-history
  • t-distinct-parents
  • v8.1.0
  • v8.0.0
  • v7.0.2
  • v7.0.1
  • v7.0.0
  • v6.0.1
  • v6.0.0
  • v5.0.0
  • v4.1.0
  • v4.0.0
  • v3.0
  • v2.0.30
29 results

initSubEntity.sql

Blame
  • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    finishSubProperty.sql 1.49 KiB
    /*
     * ** header v3.0
     * This file is a part of the CaosDB Project.
     *
     * Copyright (C) 2018 Research Group Biomedical Physics,
     * Max-Planck-Institute for Dynamics and Self-Organization Göttingen
     *
     * This program is free software: you can redistribute it and/or modify
     * it under the terms of the GNU Affero General Public License as
     * published by the Free Software Foundation, either version 3 of the
     * License, or (at your option) any later version.
     *
     * This program is distributed in the hope that it will be useful,
     * but WITHOUT ANY WARRANTY; without even the implied warranty of
     * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
     * GNU Affero General Public License for more details.
     *
     * You should have received a copy of the GNU Affero General Public License
     * along with this program. If not, see <https://www.gnu.org/licenses/>.
     *
     * ** end header
     */
    
    DROP PROCEDURE IF EXISTS db_2_0.finishSubProperty;
    DELIMITER //
    
    CREATE PROCEDURE db_2_0.finishSubProperty(in sourceSet VARCHAR(255),in targetSet VARCHAR(255),
                                              in list VARCHAR(255), in versioned BOOLEAN)
    BEGIN
        DECLARE data VARCHAR(20000) DEFAULT CONCAT('`',list,'`');
        SET @finishSubPropertyStmtStr = makeStmt(sourceSet, targetSet, data, NULL, versioned);
    
        PREPARE finishSubPropertyStmt FROM @finishSubPropertyStmtStr;
        EXECUTE finishSubPropertyStmt;
        DEALLOCATE PREPARE finishSubPropertyStmt;
    
        SELECT @finishSubPropertyStmtStr AS finishSubPropertyStmt;
    
    END;
    //
    DELIMITER ;