Examples of org.dspace.storage.rdbms.TableRowIterator.toList()

Class org.dspace.storage.rdbms.TableRowIterator

Examples of org.dspace.storage.rdbms.TableRowIterator.toList()

org.dspace.storage.rdbms.TableRowIterator.toList()
Saves all the values returned by iterator into a list. As a side effect the result set is closed and no more operations can be preformed on this object. @return - A list of all the values returned by the iterator. @exception SQLException -If a database error occurs while fetching values


        // Get all the epeople that match the query
    TableRowIterator rows = DatabaseManager.query(context, dbquery, paramArr);
    try
        {
            List epeopleRows = rows.toList();
            EPerson[] epeople = new EPerson[epeopleRows.size()];


            for (int i = 0; i < epeopleRows.size(); i++)
            {
                TableRow row = (TableRow) epeopleRows.get(i);

View Full Code Here

        TableRowIterator rows = DatabaseManager.query(context,
                "SELECT * FROM eperson ORDER BY "+s);


        try
        {
            List epeopleRows = rows.toList();


            EPerson[] epeople = new EPerson[epeopleRows.size()];


            for (int i = 0; i < epeopleRows.size(); i++)
            {

View Full Code Here

            context, "epersongroup",
                "SELECT * FROM epersongroup ORDER BY "+s);


        try
        {
            List gRows = rows.toList();


            Group[] groups = new Group[gRows.size()];


            for (int i = 0; i < gRows.size(); i++)
            {

View Full Code Here

        TableRowIterator rows =
      DatabaseManager.query(context, dbquery, paramArr);


        try
        {
            List groupRows = rows.toList();
            Group[] groups = new Group[groupRows.size()];


            for (int i = 0; i < groupRows.size(); i++)
            {
                TableRow row = (TableRow) groupRows.get(i);

View Full Code Here

        }


        TableRowIterator rows = DatabaseManager.query(context, queryBuf.toString(), paramArr);


        try {
            List<TableRow> epeopleRows = rows.toList();


            EPerson[] epeople = new EPerson[epeopleRows.size()];


            for (int i = 0; i < epeopleRows.size(); i++) {
                TableRow row = epeopleRows.get(i);

View Full Code Here

        }


        // Get all the epeople that match the query
        TableRowIterator rows = DatabaseManager.query(context, queryBuf.toString(), paramArr);
        try {
            List<TableRow> epeopleRows = rows.toList();
            EPerson[] epeople = new EPerson[epeopleRows.size()];


            for (int i = 0; i < epeopleRows.size(); i++) {
                TableRow row = epeopleRows.get(i);

View Full Code Here

        TableRowIterator rows =
      DatabaseManager.query(context, dbquery, paramArr);


        try
        {
            List<TableRow> groupRows = rows.toList();
            Group[] groups = new Group[groupRows.size()];


            for (int i = 0; i < groupRows.size(); i++)
            {
                TableRow row = groupRows.get(i);

View Full Code Here

        );




        try
        {
            List<TableRow> gRows = rows.toList();


            Group[] groups = new Group[gRows.size()];


            for (int i = 0; i < gRows.size(); i++)
            {

View Full Code Here

    }


    public static int getNumberOfInProgressUsers(Context c, int wfiID) throws SQLException {
        TableRowIterator tri = DatabaseManager.queryTable(c,"cwf_in_progress_user",
                "SELECT * FROM cwf_in_progress_user WHERE workflowitem_id="+wfiID+" AND finished= '0'");
        return tri.toList().size();
    }


    public static int getNumberOfFinishedUsers(Context c, int wfiID) throws SQLException {
        TableRowIterator tri = DatabaseManager.queryTable(c,"cwf_in_progress_user",
                "SELECT * FROM cwf_in_progress_user WHERE workflowitem_id="+wfiID+" AND finished= '1'");

View Full Code Here

    }


    public static int getNumberOfFinishedUsers(Context c, int wfiID) throws SQLException {
        TableRowIterator tri = DatabaseManager.queryTable(c,"cwf_in_progress_user",
                "SELECT * FROM cwf_in_progress_user WHERE workflowitem_id="+wfiID+" AND finished= '1'");
        return tri.toList().size();
    }


    public static InProgressUser create(Context context) throws SQLException {


        TableRow row = DatabaseManager.create(context, "cwf_in_progress_user");

View Full Code Here

0 1

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.