Mantis Bug Tracker

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

- Relationships

-  Notes
(0000251)
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

(0000253)
ycastonguay (administrator)
2011-12-24 10:16

Added to the migration script (1.01)
(0000255)
svn (developer)
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


- Issue History
Date Modified Username Field Change
2011-12-24 09:20 ycastonguay New Issue
2011-12-24 09:20 ycastonguay Status new => assigned
2011-12-24 09:20 ycastonguay Assigned To => ycastonguay
2011-12-24 09:27 svn Checkin
2011-12-24 09:27 svn Note Added: 0000251
2011-12-24 10:16 ycastonguay Note Added: 0000253
2011-12-24 10:16 ycastonguay Status assigned => resolved
2011-12-24 10:16 ycastonguay Fixed in Version => 0.5.0.4
2011-12-24 10:16 ycastonguay Resolution open => fixed
2011-12-24 10:16 ycastonguay Summary Add 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:16 ycastonguay Description Updated View Revisions
2011-12-24 10:17 ycastonguay Summary Make 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:17 ycastonguay Description Updated View Revisions
2011-12-24 10:19 svn Checkin
2011-12-24 10:19 svn Note Added: 0000255


Copyright © 2000 - 2011 MantisBT Group
Powered by Mantis Bugtracker