| Anonymous | Login | Signup for a new account | 2024-11-27 01:00 PST |  |
| Main | My View | View Issues | Change Log | Roadmap | Repositories | My Account |
| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||
| 0000203 | MPfm | Library | public | 2011-12-24 08:43 | 2011-12-24 10:19 | |||
| Reporter | ycastonguay | |||||||
| Assigned To | ycastonguay | |||||||
| Priority | urgent | Severity | feature | Reproducibility | N/A | |||
| Status | resolved | Resolution | fixed | |||||
| Platform | OS | OS Version | ||||||
| Product Version | ||||||||
| Target Version | 0.5.0.4 | Fixed in Version | 0.5.0.4 | |||||
| Summary | 0000203: Add an automatic database update (via an embedded script) | |||||||
| Description | Re-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" | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships |
|
 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 |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2011 MantisBT Group |
 |