Class OltDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.bgb.getolt.dao.OltDAO

public class OltDAO
extends CommonDAO

Nested Class Summary

Nested classes/interfaces inherited from class CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T>

Field Summary

Fields inherited from class CommonDAO

con, log, SQL_AND, SQL_DELETE, SQL_DELETE_FROM, SQL_DESC, SQL_DISTINCT, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT_IGNORE_INTO, SQL_INSERT_INTO, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UNION_ALL, SQL_UPDATE, SQL_VALUES, SQL_VALUES_1, SQL_VALUES_2, SQL_VALUES_3, SQL_VALUES_4, SQL_VALUES_5, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
OltDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	delete(int id)
List<Olt>	getAll()
List<Olt>	getByBillings(Set<String> billings)
Olt	getById(int id)
Olt	getByIp(String ip)
List<String>	getDistinctBillings()
List<String>	getDistinctStatuses()
List<String>	getDistinctVendors()
List<Olt>	getFiltered(Set<String> billings, Set<String> statuses, Set<String> vendors, Set<Integer> oltIds)	Filtered query by billing, status, vendor, and optional OLT IDs.
List<Olt>	getStale(int staleMinutes, int limit)
int	insert(Olt olt)
void	insertOrUpdate(Olt olt)
int	resetStuckUpdating()	Resets OLTs stuck in UPDATING status back to NEW (e.g.
void	update(Olt olt)
void	updatePortCount(int oltId, int portCount)
void	updateStatus(int oltId, OltStatus status)

Methods inherited from class CommonDAO

deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

OltDAO

public OltDAO(Connection con)

Method Details

getAll

public List<Olt> getAll()
                 throws SQLException

Throws:

SQLException

getByIp

public Olt getByIp(String ip)
            throws SQLException

Throws:

SQLException

getById

public Olt getById(int id)
            throws SQLException

Throws:

SQLException

getStale

public List<Olt> getStale(int staleMinutes,
 int limit)
                   throws SQLException

Throws:

SQLException

update

public void update(Olt olt)
            throws SQLException

Throws:

SQLException

insert

public int insert(Olt olt)
           throws SQLException

Throws:

SQLException

insertOrUpdate

public void insertOrUpdate(Olt olt)
                    throws SQLException

Throws:

SQLException

updateStatus

public void updateStatus(int oltId,
 OltStatus status)
                  throws SQLException

Throws:

SQLException

resetStuckUpdating

public int resetStuckUpdating()
                       throws SQLException

Resets OLTs stuck in UPDATING status back to NEW (e.g. after server restart).

Returns:

number of reset OLTs

Throws:

SQLException

delete

public void delete(int id)
            throws SQLException

Throws:

SQLException

updatePortCount

public void updatePortCount(int oltId,
 int portCount)
                     throws SQLException

Throws:

SQLException

getDistinctBillings

public List<String> getDistinctBillings()
                                 throws SQLException

Throws:

SQLException

getDistinctVendors

public List<String> getDistinctVendors()
                                throws SQLException

Throws:

SQLException

getDistinctStatuses

public List<String> getDistinctStatuses()
                                 throws SQLException

Throws:

SQLException

getByBillings

public List<Olt> getByBillings(Set<String> billings)
                        throws SQLException

Throws:

SQLException

getFiltered

public List<Olt> getFiltered(Set<String> billings,
 Set<String> statuses,
 Set<String> vendors,
 Set<Integer> oltIds)
                      throws SQLException

Filtered query by billing, status, vendor, and optional OLT IDs. Empty sets mean "no filter".

Throws:

SQLException