aliaqa256 / go_pgsql_orm

go_pgsql_orm

summary

this is a simple example of go-pgsql-orm usage. i designed this simple lib to help myself learn go and postgresql better.

there are many improvements that can be done to this lib.

with this small lib you can:

• connect to postgresql (singleton connection)
• create schema (migrate)
• create table (migrate)
• insert data
• read one record
• alert table to change type of cols (migrate)
• alert table to add new col (migrate)

this is a simple example of go-pgsql-orm usage.:

how to create schema:

package main

import (
	"fmt"
	"time"
	managers "github.com/aliaqa256/go_pgsql_orm/managerspkg"
)

type User struct {

	Id uint  `orm:"serial PRIMARY KEY"`
	CreatedAt time.Time 
	UpdatedAt time.Time 
	UserName string `orm:"varchar(255) not null"`
	Email string `orm:"varchar(255) not null"`
	Phone string `orm:"varchar(255) not null"`
	Age  float32  `orm:"int"`
}


func main() {
    a:= User{}
    modelpkg.Migrate(a)
}

how to insert data:

import (
	"fmt"
	"time"
	managers "github.com/aliaqa256/go_pgsql_orm/managerspkg"
)
func main() {
    user := &User{
        UserName: "Aliaqa",
        Email: "[email protected]"
        age: 25,
        Phone: "09121234567",
    }
    managers.Create(user)
}

how to get id of one record:

dbc:=managers.GetId(user,map[string]string{
 	"username": "aliaqa",
    "email": "[email protected]"
 })

 fmt.Println(dbc.Resualt)

how to get < filed > of one record:

                    ///   struct,id,fieldname
	dbc:=managers.GetField(user,26,"age")
	fmt.Println(dbc.Resualt)

if you have any suggestions or questions please contact me at :

https://alilotfidev.ir
[email protected]