couchdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Le Drew (JIRA)" <j...@apache.org>
Subject [jira] Updated: (COUCHDB-899) Array fields being returned empty in permanent views, but work fine as temporary views.
Date Thu, 30 Sep 2010 18:04:33 GMT

     [ https://issues.apache.org/jira/browse/COUCHDB-899?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

John Le Drew updated COUCHDB-899:
---------------------------------


Same db replicated to my cloudant account does not show this issue.

> Array fields being returned empty in permanent views, but work fine as temporary views.
> ---------------------------------------------------------------------------------------
>
>                 Key: COUCHDB-899
>                 URL: https://issues.apache.org/jira/browse/COUCHDB-899
>             Project: CouchDB
>          Issue Type: Bug
>          Components: JavaScript View Server
>    Affects Versions: 1.0.1
>         Environment: CouchDB 1.0.1  running on Ubuntu 10.10 beta - this is the contents
of my local.ini (comments removed)
> [couchdb]
> delayed_commits = false
> [httpd]
> port = 80
> bind_address = 0.0.0.0
> WWW-Authenticate = Basic realm="administrator"
> [couch_httpd_auth]
> require_valid_user = true
> [log]
> level = debug
>            Reporter: John Le Drew
>
> I am creating an accounting app; the transactions are stored using the following doc:
> {
>    "_id": "405b791b64424d12e03c12e6e5001535",
>    "_rev": "1-97d53ba31a6ebb8c0508d0fc8776fac5",
>    "type": "transaction",
>    "account": "account_id",
>    "payee": "Gas Company",
>    "description": "May Bill",
>    "date": "2009/05/25",
>    "status": "cleared",
>    "category": "Bills / Gas",
>    "value": -5000
> }
> Or they can be split acroll multiple accounts / categories / etc. In this case split
over two categories:
> {
>    "_id": "405b791b64424d12e03c12e6e5002532",
>    "_rev": "1-da46384d5f9fbfd26acbf8fc9a8e82fe",
>    "type": "transaction",
>    "account": "account_id",
>    "payee": "Credit Card Company",
>    "description": "May Statement",
>    "date": "2009/06/02",
>    "status": "uncleared",
>    "category": "Debt / Credit Card Payments",
>    "value": -5000,
>    "split": [
>        {
>            "category": "Dept / Default Charges",
>            "value": -1000
>        }
>    ]
> }
> I have made a view to display all the unique categories in use across all transactions.
> // MAP
> function(doc) {
> 	if (doc.type && doc.type == 'transaction') {
> 		if (doc.category) emit(doc.category);
> 		if (doc.split) doc.split.map(function(spl) {
> 			if (spl.category) emit(spl.category);
> 		});
> 	}
> }
> // REDUCE
> function(keys, values, rereduce) {
> 	return true;
> }
> // CURRENT OUTPUT OF VIEW (with group=true)
> {
> 	"rows": [
> 		{
> 			"key": "Debt / Credit Card Payments", 
> 			"value": true
> 		}, 
> 		{
> 			"key": "Bills / Gas", 
> 			"value": true
> 		}
> 	]
> }
> // CURRENT OUTPUT OF VIEW WHEN RUN AS A TEMPORARY VIEW (with group=true)
> {
> 	"rows": [
> 		{
> 			"key": "Dept / Default Charges", 
> 			"value": true
> 		}, 
> 		{
> 			"key": "Debt / Credit Card Payments", 
> 			"value": true
> 		}, 
> 		{
> 			"key": "Bills / Gas", 
> 			"value": true
> 		}
> 	]
> }
> SIMPLE TEST VIEW
> function(doc) {
> 	if (doc.split) emit(null,doc.split);
> }
> OUTPUT OF TEMP VIEW
> {
> 	"total_rows": 1, 
> 	"offset": 0, 
> 	"rows": [
> 		{
> 			"id": "405b791b64424d12e03c12e6e5002532", 
> 			"key": null, 
> 			"value": [
> 				{
> 					"category": "Dept / Default Charges", 
> 					"value": -1000
> 				}
> 			]
> 		}
> 	]
> }
> OUTPUT OF SAME VIEW AFTER SAVE
> {
> 	"total_rows": 1, 
> 	"offset": 0, 
> 	"rows": [
> 		{
> 			"id": "405b791b64424d12e03c12e6e5002532", 
> 			"key": null, 
> 			"value": [
> 			]
> 		}
> 	]
> }
> It seems from the above that couch is for some reason returning the array as empty. 
> Thanks for your time on IRC already.
> Cheers
> John

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message