Coverage Summary for Class: SQL (net.sf.persism)

 package net.sf.persism;
 
 import java.util.Scanner;
 import java.util.regex.Pattern;
 
 /**
  * Simple wrapper for SQL String. Mainly to allow for overloads to fetch/query methods.
  *
  * @see <a href="https://sproket.github.io/Persism/manual2.html">Using the new Query/Fetch methods</a>
  */
 public final class SQL {
 
     enum SQLType {Select, Where, StoredProc}
 
     SQLType type;
 
     final String sql;
 
     String processedSQL = null;
 
     int limit;
 
     private static final Pattern commentPattern = Pattern.compile("/\\*.*?\\*/", Pattern.DOTALL);
 
     SQL(String sql) {
         sql = sql.trim();
 
         if (sql.startsWith("--") || sql.startsWith("/*")) {
             // trim comments
 
             // line comments
             StringBuilder sb = new StringBuilder();
             try (Scanner scanner = new Scanner(sql)) {
                 while (scanner.hasNextLine()) {
                     String line = scanner.nextLine().trim();
                     if (!line.startsWith("--")) {
                         sb.append(line).append("\n");
                     }
                 }
             }
             sql = sb.toString();
 
             // /* */ comments
             //Pattern commentPattern = Pattern.compile("/\\*.*?\\*/", Pattern.DOTALL);
             sql = commentPattern.matcher(sql).replaceAll("").trim();
         }
 
         this.sql = sql;
         this.type = SQLType.Select;
     }
 
     SQL(String sql, SQLType type) {
         this.sql = sql.trim();
         this.type = type;
     }
 
     /**
      * Method to instantiate a regular SQL string.
      * <pre>{@code
      *      Contact> contact;
      *      contact = session.fetch(Contact.class,
      *                sql("SELECT * FROM CONTACTS WHERE LAST_NAME = ? AND FIRST_NAME = ?"),
      *                params("Fred", "Flintstone");
      * }</pre>
      *
      * @param sql String
      * @return new SQL object
      */
     public static SQL sql(String sql) {
         return new SQL(sql);
     }
 
     /**
      * Method used to specify an SQL WHERE clause for an SQL Statement.
      * The SELECT ... parts would be provided by Persism.
      * Only here do we allow property names in the query
      * <pre>{@code
      *      List<Contact> contacts;
      *      contacts = session.query(Contact.class,
      *                 where("(:firstname = @name OR :company = @name) and :lastname = @last and :city = @city and :amountOwed > @owe ORDER BY :dateAdded"),
      *                 named(Map.of("name", "Fred", "last", "Flintstone", "owe", 10, "city", "Somewhere")));
      * }</pre>
      *
      * @param where String
      * @return new SQL object
      */
     public static SQL where(String where) {
         return new SQL("WHERE " + where, SQLType.Where);
     }
 
     /**
      * Static initializer for a new SQL stored procedure string.
      * <pre>{@code
      *      List<CustomerOrder> list;
      *      list = session.query(CustomerOrder.class, proc("[spCustomerOrders](?)"), params("123"));
      * }</pre>
      *
      * @param storedProc String
      * @return new SQL object
      */
     public static SQL proc(String storedProc) {
         return new SQL(storedProc, SQLType.StoredProc);
     }
 
     public SQL limit(int limit) {
         this.limit = limit;
         return this;
     }
 
     /**
      * @hidden
      */
     @Override
     public String toString() {
         if (processedSQL != null) {
             return processedSQL;
         }
         return sql;
     }
 }