Package org.openbravo.model.ad.datamodel

Examples of org.openbravo.model.ad.datamodel.Table


    String parentObjectId = vars.getStringParameter("parentObjectId");
    if (parentObjectId == null || parentObjectId.equals("")) {
      boolean adminMode = OBContext.getOBContext().setInAdministratorMode(true);
      try {
        Table table = OBDal.getInstance().get(Table.class, vars.getStringParameter("inpTableId"));
        List<Column> cols = table.getADColumnList();
        String keyCol = "";
        for (Column col : cols) {
          if (col.isKeyColumn()) {
            keyCol = col.getDBColumnName();
            break;
          }
        }
        parentObjectId = vars.getStringParameter("inp" + Sqlc.TransformaNombreColumna(keyCol));
      } finally {
        OBContext.getOBContext().setInAdministratorMode(adminMode);
      }
    }
    if (vars.commandIn("DEFAULT")) {

      printPageFrame(response, vars, imageID, tableId, columnName, parentObjectId);
    } else if (vars.commandIn("SAVE")) {
      final FileItem fi = vars.getMultiFile("inpFile");
      byte[] bytea = fi.get();

      // Using DAL to write the image data to the database
      Image image;
      if (imageID == null || imageID.equals("")) {
        image = OBProvider.getInstance().get(Image.class);
        image.setBindaryData(bytea);
        image.setActive(true);
        image.setName("Image");
        OBDal.getInstance().save(image);
        OBDal.getInstance().flush();

      } else {
        image = OBDal.getInstance().get(Image.class, imageID);
        image.setActive(true);
        image.setBindaryData(bytea);
        OBDal.getInstance().flush();
      }
      response.setContentType("text/html; charset=UTF-8");
      PrintWriter writer = response.getWriter();
      writeRedirect(writer, image.getId(), columnName);
    } else if (vars.commandIn("DELETE")) {
      if (imageID != null && !imageID.equals("")) {
        boolean adminMode = OBContext.getOBContext().setInAdministratorMode(true);
        try {
          Image image = OBDal.getInstance().get(Image.class, imageID);
          Table table = OBDal.getInstance().get(Table.class, tableId);
          String propertyName = ModelProvider.getInstance().getEntityByTableName(
              table.getDBTableName()).getPropertyByColumnName(columnName).getName();
          DataPackage dpackage = table.getDataPackage();
          try {
            Class tableClass = Class.forName(dpackage.getJavaPackage() + "."
                + table.getJavaClassName());
            BaseOBObject parentObject = (BaseOBObject) OBDal.getInstance().get(tableClass,
                parentObjectId);
            parentObject.set(propertyName, null);
            OBDal.getInstance().flush();
            OBDal.getInstance().remove(image);
View Full Code Here


      }
      return entity;
    }
    if (property.getEntity().getName().equals(Alert.ENTITY_NAME)) {
      final Alert alert = (Alert) obObject;
      final Table table = alert.getAlertRule().getTab().getTable();
      final Entity entity = ModelProvider.getInstance().getEntity(table.getName());
      if (entity == null) {
        throw new OBException("No entity for table with name " + table.getName());
      }
      return entity;
    }
    if (property.getEntity().getName().equals(Attachment.ENTITY_NAME)) {
      final Attachment attachment = (Attachment) obObject;
View Full Code Here

   * Creates a table that is valid, it has a valid name according with the db prefix for the module
   * it is assigned to
   */
  public void testCreateTable1() {
    setUserContext("0");
    Table table = OBProvider.getInstance().get(Table.class);
    table.setName("TEST1_Table1");
    table.setDBTableName("TEST1_Table1");
    table.setDataAccessLevel("1");
    table.setJavaClassName("Table1");

    table.setDataPackage(getPackage("org.openbravo.test.tablename.data"));
    OBDal.getInstance().save(table);
    commitTransaction();
  }
View Full Code Here

   * It tries to insert a table with a non-valid name prefix, it is tested that DB raises an
   * exception and thus the table is not inserted.
   */
  public void testCreateTable2() {
    setUserContext("0");
    Table table = OBProvider.getInstance().get(Table.class);
    table.setName("TEST_Table2");
    table.setDBTableName("TEST_Table2");
    table.setDataAccessLevel("1");
    table.setJavaClassName("Table2");

    table.setDataPackage(getPackage("org.openbravo.test.tablename.data"));
    OBDal.getInstance().save(table);
    try {
      // force dal commit to throw exception
      commitTransaction();
      fail("Saved table but it shouldn't be");
View Full Code Here

   * Same test as testCreateTable2 but trying to insert the table in a package that for core module,
   * it should not insert anything
   */
  public void testCreateTable3() {
    setUserContext("0");
    Table table = OBProvider.getInstance().get(Table.class);
    table.setName("TEST1_Table3");
    table.setDBTableName("TEST1_Table3");
    table.setDataAccessLevel("1");
    table.setJavaClassName("Table3");

    table.setDataPackage(getPackage("org.openbravo.model.ad.module"));
    OBDal.getInstance().save(table);
    try {
      // force dal commit to throw exception
      commitTransaction();
      fail("Saved table but it shouldn't be");
View Full Code Here

  public void testChangePackage() {
    setUserContext("0");
    OBCriteria<Table> obCriteria = OBDal.getInstance().createCriteria(Table.class);
    obCriteria.add(Expression.eq(Module.PROPERTY_NAME, "TEST1_Table1"));
    List<Table> tables = obCriteria.list();
    Table table = tables.get(0);
    table.setDataPackage(getPackage("org.openbravo.model.ad.module"));
    OBDal.getInstance().save(table);
    try {
      // force dal commit to throw exception
      commitTransaction();
      fail("Saved table but it shouldn't be");
View Full Code Here

   * @see Table
   */
  public void testDataSetTable() {
    setUserContext("100");
    final DataSetTable dst = OBProvider.getInstance().get(DataSetTable.class);
    final Table t = OBProvider.getInstance().get(Table.class);
    t.setName("ADTable");
    dst.setTable(t);
    dst.setSQLWhereClause("(" + Table.PROPERTY_DELETABLERECORDS + "='N' or " + Table.PROPERTY_VIEW
        + "='N') and client.id='0'");
    final List<BaseOBObject> l = DataSetService.getInstance().getExportableObjects(dst, "0");
    for (final BaseOBObject bob : l) {
View Full Code Here

   * Test the System access level.
   */
  public void testAccessLevelSystem() {
    setUserContext("0");
    final Organization o = OBDal.getInstance().get(Organization.class, "1000002");
    final Table t = OBDal.getInstance().get(Table.class, "100");
    t.setOrganization(o);

    try {
      commitTransaction();
      fail();
    } catch (final OBException e) {
View Full Code Here

  private DataSetTable createDataSetTable(DataSet ds, String tableName) {
    final OBCriteria<Table> obcTable = OBDal.getInstance().createCriteria(Table.class);
    obcTable.add(Expression.eq(Table.PROPERTY_DBTABLENAME, tableName));
    assertTrue(obcTable.list().size() == 1);
    final Table table = obcTable.list().get(0);

    final DataSetTable dst = OBProvider.getInstance().get(DataSetTable.class);
    dst.setId("" + System.currentTimeMillis());
    dst.setClient(OBContext.getOBContext().getCurrentClient());
    dst.setOrganization(OBContext.getOBContext().getCurrentOrganization());
View Full Code Here

    // write the entities
    int cnt = 0;
    for (Entity entity : ModelProvider.getInstance().getModel()) {
      final Map<String, String> content = new HashMap<String, String>();
      final Table table = getTable(entity.getTableName());
      content.put("CONTENT", generateEntityPage(table, entity));
      content.put("ENTITY_NAME", entity.getName());
      content.put("ENTITY_HELP", (table.getHelpComment() != null ? table.getHelpComment() : ""));
      content.put("SOURCE", getJavaSourceCode(entity.getClassName()));
      content.put("BACK_TO_ENTITY_MODEL", "ERP/2.50/Developers_Guide/Reference/Entity_Model#"
          + entity.getName());
      content.put("TABLE_LINK", getLink("ERP/2.50/Developers_Guide/Database_Model/"
          + entity.getPackageName() + "/" + entity.getTableName(), "To the database table ("
View Full Code Here

TOP

Related Classes of org.openbravo.model.ad.datamodel.Table

Copyright © 2018 www.massapicom. All rights reserved.
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.