Examples of org.dspace.storage.rdbms.TableRowIterator

org.dspace.storage.rdbms.TableRowIterator
Represents the results of a database query @author Peter Breton @version $Revision: 3705 $

                if (!isFirstOccurrence(distinctIDs, i))
                    distinctIDs[i] = -1;
            }


            // Find all existing mappings for this item
            TableRowIterator tri = DatabaseManager.queryTable(context, table, "SELECT * FROM " + table + " WHERE item_id=?", itemID);
            if (tri != null)
            {
                try
                {
                    while (tri.hasNext())
                    {
                        TableRow tr = tri.next();


                        // Check the item mappings to see if it contains this mapping
                        boolean itemIsMapped = false;
                        int trDistinctID = tr.getIntColumn("distinct_id");
                        for (int i = 0; i < distinctIDs.length; i++)
                        {
                            // Found this mapping
                            if (distinctIDs[i] == trDistinctID)
                            {
                                // Flag it, and remove (-1) from the item mappings
                                itemIsMapped = true;
                                distinctIDs[i] = -1;
                            }
                        }


                        // The item is no longer mapped to this community, so remove the database record
                        if (!itemIsMapped)
                            DatabaseManager.delete(context, tr);
                    }
                }
                finally
                {
                    tri.close();
                }
            }


            // Any remaining mappings need to be added to the database
            for (int i = 0; i < distinctIDs.length; i++)

View Full Code Here

     * @see org.dspace.browse.BrowseCreateDAO#getDistinctID(java.lang.String, java.lang.String, java.lang.String)
     */
    public int getDistinctID(String table, String value, String authority, String sortValue)
        throws BrowseException
    {
        TableRowIterator tri = null;
        
        if (log.isDebugEnabled())
        {
            log.debug("getDistinctID: table=" + table + ",value=" + value + ",sortValue=" + sortValue);
        }
        
        try
        {
            Object[] params;
            String select;
      if (authority != null)
      {
        params = new Object[]{ value, authority };
      }
      else
      {
        params = new Object[]{ value };
      }


            if (ConfigurationManager.getBooleanProperty("webui.browse.metadata.case-insensitive", false))
            {
        if (authority != null)
              {               
                  select = "SELECT distinct_id FROM " + table + " WHERE UPPER(value) = UPPER(?) and authority = ?";
              }
              else
              {                  
                  select = "SELECT distinct_id FROM " + table + " WHERE UPPER(value) = UPPER(?) and authority IS NULL";
              }
            }
            else
            {
                select = "SELECT id FROM " + table + " WHERE value = ?";
        if (authority != null)
              {               
                  select = "SELECT distinct_id FROM " + table + " WHERE value = ? and authority = ?";
              }
              else
              {                  
                  select = "SELECT distinct_id FROM " + table + " WHERE value = ? and authority IS NULL";
              }
            }


            tri = DatabaseManager.query(context, select, params);
            int distinctID = -1;
            if (!tri.hasNext())
            {
                distinctID = insertDistinctRecord(table, value, authority, sortValue);
            }
            else
            {
                distinctID = tri.next().getIntColumn("distinct_id");
            }


            if (log.isDebugEnabled())
            {
                log.debug("getDistinctID: return=" + distinctID);
            }


            return distinctID;
        }
        catch (SQLException e)
        {
            log.error("caught exception: ", e);
            throw new BrowseException(e);
        }
        finally
        {
            if (tri != null)
            {
                tri.close();
            }
        }
    }

View Full Code Here

                if (!isFirstOccurrence(commID, i))
                    commID[i] = -1;
            }


            // Find all existing mappings for this item
            TableRowIterator tri = DatabaseManager.queryTable(context, "Communities2Item", "SELECT * FROM Communities2Item WHERE item_id=?", itemID);
            if (tri != null)
            {
                try
                {
                    while (tri.hasNext())
                    {
                        TableRow tr = tri.next();


                        // Check the item mappings to see if it contains this community mapping
                        boolean itemIsMapped = false;
                        int trCommID = tr.getIntColumn("community_id");
                        for (int i = 0; i < commID.length; i++)
                        {
                            // Found this community
                            if (commID[i] == trCommID)
                            {
                                // Flag it, and remove (-1) from the item mappings
                                itemIsMapped = true;
                                commID[i] = -1;
                            }
                        }


                        // The item is no longer mapped to this community, so remove the database record
                        if (!itemIsMapped)
                            DatabaseManager.delete(context, tr);
                    }
                }
                finally
                {
                    tri.close();
                }
            }


            // Any remaining mappings need to be added to the database
            for (int i = 0; i < commID.length; i++)

View Full Code Here

     */
    private int[] getAllCommunityIDs(int itemId) throws SQLException
    {
        List<Integer> commIdList = new ArrayList<Integer>();


        TableRowIterator tri = null;


        try
        {
            tri = DatabaseManager.queryTable(context, "Community2Item",
                        "SELECT * FROM Community2Item WHERE item_id=?", itemId);


            while (tri.hasNext())
            {
                TableRow row = tri.next();
                int commId = row.getIntColumn("community_id");
                commIdList.add(commId);


                // Get the parent community, and continue to get all ancestors
                Integer parentId = getParentCommunityID(commId);
                while (parentId != null)
                {
                    commIdList.add(parentId);
                    parentId = getParentCommunityID(parentId);
                }
            }
        }
        finally
        {
            if (tri != null)
                tri.close();
        }


        // Need to iterate the array as toArray will produce an array Integers,
        // not ints as we need.
        int[] cIds = new int[commIdList.size()];

View Full Code Here

     * @return
     * @throws SQLException
     */
    private Integer getParentCommunityID(int commId) throws SQLException
    {
        TableRowIterator tri = null;


        try
        {
            tri = DatabaseManager.queryTable(context, "Community2Community",
                        "SELECT * FROM Community2Community WHERE child_comm_id=?", commId);


            if (tri.hasNext())
            {
                return tri.next().getIntColumn("parent_comm_id");
            }
        }
        finally
        {
            if (tri != null)
                tri.close();
        }


        return null;
    }

View Full Code Here

     * @return List of <code>ResourcePolicy</code> objects
     */
    public static List<ResourcePolicy> getPolicies(Context c, DSpaceObject o)
            throws SQLException
    {
      TableRowIterator tri = DatabaseManager.queryTable(c, "resourcepolicy",
                "SELECT * FROM resourcepolicy WHERE resource_type_id= ? AND resource_id= ? ",
                o.getType(),o.getID());


        List<ResourcePolicy> policies = new ArrayList();


        try
        {
            while (tri.hasNext())
            {
                TableRow row = tri.next();


                // first check the cache (FIXME: is this right?)
                ResourcePolicy cachepolicy = (ResourcePolicy) c.fromCache(
                        ResourcePolicy.class, row.getIntColumn("policy_id"));


                if (cachepolicy != null)
                {
                    policies.add(cachepolicy);
                }
                else
                {
                    policies.add(new ResourcePolicy(c, row));
                }
            }
        }
        finally
        {
            if (tri != null)
                tri.close();
        }


        return policies;
    }

View Full Code Here

     * @return List of <code>ResourcePolicy</code> objects
     */
    public static List<ResourcePolicy> getPoliciesForGroup(Context c, Group g)
            throws SQLException
    {
      TableRowIterator tri = DatabaseManager.queryTable(c, "resourcepolicy",
                "SELECT * FROM resourcepolicy WHERE epersongroup_id= ? ",
                g.getID());


        List<ResourcePolicy> policies = new ArrayList<ResourcePolicy>();


        try
        {
            while (tri.hasNext())
            {
                TableRow row = tri.next();


                // first check the cache (FIXME: is this right?)
                ResourcePolicy cachepolicy = (ResourcePolicy) c.fromCache(
                        ResourcePolicy.class, row.getIntColumn("policy_id"));


                if (cachepolicy != null)
                {
                    policies.add(cachepolicy);
                }
                else
                {
                    policies.add(new ResourcePolicy(c, row));
                }
            }
        }
        finally
        {
            if (tri != null)
                tri.close();
        }


        return policies;
    }

View Full Code Here

     *             if there's a database problem
     */
    public static List<ResourcePolicy> getPoliciesActionFilter(Context c, DSpaceObject o,
            int actionID) throws SQLException
    {
      TableRowIterator tri = DatabaseManager.queryTable(c, "resourcepolicy",
                "SELECT * FROM resourcepolicy WHERE resource_type_id= ? "+
                "AND resource_id= ? AND action_id= ? ", 
                o.getType(), o.getID(),actionID);


        List<ResourcePolicy> policies = new ArrayList<ResourcePolicy>();


        try
        {
            while (tri.hasNext())
            {
                TableRow row = tri.next();


                // first check the cache (FIXME: is this right?)
                ResourcePolicy cachepolicy = (ResourcePolicy) c.fromCache(
                        ResourcePolicy.class, row.getIntColumn("policy_id"));


                if (cachepolicy != null)
                {
                    policies.add(cachepolicy);
                }
                else
                {
                    policies.add(new ResourcePolicy(c, row));
                }
            }
        }
        finally
        {
            if (tri != null)
                tri.close();
        }


        return policies;
    }

View Full Code Here

     */
    public static Group[] getAuthorizedGroups(Context c, DSpaceObject o,
            int actionID) throws java.sql.SQLException
    {
        // do query matching groups, actions, and objects
        TableRowIterator tri = DatabaseManager.queryTable(c, "resourcepolicy",
                "SELECT * FROM resourcepolicy WHERE resource_type_id= ? "+
                "AND resource_id= ? AND action_id= ? ",o.getType(),o.getID(),actionID);


        List<Group> groups = new ArrayList<Group>();
        try
        {


            while (tri.hasNext())
            {
                TableRow row = tri.next();


                // first check the cache (FIXME: is this right?)
                ResourcePolicy cachepolicy = (ResourcePolicy) c.fromCache(
                        ResourcePolicy.class, row.getIntColumn("policy_id"));


                ResourcePolicy myPolicy = null;


                if (cachepolicy != null)
                {
                    myPolicy = cachepolicy;
                }
                else
                {
                    myPolicy = new ResourcePolicy(c, row);
                }


                // now do we have a group?
                Group myGroup = myPolicy.getGroup();


                if (myGroup != null)
                {
                    groups.add(myGroup);
                }
            }
        }
        finally
        {
            if (tri != null)
                tri.close();
        }


        Group[] groupArray = new Group[groups.size()];
        groupArray = groups.toArray(groupArray);

View Full Code Here

     * return: list of collection id's
     * @throws SQLException 
     */
    public static List<Integer> findAll(Context c) throws SQLException 
    {
      TableRowIterator tri = DatabaseManager.queryTable(c, "harvested_collection",
          "SELECT * FROM harvested_collection");
      
      List<Integer> collectionIds = new ArrayList<Integer>();
      while (tri.hasNext())
      {
        TableRow row = tri.next();
        collectionIds.add(row.getIntColumn("collection_id"));
      }
      
      return collectionIds;
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.dspace.storage.rdbms.TableRowIterator

org.dspace.administer.Upgrade101To11

org.dspace.app.util.AbstractDSpaceWebapp

org.dspace.authorize.AuthorizeManager

org.dspace.browse.BrowseCreateDAOOracle

org.dspace.browse.BrowseCreateDAOPostgres

org.dspace.browse.BrowseDAOOracle

org.dspace.browse.BrowseDAOPostgres

org.dspace.browse.BrowseItemDAOOracle

org.dspace.browse.BrowseItemDAOPostgres

org.dspace.browse.ItemCountDAOOracle

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.