netz98/n98-magerun

Feature: db:version

f1-outsourcing opened this issue · 8 comments

Feature description

Problem and motivation

Maybe interesting to dump database version information from core_resource so you can check if all patches have been applied?

adminnotification_setup	1.6.0.0	1.6.0.0
admin_setup	1.6.1.2	1.6.1.2
api2_setup	1.0.0.0	1.0.0.0
api_setup	1.6.0.1	1.6.0.1
backup_setup	1.6.0.0	1.6.0.0
bankintegration_setup	2.1.0	2.1.0
bankrules_setup	2.1.0	2.1.0
bundle_setup	1.6.0.0.1	1.6.0.0.1
captcha_setup	1.7.0.0.0	1.7.0.0.0
catalogindex_setup	1.6.0.0	1.6.0.0
cataloginventory_setup	1.6.0.0.2	1.6.0.0.2
catalogrule_setup	1.6.0.3	1.6.0.3
catalogsearch_setup	1.8.2.0	1.8.2.0
catalog_setup	1.6.0.0.19.1.5	1.6.0.0.19.1.5
checkout_setup	1.6.0.0	1.6.0.0
cms_setup	1.6.0.0.2	1.6.0.0.2
Coinbase_setup	1.0	1.0
compiler_setup	1.6.0.0	1.6.0.0
contacts_setup	1.6.0.0	1.6.0.0
core_setup	1.6.0.7	1.6.0.7
cron_setup	1.6.0.0	1.6.0.0
customer_setup	1.6.2.0.6	1.6.2.0.6
dataflow_setup	1.6.0.0	1.6.0.0
deleteorder_setup	1.0.9	1.0.9
directory_setup	1.6.0.3	1.6.0.3
downloadable_setup	1.6.0.0.3	1.6.0.0.3
eav_setup	1.6.0.1	1.6.0.1
exporter_setup	1.0.5	1.0.5
giftmessage_setup	1.6.0.0	1.6.0.0
googleanalytics_setup	1.6.0.0	1.6.0.0
importexport_setup	1.6.0.2	1.6.0.2
imports_setup	1.0.0	1.0.0
index_setup	1.6.0.0	1.6.0.0
log_setup	1.6.1.1	1.6.1.1
moneybookers_setup	1.6.0.0	1.6.0.0
newsletter_setup	1.6.0.2	1.6.0.2
oauth_setup	1.0.0.0	1.0.0.0
paygate_setup	1.6.0.0	1.6.0.0
payment_setup	1.6.0.0	1.6.0.0
paypaluk_setup	1.6.0.0	1.6.0.0
paypal_setup	1.6.0.6	1.6.0.6
pay_payment_setup	3.5.9	3.5.9
persistent_setup	1.0.0.0	1.0.0.0
poll_setup	1.6.0.1	1.6.0.1
productalert_setup	1.6.0.0	1.6.0.0
rating_setup	1.6.0.1	1.6.0.1
reports_setup	1.6.0.0.1	1.6.0.0.1
review_setup	1.6.0.0	1.6.0.0
rss_setup	1.6.0.0	1.6.0.0
salesrule_setup	1.6.0.3	1.6.0.3
sales_setup	1.6.0.10	1.6.0.10
sendfriend_setup	1.6.0.1	1.6.0.1
shipping_setup	1.6.0.0	1.6.0.0
sitemap_setup	1.6.0.0	1.6.0.0
tag_setup	1.6.0.0	1.6.0.0
tax_setup	1.6.0.4	1.6.0.4
usa_setup	1.6.0.3	1.6.0.3
weee_setup	1.6.0.0	1.6.0.0
widget_setup	1.6.0.0	1.6.0.0
wishlist_setup	1.6.0.0	1.6.0.0

Maybe even report on what is not up to date?

Is this something you're interested in working on

@f1-outsourcing did you try the sys:setup:compare-versions command?

@f1-outsourcing did you try the sys:setup:compare-versions command?

Ooohhh cool, very nice. I still have to switch to old magento db, to really have useful comparison. Now I am testing with fresh install of magento-lts.

@f1-outsourcing try also the sys:setup:incremental command to run the setup scripts as alternative to sys:setup:run command.

Ok so if I did a fresh install with magento-lts, than change local.xml to point to an old magento 1.9.? database, I should run this sys:setup:incremental, and that will try and apply database patches to this old database?

Yes.

It's a command to test or debug own setups.

Although I got all the green ok's, I decided to stick with the fresh install db. I had some weird issue with the old db that I could not create a new catalog.

@f1-outsourcing ok.
I will close the issue, because the feature already exists.