@Test public void getInsertQuery() { final String queryWithTenantId = "INSERT into egasset_asset(id,assetcategory,name,code,department,assetdetails,description," + "dateofcreation,remarks,length,width,totalarea,modeofacquisition,status,tenantid," + "zone,revenueward,street,electionward,doorno,pincode,locality,block,properties,createdby," + "createddate,lastmodifiedby,lastmodifieddate,grossvalue,accumulateddepreciation,assetreference,version," + "depreciationrate,surveynumber,marketvalue,function,scheme,subscheme,purchaseValue,purchaseDate,constructionValue," + " acquisitionValue,acquisitionDate,notApplicableForSaleOrDisposal,donationDate,constructionDate)" + "values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?," + "?,?,?,?,?,?,?,?)"; assertEquals(queryWithTenantId, assetQueryBuilder.getInsertQuery()); }
public String getInsertQuery() { return "INSERT into egasset_asset(id,assetcategory,name,code,department,assetdetails,description," + "dateofcreation,remarks,length,width,totalarea,modeofacquisition,status,tenantid," + "zone,revenueward,street,electionward,doorno,pincode,locality,block,properties,createdby," + "createddate,lastmodifiedby,lastmodifieddate,grossvalue,accumulateddepreciation,assetreference,version," + "depreciationrate,surveynumber,marketvalue,function,scheme,subscheme,purchaseValue,purchaseDate,constructionValue," + " acquisitionValue,acquisitionDate,notApplicableForSaleOrDisposal,donationDate,constructionDate)" + "values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?," + "?,?,?,?,?,?,?,?)"; }
AssetQueryBuilder { public String getInsertQuery() { return "INSERT into egasset_asset(id,assetcategory,name,code,department,assetdetails,description," + "dateofcreation,remarks,length,width,totalarea,modeofacquisition,status,tenantid," + "zone,revenueward,street,electionward,doorno,pincode,locality,block,properties,createdby," + "createddate,lastmodifiedby,lastmodifieddate,grossvalue,accumulateddepreciation,assetreference,version," + "depreciationrate,surveynumber,marketvalue,function,scheme,subscheme,purchaseValue,purchaseDate,constructionValue," + " acquisitionValue,acquisitionDate,notApplicableForSaleOrDisposal,donationDate,constructionDate)" + "values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?," + "?,?,?,?,?,?,?,?)"; } }
AssetQueryBuilder { public String getInsertQuery() { return "INSERT into egasset_asset(id,assetcategory,name,code,department,assetdetails,description," + "dateofcreation,remarks,length,width,totalarea,modeofacquisition,status,tenantid," + "zone,revenueward,street,electionward,doorno,pincode,locality,block,properties,createdby," + "createddate,lastmodifiedby,lastmodifieddate,grossvalue,accumulateddepreciation,assetreference,version," + "depreciationrate,surveynumber,marketvalue,function,scheme,subscheme,purchaseValue,purchaseDate,constructionValue," + " acquisitionValue,acquisitionDate,notApplicableForSaleOrDisposal,donationDate,constructionDate)" + "values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?," + "?,?,?,?,?,?,?,?)"; }  }
AssetQueryBuilder { public String getInsertQuery() { return "INSERT into egasset_asset(id,assetcategory,name,code,department,assetdetails,description," + "dateofcreation,remarks,length,width,totalarea,modeofacquisition,status,tenantid," + "zone,revenueward,street,electionward,doorno,pincode,locality,block,properties,createdby," + "createddate,lastmodifiedby,lastmodifieddate,grossvalue,accumulateddepreciation,assetreference,version," + "depreciationrate,surveynumber,marketvalue,function,scheme,subscheme,purchaseValue,purchaseDate,constructionValue," + " acquisitionValue,acquisitionDate,notApplicableForSaleOrDisposal,donationDate,constructionDate)" + "values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?," + "?,?,?,?,?,?,?,?)"; }  @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 getInsertQuery() { return "INSERT into egasset_asset(id,assetcategory,name,code,department,assetdetails,description," + "dateofcreation,remarks,length,width,totalarea,modeofacquisition,status,tenantid," + "zone,revenueward,street,electionward,doorno,pincode,locality,block,properties,createdby," + "createddate,lastmodifiedby,lastmodifieddate,grossvalue,accumulateddepreciation,assetreference,version," + "depreciationrate,surveynumber,marketvalue,function,scheme,subscheme,purchaseValue,purchaseDate,constructionValue," + " acquisitionValue,acquisitionDate,notApplicableForSaleOrDisposal,donationDate,constructionDate)" + "values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?," + "?,?,?,?,?,?,?,?)"; }  @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; }