[
http://mifosforge.jira.com/browse/MIFOS-3897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adam Monsen updated MIFOS-3897:
-------------------------------
Description:
>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]
was:
includes changes to Mifos to store something different than question title for
short_name
Acceptance Criteria:
* short name is tied to each question
* short name is used to map to questions in Mifos PPI Scoring and Lookup Tool
Attachment: 0001-WIP-throwaway-code-working-on-adding-nickname.patch
Summary: Store an immutable reference for questions in imported
question groups (such as PPI surveys) (was: Store an immutable nickname for
questions in imported question groups (such as PPI surveys))
> 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 9, 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
------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
