2011-08-26

Random SQL from hell ¬¬

SELECT
     Table1.XXX as YYY,
     Table3.XXX as YYY,
     Table3.XXX as YYY,
     Table2.XXX as YYY,
     Table2.XXX as YYY,
     Table2.XXX as YYY,
     Table2.XXX as YYY,
     CASE WHEN Table7.XXX IS NULL THEN ' ' ELSE Table7.XXX END ZZZ,
     CASE WHEN Table1.XXX IS NULL THEN 0 ELSE Table1.XXX END ZZZ,
     CASE WHEN Table1.XXX  IS NULL THEN ' ' ELSE Table1.XXX END ZZZ,
     CASE WHEN Table1.XXX IS NULL THEN SYSDATE ELSE Table1.XXX END ZZZ,    
     CASE WHEN Table1.XXX IS NULL THEN 0 ELSE Table1.XXX END ZZZ,
     CASE WHEN Table1.XXX IS NULL THEN 0 ELSE Table1.XXX END ZZZ,    
     CASE WHEN Table1.XXX IS NULL THEN 0 ELSE Table1.XXX END ZZZ,
     CASE WHEN Table1.XXX IS NULL THEN 0 ELSE XXX END ZZZ,
     CASE WHEN Table8.XXX IS NULL THEN ' ' ELSE Table8.XXX END ZZZ,    
     CASE WHEN Table2.XXX IS NULL THEN 0 ELSE Table2.XXX END ZZZ,
     Table5.XXX as YYY,
     CASE WHEN Table2.XXX IS NULL THEN 0 ELSE Table2.XXX END ZZZ,
     CASE WHEN Table2.XXX IS NULL THEN ' ' ELSE Table2.XXX END ZZZ,
     CASE WHEN Table10.XXX IS NULL THEN ' ' ELSE Table10.XXX END ZZZ,         
     CASE WHEN Table2.XXX IS NULL THEN ' ' ELSE Table2.XXX END ZZZ,
     CASE WHEN Table2.XXX IS NULL THEN ' ' ELSE Table2.XXX END ZZZ,
     CASE WHEN Table2.XXX IS NULL THEN ' ' ELSE Table2.XXX END ZZZ,
     Table2.XXX as YYY,
     CASE WHEN Table2.XXX IS NULL THEN SYSDATE ELSE Table2.XXX END ZZZ,
     CASE WHEN Table2.XXX IS NULL THEN 0 ELSE Table2.XXX END ZZZ,
     (SELECT COUNT (*) FROM TABLE_21 Table21 WHERE Table21.XXX = Table2.XXX ) XXX,
     CASE WHEN Table1.XXX IS NULL THEN ' ' ELSE Table1.XXX END ZZZ,
     CASE WHEN Table2.XXX IS NULL THEN 0 ELSE Table2.XXX END ZZZ,
     CASE WHEN Table21.XXX IS NULL THEN 0 ELSE Table21.XXX END ZZZ,
     CASE WHEN Table10.XXX IS NULL THEN 0 ELSE Table10.XXX END ZZZ,  
     CASE WHEN Table2.XXX IS NULL THEN ' ' ELSE Table2.XXX END ZZZ,
     CASE WHEN Table2.XXX IS NULL THEN ' ' ELSE Table2.XXX END ZZZ,
     CASE WHEN Table1.XXX IS NULL THEN 0 ELSE Table1.XXX END ZZZ,
     CASE WHEN Table1.XXX IS NULL THEN SYSDATE ELSE Table1.XXX END ZZZ,
     CASE WHEN Table2.XXX IS NULL THEN 0 ELSE Table2.XXX END ZZZ,
     CASE WHEN Table2.XXX IS NULL THEN 0 ELSE Table2.XXX END ZZZ,
     CASE WHEN
         (SELECT XXX FROM TABLE_16  WHERE XXX = XXX)    
     IS NULL THEN ' ' ELSE
         (SELECT XXX FROM TABLE_16  WHERE XXX = XXX) END ZZZ,    
     CASE WHEN Table1.XXX IS NULL THEN 0 ELSE Table1.XXX END ZZZ,
     CASE WHEN Table1.XXX IS NULL THEN 0 ELSE Table1.XXX END ZZZ,
     CASE WHEN Table1.XXX IS NULL THEN SYSDATE ELSE Table1.XXX END ZZZ,
     Table11.XXX as YYY,
     Table11.XXX as YYY,
     Table11.XXX as YYY,
     Table11.XXX as YYY,
     CASE WHEN T.XXX IS NULL THEN ' ' ELSE T.XXX END ZZZ,
     CASE WHEN T.XXX IS NULL THEN ' ' ELSE T.XXX END ZZZ,
     CASE WHEN T.XXX IS NULL THEN ' ' ELSE T.XXX END ZZZ,
     CASE WHEN V.XXX IS NULL THEN ' ' ELSE V.XXX END ZZZ,
     CASE WHEN V.XXX IS NULL THEN ' ' ELSE V.XXX END ZZZ,
     CASE WHEN V.XXX IS NULL THEN ' ' ELSE V.XXX END ZZZ,
     CASE WHEN
         (SELECT XXX FROM TABLE_17 Table17 WHERE Table17.XXX AND Table17.XXX  )
     IS NULL THEN 0 ELSE
         (SELECT XXX FROM TABLE_17 Table17 WHERE Table17.XXX AND Table17.XXX ) END ZZZ, 
     CASE WHEN     
         (SELECT XXX FROM TABLE_18 Table18 WHERE Table18.XXX AND Table18.XXX )
     IS NULL THEN 0 ELSE         
         (SELECT XXX FROM TABLE_18 Table18 WHERE Table18.XXX AND Table18.XXX ) END ZZZ,
     CASE WHEN     
         (SELECT XXX FROM TABLE_18 Table18 WHERE Table18.XXX AND Table18.XXX )
     IS NULL THEN 0 ELSE        
         (SELECT XXX FROM TABLE_18 Table18 WHERE Table18.XXX AND Table18.XXX ) END ZZZ
FROM
     TABLE_2 Table2,
     TABLE_1 Table1,
     TABLE_3 Table3,
     TABLE_4 Table4,
     TABLE_5 Table5,
     TABLE_6 Table6,
     TABLE_7 Table7,    
     TABLE_8 Table8,    
     TABLE_9 Table9,
     TABLE_10 Table10,
     TABLE_11 Table11,
     TABLE_12 Table12,
     (SELECT
          Table12.XXX as YYY,Table13.XXX as YYY, Table19.XXX as YYY,
          (SELECT a.XXX FROM TABLE_14 a, TABLE_15 b
               WHERE a.XXX = b.XXX AND b.XXX = Table19.XXX ) AS XXX
      FROM
          TABLE_12 Table12,
          TABLE_13 Table13,
          TABLE_19 Table19
      WHERE
          Table12.XXX = Table13.XXX
          AND Table19.XXX = Table13.XXX
      union
      SELECT
          Table12.XXX as YYY, null as XXX, null as XXX, null AS XXX
      FROM
          TABLE_12 Table12
      WHERE
          Table12.XXX is null) T,     
      (SELECT
          Table12.XXX as YYY,Table13.XXX as YYY, Table19.XXX as YYY,
          (SELECT a.descripcion FROM TABLE_14 a, TABLE_15 b
               WHERE a.XXX = b.XXX AND b.XXX = Table19.XXX ) AS XXX
      FROM
          TABLE_12 Table12,
          TABLE_13 Table13,
          TABLE_19 Table19
      WHERE
          Table12.XXX = Table13.XXX
          AND Table19.XXX = Table13.XXX
      union
      SELECT
          Table12.XXX as YYY, null as XXX, null as XXX, null AS XXX
      FROM
          TABLE_12 Table12
      WHERE
          Table12.XXX is null) V
WHERE
     Table2.XXX = Table1.XXX
     AND XXX.XXX = XXX.XXX
     AND Table2.XXX = Table10.XXX (+)
     AND Table4.XXX = Table1.XXX
     AND XXX.XXX = Table4.XXX
     AND XXX.XXX = Table6.XXX
     AND Table1.XXX = XXX.XXX    
     AND XXX.XXX = Table9.XXX
     AND Table12.XXX = Table11.XXX
     AND Table1.XXX = Table7.XXX (+)
     AND Table1.XXX = Table8.XXX (+) 
     AND T.XXX = Table2.XXX
     AND V.XXX = Table2.XXX   
     AND (Table2.XXX  IS NULL OR Table2.XXX NOT IN ('N'))
     AND Table1.XXX = 1                                             
order by XXX, XXX, XXX
Publicadas por Rafael Martinez - Slayer SA a la/s 14:46 0 comentarios Vínculos a esta publicación

2011-04-18

Bad english. Impending failure edition ¬¬

Blank stare
Publicadas por Rafael Martinez - Slayer SA a la/s 16:19 0 comentarios Vínculos a esta publicación

Sigh

Sometimes it really boggles me how can someone misunderstand simple things. Perhaps I've read obscure IT books just to know what means to:

  • Introduce an abstract parent and pull up a method.

This guy just stared blank at me ¬¬...

Have I mentioned that the same recipe was used at least 3 times on the same project and this particular dev did one of them?
Publicadas por Rafael Martinez - Slayer SA a la/s 16:14 0 comentarios Vínculos a esta publicación

2011-04-13

If something fails...

In case you are wondering, yes, all this code is on the same method.


 
try {
            Class.forName("DriverClass");
            Connection conn = DriverManager.getConnection(
                    "jdbc:___",
                    "myUser", "myPass");
            try {
                Statement stmt = conn.createStatement(
                        ResultSet.TYPE_SCROLL_SENSITIVE,
                        ResultSet.CONCUR_READ_ONLY);
                try {
                    ResultSet rset = stmt.executeQuery(getQuery(true, filter));
                    if (rset.last()) {
                        counter = rset.getRow();
                    } else {
                        return;
                    }
             //CODE   
                    rset = stmt.executeQuery(getQuery(false, filter));
                   
                    try {
                        while (rset.next()) {

// CODE

                            if (rset.getString("ID_BLA") != null) {
                                String currentTC = rset
                                        .getString("ID_BLA");
                                if (!newTC.equals(currentTC)) {
                                    if (rset.getString("BLA").equals(
                                            "bla")) {
 //CODE
                                        try {
                                           // CODE
                                        } catch (SQLException ex) {
                                            System.err
                                                    .println("Error "
                                                            + ex.getMessage());
                                        }
                                    } else {
                                        // CODE
                                        try {
                                           // CODE
                                        } catch (SQLException ex) {
                                            System.err
                                                    .println("Error"
                                                            + ex.getMessage());
                                        }
                                    }
                                }
          
                            }
                        }

//CODE

                    } finally {
                        try {
                            rset.close();
                        } catch (Exception ignore) {
                            System.err.println(ignore.getMessage());
                        }
                    }
                } finally {
                    try {
                        stmt.close();
                    } catch (Exception ignore) {
                        System.err.println(ignore.getMessage());
                    }
                }
            } finally {
                try {
                    conn.close();
                } catch (Exception ignore) {
                    System.err.println(ignore.getMessage());
                }
            }

        } catch (Exception x) {
            x.printStackTrace();
            System.err.println("Error")
        }
Publicadas por Rafael Martinez - Slayer SA a la/s 18:04 1 comentarios Vínculos a esta publicación
Suscribirse a: Entradas (Atom)