Skip to content
Snippets Groups Projects
Select Git revision
  • 4bd267a8953154240ae22685fc940ad2b8fc18d7
  • main default protected
  • f-prefill
  • dev
  • f-docs-pylib
  • f-parse-value
  • f-compare
  • f-string-ids
  • f-217-set-special-property
  • f-filesystem-import
  • f-filesystem-link
  • f-filesystem-directory
  • f-filesystem-core
  • f-filesystem-cleanup
  • f-check-merge-entities
  • f-compare-enid
  • f-select-subproperties
  • v0.18.0
  • v0.17.0
  • v0.16.0
  • v0.15.1
  • v0.15.0
  • v0.14.0
  • v0.13.2
  • v0.13.1
  • v0.13.0
  • linkahead-rename-step-2
  • linkahead-rename-step-1
  • v0.12.0
  • v0.11.2
  • v0.11.1
  • v0.11.0
  • v0.10.0
  • v0.9.0
  • v0.8.0
  • v0.7.4
  • v0.7.3
37 results

test_state.py

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 ;