Tag: customizzazione

    String tableLike = null;
    tableLike = "'%'";  //  All tables
    // tableLike = "'AD_OrgInfo', 'AD_Role', 'C_CashLine', 'C_Currency', 'C_Invoice', 'C_Order', 'C_Payment', 'M_InventoryLine', 'M_PriceList', 'M_Product', 'U_POSTerminal'";  //  Only specific tables
    if (args.length > 3)
      tableLike = args[3];
    log.info("Table Like: " + tableLike);

    //  complete sql
    sql.insert(0, "SELECT AD_Table_ID "
      + "FROM AD_Table "
      + "WHERE (TableName IN ('RV_WarehousePrice','RV_BPartner')"  //  special views
      + " OR IsView='N')"
      + " AND IsActive = 'Y' AND TableName NOT LIKE '%_Trl' AND ");
    // Autodetect if we need to use IN or LIKE clause - teo_sarca [ 3020640 ]
    if (tableLike.indexOf(",") == -1)
      sql.append(" AND TableName LIKE ").append(tableLike);
    else
      sql.append(" AND TableName IN (").append(tableLike).append(")"); // only specific tables

    sql.append(" ORDER BY TableName");
    
    //
    int count = 0;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try
    {
      pstmt = DB.prepareStatement(sql.toString(), null);
      rs = pstmt.executeQuery();
      while (rs.next())
      {
        new ModelInterfaceGenerator(rs.getInt(1), directory, packageName);
        new ModelClassGenerator(rs.getInt(1), directory, packageName);
        count++;
      }
     }
    catch (Exception e)
    {
      log.log(Level.SEVERE, sql.toString(), e);
    }
    finally
    {
      DB.close(rs, pstmt);
      rs = null; pstmt = null;
    }
    log.info("Generated = " + count);
  }