[
http://mifosforge.jira.com/browse/MIFOS-3897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
jbrewster reassigned MIFOS-3897:
--------------------------------
Assignee: Adam Monsen (was: Jakub Sławiński)
Adam, I think you will be using this change, right? If so, can you verify this
issue when you confirm the references are in place for your PPI survey needs?
> Store an immutable reference for questions in imported question groups (such
> as PPI surveys)
> --------------------------------------------------------------------------------------------
>
> Key: MIFOS-3897
> URL: http://mifosforge.jira.com/browse/MIFOS-3897
> Project: mifos
> Issue Type: Story
> Components: Surveys/PPI
> Reporter: Kay Chau
> Assignee: Adam Monsen
> Priority: Major
> Fix For: Release E - Iteration 10, Release E
>
> Attachments: 0001-WIP-throwaway-code-working-on-adding-nickname.patch
>
>
> From PPI reports, we need a way to uniquely refer to questions. We want to
> avoid using the primary key. This reference should be immutable once created.
> Also, it may be used in the future for column names in denormalized data
> warehouse tables, so nicknames should follow the constraints for columns on
> [Database
> Naming
> Conventions|http://mifosforge.jira.com/wiki/display/MIFOS/Database+Naming+Conventions].
> Originally we were going to repurpose short_name, but what I'd rather do
> (given the current use of short_name and what we need) is create a new column
> called questions.nickname. The fate of short_name is outlined in MIFOS-3934.
> * add new column: questions.nickname
> * VARCHAR(64) NOT NULL
> * enforce as unique
> * service-level constraints
> ** only allow \[a-z0-9\] in this column
> * adapt test cases as necessary
> * update queries in QuestionEntity.hbm.xml
> * generate if necessary (only on creation)
> ** md5sum question text
> * immutable once created
> ** ie: no way to edit
> ** only enforce this in Java code
> * make sure questionnaire migration code works
> * XML PPI survey import must be able to specify nickname
> ** add "nickname" element to schema
> ** see attached patch
> 0001-WIP-throwaway-code-working-on-adding-nickname.patch for some ideas
> [Related
> discussion|http://thread.gmane.org/gmane.comp.finance.mifos.devel/9907/focus=9930]
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
