Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
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"
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
(0000247)
ycastonguay (administrator)
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 (developer)
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 (developer)
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


- Issue History
Date Modified Username Field Change
2011-12-24 08:43 ycastonguay New Issue
2011-12-24 08:43 ycastonguay Status new => assigned
2011-12-24 08:43 ycastonguay Assigned To => ycastonguay
2011-12-24 08:48 ycastonguay Note Added: 0000247
2011-12-24 09:27 svn Checkin
2011-12-24 09:27 svn Note Added: 0000249
2011-12-24 10:18 svn Checkin
2011-12-24 10:18 svn Note Added: 0000254
2011-12-24 10:19 ycastonguay Status assigned => resolved
2011-12-24 10:19 ycastonguay Fixed in Version => 0.5.0.4
2011-12-24 10:19 ycastonguay Resolution open => fixed


Copyright © 2000 - 2011 MantisBT Group
Powered by Mantis Bugtracker