GModel

GModel are parts of MVC, meaning for model and running for Go. the go model learning from php framework models, and Golang Features to operate databases for sql easily.

HelloWorld!

import package

go get github.com/lingdor/gmodel

gsql package demos:

where:=gsql.group(gsql.Equal(TbUserFields.Id, 123).And(gsql.Gt(TbUserFields.Id, 5))).Or(gsql.Like(TbUserFields.Name, "%tom%"))
gmodel.QueryArr(tx, gsql.Select().From("user").Where(where).Last(gsql.Limit(1, 2)))
gmodel.QueryMap(tx, gsql.Select("id",""user_name","age").From("user").Where(gsql.Eq("id",1)).OrderBy(gsql.Asc("id")))
gmodel.QueryArrRows(tx, gsql.Select().From(TbUserSchema).Limit(10))
//Join SQLs:gmodel.QueryMap(tx,conn,gsql.Select("u.id","u.name").from("user1")
.LeftJoin(gsql.As("school","s")).On(gsql.Eq("s.id",gsql.Sql("u.school_id"))).Where(gsql.Eq("u.age",12))
// update Sqls:gmodel.Execute(ctx,conn,gsql.Update("user").SetMap(map[string]any{
"user_name": 'user_updated',
"age": 22,
}.Where(gmodel.Eq("id",1)).Last(gsql.Limit(1));
gmodel.Execute(ctx,conn,gsql.Update("user").Set("user_name","xx").Set("age",80).Where(gsql.Eq("id",1)).Last(gsql.Limit(1));
//insert gsqlgmodel.Execute(ctx,conn,gsql.Insert("user").MapValues(mapsmap[string]string{
"user_name":"user1",
"age":11,
}).
MapValues(mapsmap[string]string{
"user_name":"user2",
"age":12,
}))
}
gmodel.Execute(ctx,conn,gsql.Insert("user","user_name","age").Values("uname1",12).Values("user2",19);
ivals:=map[string]any{
"user_name": "lily",
"age": 12,
}
gmodel.Execute(ctx, conn, gsql.Insert("user").valuesMap(vals))

orm package demos:

//insert ormgmodel.Execute(ctx,conn,orm.Insert(UserSchema).ValuesMap(map[Field]any{
UserSchema.UserName:"user1",
UserSchema.Age:11,
})
gmodel.Execute(ctx,conn,orm.Insert(Tbuser,UserSchema.UserName,UserSchema.Age).Values("uname1",12).Values("user2",19);
//insert into select:gmodel.Execute(ctx,conn,orm.Insert(UserSchema).Select().From(UserSchema).Where(orm.Eq(UserSchema.Id,1))
// insert set:gmodel.Execute(ctx,conn,gsql.Insert(UserSchema).Set(UserSchema.UserName,"testuser").Set(UserSchema.Age,16));

todo: gentools read/write database config load