Examples of TableRowIterator

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

Examples of org.dspace.storage.rdbms.TableRowIterator

    public static WorkflowItem[] findByEPerson(Context context, EPerson ep)
            throws SQLException
    {
        List wfItems = new ArrayList();


        TableRowIterator tri = DatabaseManager.queryTable(context, "workflowitem",
                "SELECT workflowitem.* FROM workflowitem, item WHERE " +
                "workflowitem.item_id=item.item_id AND " +
                "item.submitter_id= ? " + 
                "ORDER BY workflowitem.workflow_id",
                ep.getID());


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


                // Check the cache
                WorkflowItem wi = (WorkflowItem) context.fromCache(
                        WorkflowItem.class, row.getIntColumn("workflow_id"));


                if (wi == null)
                {
                    wi = new WorkflowItem(context, row);
                }


                wfItems.add(wi);
            }
        }
        finally
        {
            if (tri != null)
                tri.close();
        }


        WorkflowItem[] wfArray = new WorkflowItem[wfItems.size()];
        wfArray = (WorkflowItem[]) wfItems.toArray(wfArray);

View Full Code Here

Examples of org.dspace.storage.rdbms.TableRowIterator

    public static WorkflowItem[] findByCollection(Context context, Collection c)
            throws SQLException
    {
        List wsItems = new ArrayList();


        TableRowIterator tri = DatabaseManager.queryTable(context, "workflowitem",
                "SELECT workflowitem.* FROM workflowitem WHERE " +
                "workflowitem.collection_id= ? ",
                c.getID());


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


                // Check the cache
                WorkflowItem wi = (WorkflowItem) context.fromCache(
                        WorkflowItem.class, row.getIntColumn("workflow_id"));


                // not in cache? turn row into workflowitem
                if (wi == null)
                {
                    wi = new WorkflowItem(context, row);
                }


                wsItems.add(wi);
            }
        }
        finally
        {
            if (tri != null)
                tri.close();
        }


        WorkflowItem[] wsArray = new WorkflowItem[wsItems.size()];
        wsArray = (WorkflowItem[]) wsItems.toArray(wsArray);

View Full Code Here

Examples of org.dspace.storage.rdbms.TableRowIterator

        modified = false;
        dublinCore = new ArrayList<DCValue>();
        clearDetails();
 
        // Get Dublin Core metadata
        TableRowIterator tri = retrieveMetadata();


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


                // Get the associated metadata field and schema information
                int fieldID = resultRow.getIntColumn("metadata_field_id");
                MetadataField field = MetadataField.find(context, fieldID);


                if (field == null)
                {
                    log.error("Loading item - cannot found metadata field "
                            + fieldID);
                }
                else
                {
                    MetadataSchema schema = MetadataSchema.find(
                            context, field.getSchemaID());


                    // Make a DCValue object
                    DCValue dcv = new DCValue();
                        dcv.element = field.getElement();
                        dcv.qualifier = field.getQualifier();
                    dcv.value = resultRow.getStringColumn("text_value");
                    dcv.language = resultRow.getStringColumn("text_lang");
                        //dcv.namespace = schema.getNamespace();
                        dcv.schema = schema.getName();
                    dcv.authority = resultRow.getStringColumn("authority");
                    dcv.confidence = resultRow.getIntColumn("confidence");


                    // Add it to the list
                    dublinCore.add(dcv);
                }
            }
        }
        finally
        {
            // close the TableRowIterator to free up resources
            if (tri != null)
                tri.close();
        }


        // Get our Handle if any
        handle = HandleManager.findHandle(context, this);

View Full Code Here

Examples of org.dspace.storage.rdbms.TableRowIterator

     */
    public static ItemIterator findAll(Context context) throws SQLException
    {
        String myQuery = "SELECT * FROM item WHERE in_archive='1'";


        TableRowIterator rows = DatabaseManager.queryTable(context, "item", myQuery);


        return new ItemIterator(context, rows);
    }

View Full Code Here

Examples of org.dspace.storage.rdbms.TableRowIterator

            throws SQLException
    {
        String myQuery = "SELECT * FROM item WHERE in_archive='1' AND submitter_id="
                + eperson.getID();


        TableRowIterator rows = DatabaseManager.queryTable(context, "item", myQuery);


        return new ItemIterator(context, rows);
    }

View Full Code Here

Examples of org.dspace.storage.rdbms.TableRowIterator

    public Collection[] getCollections() throws SQLException
    {
        List<Collection> collections = new ArrayList<Collection>();


        // Get collection table rows
        TableRowIterator tri = DatabaseManager.queryTable(ourContext,"collection",
                        "SELECT collection.* FROM collection, collection2item WHERE " +
                        "collection2item.collection_id=collection.collection_id AND " +
                        "collection2item.item_id= ? ",
                        itemRow.getIntColumn("item_id"));


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


                // First check the cache
                Collection fromCache = (Collection) ourContext.fromCache(
                        Collection.class, row.getIntColumn("collection_id"));


                if (fromCache != null)
                {
                    collections.add(fromCache);
                }
                else
                {
                    collections.add(new Collection(ourContext, row));
                }
            }
        }
        finally
        {
            // close the TableRowIterator to free up resources
            if (tri != null)
                tri.close();
        }


        Collection[] collectionArray = new Collection[collections.size()];
        collectionArray = (Collection[]) collections.toArray(collectionArray);

View Full Code Here

Examples of org.dspace.storage.rdbms.TableRowIterator

    public Community[] getCommunities() throws SQLException
    {
        List<Community> communities = new ArrayList<Community>();


        // Get community table rows
        TableRowIterator tri = DatabaseManager.queryTable(ourContext,"community",
                        "SELECT community.* FROM community, community2item " +
                        "WHERE community2item.community_id=community.community_id " +
                        "AND community2item.item_id= ? ",
                        itemRow.getIntColumn("item_id"));


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


                // First check the cache
                Community owner = (Community) ourContext.fromCache(Community.class,
                        row.getIntColumn("community_id"));


                if (owner == null)
                {
                    owner = new Community(ourContext, row);
                }


                communities.add(owner);


                // now add any parent communities
                Community[] parents = owner.getAllParents();


                for (int i = 0; i < parents.length; i++)
                {
                    communities.add(parents[i]);
                }
            }
        }
        finally
        {
            // close the TableRowIterator to free up resources
            if (tri != null)
                tri.close();
        }


        Community[] communityArray = new Community[communities.size()];
        communityArray = (Community[]) communities.toArray(communityArray);

View Full Code Here

Examples of org.dspace.storage.rdbms.TableRowIterator

    {
        if (bundles == null)
        {
                bundles = new ArrayList<Bundle>();
                // Get bundles
                TableRowIterator tri = DatabaseManager.queryTable(ourContext, "bundle",
                                        "SELECT bundle.* FROM bundle, item2bundle WHERE " +
                                        "item2bundle.bundle_id=bundle.bundle_id AND " +
                                        "item2bundle.item_id= ? ",
                        itemRow.getIntColumn("item_id"));


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


                    // First check the cache
                    Bundle fromCache = (Bundle) ourContext.fromCache(Bundle.class,
                                                r.getIntColumn("bundle_id"));


                    if (fromCache != null)
                    {
                        bundles.add(fromCache);
                    }
                    else
                    {
                        bundles.add(new Bundle(ourContext, r));
                    }
                }
            }
            finally
            {
                // close the TableRowIterator to free up resources
                if (tri != null)
                    tri.close();
            }
        }
        
        Bundle[] bundleArray = new Bundle[bundles.size()];
        bundleArray = (Bundle[]) bundles.toArray(bundleArray);

View Full Code Here

Examples of org.dspace.storage.rdbms.TableRowIterator

                getID(), b.getID());


        ourContext.addEvent(new Event(Event.REMOVE, Constants.ITEM, getID(), Constants.BUNDLE, b.getID(), b.getName()));


        // If the bundle is orphaned, it's removed
        TableRowIterator tri = DatabaseManager.query(ourContext,
                "SELECT * FROM item2bundle WHERE bundle_id= ? ",
                b.getID());


        try
        {
            if (!tri.hasNext())
            {
                //make the right to remove the bundle explicit because the implicit
                // relation
                //has been removed. This only has to concern the currentUser
                // because
                //he started the removal process and he will end it too.
                //also add right to remove from the bundle to remove it's
                // bitstreams.
                AuthorizeManager.addPolicy(ourContext, b, Constants.DELETE,
                        ourContext.getCurrentUser());
                AuthorizeManager.addPolicy(ourContext, b, Constants.REMOVE,
                        ourContext.getCurrentUser());


                // The bundle is an orphan, delete it
                b.delete();
            }
        }
        finally
        {
            // close the TableRowIterator to free up resources
            if (tri != null)
                tri.close();
        }
    }

View Full Code Here

Examples of org.dspace.storage.rdbms.TableRowIterator

                }
            }


            // Now the precalculations are done, iterate through the existing metadata
            // looking for matches
            TableRowIterator tri = retrieveMetadata();
            if (tri != null)
            {
                try
                {
                    while (tri.hasNext())
                    {
                        TableRow tr = tri.next();
                        // Assume that we will remove this row, unless we get a match
                        boolean removeRow = true;


                        // Go through the in-memory metadata, unless we've already decided to keep this row
                        for (int dcIdx = 0; dcIdx < dublinCore.size() && removeRow; dcIdx++)
                        {
                            // Only process if this metadata has not already been matched to something in the DB
                            if (!storedDC[dcIdx])
                            {
                                boolean matched = true;
                                DCValue dcv   = dublinCore.get(dcIdx);


                                // Check the metadata field is the same
                                if (matched && dcFields[dcIdx].getFieldID() != tr.getIntColumn("metadata_field_id"))
                                    matched = false;


                                // Check the place is the same
                                if (matched && placeNum[dcIdx] != tr.getIntColumn("place"))
                                    matched = false;


                                // Check the text is the same
                                if (matched)
                                {
                                    String text = tr.getStringColumn("text_value");
                                    if (dcv.value == null && text == null)
                                        matched = true;
                                    else if (dcv.value != null && dcv.value.equals(text))
                                        matched = true;
                                    else
                                        matched = false;
                                }


                                // Check the language is the same
                                if (matched)
                                {
                                    String lang = tr.getStringColumn("text_lang");
                                    if (dcv.language == null && lang == null)
                                        matched = true;
                                    else if (dcv.language != null && dcv.language.equals(lang))
                                        matched = true;
                                    else
                                        matched = false;
                                }


                                // check that authority and confidence match
                                if (matched)
                                {
                                    String auth = tr.getStringColumn("authority");
                                    int conf = tr.getIntColumn("confidence");
                                    if (!((dcv.authority == null && auth == null) ||
                                      (dcv.authority != null && auth != null && dcv.authority.equals(auth))
                                     && dcv.confidence == conf))
                                        matched = false;
                                }


                                // If the db record is identical to the in memory values
                                if (matched)
                                {
                                    // Flag that the metadata is already in the DB
                                    storedDC[dcIdx] = true;


                                    // Flag that we are not going to remove the row
                                    removeRow = false;
                                }
                            }
                        }


                        // If after processing all the metadata values, we didn't find a match
                        // delete this row from the DB
                        if (removeRow)
                        {
                            DatabaseManager.delete(ourContext, tr);
                        }
                    }
                }
                finally
                {
                    tri.close();
                }
            }


            // Add missing in-memory DC
            for (int dcIdx = 0; dcIdx < dublinCore.size(); dcIdx++)

View Full Code Here

0 1 2 3 4 5

TOP

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.