You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Heidi Dehaes - Olagos <in...@gmail.com> on 2016/01/13 13:59:29 UTC
creation of one table
Hello,
I upgraded from ofbiz version 11 to version 14.12 for the application files.
However i did not upgrade the database.
Now i see i don't have the new table "PRODUCT_KEYWORD_NEW".
How can i upgrade the database with the new table without touching the
other tables?
Can i do a simple "install" or will this delete the content of all the
other tables?
<entity entity-name="ProductKeyword" table-name="PRODUCT_KEYWORD_NEW"
package-name="org.ofbiz.product.product" title="Product Keyword
Entity" never-cache="true">
<field name="productId" type="id-ne"></field>
<field name="keyword" type="short-varchar"></field>
<field name="keywordTypeId" type="id-ne"></field>
<field name="relevancyWeight" type="numeric"></field>
<field name="statusId" type="id-ne"></field>
<prim-key field="productId"/>
<prim-key field="keyword"/>
<prim-key field="keywordTypeId"/>
<relation type="one" fk-name="PROD_KWD_PROD_NEW"
rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_KWD_TYPE"
rel-entity-name="Enumeration">
<key-map field-name="keywordTypeId" rel-field-name="enumId"/>
</relation>
<relation type="one" fk-name="PROD_KWD_STTS"
rel-entity-name="StatusItem">
<key-map field-name="statusId"/>
</relation>
<index name="PROD_KWD_KWD_NEW">
<index-field name="keyword"/>
</index>
</entity>
Regards,
Eric
Olagos bvba
Heidi Dehaes
Kerkstraat 34
2570 Duffel
Belgium
Tel. : 015/31 53 04
GSM : 0485/22 35 80
E-mail : info.olagos@gmail.com
http://www.olagos.eu
http://www.olagos.com
http://www.olagos.be
http://www.olagos.nl
Re: creation of one table
Posted by Deepak Dixit <de...@hotwaxsystems.com>.
Hi Eric,
Please refer entityengine.xml file, in the datasource section we have two
option:
check-on-start="true"
add-missing-on-start="true"
Please make sure in your entityengie.xml file thee are set to true,
this will automatically add new table and fields in table.
Please note that
- This only add new table and field,
- If you made changes in composite primary key then you need to
manually alter table form database.
For more reference please refer following document:
https://cwiki.apache.org/confluence/x/1IDfAg
Thanks & Regards
--
Deepak Dixit
www.hotwaxsystems.com
On Thu, May 5, 2016 at 10:23 AM, Rishi Solanki <ri...@gmail.com>
wrote:
> Eric,
>
> Your old entity PRODUCT_KEYWORD should exists with delegator/OFBiz entity
> name as OldProductKeyword. As you are upgrading then I think you would like
> to use new ProductKeyword entity with enhancement added. You have two
> options here as;
> - re-generate the contents and just run the generate keywords routine.
> - Or use the migrateProductKeyword service to migrate the data from
> OldProductKeyword to ProductKeyword entity you shared.
>
>
> As a general practice, if any changes done in OFBiz entity then
> migrateEntityName service exists for resolving compatibility issue. Refer -
>
> https://cwiki.apache.org/confluence/display/OFBIZ/General+Entity+Overview#GeneralEntityOverview-DeprecatedEntities
>
> HTH!
>
> --
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
>
> On Wed, Jan 13, 2016 at 6:29 PM, Heidi Dehaes - Olagos <
> info.olagos@gmail.com> wrote:
>
> > Hello,
> >
> > I upgraded from ofbiz version 11 to version 14.12 for the application
> > files.
> > However i did not upgrade the database.
> >
> > Now i see i don't have the new table "PRODUCT_KEYWORD_NEW".
> >
> > How can i upgrade the database with the new table without touching the
> > other tables?
> >
> > Can i do a simple "install" or will this delete the content of all the
> > other tables?
> >
> >
> >
> > <entity entity-name="ProductKeyword" table-name="PRODUCT_KEYWORD_NEW"
> > package-name="org.ofbiz.product.product" title="Product
> Keyword
> > Entity" never-cache="true">
> > <field name="productId" type="id-ne"></field>
> > <field name="keyword" type="short-varchar"></field>
> > <field name="keywordTypeId" type="id-ne"></field>
> > <field name="relevancyWeight" type="numeric"></field>
> > <field name="statusId" type="id-ne"></field>
> > <prim-key field="productId"/>
> > <prim-key field="keyword"/>
> > <prim-key field="keywordTypeId"/>
> > <relation type="one" fk-name="PROD_KWD_PROD_NEW"
> > rel-entity-name="Product">
> > <key-map field-name="productId"/>
> > </relation>
> > <relation type="one" fk-name="PROD_KWD_TYPE"
> > rel-entity-name="Enumeration">
> > <key-map field-name="keywordTypeId" rel-field-name="enumId"/>
> > </relation>
> > <relation type="one" fk-name="PROD_KWD_STTS"
> > rel-entity-name="StatusItem">
> > <key-map field-name="statusId"/>
> > </relation>
> > <index name="PROD_KWD_KWD_NEW">
> > <index-field name="keyword"/>
> > </index>
> > </entity>
> >
> >
> > Regards,
> > Eric
> >
> > Olagos bvba
> > Heidi Dehaes
> > Kerkstraat 34
> > 2570 Duffel
> > Belgium
> > Tel. : 015/31 53 04
> > GSM : 0485/22 35 80
> > E-mail : info.olagos@gmail.com
> > http://www.olagos.eu
> > http://www.olagos.com
> > http://www.olagos.be
> > http://www.olagos.nl
> >
>
Re: creation of one table
Posted by Rishi Solanki <ri...@gmail.com>.
Eric,
Your old entity PRODUCT_KEYWORD should exists with delegator/OFBiz entity
name as OldProductKeyword. As you are upgrading then I think you would like
to use new ProductKeyword entity with enhancement added. You have two
options here as;
- re-generate the contents and just run the generate keywords routine.
- Or use the migrateProductKeyword service to migrate the data from
OldProductKeyword to ProductKeyword entity you shared.
As a general practice, if any changes done in OFBiz entity then
migrateEntityName service exists for resolving compatibility issue. Refer -
https://cwiki.apache.org/confluence/display/OFBIZ/General+Entity+Overview#GeneralEntityOverview-DeprecatedEntities
HTH!
--
Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
On Wed, Jan 13, 2016 at 6:29 PM, Heidi Dehaes - Olagos <
info.olagos@gmail.com> wrote:
> Hello,
>
> I upgraded from ofbiz version 11 to version 14.12 for the application
> files.
> However i did not upgrade the database.
>
> Now i see i don't have the new table "PRODUCT_KEYWORD_NEW".
>
> How can i upgrade the database with the new table without touching the
> other tables?
>
> Can i do a simple "install" or will this delete the content of all the
> other tables?
>
>
>
> <entity entity-name="ProductKeyword" table-name="PRODUCT_KEYWORD_NEW"
> package-name="org.ofbiz.product.product" title="Product Keyword
> Entity" never-cache="true">
> <field name="productId" type="id-ne"></field>
> <field name="keyword" type="short-varchar"></field>
> <field name="keywordTypeId" type="id-ne"></field>
> <field name="relevancyWeight" type="numeric"></field>
> <field name="statusId" type="id-ne"></field>
> <prim-key field="productId"/>
> <prim-key field="keyword"/>
> <prim-key field="keywordTypeId"/>
> <relation type="one" fk-name="PROD_KWD_PROD_NEW"
> rel-entity-name="Product">
> <key-map field-name="productId"/>
> </relation>
> <relation type="one" fk-name="PROD_KWD_TYPE"
> rel-entity-name="Enumeration">
> <key-map field-name="keywordTypeId" rel-field-name="enumId"/>
> </relation>
> <relation type="one" fk-name="PROD_KWD_STTS"
> rel-entity-name="StatusItem">
> <key-map field-name="statusId"/>
> </relation>
> <index name="PROD_KWD_KWD_NEW">
> <index-field name="keyword"/>
> </index>
> </entity>
>
>
> Regards,
> Eric
>
> Olagos bvba
> Heidi Dehaes
> Kerkstraat 34
> 2570 Duffel
> Belgium
> Tel. : 015/31 53 04
> GSM : 0485/22 35 80
> E-mail : info.olagos@gmail.com
> http://www.olagos.eu
> http://www.olagos.com
> http://www.olagos.be
> http://www.olagos.nl
>