public int updateCampaignGroup(CampaignGroup cg) {
return pgJdbcTemplate.update(
"UPDATE ad_campaign_group SET name=?, update_date=NOW(), campaign_group_status=? WHERE id=?",
new Object[] {cg.getName(), cg.getCampaignGroupStatus(), cg.getId()});
}
public int insertCampaignGroup(CampaignGroup cg) {
return pgJdbcTemplate.update(
"INSERT INTO ad_campaign_group(id, name, objective, ad_account_id, create_date) "
+ "VALUES(?, ?, ?, ?, NOW())",
new Object[] {cg.getId(), cg.getName(), cg.getObjective(), cg.getAdAccountId()});
}