How do I insert the struct inside the range?
//Department array (department table)
var depValues []model.Department = []model.Department{
model.Department{DepartmentName: "Software Analyst", DeptCode: "SA"},
model.Department{DepartmentName: "Bussiness Analyst", DeptCode: "BA"},
}
for _, dep := range depValues {
db.Create(&dep) //It's working fine
}
Here, dep.ID
return the both records id
//Another array (employee table)
var empValues []model.Employee = []model.Employee{
model.Employee{EmpId: "001", EmpName: "samsung", departmentRef: dep.ID},
model.Employee{EmpId: "002", EmpName: "Nokia", departmentRef: dep.ID},
}
Now, I want to insert the departmentId
into employee
table, How can I do it, Any one can teach me.
Already Tried
It will be return duplicate values
var depValues []model.Department = []model.Department{
model.Department{DepartmentName: "Software Analyst", DeptCode: "SA"},
model.Department{DepartmentName: "Bussiness Analyst", DeptCode: "BA"},
}
for _, dep := range depValues {
db.Create(&dep)
//Insert into Employee
var empValues []model.Employee = []model.Employee{
model.Employee{EmpId: "001", EmpName: "samsung", DepRefer: dep.ID},
model.Employee{EmpId: "002", EmpName: "Nokia", DepRefer: dep.ID},
}
for _, empv := range empValues {
db.Create(&empv)
}
}
Database duplicate records
'1', '2018-07-10 15:12:27', '2018-07-10 15:12:27', NULL, '001', 'samsung', '1'
'2', '2018-07-10 15:12:28', '2018-07-10 15:12:28', NULL, '002', 'Nokia', '2'
'3', '2018-07-10 15:12:29', '2018-07-10 15:12:29', NULL, '001', 'samsung', '1'
'4', '2018-07-10 15:12:29', '2018-07-10 15:12:29', NULL, '002', 'Nokia', '2'