Re: Equivalent Steps for Creating Sample Data

[Jacques Le Roux <ja...@les7arts.com>]

At large, when you miss information from the main README.md file or from the user ML archives (https://lists.apache.org/, Markmail or Nabble) make a 
search in the wiki, eg from there http://ofbiz.apache.org/documentation.html

For instance you can find the word postgres in https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide when 
looking into the "public wiki"

HTH

Jacques


Le 26/03/2017 à 22:57, stimits@comcast.net a écrit :
> ...
>> cleanAll deletes everything as long as you are using an embedded database> (default) otherwise you have to clean itup yourself.
> ...
>   
> This is the reason why I'm trying to better understand if loadDefault and cleanAll have a series of smaller commands which are equivalent...I am not using the embedded database, and those commands leave a non-working ofbiz while not clearing out or resetting data in PostgreSQL. The README.md does not say much about PostgreSQL.
>   
> When configured to use PostgreSQL running "gradlew cleanAll loadDefault" leaves ofbiz in a non-working state. Clearing out the ofbiz install, running it with Derby and the default data makes ofbiz work again; reconfiguring to once again use PostgreSQL succeeds, but the previous experimental data changes are there, not the fresh demo data. This is expected since gradlew commands have no concept of the XML database configuration...only commands going through ofbiz itself would have any way of talking to the database as configured in entityengine.xml. If I know exactly what sub-steps cleanAll and loadDefault take I might be able to clean out my PostgreSQL tables and load default sample data in PostgreSQL with a standard mechanism which is repeatable. Manually dropping and recreating a database or wiping out my install and starting from scratch (but pointing back at the original PostgreSQL database) does not give me confidence that I understand enough about the process to put this in place in a real store depending on the software (hard drives die, machines die, networks change, various software versions migrate to newer versions, so on). I'd like to understand what goes on under cleanAll and loadDefault and equivalents if working through ofbiz instead of gradlew.
>   
> An alternate view of my question might read: Does "gradlew cleanAll loadDefault" have an equivalent using ofbiz's interface which might work in a uniform way regardless of which database is used? The information in README.md is minimal with regard to the right way to modify procedures when using a non-Derby DB.
>   
> Thanks!