[jira] [Created] (OFBIZ-4779) Add an ant task/code/script for dropping all datas from the database
Locked
[jira] [Created] (OFBIZ-4779) Add an ant task/code/script for dropping all datas from the database
 
|
Add an ant task/code/script for dropping all datas from the database
-------------------------------------------------------------------- Key: OFBIZ-4779 URL: https://issues.apache.org/jira/browse/OFBIZ-4779 Project: OFBiz Issue Type: Improvement Components: framework Affects Versions: SVN trunk Environment: WXP SP3 Sun JDK 1.6.0_30 Postgres 9.1 Reporter: Francis ANDRE Hi It would be nice to have an ant task or a script for cleaning/removing all datas in the databases so that one can restart reloading the seed, seed-initial and then its own data file. When developing a new environment for ofbiz, one has always to fix bugs on the entities values in this datafile until it is properly cleaned up. Thus, avoiding the unnecessary "create tables/key/indexes" phases will shorten the development cycle. Rgds -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
[jira] [Commented] (OFBIZ-4779) Add an ant task/code/script for dropping all datas from the database
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244428#comment-13244428 ] Pierre Smits commented on OFBIZ-4779: ------------------------------------- Cleaning the data environment is already in the build.xml file called: 'clean-data'... You can start this clean-up process by following command: ./ant clean-data Avoiding the 'unnecessay 'create tables/key/indexes phases' saves only a few minutes per run. Regarding, Pierre > Add an ant task/code/script for dropping all datas from the database > -------------------------------------------------------------------- > > Key: OFBIZ-4779 > URL: https://issues.apache.org/jira/browse/OFBIZ-4779 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Environment: WXP SP3 Sun JDK 1.6.0_30 Postgres 9.1 > Reporter: Francis ANDRE > > Hi > It would be nice to have an ant task or a script for cleaning/removing all datas in the databases so that one can restart reloading the seed, seed-initial and then its own data file. > When developing a new environment for ofbiz, one has always to fix bugs on the entities values in this datafile until it is properly cleaned up. Thus, avoiding the unnecessary "create tables/key/indexes" phases will shorten the development cycle. > Rgds -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
[jira] [Commented] (OFBIZ-4779) Add an ant task/code/script for dropping all datas from the database
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244485#comment-13244485 ] Jacques Le Roux commented on OFBIZ-4779: ---------------------------------------- Francis, If I understood well (from "Environment: WXP SP3 Sun JDK 1.6.0_30 Postgres 9.1" above) it's related to Postgres? > Add an ant task/code/script for dropping all datas from the database > -------------------------------------------------------------------- > > Key: OFBIZ-4779 > URL: https://issues.apache.org/jira/browse/OFBIZ-4779 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Environment: WXP SP3 Sun JDK 1.6.0_30 Postgres 9.1 > Reporter: Francis ANDRE > > Hi > It would be nice to have an ant task or a script for cleaning/removing all datas in the databases so that one can restart reloading the seed, seed-initial and then its own data file. > When developing a new environment for ofbiz, one has always to fix bugs on the entities values in this datafile until it is properly cleaned up. Thus, avoiding the unnecessary "create tables/key/indexes" phases will shorten the development cycle. > Rgds -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
[jira] [Commented] (OFBIZ-4779) Add an ant task/code/script for dropping all datas from the database
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244988#comment-13244988 ] Francis ANDRE commented on OFBIZ-4779: -------------------------------------- Jacques Yes, this is related to a non derby database, Postgres in my case. ant clean-data only cleans datas from the derby database, not any "external" database. And I do not have enough knowledge of ofbiz database subsystem for proposing a pertinent patch. > Add an ant task/code/script for dropping all datas from the database > -------------------------------------------------------------------- > > Key: OFBIZ-4779 > URL: https://issues.apache.org/jira/browse/OFBIZ-4779 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Environment: WXP SP3 Sun JDK 1.6.0_30 Postgres 9.1 > Reporter: Francis ANDRE > > Hi > It would be nice to have an ant task or a script for cleaning/removing all datas in the databases so that one can restart reloading the seed, seed-initial and then its own data file. > When developing a new environment for ofbiz, one has always to fix bugs on the entities values in this datafile until it is properly cleaned up. Thus, avoiding the unnecessary "create tables/key/indexes" phases will shorten the development cycle. > Rgds -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
[jira] [Commented] (OFBIZ-4779) Add an ant task/code/script for dropping all datas from the database
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13245009#comment-13245009 ] Jacopo Cappellato commented on OFBIZ-4779: ------------------------------------------ This would be a *very* dangerous tool! > Add an ant task/code/script for dropping all datas from the database > -------------------------------------------------------------------- > > Key: OFBIZ-4779 > URL: https://issues.apache.org/jira/browse/OFBIZ-4779 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Environment: WXP SP3 Sun JDK 1.6.0_30 Postgres 9.1 > Reporter: Francis ANDRE > > Hi > It would be nice to have an ant task or a script for cleaning/removing all datas in the databases so that one can restart reloading the seed, seed-initial and then its own data file. > When developing a new environment for ofbiz, one has always to fix bugs on the entities values in this datafile until it is properly cleaned up. Thus, avoiding the unnecessary "create tables/key/indexes" phases will shorten the development cycle. > Rgds -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
[jira] [Commented] (OFBIZ-4779) Add an ant task/code/script for dropping all datas from the database
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13245057#comment-13245057 ] Jacques Le Roux commented on OFBIZ-4779: ---------------------------------------- I agree with Jacopo, I prefer to rely on pgAgmin or such tools and do it by hand, it's not often and that hard you want to drop a DB and not that long to populate. And like Pierre said the tables/key/indexes phases creation are not the longer steps, loading data is longer. Also since the DB is still (slowly now) evolving, it would require to maintain the script when we try to slim down and delegate as much as possible... > Add an ant task/code/script for dropping all datas from the database > -------------------------------------------------------------------- > > Key: OFBIZ-4779 > URL: https://issues.apache.org/jira/browse/OFBIZ-4779 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Environment: WXP SP3 Sun JDK 1.6.0_30 Postgres 9.1 > Reporter: Francis ANDRE > > Hi > It would be nice to have an ant task or a script for cleaning/removing all datas in the databases so that one can restart reloading the seed, seed-initial and then its own data file. > When developing a new environment for ofbiz, one has always to fix bugs on the entities values in this datafile until it is properly cleaned up. Thus, avoiding the unnecessary "create tables/key/indexes" phases will shorten the development cycle. > Rgds -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
[jira] [Commented] (OFBIZ-4779) Add an ant task/code/script for dropping all datas from the database
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13262285#comment-13262285 ] Daniel Riquelme commented on OFBIZ-4779: ---------------------------------------- I have lot of experience with this matter and I came to the conclusion that the optimal solution in general is to drop tables or indexes as needed during development. And dropping the entire database and recreating it when the mess is to big. If for any reason you need to delete all data frequently and don't want to wait for database re-recreation, you can always have a blank database with all the tables and indexes created and use that as a template, in Postgres you can do a: {code} DROP DATABASE <database name> {code} and then: {code} CREATE DATABASE <database name> TEMPLATE <blank database> {code} This will be faster than letting OFBiz do the database creation. > Add an ant task/code/script for dropping all datas from the database > -------------------------------------------------------------------- > > Key: OFBIZ-4779 > URL: https://issues.apache.org/jira/browse/OFBIZ-4779 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Environment: WXP SP3 Sun JDK 1.6.0_30 Postgres 9.1 > Reporter: Francis ANDRE > > Hi > It would be nice to have an ant task or a script for cleaning/removing all datas in the databases so that one can restart reloading the seed, seed-initial and then its own data file. > When developing a new environment for ofbiz, one has always to fix bugs on the entities values in this datafile until it is properly cleaned up. Thus, avoiding the unnecessary "create tables/key/indexes" phases will shorten the development cycle. > Rgds -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
[jira] [Commented] (OFBIZ-4779) Add an ant task/code/script for dropping all datas from the database
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13262430#comment-13262430 ] Pierre Smits commented on OFBIZ-4779: ------------------------------------- Daniel, In my opinion we don't need a RMBS-function in OFBiz, that can be handled with good tools (both proprietary and Open Source). Functions or tasks that happen only at the beginning of implementation phase, or at the end of the lifecycle of the implementation. Creating the database, the system's user and password, and being able to drop it, as well as other RDBM-tasks is, in general, the area of expertise of RDBMS-administrators. Let's leave it there. Building such functionality in OFBiz is a waste of resources. You're free to provide a patch, of course. But I would be against having it implemented in OFBiz. > Add an ant task/code/script for dropping all datas from the database > -------------------------------------------------------------------- > > Key: OFBIZ-4779 > URL: https://issues.apache.org/jira/browse/OFBIZ-4779 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Environment: WXP SP3 Sun JDK 1.6.0_30 Postgres 9.1 > Reporter: Francis ANDRE > > Hi > It would be nice to have an ant task or a script for cleaning/removing all datas in the databases so that one can restart reloading the seed, seed-initial and then its own data file. > When developing a new environment for ofbiz, one has always to fix bugs on the entities values in this datafile until it is properly cleaned up. Thus, avoiding the unnecessary "create tables/key/indexes" phases will shorten the development cycle. > Rgds -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
[jira] [Commented] (OFBIZ-4779) Add an ant task/code/script for dropping all datas from the database
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13262438#comment-13262438 ] Pierre Smits commented on OFBIZ-4779: ------------------------------------- Besided, functions in OFBiz include the creation of tables in the database (any supported database). Please let's reduce the impact of this issue to minor, and close it. > Add an ant task/code/script for dropping all datas from the database > -------------------------------------------------------------------- > > Key: OFBIZ-4779 > URL: https://issues.apache.org/jira/browse/OFBIZ-4779 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Environment: WXP SP3 Sun JDK 1.6.0_30 Postgres 9.1 > Reporter: Francis ANDRE > > Hi > It would be nice to have an ant task or a script for cleaning/removing all datas in the databases so that one can restart reloading the seed, seed-initial and then its own data file. > When developing a new environment for ofbiz, one has always to fix bugs on the entities values in this datafile until it is properly cleaned up. Thus, avoiding the unnecessary "create tables/key/indexes" phases will shorten the development cycle. > Rgds -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
[jira] [Closed] (OFBIZ-4779) Add an ant task/code/script for dropping all datas from the database
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux closed OFBIZ-4779. ---------------------------------- Resolution: Won't Fix > Add an ant task/code/script for dropping all datas from the database > -------------------------------------------------------------------- > > Key: OFBIZ-4779 > URL: https://issues.apache.org/jira/browse/OFBIZ-4779 > Project: OFBiz > Issue Type: Improvement > Components: framework > Affects Versions: SVN trunk > Environment: WXP SP3 Sun JDK 1.6.0_30 Postgres 9.1 > Reporter: Francis ANDRE > > Hi > It would be nice to have an ant task or a script for cleaning/removing all datas in the databases so that one can restart reloading the seed, seed-initial and then its own data file. > When developing a new environment for ofbiz, one has always to fix bugs on the entities values in this datafile until it is properly cleaned up. Thus, avoiding the unnecessary "create tables/key/indexes" phases will shorten the development cycle. > Rgds -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |