Update:Remora Migration: Difference between revisions

Jump to navigation Jump to search

Update:Remora Migration (view source)

Revision as of 02:46, 19 September 2006

941 bytes added ,  19 September 2006
→‎Discussion
No edit summary
 
Line 7: Line 7:
Addon #1980 has two versions (both designated as version 1.0, but that is a different problem).  The first version of the addon is for Firefox 1.0 through 1.6.  Because 1.6 does not exist, migrating that version fails because there is no valid foreign key value for FF1.6.  The second version of this addon is for Firefox 1.0 through 1.5.1.  Well, that version of Firefox doesn't exist either, so that version fails to migrate.
Addon #1980 has two versions (both designated as version 1.0, but that is a different problem).  The first version of the addon is for Firefox 1.0 through 1.6.  Because 1.6 does not exist, migrating that version fails because there is no valid foreign key value for FF1.6.  The second version of this addon is for Firefox 1.0 through 1.5.1.  Well, that version of Firefox doesn't exist either, so that version fails to migrate.


Many of addon version entries have faulty version numbers.
Many addon version entries have faulty version numbers.


Complicating this issue is the incompleteness of the appversions table.  This table is populated by finding the unique entries in the original database's ''applications'' table.   
Complicating this issue is the incompleteness of the appversions table.  This table is populated by finding the unique entries in the original database's ''applications'' table.   
==== Versions from appversions ====


{| border="1"
{| border="1"
!olddb:Application.ID<br/>newdb:appversion.id!!version
!version from appversions
|-
|-
| 1||0.8       
|0.8       
|-
|-
|22||0.9.x     
|0.9.x     
|-
|-
|24||1.0PR     
|1.0PR     
|-
|-
|27||0.10+     
|0.10+     
|-
|-
|34||0.9.3     
|0.9.3     
|-
|-
|35||1.0       
|1.0       
|-
|-
|41||Deer Park  
|Deer Park  
|-
|-
|42||0.7       
|0.7       
|-
|-
|43||1.0.1     
|1.0.1     
|-
|-
|45||1.0.2     
|1.0.2     
|-
|-
|48||1.0.3     
|1.0.3     
|-
|-
|55||1.0.4     
|1.0.4     
|-
|-
|61||1.0.5     
|1.0.5     
|-
|-
|62||1.0.6     
|1.0.6     
|-
|-
|65||1.5b1     
|1.5b1     
|-
|-
|68||1.6a1     
|1.6a1     
|-
|-
|73||1.0.7     
|1.0.7     
|-
|-
|74||1.5b2     
|1.5b2     
|-
|-
|79||1.5.0.*   
|1.5.0.*   
|-
|-
|82||1.5       
|1.5       
|-
|-
|85||2.0b1     
|2.0b1     
|-
|-
|86||3.0a1     
|3.0a1     
|-
|-
|93||1.5.0.4   
|1.5.0.4   
|-
|-
|94||2.0a1     
|2.0a1     
|-
|-
|95||2.0a2     
|2.0a2     
|-
|-
|96||2.0a3     
|2.0a3     
|-
|-
|97||2.0       
|2.0       
|-
|-
|99||2.0.0.*   
|2.0.0.*   
|}
|}
==== Versions from MinAppVer & MaxAppVer ====
{| border="1"
!ersions from MinAppVer & MaxAppVer
|-
|0.8     
|-
|0.9     
|-
|0.7     
|-
|0.6     
|-
|0.7+     
|-
|0.8+     
|-
|0.9.1+   
|-
|0.10     
|-
|0.9.3   
|-
|0.9.0+   
|-
|0.9+     
|-
|1.0     
|-
|0.10+   
|-
|0.9.6   
|-
|0.3     
|-
|.9       
|-
|1.0.1   
|-
|1.0+     
|-
|1.0.4   
|-
|00.8     
|-
|1.5     
|-
|1.4     
|-
|1.0.3   
|-
|1.0.5   
|-
|1.4.0   
|-
|Deer Park
|-
|1.4.1   
|-
|0.1     
|-
|1.0.2   
|-
|1.5*     
|-
|1.0.6   
|-
|1.5.0.* 
|-
|1.0.7   
|-
|1.5.0.4 
|-
|0.80     
|-
|1.6     
|-
|0.9.x   
|-
|1.0PR   
|-
|2.0b1   
|-
|2.0a1   
|-
|2.0a2   
|-
|2.0a3   
|-
|0.9.2+   
|-
|0.9.3+   
|-
|0.10.1+ 
|-
|0.10.1   
|-
|0.11     
|-
|3.0a1   
|-
|1.1     
|-
|3.0     
|-
|2.0     
|-
|01.6     
|-
|3.0.0.a1 
|-
|1.6a1   
|-
|2.0.0.b1 
|-
|2.0.0.a3 
|-
|2.0.0.* 
|}
''''How do we make a programmatic mapping from fuzzy application versions to real ones?''''


=== The Solution ===
=== The Solution ===


I'm quite open to having someone give some input into this section.
I'm quite open to having someone give some input into this section.
Twobraids
Confirmed users
675

edits

Retrieved from "https://wiki.mozilla.org/Special:MobileDiff/34296"

Navigation menu