title: ATG Repository API
body: <p>Im trying to update multiple records via an ATG class extending GenericService. 
  However im running against a roadblock. 
  How do I do a multiple insert query where i can keep adding all the items / rows into the cached object and then do a single command sync with the table using item.add()  ?</p>
  
  <p>Sample code</p>
  
  <p>the first part is to clear out the rows in the table before insertion happens (mighty helpful if anyone knows of a way to clear all rows in a table without having to loop through and delete one by one). </p>
  
  <pre><code>    MutableRepository repo = (MutableRepository) feedRepository;
      RepositoryView view = null; 
  
      try{
          view = getFeedRepository().getView(getFeedRepositoryFeedDataDescriptorName());
          RepositoryItem[] items = null;
          if(view != null){        
              QueryBuilder qb = view.getQueryBuilder();
              Query getFeedsQuery = qb.createUnconstrainedQuery();
              items = view.executeQuery(getFeedsQuery);
          }
          if(items != null &amp;&amp; items.length&gt;0){
              // remove all items in the repository
              for(RepositoryItem item :items){
                  repo.removeItem(item.getRepositoryId(), getFeedRepositoryFeedDataDescriptorName());
              }
          }
  
  
  
          for(RSSFeedObject rfo : feedEntries){
              MutableRepositoryItem feedItem = repo.createItem(getFeedRepositoryFeedDataDescriptorName());
  
              feedItem.setPropertyValue(DB_COL_AUTHOR, rfo.getAuthor());
              feedItem.setPropertyValue(DB_COL_FEEDURL, rfo.getFeedUrl());
              feedItem.setPropertyValue(DB_COL_TITLE, rfo.getTitle());
              feedItem.setPropertyValue(DB_COL_FEEDURL, rfo.getPublishedDate());
  
              RepositoryItem item = repo.addItem(feedItem) ;
          }
  </code></pre>