Examples of org.dspace.storage.rdbms.TableRow

org.dspace.storage.rdbms.TableRow
Represents a database row. @author Peter Breton @version $Revision: 4316 $

    catch (NumberFormatException e) {
      int_param = new Integer(-1);
    }
    
    // Get all the epeople that match the query
    TableRow row = DatabaseManager.querySingle(context,
            "SELECT count(*) as epcount FROM eperson WHERE eperson_id = ? OR " +
            "LOWER(firstname) LIKE LOWER(?) OR LOWER(lastname) LIKE LOWER(?) OR LOWER(email) LIKE LOWER(?)",
            new Object[] {int_param,dbquery,dbquery,dbquery});
        
    // use getIntColumn for Oracle count data
        if ("oracle".equals(ConfigurationManager.getProperty("db.name")))
        {
            count = new Long(row.getIntColumn("epcount"));
        }
        else  //getLongColumn works for postgres
        {
            count = new Long(row.getLongColumn("epcount"));
        }
        
    return count.intValue();
  }

View Full Code Here

                return new DCValue[0];
            }


            while (tri.hasNext())
            {
                TableRow tr = tri.next();
                DCValue dcv = new DCValue();
                dcv.schema = schema;
                dcv.element = tr.getStringColumn("element");
                dcv.qualifier = tr.getStringColumn("qualifier");
                dcv.language = tr.getStringColumn("text_lang");
                dcv.value = tr.getStringColumn("text_value");
                dcv.authority = tr.getStringColumn("authority");
                dcv.confidence = tr.getIntColumn("confidence");
                values.add(dcv);
            }
        }
        finally
        {

View Full Code Here


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


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


                // First check the cache
                EPerson fromCache = (EPerson) context.fromCache(EPerson.class, row
                        .getIntColumn("eperson_id"));


                if (fromCache != null)
                {
                    epeople[i] = fromCache;

View Full Code Here

            throw new AuthorizeException(
                    "You must be an admin to create an EPerson");
        }


        // Create a table row
        TableRow row = DatabaseManager.create(context, "eperson");


        EPerson e = new EPerson(context, row);


        log.info(LogManager.getHeader(context, "create_eperson", "eperson_id="
                + e.getID()));

View Full Code Here

     * @return The email address corresponding to token, or null.
     */
    public static String getEmail(Context context, String token)
            throws SQLException
    {
        TableRow rd = DatabaseManager.findByUnique(context, "RegistrationData",
                "token", token);


        if (rd == null)
        {
            return null;
        }


        /*
         * ignore the expiration date on tokens Date expires =
         * rd.getDateColumn("expires"); if (expires != null) { if ((new
         * java.util.Date()).after(expires)) return null; }
         */
        return rd.getStringColumn("email");
    }

View Full Code Here

    protected static TableRow sendInfo(Context context, String email,
            boolean isRegister, boolean send) throws SQLException, IOException,
            MessagingException, AuthorizeException
    {
        // See if a registration token already exists for this user
        TableRow rd = DatabaseManager.findByUnique(context, "registrationdata",
                "email", email);


        // If it already exists, just re-issue it
        if (rd == null)
        {
            rd = DatabaseManager.create(context, "RegistrationData");
            rd.setColumn("token", Utils.generateHexKey());


            // don't set expiration date any more
            //            rd.setColumn("expires", getDefaultExpirationDate());
            rd.setColumn("email", email);
            DatabaseManager.update(context, rd);


            // This is a potential problem -- if we create the callback
            // and then crash, registration will get SNAFU-ed.
            // So FIRST leave some breadcrumbs
            if (log.isDebugEnabled())
            {
                log.debug("Created callback "
                        + rd.getIntColumn("registrationdata_id")
                        + " with token " + rd.getStringColumn("token")
                        + " with email \"" + email + "\"");
            }
        }


        if (send)

View Full Code Here

      if (!tri.hasNext())
      {
        return 0;
      }
      
      TableRow tr = tri.next();
      
      if (tri.hasNext())
      {
        throw new ItemCountException("More than one count row in the database");
      }


      return tr.getIntColumn("count");
    }
    catch (SQLException e)
    {
      log.error("caught exception: ", e);
      throw new ItemCountException(e);

View Full Code Here

      if (!tri.hasNext())
      {
        return 0;
      }
      
      TableRow tr = tri.next();
      
      if (tri.hasNext())
      {
        throw new ItemCountException("More than one count row in the database");
      }


      return tr.getIntColumn("count");
    }
    catch (SQLException e)
    {
      log.error("caught exception: ", e);
      throw new ItemCountException(e);

View Full Code Here

        if (fromCache != null)
        {
            return fromCache;
        }


        TableRow row = DatabaseManager.find(context, "bitstream", id);


        if (row == null)
        {
            if (log.isDebugEnabled())
            {

View Full Code Here


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


                // First check the cache
                Bitstream fromCache = (Bitstream) context.fromCache(
                        Bitstream.class, row.getIntColumn("bitstream_id"));


                if (fromCache != null)
                {
                    bitstreams.add(fromCache);
                }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

org.dspace.administer.Upgrade101To11

org.dspace.app.cris.integration.BindItemToRP

org.dspace.app.cris.model.listener.RPResourcePolicyListener

org.dspace.app.requestitem.RequestItem

org.dspace.app.statistics.LogAnalyser

org.dspace.app.webui.servlet.RequestItemServlet

org.dspace.app.webui.util.RequestItemManager

org.dspace.app.xmlui.objectmanager.ItemAdapter

org.dspace.authorize.AuthorizeManager

org.dspace.authorize.ResourcePolicy

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.