MantisBT - MPfm
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000203MPfmLibrarypublic2011-12-24 08:432011-12-24 10:19
Reporterycastonguay 
Assigned Toycastonguay 
PriorityurgentSeverityfeatureReproducibilityN/A
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version 
Target Version0.5.0.4Fixed in Version0.5.0.4 
Summary0000203: Add an automatic database update (via an embedded script)
DescriptionRe-use the code made for the database creation at the start of MPfm.
Store the database version into the Settings table.
SettingName = "DatabaseVersion"
Version = "1.00"
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-12-24 08:43ycastonguayNew Issue
2011-12-24 08:43ycastonguayStatusnew => assigned
2011-12-24 08:43ycastonguayAssigned To => ycastonguay
2011-12-24 08:48ycastonguayNote Added: 0000247
2011-12-24 09:27svnCheckin
2011-12-24 09:27svnNote Added: 0000249
2011-12-24 10:18svnCheckin
2011-12-24 10:18svnNote Added: 0000254
2011-12-24 10:19ycastonguayStatusassigned => resolved
2011-12-24 10:19ycastonguayFixed in Version => 0.5.0.4
2011-12-24 10:19ycastonguayResolutionopen => fixed

Notes
(0000247)
ycastonguay   
2011-12-24 08:48   
Damn, SQLite does not fully support ALTER TABLE!

http://stackoverflow.com/questions/805363/how-do-i-rename-a-column-in-a-sqlite-database-table#805508 [^]
(0000249)
svn   
2011-12-24 09:27   
The user admin has checked in files related to this issue (revision 184).

Comment:
MPfm 0.5.0.4
- Added the Setting and History objects to Library.
- Added the Settings methods in MPfmLibrary.
- Added the draft for the 1.00 to 1.01 database script update.

Related to issue 0000181, issue 0000203, issue 0000204, issue 0000205 and issue 0000206.

Files modified:
U MPfm/branches/current/MPfm/frmMain.cs
U MPfm/branches/current/MPfm.Library/ConvertLibrary.cs
D MPfm/branches/current/MPfm.Library/Folder.cs
U MPfm/branches/current/MPfm.Library/Library.cs
U MPfm/branches/current/MPfm.Library/MPfm.Library.csproj
U MPfm/branches/current/MPfm.Library/MPfmGateway.cs
A MPfm/branches/current/MPfm.Library/Objects/
A MPfm/branches/current/MPfm.Library/Objects/Folder.cs
A MPfm/branches/current/MPfm.Library/Objects/History.cs
A MPfm/branches/current/MPfm.Library/Objects/Setting.cs
A MPfm/branches/current/MPfm.Library/Scripts/1.00-1.01.sql
(0000254)
svn   
2011-12-24 10:18   
The user admin has checked in files related to this issue (revision 185).

Comment:
MPfm 0.5.0.4
- Finished migration script for 1.00-1.01 database version.
- Added the database version check to the main form init (now updates the database structure by executing the migration scripts needed in a loop)
- Added the GetAudioFilePlayCountFromHistory and GetAudioFileLastPlayedFromHistory in the MPfmGateway class.

Related to issue 0000203, issue 0000205 and issue 0000206.

Files modified:
U MPfm/branches/current/MPfm/frmMain.cs
U MPfm/branches/current/MPfm.Library/Library.cs
U MPfm/branches/current/MPfm.Library/MPfmGateway.cs
U MPfm/branches/current/MPfm.Library/SQLiteGateway.cs
U MPfm/branches/current/MPfm.Library/Scripts/1.00-1.01.sql