Couch DB escape characters

Question

I have a list function for CouchDB, but I can't get it into the DB because I'm constantly getting syntax erros. Here is the function:

function(head,req) {
  var headers;
  start({'headers':{'Content-Type' : 'text/csv; charset=utf-8; header=present'}});
  while(r = getRow()) {
    if(!headers) {
      headers = Object.keys(r.value);
      send('"' + headers.join('","') + '"\n');
    }
    headers.forEach(function(v,i) {
      send(String(r.value[v]).replace(/\"/g,'""').replace(/^|$/g,'"'));
      (i + 1 < headers.length) ? send(',') : send('\n');
    });
  }
}

Can anyone show me an example of this function formatted that can be inserted into CouchDB?

score 1 · Accepted Answer · answered Mar 17 '15 at 13:57

1

List functions are stored in design documents. Design documents are JSON documents, so you need to make sure they conform to the JSON standard. Since List functions are string values in JSON, you need to make sure that you:

Escape any double quotes in the function, so " becomes \". Where possible, you should use single quotes instead of double quotes.
Make sure you replace any line breaks with \n or just remove line breaks as Javascript ignores them anyway.
Escape any backslashes, so \ becomes \\.

answered Mar 17 '15 at 13:57

Kim Stebel

41,826
12
125
142

Can you give me an example of mine function with all these rules ? Because I did all you said and still getting syntax error? – Markuz Shultz Mar 17 '15 at 14:08
Can you post the entire JSON document you tried to upload? – Kim Stebel Mar 17 '15 at 14:36
That's not the entire JSON document you tried to upload. – Kim Stebel Mar 17 '15 at 15:14

Couch DB escape characters

1 Answers1