www.digitalmars.com         C & C++   DMDScript  

digitalmars.D.learn - Convert ResultSet to List of Associted Array

reply Jshah <jitenshah78 gmail.com> writes:
Hi

I am new to D writing a web service with vibe.

My webservice connect to mysql and return the result
as JSON.

How do I convert resultset to Array of Associated Array
[["col1" : value, "col2" : value], ....]
Jul 30
parent reply Jshah <jitenshah78 gmail.com> writes:
On Sunday, 30 July 2017 at 16:39:05 UTC, Jshah wrote:
 Hi

 I am new to D writing a web service with vibe.

 My webservice connect to mysql and return the result
 as JSON.

 How do I convert resultset to Array of Associated Array
 [["col1" : value, "col2" : value], ....]
I am using mysql-native
Jul 30
parent reply Steven Schveighoffer <schveiguy yahoo.com> writes:
On 7/30/17 1:02 PM, Jshah wrote:
 On Sunday, 30 July 2017 at 16:39:05 UTC, Jshah wrote:
 Hi

 I am new to D writing a web service with vibe.

 My webservice connect to mysql and return the result
 as JSON.

 How do I convert resultset to Array of Associated Array
 [["col1" : value, "col2" : value], ....]
I am using mysql-native
Variant[string][] realresult; realresult.reserve(resultset.length); while(!resultset.empty) { realresult ~= resultset.asAA; } -Steve
Aug 01
parent reply Steven Schveighoffer <schveiguy yahoo.com> writes:
On 8/1/17 10:14 AM, Steven Schveighoffer wrote:
 On 7/30/17 1:02 PM, Jshah wrote:
 On Sunday, 30 July 2017 at 16:39:05 UTC, Jshah wrote:
 Hi

 I am new to D writing a web service with vibe.

 My webservice connect to mysql and return the result
 as JSON.

 How do I convert resultset to Array of Associated Array
 [["col1" : value, "col2" : value], ....]
I am using mysql-native
Variant[string][] realresult; realresult.reserve(resultset.length); while(!resultset.empty) { realresult ~= resultset.asAA;
resultset.popFront(); // forgot this.
 }
 
-Steve
Aug 01
parent Jshah <jitenshah78 gmail.com> writes:
On Tuesday, 1 August 2017 at 14:14:57 UTC, Steven Schveighoffer 
wrote:
 On 8/1/17 10:14 AM, Steven Schveighoffer wrote:
 On 7/30/17 1:02 PM, Jshah wrote:
 On Sunday, 30 July 2017 at 16:39:05 UTC, Jshah wrote:
 Hi

 I am new to D writing a web service with vibe.

 My webservice connect to mysql and return the result
 as JSON.

 How do I convert resultset to Array of Associated Array
 [["col1" : value, "col2" : value], ....]
I am using mysql-native
Variant[string][] realresult; realresult.reserve(resultset.length); while(!resultset.empty) { realresult ~= resultset.asAA;
resultset.popFront(); // forgot this.
 }
 
-Steve
Thanks It is working
Aug 01