@Test public void getUpdateQuery() { final String queryWithTenantId = "UPDATE egasset_asset SET assetcategory=?,name=?,department=?,assetdetails=?,description=?,remarks=?,length=?,width=?," + "totalarea=?,modeofacquisition=?,status=?,zone=?,revenueward=?,street=?,electionward=?,doorno=?,pincode=?,locality=?," + "block=?,properties=?,lastmodifiedby=?,lastmodifieddate=?,grossvalue=?,accumulateddepreciation=?,assetreference=?,version=?," + "surveynumber=?,marketvalue=?,function=?,scheme=?,subscheme=?,purchaseValue=?,purchaseDate=?," + "constructionValue=?,acquisitionValue=?,acquisitionDate=?,notApplicableForSaleOrDisposal=?," + " donationDate=?,constructionDate=? WHERE code=? and tenantid=?"; assertEquals(queryWithTenantId, assetQueryBuilder.getUpdateQuery()); }
public String getUpdateQuery() { return "UPDATE egasset_asset SET assetcategory=?,name=?,department=?,assetdetails=?,description=?,remarks=?,length=?,width=?," + "totalarea=?,modeofacquisition=?,status=?,zone=?,revenueward=?,street=?,electionward=?,doorno=?,pincode=?,locality=?," + "block=?,properties=?,lastmodifiedby=?,lastmodifieddate=?,grossvalue=?,accumulateddepreciation=?,assetreference=?,version=?," + "surveynumber=?,marketvalue=?,function=?,scheme=?,subscheme=?,purchaseValue=?,purchaseDate=?," + "constructionValue=?,acquisitionValue=?,acquisitionDate=?,notApplicableForSaleOrDisposal=?," + " donationDate=?,constructionDate=? WHERE code=? and tenantid=?"; }
AssetQueryBuilder { public String getUpdateQuery() { return "UPDATE egasset_asset SET assetcategory=?,name=?,department=?,assetdetails=?,description=?,remarks=?,length=?,width=?," + "totalarea=?,modeofacquisition=?,status=?,zone=?,revenueward=?,street=?,electionward=?,doorno=?,pincode=?,locality=?," + "block=?,properties=?,lastmodifiedby=?,lastmodifieddate=?,grossvalue=?,accumulateddepreciation=?,assetreference=?,version=?," + "surveynumber=?,marketvalue=?,function=?,scheme=?,subscheme=?,purchaseValue=?,purchaseDate=?," + "constructionValue=?,acquisitionValue=?,acquisitionDate=?,notApplicableForSaleOrDisposal=?," + " donationDate=?,constructionDate=? WHERE code=? and tenantid=?"; } }
AssetQueryBuilder { public String getUpdateQuery() { return "UPDATE egasset_asset SET assetcategory=?,name=?,department=?,assetdetails=?,description=?,remarks=?,length=?,width=?," + "totalarea=?,modeofacquisition=?,status=?,zone=?,revenueward=?,street=?,electionward=?,doorno=?,pincode=?,locality=?," + "block=?,properties=?,lastmodifiedby=?,lastmodifieddate=?,grossvalue=?,accumulateddepreciation=?,assetreference=?,version=?," + "surveynumber=?,marketvalue=?,function=?,scheme=?,subscheme=?,purchaseValue=?,purchaseDate=?," + "constructionValue=?,acquisitionValue=?,acquisitionDate=?,notApplicableForSaleOrDisposal=?," + " donationDate=?,constructionDate=? WHERE code=? and tenantid=?"; }  }
AssetQueryBuilder { public String getUpdateQuery() { return "UPDATE egasset_asset SET assetcategory=?,name=?,department=?,assetdetails=?,description=?,remarks=?,length=?,width=?," + "totalarea=?,modeofacquisition=?,status=?,zone=?,revenueward=?,street=?,electionward=?,doorno=?,pincode=?,locality=?," + "block=?,properties=?,lastmodifiedby=?,lastmodifieddate=?,grossvalue=?,accumulateddepreciation=?,assetreference=?,version=?," + "surveynumber=?,marketvalue=?,function=?,scheme=?,subscheme=?,purchaseValue=?,purchaseDate=?," + "constructionValue=?,acquisitionValue=?,acquisitionDate=?,notApplicableForSaleOrDisposal=?," + " donationDate=?,constructionDate=? WHERE code=? and tenantid=?"; }  @SuppressWarnings("rawtypes") String getQuery(final AssetCriteria searchAsset, final List preparedStatementValues); @SuppressWarnings({ "rawtypes", "unchecked" }) String getHistoryQuery(final List<Long> assetIds, final String tenantid); String getInsertQuery(); String getUpdateQuery(); @SuppressWarnings("rawtypes") String getPaginatedQuery(final AssetCriteria searchAsset, final List preparedStatementValues); }
AssetQueryBuilder { public String getUpdateQuery() { return "UPDATE egasset_asset SET assetcategory=?,name=?,department=?,assetdetails=?,description=?,remarks=?,length=?,width=?," + "totalarea=?,modeofacquisition=?,status=?,zone=?,revenueward=?,street=?,electionward=?,doorno=?,pincode=?,locality=?," + "block=?,properties=?,lastmodifiedby=?,lastmodifieddate=?,grossvalue=?,accumulateddepreciation=?,assetreference=?,version=?," + "surveynumber=?,marketvalue=?,function=?,scheme=?,subscheme=?,purchaseValue=?,purchaseDate=?," + "constructionValue=?,acquisitionValue=?,acquisitionDate=?,notApplicableForSaleOrDisposal=?," + " donationDate=?,constructionDate=? WHERE code=? and tenantid=?"; }  @SuppressWarnings("rawtypes") String getQuery(final AssetCriteria searchAsset, final List preparedStatementValues); @SuppressWarnings({ "rawtypes", "unchecked" }) String getHistoryQuery(final List<Long> assetIds, final String tenantid); String getInsertQuery(); String getUpdateQuery(); @SuppressWarnings("rawtypes") String getPaginatedQuery(final AssetCriteria searchAsset, final List preparedStatementValues); final static String FINDBYNAMEQUERY; }