Coverage Report

Coverage Report - org.codehaus.mojo.sql.SqlSplitter

Classes in this File

0/36

0/40

 package org.codehaus.mojo.sql;
 
 /*
  * Licensed to the Apache Software Foundation (ASF) under one
  * or more contributor license agreements.  See the NOTICE file
  * distributed with this work for additional information
  * regarding copyright ownership.  The ASF licenses this file
  * to you under the Apache License, Version 2.0 (the
  * "License"); you may not use this file except in compliance
  * with the License.  You may obtain a copy of the License at
  *
  * http://www.apache.org/licenses/LICENSE-2.0
  *
  * Unless required by applicable law or agreed to in writing,
  * software distributed under the License is distributed on an
  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  * KIND, either express or implied.  See the License for the
  * specific language governing permissions and limitations
  * under the License.
  */
 
 import org.codehaus.plexus.util.StringUtils;
 
 /**
  * Utility class to split a long sql batch script into single SQL commands.
  */
 public class SqlSplitter {
     /**
      * Value indicating the sql has no end-delimiter like i.e. semicolon
      */
     public static final int NO_END = -1;
 
     /**
      * Check if the given sql line contains an end of command ';' Please note that we do <em>not</em> fully parse the
      * SQL, so if we get a malformed statement, we cannot detect it.
      *
      * @param line
      *            to parse
      * @param delimiter
      *            which should be used to split SQL commands
      * @return position after the end character if the given line contains the end of a SQL script,
      *         {@value SqlSplitter#NO_END} if it doesn't contain an end char.
      */
     public static int containsSqlEnd(String line, String delimiter) {
         // / * * / comments
         boolean isComment = false;
 
         boolean isAlphaDelimiter = StringUtils.isAlpha(delimiter);
 
         if (line == null || line.length() == 0) {
             return NO_END;
         }
 
         int pos = 0;
 
         do {
             if (isComment) {
                 if (line.startsWith("*/", pos)) {
                     isComment = false;
                 } else {
                     pos++;
                     continue;
                 }
             }
 
             if (line.startsWith("/*", pos)) {
                 isComment = true;
                 pos += 2;
                 continue;
             }
 
             if (line.startsWith("--", pos)) {
                 return NO_END;
             }
 
             if (line.startsWith("'", pos) || line.startsWith("\"", pos)) {
                 String quoteChar = "" + line.charAt(pos);
                 String quoteEscape = "\\" + quoteChar;
                 pos++;
 
                 if (line.length() <= pos) {
                     return NO_END;
                 }
 
                 do {
                     if (line.startsWith(quoteEscape, pos)) {
                         pos += 2;
                     }
                 } while (!line.startsWith(quoteChar, pos++));
 
                 continue;
             }
 
             if (line.startsWith(delimiter, pos)) {
                 if (isAlphaDelimiter) {
                     // check if delimiter is at start or end of line, surrounded
                     // by non-alpha character
                     if ((pos == 0 || !isAlpha(line.charAt(pos - 1)))
                             && (line.length() == pos + delimiter.length() || !isAlpha(line.charAt(pos
                                     + delimiter.length())))) {
                         return pos + delimiter.length();
                     }
                 } else {
                     return pos + delimiter.length();
                 }
             }
 
             pos++;
 
         } while (line.length() >= pos);
 
         return NO_END;
     }
 
     /**
      * @param c
      *            the char to check
      * @return <code>true</code> if the given character is either a lower or an upperchase alphanumerical character
      */
     private static boolean isAlpha(char c) {
         return Character.isUpperCase(c) || Character.isLowerCase(c);
     }
 
 }

1		package org.codehaus.mojo.sql;
2
3		/*
4		* Licensed to the Apache Software Foundation (ASF) under one
5		* or more contributor license agreements. See the NOTICE file
6		* distributed with this work for additional information
7		* regarding copyright ownership. The ASF licenses this file
8		* to you under the Apache License, Version 2.0 (the
9		* "License"); you may not use this file except in compliance
10		* with the License. You may obtain a copy of the License at
11		*
12		* http://www.apache.org/licenses/LICENSE-2.0
13		*
14		* Unless required by applicable law or agreed to in writing,
15		* software distributed under the License is distributed on an
16		* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
17		* KIND, either express or implied. See the License for the
18		* specific language governing permissions and limitations
19		* under the License.
20		*/
21
22		import org.codehaus.plexus.util.StringUtils;
23
24		/**
25		* Utility class to split a long sql batch script into single SQL commands.
26		*/
27	0	public class SqlSplitter {
28		/**
29		* Value indicating the sql has no end-delimiter like i.e. semicolon
30		*/
31		public static final int NO_END = -1;
32
33		/**
34		* Check if the given sql line contains an end of command ';' Please note that we do <em>not</em> fully parse the
35		* SQL, so if we get a malformed statement, we cannot detect it.
36		*
37		* @param line
38		* to parse
39		* @param delimiter
40		* which should be used to split SQL commands
41		* @return position after the end character if the given line contains the end of a SQL script,
42		* {@value SqlSplitter#NO_END} if it doesn't contain an end char.
43		*/
44		public static int containsSqlEnd(String line, String delimiter) {
45		// / * * / comments
46	0	boolean isComment = false;
47
48	0	boolean isAlphaDelimiter = StringUtils.isAlpha(delimiter);
49
50	0	if (line == null \|\| line.length() == 0) {
51	0	return NO_END;
52		}
53
54	0	int pos = 0;
55
56		do {
57	0	if (isComment) {
58	0	if (line.startsWith("*/", pos)) {
59	0	isComment = false;
60		} else {
61	0	pos++;
62	0	continue;
63		}
64		}
65
66	0	if (line.startsWith("/*", pos)) {
67	0	isComment = true;
68	0	pos += 2;
69	0	continue;
70		}
71
72	0	if (line.startsWith("--", pos)) {
73	0	return NO_END;
74		}
75
76	0	if (line.startsWith("'", pos) \|\| line.startsWith("\"", pos)) {
77	0	String quoteChar = "" + line.charAt(pos);
78	0	String quoteEscape = "\\" + quoteChar;
79	0	pos++;
80
81	0	if (line.length() <= pos) {
82	0	return NO_END;
83		}
84
85		do {
86	0	if (line.startsWith(quoteEscape, pos)) {
87	0	pos += 2;
88		}
89	0	} while (!line.startsWith(quoteChar, pos++));
90
91	0	continue;
92		}
93
94	0	if (line.startsWith(delimiter, pos)) {
95	0	if (isAlphaDelimiter) {
96		// check if delimiter is at start or end of line, surrounded
97		// by non-alpha character
98	0	if ((pos == 0 \|\| !isAlpha(line.charAt(pos - 1)))
99		&& (line.length() == pos + delimiter.length() \|\| !isAlpha(line.charAt(pos
100		+ delimiter.length())))) {
101	0	return pos + delimiter.length();
102		}
103		} else {
104	0	return pos + delimiter.length();
105		}
106		}
107
108	0	pos++;
109
110	0	} while (line.length() >= pos);
111
112	0	return NO_END;
113		}
114
115		/**
116		* @param c
117		* the char to check
118		* @return <code>true</code> if the given character is either a lower or an upperchase alphanumerical character
119		*/
120		private static boolean isAlpha(char c) {
121	0	return Character.isUpperCase(c) \|\| Character.isLowerCase(c);
122		}
123
124		}