/**
  * Performs a dynamic query on the database and returns an ordered range of the matching rows.
  *
  * <p>Useful when paginating results. Returns a maximum of <code>end - start</code> instances.
  * <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result
  * set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start
  * </code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}
  * will return the full result set. If <code>orderByComparator</code> is specified, then the query
  * will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and
  * pagination is required (<code>start</code> and <code>end</code> are not {@link
  * com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default
  * ORDER BY logic from {@link ec.gob.snap.vuv.model.impl.CentroModelImpl}. If both <code>
  * orderByComparator</code> and pagination are absent, for performance reasons, the query will not
  * have an ORDER BY clause and the returned result set will be sorted on by the primary key in an
  * ascending order.
  *
  * @param dynamicQuery the dynamic query
  * @param start the lower bound of the range of model instances
  * @param end the upper bound of the range of model instances (not inclusive)
  * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
  * @return the ordered range of matching rows
  * @throws SystemException if a system exception occurred
  */
 @Override
 @SuppressWarnings("rawtypes")
 public List dynamicQuery(
     DynamicQuery dynamicQuery, int start, int end, OrderByComparator orderByComparator)
     throws SystemException {
   return centroPersistence.findWithDynamicQuery(dynamicQuery, start, end, orderByComparator);
 }
  /**
   * Adds the centro to the database. Also notifies the appropriate model listeners.
   *
   * @param centro the centro
   * @return the centro that was added
   * @throws SystemException if a system exception occurred
   */
  @Indexable(type = IndexableType.REINDEX)
  @Override
  public Centro addCentro(Centro centro) throws SystemException {
    centro.setNew(true);

    return centroPersistence.update(centro);
  }
  /**
   * Performs an SQL query.
   *
   * @param sql the sql query
   */
  protected void runSQL(String sql) throws SystemException {
    try {
      DataSource dataSource = centroPersistence.getDataSource();

      SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql, new int[0]);

      sqlUpdate.update();
    } catch (Exception e) {
      throw new SystemException(e);
    }
  }
 /**
  * Updates the centro in the database or adds it if it does not yet exist. Also notifies the
  * appropriate model listeners.
  *
  * @param centro the centro
  * @return the centro that was updated
  * @throws SystemException if a system exception occurred
  */
 @Indexable(type = IndexableType.REINDEX)
 @Override
 public Centro updateCentro(Centro centro) throws SystemException {
   return centroPersistence.update(centro);
 }
 /**
  * Returns the number of centros.
  *
  * @return the number of centros
  * @throws SystemException if a system exception occurred
  */
 @Override
 public int getCentrosCount() throws SystemException {
   return centroPersistence.countAll();
 }
 /**
  * Returns a range of all the centros.
  *
  * <p>Useful when paginating results. Returns a maximum of <code>end - start</code> instances.
  * <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result
  * set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start
  * </code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}
  * will return the full result set. If <code>orderByComparator</code> is specified, then the query
  * will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and
  * pagination is required (<code>start</code> and <code>end</code> are not {@link
  * com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default
  * ORDER BY logic from {@link ec.gob.snap.vuv.model.impl.CentroModelImpl}. If both <code>
  * orderByComparator</code> and pagination are absent, for performance reasons, the query will not
  * have an ORDER BY clause and the returned result set will be sorted on by the primary key in an
  * ascending order.
  *
  * @param start the lower bound of the range of centros
  * @param end the upper bound of the range of centros (not inclusive)
  * @return the range of centros
  * @throws SystemException if a system exception occurred
  */
 @Override
 public List<Centro> getCentros(int start, int end) throws SystemException {
   return centroPersistence.findAll(start, end);
 }
 @Override
 public PersistedModel getPersistedModel(Serializable primaryKeyObj)
     throws PortalException, SystemException {
   return centroPersistence.findByPrimaryKey(primaryKeyObj);
 }
 /**
  * Returns the centro with the primary key.
  *
  * @param id_centro the primary key of the centro
  * @return the centro
  * @throws PortalException if a centro with the primary key could not be found
  * @throws SystemException if a system exception occurred
  */
 @Override
 public Centro getCentro(long id_centro) throws PortalException, SystemException {
   return centroPersistence.findByPrimaryKey(id_centro);
 }
 @Override
 public Centro fetchCentro(long id_centro) throws SystemException {
   return centroPersistence.fetchByPrimaryKey(id_centro);
 }
 /**
  * Returns the number of rows that match the dynamic query.
  *
  * @param dynamicQuery the dynamic query
  * @param projection the projection to apply to the query
  * @return the number of rows that match the dynamic query
  * @throws SystemException if a system exception occurred
  */
 @Override
 public long dynamicQueryCount(DynamicQuery dynamicQuery, Projection projection)
     throws SystemException {
   return centroPersistence.countWithDynamicQuery(dynamicQuery, projection);
 }
 /**
  * Performs a dynamic query on the database and returns the matching rows.
  *
  * @param dynamicQuery the dynamic query
  * @return the matching rows
  * @throws SystemException if a system exception occurred
  */
 @Override
 @SuppressWarnings("rawtypes")
 public List dynamicQuery(DynamicQuery dynamicQuery) throws SystemException {
   return centroPersistence.findWithDynamicQuery(dynamicQuery);
 }
 /**
  * Deletes the centro from the database. Also notifies the appropriate model listeners.
  *
  * @param centro the centro
  * @return the centro that was removed
  * @throws SystemException if a system exception occurred
  */
 @Indexable(type = IndexableType.DELETE)
 @Override
 public Centro deleteCentro(Centro centro) throws SystemException {
   return centroPersistence.remove(centro);
 }
 /**
  * Deletes the centro with the primary key from the database. Also notifies the appropriate model
  * listeners.
  *
  * @param id_centro the primary key of the centro
  * @return the centro that was removed
  * @throws PortalException if a centro with the primary key could not be found
  * @throws SystemException if a system exception occurred
  */
 @Indexable(type = IndexableType.DELETE)
 @Override
 public Centro deleteCentro(long id_centro) throws PortalException, SystemException {
   return centroPersistence.remove(id_centro);
 }
 /**
  * Creates a new centro with the primary key. Does not add the centro to the database.
  *
  * @param id_centro the primary key for the new centro
  * @return the new centro
  */
 @Override
 public Centro createCentro(long id_centro) {
   return centroPersistence.create(id_centro);
 }