@Test
  public void testPersistEntity_EntityWithArray() {

    System.out.println("\nTestPersistenceManager.testPersistEntity_EntityWithArray()");
    System.out.println("------------------------------------------------------------");
    Filter filter = new Filter();
    List<String> values = new ArrayList<String>();
    values.add("Value1");
    values.add("Value2");
    filter.setValues(values);

    String[] simpleArray = new String[] {"Kayal", "Vizhi"};
    filter.setSimpleArray(simpleArray);
    Tuple[] complexArray = new Tuple[] {new Tuple("a", "A"), new Tuple("b", "B")};
    filter.setComplexArray(complexArray);

    persistenceManager.persistEntity(filter);

    List<Filter> filters = persistenceManager.getEntities(Filter.class);
    assertNotNull(filters);
    assertEquals(1, filters.size());
    Filter retrievedFilter = filters.get(0);
    assertNotNull(retrievedFilter.getId());
    assertEquals(filter.getValues(), retrievedFilter.getValues());
    assertEquals(complexArray.length, retrievedFilter.getComplexArray().length);
    for (int i = 0; i < complexArray.length; i++) {
      assertEquals(complexArray[i], retrievedFilter.getComplexArray()[i]);
    }
  }
  public static InstanceStateMachine_c getOneSM_ISMOnR518(
      ModelRoot modelRoot, ModelClass_c target, ClassQueryInterface_c test, boolean loadComponent) {
    InstanceStateMachine_c result = null;

    result = find_getOneSM_ISMOnR518(modelRoot, target, test);
    if (result == null && (loadComponent)) {
      // Containment Relation
      List comps =
          PersistenceManager.findAllChildComponents(
              target.getPersistableComponent(), modelRoot, InstanceStateMachine_c.class);
      for (int i = 0; i < comps.size(); i++) {
        PersistableModelComponent component = (PersistableModelComponent) comps.get(i);
        if (!component.isLoaded()) {
          try {
            component.load(new NullProgressMonitor());
            result = find_getOneSM_ISMOnR518(modelRoot, target, test);
            if (result != null) return result;
          } catch (Exception e) {
            CorePlugin.logError("Error Loading component", e);
          }
        }
      }
    }

    return result;
  }
  public static Localidad findByFields(String nombreProvincia, String nombreLocalidad) {

    EntityManager entityManager = PersistenceManager.getEntityManager();

    Localidad localidad = null;

    try {

      TypedQuery<Localidad> query =
          entityManager.createNamedQuery("Localidad.findByFields", Localidad.class);

      query.setParameter("localidad", nombreLocalidad);
      query.setParameter("provincia", nombreProvincia);

      if (!query.getResultList().isEmpty() && query.getResultList().size() < 2) {

        localidad = query.getResultList().get(0);
      }

    } catch (Exception ex) {
      ex.printStackTrace();

    } finally {
      entityManager.close();
    }

    return localidad;
  }
Esempio n. 4
0
  /**
   * @param maxResults no of URLs to pull
   * @return Pulls any URLs that have get_authority_data = TRUE
   */
  @SuppressWarnings("unchecked")
  public List<URL> getUnProccessedAuthorityData(Integer maxResults) {

    log.info("Entering getUnProccessedAuthorityData()");

    List<URL> urls = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {

      urls =
          (List<URL>)
              mgr.createQuery("SELECT u FROM URL u WHERE u.get_authority_data = TRUE")
                  .setMaxResults(maxResults)
                  .getResultList();

    } catch (Exception e) {
      String msg = "Exception thrown. URLDBService: getUnProccessedAuthorityData";
      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }

    return urls;
  }
Esempio n. 5
0
  public Integer getNoOfUnProccessedTUrls() {

    log.info("Entering getNoOfUnProccessedTUrls");

    Integer result = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {
      result =
          ((Number)
                  mgr.createQuery(
                          "SELECT COUNT(u) FROM URL u WHERE u.get_backlinks = TRUE and u.backlinks_got = false")
                      .getSingleResult())
              .intValue();

    } catch (Exception e) {
      log.severe(e.getMessage());

    } finally {
      mgr.close();
    }
    return result;
  }
Esempio n. 6
0
  public List<URL> getURLsFromIDs(List<Integer> idList) {

    log.info("Entering getURLsFromIDs");
    List<URL> urls = new ArrayList<URL>(); // used if we use option 2.

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    // TODO: decide: 2 options: - need to check in optimization....

    // 1: one call to DB and search list for idList
    //		get list of all urls and then use java selection process to retrieve urls from this list
    // that are in idList

    // 2: multiple calls to DB:
    //	loop through all idList and make repeat calls to DB retrieving URL for each.

    try {

      // 2:
      for (int i = 0; i < idList.size(); i++) {

        urls.add(mgr.find(URL.class, idList.get(i)));
      }

    } catch (Exception e) {
      String msg = "Exception thrown. URLService: getURLsFromIDs";
      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }

    return urls;
  }
Esempio n. 7
0
  /**
   * Updates record with url address with new page authority (pa) & domain authority (da) data
   *
   * @param urlAddress - target url
   * @param pa - Page Authority
   * @param da - Domain Authority
   * @param domainName - Domain name of url.
   */
  public void updateBackLinksGot(URL url, boolean backLinksGot) {

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    int url_id;

    try {

      url_id = url.getId();

      mgr.getTransaction().begin();

      URL urlDB = mgr.find(URL.class, url_id);
      urlDB.setBacklinks_got(backLinksGot);

      mgr.merge(urlDB);
      mgr.getTransaction().commit();

    } catch (Exception e) {
      String msg = "Exception thrown. URLService: updateURLData";

      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }
  }
Esempio n. 8
0
  public void updateSocialFrequencyData(URL url) {

    log.info("Entering URLService::updateSocialFrequencyData");

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {

      mgr.getTransaction().begin();

      URL urlDB = mgr.find(URL.class, url.getId());
      urlDB.setSocial_data_freq(url.getSocial_data_freq());
      urlDB.setSocial_data_date(url.getSocial_data_date());

      mgr.merge(urlDB);
      // mgr.flush();
      mgr.getTransaction().commit();

    } catch (Exception e) {
      String msg = "Exception thrown. URLService: updateSocialFrequencyData";
      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }
  }
Esempio n. 9
0
  /**
   * @param links list of links that we want the urls
   * @return - list of urls that are the source urls in the list of links passed
   */
  @SuppressWarnings("unchecked")
  public List<URL> getBackLinkURLs(List<Integer> sourceIDs) {

    log.info("Entering getBackLinkURLs - list of links version");
    List<URL> result = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    Query query =
        mgr.createQuery("SELECT u FROM URL u WHERE u.url_id IN :sourceIDs ORDER BY u.url_id")
            .setParameter("sourceIDs", sourceIDs);

    try {

      result = query.getResultList();

    } catch (Exception e) {
      String msg = "Exception thrown. URLService: getBackLinkURLs (Link List version) ";

      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }

    return result;
  }
Esempio n. 10
0
  // see: http://en.wikibooks.org/wiki/Java_Persistence/Querying#Pagination.2C_Max.2FFirst_Results
  // for limiting results... and ordering correclty...
  @SuppressWarnings("unchecked")
  public List<URL> getBackLinkURLs(int targetURLId, int limitStart, Integer limitEnd) {
    log.info(
        "Entering getBackLinkURLs: Start = "
            + Integer.toString(limitStart)
            + ". End = "
            + Integer.toString(limitEnd));
    List<URL> result = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    Query query =
        mgr.createQuery(
            "SELECT u FROM URL u WHERE u.url_id = ANY (SELECT l.source_id FROM Link l WHERE l.target_id = :id) ORDER BY u.url_id");
    query.setParameter("id", targetURLId);
    query.setFirstResult(limitStart);
    query.setMaxResults(limitEnd);

    try {

      result = query.getResultList();
      log.info("getBackLinkURLs: No Of Results: " + Integer.toString(result.size()));

    } catch (Exception e) {
      String msg = "Exception thrown. URLService: getBackLinkURLs. ";

      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }

    return result;
  }
Esempio n. 11
0
  /**
   * @return all URLs that have their social_data date set for today or before, ordered by url_id
   *     max ever pulled: GoFetchConstants.MAX_NO_OF_SOCIAL_URLS
   * @throws Exception
   */
  @SuppressWarnings("unchecked")
  public List<URL> getAllTodaysSocialCrawlURLs() throws Exception {
    log.info("Entering getTodaysSocialCrawlURLs");
    List<URL> result = null;
    Date date = DateUtil.getTodaysDate();

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {

      result =
          (List<URL>)
              mgr.createQuery(
                      "SELECT u FROM URL u WHERE u.get_social_data = true AND u.social_data_date <= :date ORDER BY u.url_id")
                  .setParameter("date", date, TemporalType.DATE)
                  .setMaxResults(GoFetchConstants.MAX_NO_OF_SOCIAL_URLS)
                  .getResultList();

    } catch (Exception e) {

      log.severe("Error: getAllTodaysSocialCrawlURLs " + e.getMessage());
      throw (e);

    } finally {
      mgr.close();
    }
    if (result == null) {
      log.warning("No URLs returned");
    }

    return result;
  }
Esempio n. 12
0
  @SuppressWarnings("unchecked")
  public List<URL> getTodaysSocialCrawlURLs(int noOfResults) {
    log.info("Entering getTodaysSocialCrawlURLs");
    List<URL> result = null;
    Date date = DateUtil.getTodaysDate();

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {
      result =
          (List<URL>)
              mgr.createQuery(
                      "SELECT u FROM URL u WHERE u.get_social_data = true AND u.social_data_date <= :date ORDER BY u.social_data_date")
                  .setParameter("date", date, TemporalType.DATE)
                  .setMaxResults(noOfResults)
                  .getResultList();

    } catch (Exception e) {
      String msg = "Exception thrown. URLService: getURLs";

      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }
    if (result == null) {
      log.warning("No URLs returned");
    }

    return result;
  }
Esempio n. 13
0
  @SuppressWarnings("unchecked")
  public List<String> getURLAddressesStartingWith(String query, int noOfResults) {

    // log.info("Entering getURLAddresses");
    List<String> result = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {
      result =
          (List<String>)
              mgr.createQuery("SELECT u.url_address FROM URL u where u.url_address LIKE :query")
                  .setMaxResults(noOfResults)
                  .setParameter("query", query + "%")
                  .getResultList();

    } catch (Exception e) {
      String msg = "Exception thrown. URLService: getURLAddresses";

      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }

    return result;
  }
Esempio n. 14
0
  // updates the corresponding URL in the DB with the client and campaign data passed as a parameter
  //	and sets client_target_url = true.
  public void updateURLClientAndCampaign(URL targetURLDB) {

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {

      mgr.getTransaction().begin();

      URL url = mgr.find(URL.class, targetURLDB.getId());
      url.setClient_category_id(targetURLDB.getClient_category_id());
      url.setUsers_user_id(targetURLDB.getUsers_user_id());
      url.setClient_target_url(true);

      mgr.merge(url);
      mgr.getTransaction().commit();

    } catch (Exception e) {
      String msg = "Exception thrown: URLDBService: updateURLClientAndCampaign";
      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }
  }
  public static InstanceStateMachine_c[] getManySM_ISMsOnR518(
      ModelClass_c[] targets, ClassQueryInterface_c test, boolean loadComponent) {

    if (targets == null || targets.length == 0 || targets[0] == null)
      return new InstanceStateMachine_c[0];

    ModelRoot modelRoot = targets[0].getModelRoot();
    if (loadComponent) {
      // Containment Relation
      PersistableModelComponent[] pmcs = new PersistableModelComponent[targets.length];
      for (int i = 0; i < targets.length; i++) {
        pmcs[i] = targets[i].getPersistableComponent();
      }
      PersistenceManager.ensureAllChildInstancesLoaded(
          pmcs, modelRoot, InstanceStateMachine_c.class);
    }

    InstanceList instances = modelRoot.getInstanceList(InstanceStateMachine_c.class);

    Vector matches = new Vector();
    for (int i = 0; i < targets.length; i++) {
      InstanceStateMachine_c source =
          (InstanceStateMachine_c) targets[i].backPointer_InstanceStateMachine_R518;
      if (source != null && (test == null || test.evaluate(source))) {
        matches.add(source);
      }
    }
    if (matches.size() > 0) {
      InstanceStateMachine_c[] ret_set = new InstanceStateMachine_c[matches.size()];
      matches.copyInto(ret_set);
      return ret_set;
    } else {
      return new InstanceStateMachine_c[0];
    }
  }
Esempio n. 16
0
  /**
   * Updates record with url address with new page authority (pa), domain authority (da), docTitle
   * data Then sets URL's get_authority_data to false.
   *
   * @param urlAddress - target url
   * @param pa - Page Authority
   * @param da - Domain Authority
   * @param domainName - Domain name of url.
   */
  public void updateURLData(String urlAddress, Integer pa, Integer da, String docTitle) {

    log.info("Entering updateURLData(...) for: " + urlAddress);

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    int url_id;

    try {

      url_id = getURLIDFromAddress(urlAddress);

      mgr.getTransaction().begin();

      URL url = mgr.find(URL.class, url_id);
      url.setPage_authority(pa);
      url.setDomain_authority(da);
      url.setDoc_title(docTitle);
      url.setGet_authority_data(false);

      mgr.merge(url);
      mgr.getTransaction().commit();

    } catch (Exception e) {
      String msg = "Exception thrown. URLService: updateURLData";

      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }
  }
Esempio n. 17
0
  /**
   * @param targetURL
   * @return list of URLs that point to this target
   */
  @SuppressWarnings("unchecked")
  public List<URL> getBackLinkURLs(Integer targetURLid) {

    log.info("Entering getBackLinkURLs");

    List<URL> result = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    // SQL: this works: select * from url u where u.url_id IN (select l.source_id from links l where
    // l.target_id = id);
    try {
      result =
          (List<URL>)
              mgr.createQuery(
                      "SELECT u FROM URL u WHERE u.url_id = ANY (SELECT l.source_id FROM Link l WHERE l.target_id = :id)")
                  .setParameter("id", targetURLid)
                  .getResultList();

    } catch (Exception e) {
      String msg = "Exception thrown. URLService: getBackLinkURLs. ";

      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }

    return result;
  }
Esempio n. 18
0
  public Integer noOfClientURLs(Integer clientID) {

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    Integer result = null;

    try {

      result =
          (Integer)
              mgr.createQuery("SELECT COUNT(u) FROM URL u WHERE u.users_user_id = :clientID")
                  .setParameter("clientID", clientID)
                  .getSingleResult();

    } catch (Exception e) {
      String msg = "Exception thrown: URLService: noOfClientURLs";
      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }

    return result;
  }
Esempio n. 19
0
  public void updateDomainNames(List<URL> urls) {

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {

      for (URL currentURL : urls) {

        mgr.getTransaction().begin();

        URL url = mgr.find(URL.class, currentURL.getId());
        url.setDomain(currentURL.getDomain());

        mgr.merge(url);
        mgr.getTransaction().commit();
      }

    } catch (Exception e) {
      String msg = "Exception thrown. URLService: updateDomainNames";
      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }
  }
Esempio n. 20
0
  @SuppressWarnings("unchecked")
  public List<String> getURLAddresses() {

    log.info("Entering getURLAddresses");
    List<String> result = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {
      result = (List<String>) mgr.createQuery("SELECT u.url_address FROM URL u").getResultList();
    } catch (Exception e) {
      String msg = "Exception thrown. URLService: getURLAddresses";

      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }
    if (result == null) {
      log.warning("No URLs returned");
    }

    return result;
  }
Esempio n. 21
0
  /*
   * Returns a list of URLs that are to be monitored for social data...
   */
  @SuppressWarnings("unchecked")
  public List<URL> getSociallyTrackedURLs() {

    log.info("Entering getSociallyTrackedURLs");
    List<URL> result = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {
      result =
          (List<URL>)
              mgr.createQuery("SELECT u FROM URL u WHERE u.get_social_data = TRUE").getResultList();

    } catch (Exception e) {
      String msg = "Exception thrown. URLService: getSociallyTrackedURLs";
      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }
    if (result == null) {
      log.warning("No SociallyTracked URLs returned");
    }
    return result;
  }
Esempio n. 22
0
  /**
   * Gets a URL given an ID
   *
   * @param id
   * @return URL
   */
  @SuppressWarnings("unchecked")
  public URL getURL(String address) {
    log.info("Entering getURL[" + address + "]");

    List<URL> url = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {
      url =
          (List<URL>)
              mgr.createQuery("SELECT u FROM URL u WHERE u.url_address = :address")
                  .setParameter("address", address)
                  .getResultList();
    } catch (Exception e) {
      String msg = "Exception thrown getting URL: " + address + "URLService: getURL";

      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }

    if ((null == url) || (url.isEmpty())) return null;
    else return url.get(0);
  }
Esempio n. 23
0
  public void deleteURL(int url_id) {

    log.info("Entering deleteURL. Deleting " + url_id);

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {
      mgr.getTransaction().begin();

      mgr.createQuery("DELETE FROM URL u WHERE u.url_id = :url_id")
          .setParameter("url_id", url_id)
          .executeUpdate();

      mgr.getTransaction().commit();

    } catch (Exception e) {
      String msg = "Exception thrown deleting: " + url_id + ". URLService: deleteURL";
      // logger.logp(Level.SEVERE, "URLService", "deleteURL",msg ,e);
      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }
  }
Esempio n. 24
0
  /*
   * Returns a list of URLs that were added to the database today.
   */
  @SuppressWarnings("unchecked")
  public List<URL> getTargetURLsFrom(Date date) {

    log.info("Entering getTargetURLsFrom");
    List<URL> result = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {
      result =
          (List<URL>)
              mgr.createQuery("SELECT u FROM URL u WHERE u.date = :date AND u.get_backlinks = TRUE")
                  .setParameter("date", date, TemporalType.DATE)
                  .getResultList();

    } catch (Exception e) {
      String msg = "Exception thrown. URLService: getTargetURLsFrom";

      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }
    if (result == null) {
      log.warning("No URLs returned");
    }
    return result;
  }
Esempio n. 25
0
  /*
   * Returns list of urls that have had their get_backlinks flag checked, but have not yet got their backlink data eg: from SEOMoz
   */
  @SuppressWarnings("unchecked")
  public List<URL> getUnproccessedTargetURLs(Integer limit) {

    log.info("Entering getUnproccessedTargetURLs");

    List<URL> urls = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {

      urls =
          (List<URL>)
              mgr.createQuery(
                      "SELECT u FROM URL u WHERE u.get_backlinks = TRUE and u.backlinks_got = false")
                  .setMaxResults(limit)
                  .getResultList();

    } catch (Exception e) {
      String msg = "Exception thrown. URLDBService: getUnproccessedTargetURLs";
      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }

    return urls;
  }
Esempio n. 26
0
  /*
   * Returns a list of URLs that were added between the 2 dates
   */
  @SuppressWarnings("unchecked")
  public List<URL> getURLsBetween(Date startDate, Date endDate) {

    log.info("Entering getURLsBetween");
    List<URL> result = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {
      result =
          (List<URL>)
              mgr.createQuery("SELECT u FROM URL u WHERE u.date BETWEEN :startDate AND :endDate")
                  .setParameter("startDate", startDate, TemporalType.DATE)
                  .setParameter("endDate", endDate, TemporalType.DATE)
                  .getResultList();

    } catch (Exception e) {
      String msg = "Exception thrown: URLService: getURLsBetween";

      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }
    if (result == null) {
      log.warning("No URLs returned");
    }
    return result;
  }
Esempio n. 27
0
  /**
   * @param url
   * @return the SEOMoz metric: Domain Authority, if there's already a URL in the DB from that
   *     domain, - this saves hitting the SEOMoz server unnec. IF there's no url's with domain with
   *     the DB, then returns null
   */
  public Integer getDomainAuthorityForThisDomain(String domainName) {

    Integer result = null;
    //		String domain = "http://";
    //		domain += TextUtil.returnDomainName(url);

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {
      result =
          (Integer)
              mgr.createQuery(
                      "SELECT u.domain_authority FROM URL u WHERE u.domain_authority > 0 AND u.url_address LIKE :query")
                  .setMaxResults(1)
                  .setParameter("query", "%" + domainName + "%")
                  .getSingleResult();

    } catch (Exception e) {
      String msg = "Exception thrown. URLService: getDomainAuthorityForThisDomain";

      log.info(msg + e.getMessage());

    } finally {
      mgr.close();
    }

    return result;
  }
Esempio n. 28
0
  @SuppressWarnings("unchecked")
  public Integer getURLIDFromAddress(String urlAddress) {
    log.info("Entering getURLIDFromAddress()");
    Integer url_id;
    List<URL> result = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {
      result =
          (List<URL>)
              mgr.createQuery("SELECT u FROM URL u WHERE u.url_address = :urlAddress")
                  .setParameter("urlAddress", urlAddress)
                  .getResultList();
    } catch (Exception e) {
      String msg = "Exception thrown: URLService: getURLIDFromAddress";

      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }
    if (result == null || result.isEmpty()) {
      log.info("Could not find URL: " + urlAddress);
      return 0;
    }

    url_id = result.get(0).getId();
    log.info("url_id: " + url_id);
    return url_id;
  }
  public static void create(Localidad localidad) {

    EntityManager entityManager = PersistenceManager.getEntityManager();

    EntityTransaction tr = entityManager.getTransaction();

    tr.begin();

    try {
      entityManager.persist(localidad);
      tr.commit();
      System.out.println(
          "Creación de localidad:"
              + localidad.getNombre()
              + ", de la prov: "
              + localidad.getProvincia().getNombre()
              + " exitosa");
    } catch (Exception ex) {
      tr.rollback();
      System.err.println(
          "Error en LibroDAO.create"
              + "("
              + Thread.currentThread().getStackTrace()[1].getLineNumber()
              + "):"
              + ex.getLocalizedMessage());
    } finally {
      entityManager.close();
    }
  }
Esempio n. 30
0
  @SuppressWarnings("unchecked")
  public String getURLAddressFromID(Integer urlID) {

    String address;
    List<URL> result = null;

    EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
    EntityManager mgr = emf.createEntityManager();

    try {
      result =
          (List<URL>)
              mgr.createQuery("SELECT u FROM URL u WHERE u.url_id = :urlID")
                  .setParameter("urlID", urlID)
                  .getResultList();
    } catch (Exception e) {
      String msg = "Exception thrown: URLService: getURLIDFromAddress";

      log.severe(msg + e.getMessage());

    } finally {
      mgr.close();
    }
    if (result == null || result.isEmpty()) {
      return null;
    }

    address = result.get(0).getUrl_address();

    return address;
  }