adding the start of base sql and marc functions for koha to mig-init

[migration-tools.git] / sql / koha / general_functions.sql

diff --git a/sql/koha/general_functions.sql b/sql/koha/general_functions.sql
deleted file mode 100644 (file)
index 8dd0817..0000000
--- a/sql/koha/general_functions.sql
+++ /dev/null
@@ -1,45 +0,0 @@
-DROP FUNCTION IF EXISTS m_split_string;
-DELIMITER $
-CREATE FUNCTION 
-   m_split_string (s TEXT, del VARCHAR(10), i INT)
-   RETURNS TEXT
-   DETERMINISTIC
-    BEGIN
-        DECLARE n INT ;
-        SET n = LENGTH(s) - LENGTH(REPLACE(s, del, '')) + 1;
-        IF i > n THEN
-            RETURN NULL ;
-        ELSE
-            RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(s, del, i) , del , -1 ) ;        
-        END IF;
-    END
-$
-DELIMITER ;
-
-DROP FUNCTION IF EXISTS m_string_segment_count;
-DELIMITER $
-CREATE FUNCTION 
-   m_string_segment_count(s TEXT, del VARCHAR(10))
-   RETURNS TEXT
-   DETERMINISTIC
-    BEGIN
-        DECLARE n INT ;
-        SET n = LENGTH(s) - LENGTH(REPLACE(s, del, '')) + 1;
-        RETURN n;
-    END
-$
-DELIMITER ;
-
-DROP FUNCTION IF EXISTS m_remove_bracketed_text;
-DELIMITER $
-CREATE FUNCTION 
-   m_remove_bracketed_text(str TEXT)
-   RETURNS TEXT
-   DETERMINISTIC
-    BEGIN
-    RETURN REPLACE(str, SUBSTRING(str, LOCATE('(', str), LENGTH(str) - LOCATE(')', REVERSE(str)) - LOCATE('(', str) + 2), '');
-    END
-$
-DELIMITER ;
-
-