summaryrefslogtreecommitdiff
path: root/DAL/DB/CRUD.go
blob: a3b4a247602cd220e3921372949b52e4c8898928 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
package db

import (
	"reflect"
	"strings"
)

type DataTable[T any] struct {
	TableName string
}

// Forms a query to get all the fields from database
func (self *DataTable[T]) formSelectRequest() string {
	var sb = strings.Builder{}
	sb.WriteString("SELECT (")
	var fields = self.getFields()
	for i, v := range fields {
		if i != 0 {
			sb.WriteString(", ")
		}
		sb.WriteString(v)
	}
	sb.WriteString(") FROM ")
	sb.WriteString(self.TableName)
	sb.WriteString(";")
	return sb.String()
}

func (self *DataTable[T]) getFields() []string {
	var zero T
	var outp = make([]string, 0)
	for _, f := range reflect.VisibleFields(reflect.TypeOf(zero)) {
		outp = append(outp, f.Name)
	}
	return outp
}