func (r *Repository) FindOneBy(db *mysql551.Mysql, mInfo *model551.ModelInformation, param map[string]interface{}) interface{} {
sql := mInfo.SqlInformation.Select
var values []interface{}
for key, value := range param {
sql = string551.Join(sql, " AND `"+key+"` = ?")
values = append(values, value)
}
rows := db.Query(sql, values...)
defer rows.Close()
var model interface{} = nil
for rows.Next() {
if model != nil {
panic(errors.New("Extraction result there is more than one."))
}
model = mInfo.NewFuncPointer()
modelScan, ok := model.(model551.ScanInterface)
if !ok {
panic(errors.New("Not found: 'T.Scan(rows *sql.rows) error' method"))
}
err := modelScan.Scan(rows)
if err != nil {
panic(err)
}
}
return model
}
func (r *Repository) Find(db *mysql551.Mysql, mInfo *model551.ModelInformation, id int64) interface{} {
sql := mInfo.SqlInformation.Select + " AND `" + mInfo.TableInformation.PrimaryKey + "` = ?"
param := []interface{}{id}
rows := db.Query(sql, param...)
defer rows.Close()
if !rows.Next() {
return nil
}
model := mInfo.NewFuncPointer()
modelScan, ok := model.(model551.ScanInterface)
if !ok {
panic(errors.New("Not found: 'T.Scan(rows *sql.rows) error' method"))
}
err := modelScan.Scan(rows)
if err != nil {
panic(err)
}
return model
}
func (r *Repository) Delete(db *mysql551.Mysql, mInfo *model551.ModelInformation, model interface{}) {
// Delete
sql := mInfo.SqlInformation.Delete
idModel, ok := model.(model551.PrimaryInterface)
if !ok {
panic(errors.New("Not found: 'T.SetId(int64)', 'T.Id() int64' method"))
}
db.Exec(sql, idModel.GetId())
if !mInfo.TableInformation.DeleteTable {
return
}
// Logical Delete( Insert into delete table.)
sql = mInfo.SqlInformation.LogicalDelete
sqlValueModel, ok := model.(model551.ValuesInterface)
if !ok {
panic(errors.New("Not found: 'T.SqlValues(sqlType SqlType) []interface{}' method"))
}
param := sqlValueModel.SqlValues(model551.SQL_LOGICAL_DELETE)
db.Exec(sql, param...)
}
func (r *Repository) Update(db *mysql551.Mysql, mInfo *model551.ModelInformation, model interface{}) interface{} {
sql := mInfo.SqlInformation.Update
if iUpdate, ok := model.(model551.SqlUpdateInterface); ok {
sql = iUpdate.SqlUpdate()
}
sqlValueModel, ok := model.(model551.ValuesInterface)
if !ok {
panic(errors.New("Not found: 'T.SqlValues(sqlType SqlType) []interface{}' method"))
}
param := sqlValueModel.SqlValues(model551.SQL_UPDATE)
db.Exec(sql, param...)
return model
}
func (r *Repository) Create(db *mysql551.Mysql, mInfo *model551.ModelInformation, model interface{}) interface{} {
sql := mInfo.SqlInformation.Insert
if iInsert, ok := model.(model551.SqlInsertInterface); ok {
sql = iInsert.SqlInsert()
}
sqlValueModel, ok := model.(model551.ValuesInterface)
if !ok {
panic(errors.New("Not found: 'T.SqlValues(sqlType SqlType) []interface{}' method"))
}
param := sqlValueModel.SqlValues(model551.SQL_INSERT)
_, lastInsertId := db.Exec(sql, param...)
idModel, ok := model.(model551.PrimaryInterface)
if !ok {
panic(errors.New("Not found: 'T.SetId(int64)', 'T.Id() int64' method"))
}
idModel.SetId(lastInsertId)
return model
}