dsfs504545
dsfs504545
2018-03-30 05:25

如何使用gorm获取多个用户的数据?

已采纳

Database: MySql I have a two structs as follows:

type Person struct {
    gorm.Model
    Name    string
    Address string
}

type Address struct {
    gorm.Model
    PersonID int
    Address  []Address
}

I want to fetch data of multiple persons with there adresses. I tried it like:

var result []Person
db.Table("persons").Select("persons.id,persons.created_at, persons.updated_at,persons.deleted_at,persons.name,addresses.address").Joins("inner join addresses on addresses.person_id = persons.id").Scan(&result)

I got result:

[
  {
    ID: 13,
    CreatedAt: '2018-03-28T16:25:43+05:30',
    UpdatedAt: '2018-03-28T16:28:31+05:30',
    DeletedAt: null,
    Name: 'roshan',
    Address: null
  },
  {
    ID: 13,
    CreatedAt: '2018-03-28T16:25:43+05:30',
    UpdatedAt: '2018-03-28T16:28:31+05:30',
    DeletedAt: null,
    Name: 'roshan',
    Address: null
  },
  {
    ID: 14,
    CreatedAt: '2018-03-28T16:25:43+05:30',
    UpdatedAt: '0001-01-01T00:00:00Z',
    DeletedAt: null,
    Name: 'kunal2',
    Address: null
  }
];

expexted result is

[
  {
    ID: 13,
    CreatedAt: '2018-03-28T16:25:43+05:30',
    UpdatedAt: '2018-03-28T16:28:31+05:30',
    DeletedAt: null,
    Name: 'roshan',
    Address: ['pune', 'nagpur']
  },
  {
    ID: 14,
    CreatedAt: '2018-03-28T16:25:43+05:30',
    UpdatedAt: '0001-01-01T00:00:00Z',
    DeletedAt: null,
    Name: 'kunal2',
    Address: ['New York']
  }
];
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答

  • dsgfdgh14569 dsgfdgh14569 3年前

    First of all you probably should change your model declarations to this

    type Person struct {
        gorm.Model
        Name    string
        Address []Address
    }
    
    type Address struct {
        gorm.Model
        PersonID int
    }
    

    And then to preload associations you can use this query

    var person []Person
    
    err := db.Preload("Address").Find(&person).Error
    

    where you person param will be te results from db with preloaded addresses

    点赞 评论 复制链接分享