/**
* 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 fi.csc.avaa.kotus.kielikartastot.db.model.impl.IlmioModelImpl}. 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 ilmioPersistence.findWithDynamicQuery(dynamicQuery, start, end, orderByComparator);
}
/**
* Adds the ilmio to the database. Also notifies the appropriate model listeners.
*
* @param ilmio the ilmio
* @return the ilmio that was added
* @throws SystemException if a system exception occurred
*/
@Indexable(type = IndexableType.REINDEX)
@Override
public Ilmio addIlmio(Ilmio ilmio) throws SystemException {
ilmio.setNew(true);
return ilmioPersistence.update(ilmio);
}
/**
* Performs an SQL query.
*
* @param sql the sql query
*/
protected void runSQL(String sql) throws SystemException {
try {
DataSource dataSource = ilmioPersistence.getDataSource();
SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource, sql, new int[0]);
sqlUpdate.update();
} catch (Exception e) {
throw new SystemException(e);
}
}
/**
* Updates the ilmio in the database or adds it if it does not yet exist. Also notifies the
* appropriate model listeners.
*
* @param ilmio the ilmio
* @return the ilmio that was updated
* @throws SystemException if a system exception occurred
*/
@Indexable(type = IndexableType.REINDEX)
@Override
public Ilmio updateIlmio(Ilmio ilmio) throws SystemException {
return ilmioPersistence.update(ilmio);
}
/**
* Returns the number of ilmios.
*
* @return the number of ilmios
* @throws SystemException if a system exception occurred
*/
@Override
public int getIlmiosCount() throws SystemException {
return ilmioPersistence.countAll();
}
/**
* Returns a range of all the ilmios.
*
* <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 fi.csc.avaa.kotus.kielikartastot.db.model.impl.IlmioModelImpl}. 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 ilmios
* @param end the upper bound of the range of ilmios (not inclusive)
* @return the range of ilmios
* @throws SystemException if a system exception occurred
*/
@Override
public List<Ilmio> getIlmios(int start, int end) throws SystemException {
return ilmioPersistence.findAll(start, end);
}
@Override
public PersistedModel getPersistedModel(Serializable primaryKeyObj)
throws PortalException, SystemException {
return ilmioPersistence.findByPrimaryKey(primaryKeyObj);
}
/**
* Returns the ilmio with the primary key.
*
* @param ilmio_id the primary key of the ilmio
* @return the ilmio
* @throws PortalException if a ilmio with the primary key could not be found
* @throws SystemException if a system exception occurred
*/
@Override
public Ilmio getIlmio(int ilmio_id) throws PortalException, SystemException {
return ilmioPersistence.findByPrimaryKey(ilmio_id);
}
@Override
public Ilmio fetchIlmio(int ilmio_id) throws SystemException {
return ilmioPersistence.fetchByPrimaryKey(ilmio_id);
}
/**
* 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 ilmioPersistence.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 ilmioPersistence.findWithDynamicQuery(dynamicQuery);
}
/**
* Deletes the ilmio from the database. Also notifies the appropriate model listeners.
*
* @param ilmio the ilmio
* @return the ilmio that was removed
* @throws SystemException if a system exception occurred
*/
@Indexable(type = IndexableType.DELETE)
@Override
public Ilmio deleteIlmio(Ilmio ilmio) throws SystemException {
return ilmioPersistence.remove(ilmio);
}
/**
* Deletes the ilmio with the primary key from the database. Also notifies the appropriate model
* listeners.
*
* @param ilmio_id the primary key of the ilmio
* @return the ilmio that was removed
* @throws PortalException if a ilmio with the primary key could not be found
* @throws SystemException if a system exception occurred
*/
@Indexable(type = IndexableType.DELETE)
@Override
public Ilmio deleteIlmio(int ilmio_id) throws PortalException, SystemException {
return ilmioPersistence.remove(ilmio_id);
}
/**
* Creates a new ilmio with the primary key. Does not add the ilmio to the database.
*
* @param ilmio_id the primary key for the new ilmio
* @return the new ilmio
*/
@Override
public Ilmio createIlmio(int ilmio_id) {
return ilmioPersistence.create(ilmio_id);
}
