MantisBT - MPfm
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000205MPfmLibrarypublic2011-12-24 09:202011-12-24 10:19
Reporterycastonguay 
Assigned Toycastonguay 
PriorityhighSeveritymajorReproducibilityN/A
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version 
Target Version0.5.0.4Fixed in Version0.5.0.4 
Summary0000205: Make the database migration script (1.00 to 1.01) - Replaced LastPlayed in AudioFiles, added History table, etc.
DescriptionINSERT INTO Settings
(SettingId, SettingName, SettingValue)
VALUES
('c84dcec5-8aa5-468d-a154-cafc0492f77f', 'DatabaseVersion', '1.01')

/**/

ALTER TABLE AudioFiles ADD LastPlayedDateTime text NULL

/**/

CREATE TABLE [History] (
[HistoryId] varchar(50) NOT NULL PRIMARY KEY,
[AudioFileId] varchar(50) NULL,
[EventDateTime] text NULL
)
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-12-24 09:20ycastonguayNew Issue
2011-12-24 09:20ycastonguayStatusnew => assigned
2011-12-24 09:20ycastonguayAssigned To => ycastonguay
2011-12-24 09:27svnCheckin
2011-12-24 09:27svnNote Added: 0000251
2011-12-24 10:16ycastonguayNote Added: 0000253
2011-12-24 10:16ycastonguayStatusassigned => resolved
2011-12-24 10:16ycastonguayFixed in Version => 0.5.0.4
2011-12-24 10:16ycastonguayResolutionopen => fixed
2011-12-24 10:16ycastonguaySummaryAdd the History table to replace the PlayCount/LastPlayed columns in the AudioFile table => Make the database migration script (1.00 to 1.01)
2011-12-24 10:16ycastonguayDescription Updatedbug_revision_view_page.php?rev_id=74#r74
2011-12-24 10:17ycastonguaySummaryMake the database migration script (1.00 to 1.01) => Make the database migration script (1.00 to 1.01) - Replaced LastPlayed in AudioFiles, added History table, etc.
2011-12-24 10:17ycastonguayDescription Updatedbug_revision_view_page.php?rev_id=75#r75
2011-12-24 10:19svnCheckin
2011-12-24 10:19svnNote Added: 0000255

Notes
(0000251)
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
(0000253)
ycastonguay   
2011-12-24 10:16   
Added to the migration script (1.01)
(0000255)
svn   
2011-12-24 10:19   
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