Project to get array of map where column_name is key and its attribute_data is its value
=> => => => => => => => => => => => => => => => => => => => => => => => => => => =>
Steps to run project:
-
clone the repo
-
change your DB name, table, username & password in main.go
-
write any select query for associative fetch
-
run main.go
=> => => => => => => => => => => => => => => => => => => => => => => => => => => =>
Below is a bsic example of project output on certain DB.
/******* TEST TABLE STRUCTURE **************
mysql> desc testTable;
+----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| full_names | varchar(150) | NO | | NULL | |
| gender | varchar(6) | YES | | NULL | |
| date_of_birth | date | YES | | NULL | |
| contact_number | varchar(75) | YES | | NULL | |
| email | varchar(255) | YES | | NULL | |
+----------------+--------------+------+-----+---------+-------+
*************** TABLE VALUES ******************
mysql> select * from testTable;
+------+------------+--------+---------------+----------------+------------------+
| id | full_names | gender | date_of_birth | contact_number | email |
+------+------------+--------+---------------+----------------+------------------+
| 1 | testname1 | male | 2019-01-01 | 9909123456 | example1@abc.com |
| 2 | testname2 | male | NULL | 9909123457 | example2@abc.com |
| 3 | testname3 | male | 2019-01-02 | 9909123456 | NULL |
+------+------------+--------+---------------+----------------+------------------+
*************** ARRAY OF MAP **********************
[
map[
contact_number:9909123456
date_of_birth:2019-01-01 00:00:00 +0000 UTC
email:example1@abc.com
full_names:testname1
gender:male
id:1
]
map[
contact_number:9909123457
date_of_birth:<nil>
email:example2@abc.com
full_names:testname2
gender:male
id:2
]
map[
contact_number:9909123456
date_of_birth:2019-01-02 00:00:00 +0000 UTC
email:
full_names:testname3
gender:male
id:3
]
]
***********************/