How to retrieve the value of a specific key from the data obtained through ORM queries?

[Avey777]

res := sql conn {
	select from Pgpr where id < 3
}!
eprintln(res)
mut mapstrlist := []map[string]string{} //创建空数组
	for row in res.rows() {

		mut direct := map[string]string{} // a map with `string` keys and `string` values
		direct["mall.Pgpr.id"] = row.vals[0]
		// direct["raw_data"] = row.vals[1]

		mapstrlist << direct  //追加direct到mapstrlist 数组
	}

The above code snippet cannot be executed properly, and the result printed by eprintln(res) is as follows. The data format retrieved when using ORM is different from when directly executing SQL. I want to know how to handle the data obtained through ORM queries. For example, I want to retrieve the value of raw_data below.

[mall.Pgpr{
    id: 1
    raw_data: 'Hello'
    data_type: 1
}, mall.Pgpr{
    id: 2
    raw_data: 'Word'
    data_type: 1
}]

[JalonSolov]

Looks like you need to call json.decode on the raw_data field.

[Avey777]

id: 2
raw_data: "Hello" 
data_type: 1

How do I obtain the values of these keys？

[Avey777]

What should I do to obtain the value of raw_data from the data returned by orm？

{2 , 'Hello' , 1}

[Avey777]

module mall

import os
import db.mysql


const mysql_host = os.getenv_opt('MHOST') or { '***' }
const mysql_port = os.getenv_opt('MPORT') or { '3307' }.u32()
const mysql_user = os.getenv_opt('MUSER') or { '**' }
const mysql_pass = os.getenv_opt('MPASS') or { '**' }
const mysql_db = os.getenv_opt('MDATABASE') or { 'dabase_name' }



@[table: 'pms_goods_pool_raw']
struct Pgpr {
	id           int    @[primary; sql: serial]
	raw_data     string
	data_type	 int    @[sql: u64]
}


pub fn msql() ![]map[string]string {

	eprintln('------------ ${@METHOD} -----------------')
	mut db := mysql.connect(
		host: mysql_host
		port: mysql_port
		username: mysql_user
		password: mysql_pass
		dbname: mysql_db
	) or { panic(err) }
	defer {
		db.close()
	}


	res := sql db {
		select from Pgpr where id < 3
	}!

	// eprintln(res)

	mut mapstrlist := []map[string]string{} //创建空数组
	for row in res {
		mut direct := map[string]string{} // a map with `string` keys and `string` values
		direct["id"] = '$row.id'
		direct["raw_data"] = '$row.raw_data'

		mapstrlist << direct  //追加direct到mapstrlist 数组
	}
	return mapstrlist
}