Package org.projectforge.continuousdb

Examples of org.projectforge.continuousdb.SchemaGenerator

134
135
136
137
138
139
140
141
142
143
144
        }
        if (dao.doTableAttributesExist(AuftragDO.class, "periodOfPerformanceBegin", "periodOfPerformanceEnd") == false) {
          dao.addTableAttributes(AuftragDO.class, "periodOfPerformanceBegin", "periodOfPerformanceEnd");
        }
        if (dao.doEntitiesExist(PaymentScheduleDO.class) == false) {
          new SchemaGenerator(dao).add(PaymentScheduleDO.class).createSchema();
          dao.createMissingIndices();
        }
        return UpdateRunningStatus.DONE;
      }
    });
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
      @Override
      public UpdateRunningStatus runUpdate()
      {
        // Create initial data-base table:
        new SchemaGenerator(dao).add(doClasses).createSchema();
        dao.createMissingIndices();
        return UpdateRunningStatus.DONE;
      }
    };
  }
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
      {
        if (dao.doExist(new Table(PFUserDO.class)) == false && HibernateUtils.getDialect() == DatabaseDialect.PostgreSQL) {
          // User table doesn't exist, therefore schema should be empty. PostgreSQL needs sequence for primary keys:
          dao.createSequence("hibernate_sequence", true);
        }
        final SchemaGenerator schemaGenerator = new SchemaGenerator(dao).add(HibernateEntities.CORE_ENTITIES).add(
            HibernateEntities.HISTORY_ENTITIES);
        final Table propertyDeltaTable = schemaGenerator.getTable(PropertyDelta.class);
        final TableAttribute attr = propertyDeltaTable.getAttributeByName("clazz");
        attr.setNullable(false).setType(TableAttributeType.VARCHAR).setLength(31); // Discriminator value is may-be not handled correctly by
        propertyDeltaTable.getAttributeByName("old_value").setLength(20000); // Increase length.
        propertyDeltaTable.getAttributeByName("new_value").setLength(20000); // Increase length.
        // continuous-db.
        final Table historyEntryTable = schemaGenerator.getTable(HistoryEntry.class);
        final TableAttribute typeAttr = historyEntryTable.getAttributeByName("type");
        typeAttr.setType(TableAttributeType.INT);
        schemaGenerator.createSchema();
        dao.createMissingIndices();

        return UpdateRunningStatus.DONE;
      }
    };
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
      @Override
      public UpdateRunningStatus runUpdate()
      {
        if (dao.doEntitiesExist(TeamEventAttachmentDO.class) == false) {
          dao.dropTable(new Table(TeamEventAttendeeDO.class).getName()); // Table wasn't in use yet.
          new SchemaGenerator(dao).add(TeamEventDO.class, TeamEventAttendeeDO.class, TeamEventAttachmentDO.class).createSchema();
        }
        if (dao.doTableAttributesExist(TeamEventDO.class, newEventAttributes52) == false) {
          dao.addTableAttributes(TeamEventDO.class, newEventAttributes52);
        }
        if (dao.doTableAttributesExist(TeamEventAttendeeDO.class, "number") == false) {
          dao.addTableAttributes(TeamEventAttendeeDO.class, "number");
        }
        return UpdateRunningStatus.DONE;
      }
    });
    // /////////////////////////////////////////////////////////////////
    // 5.1
    // /////////////////////////////////////////////////////////////////
    list.add(new UpdateEntryImpl(
        TeamCalPlugin.ID,
        "5.1",
        "2013-04-25",
        "Increase length of T_PLUGIN_CALENDAR_EVENT.NOTE (255-4000), re-create T_PLUGIN_CALENDAR_EVENT_ATTENDEE, add external subscription features (T_EVENT.abo*).") {
      final Table eventTable = new Table(TeamEventDO.class);

      @Override
      public UpdatePreCheckStatus runPreCheck()
      {
        // Does the data-base table already exist?
        if (dao.doTableAttributesExist(TeamEventAttendeeDO.class, "commentOfAttendee") == true
            && dao.doTableAttributesExist(TeamCalDO.class, newEventAttributes51) == true) {
          return UpdatePreCheckStatus.ALREADY_UPDATED;
        } else {
          return UpdatePreCheckStatus.READY_FOR_UPDATE;
        }
      }

      @Override
      public UpdateRunningStatus runUpdate()
      {
        if (dao.doTableAttributesExist(TeamEventAttendeeDO.class, "commentOfAttendee") == false) {
          dao.alterTableColumnVarCharLength(eventTable.getName(), "note", 4000);
          dao.dropTable(new Table(TeamEventAttendeeDO.class).getName()); // Table wasn't in use yet.
          // TeamEventDO is only needed for generating OneToMany relation with attendee table:
          new SchemaGenerator(dao).add(TeamEventDO.class, TeamEventAttendeeDO.class).createSchema();
        }
        if (dao.doTableAttributesExist(TeamCalDO.class, newEventAttributes51) == false) {
          dao.addTableAttributes(TeamCalDO.class, newEventAttributes51);
        }
        return UpdateRunningStatus.DONE;
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
      }

      @Override
      public UpdateRunningStatus runUpdate()
      {
        new SchemaGenerator(dao).add(doClasses).createSchema();
        dao.createMissingIndices();
        return UpdateRunningStatus.DONE;
      }

      /**
 
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
      }

      @Override
      public UpdateRunningStatus runUpdate()
      {
        new SchemaGenerator(dao).add(doClasses).createSchema();
        dao.createMissingIndices();
        return UpdateRunningStatus.DONE;
      }
    };
  }
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
      @Override
      public UpdateRunningStatus runUpdate()
      {
        // Create initial data-base table:
        new SchemaGenerator(dao).add(doClasses).createSchema();
        dao.createMissingIndices();
        return UpdateRunningStatus.DONE;
      }
    };
  }
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
      @Override
      public UpdateRunningStatus runUpdate()
      {
        // Create initial data-base table:
        new SchemaGenerator(dao).add(MemoDO.class).createSchema();
        dao.createMissingIndices();
        return UpdateRunningStatus.DONE;
      }
    };
  }
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
105
106
      @Override
      public UpdateRunningStatus runUpdate()
      {
        // Create initial data-base table:
        final SchemaGenerator schemaGenerator = new SchemaGenerator(dao);
        schemaGenerator.add(LicenseDO.class);
        schemaGenerator.createSchema();
        dao.createMissingIndices();
        return UpdateRunningStatus.DONE;
      }
    };
  }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
      }

      @Override
      public UpdateRunningStatus runUpdate()
      {
        new SchemaGenerator(dao).add(doClasses).createSchema();
        dao.createMissingIndices();
        return UpdateRunningStatus.DONE;
      }
    };
  }
View Full Code Here
TOP

Related Classes of org.projectforge.continuousdb.SchemaGenerator

  • org.projectforge.database.DatabaseCoreInitial
  • org.projectforge.database.DatabaseCoreUpdates
  • org.projectforge.plugins.banking.BankingPluginUpdates
  • org.projectforge.plugins.licensemanagement.LicenseManagementPluginUpdates
  • org.projectforge.plugins.liquidityplanning.LiquidityPlanningPluginUpdates
  • org.projectforge.plugins.marketing.MarketingPluginUpdates
  • org.projectforge.plugins.memo.MemoPluginUpdates
  • org.projectforge.plugins.poll.PollPluginUpdates
  • org.projectforge.plugins.skillmatrix.SkillMatrixPluginUpdates
  • org.projectforge.plugins.teamcal.TeamCalPluginUpdates
    • 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.