github.com/qiuhoude/go-web@v0.0.0-20220223060959-ab545e78f20d/blogweb_gin/models/album_model.go (about)

     1  package models
     2  
     3  import "github.com/qiuhoude/go-web/blogweb_gin/database"
     4  
     5  type Album struct {
     6  	Id         int
     7  	Filepath   string
     8  	Filename   string
     9  	Status     int
    10  	Createtime int64
    11  }
    12  
    13  // 插入图片
    14  func InsertAlbum(album Album) (int64, error) {
    15  	return database.ModifyDB("insert into album(filepath,filename,status,createtime) values(?,?,?,?)",
    16  		album.Filepath, album.Filename, album.Status, album.Createtime)
    17  }
    18  
    19  func FindAllAlbums() ([]Album, error) {
    20  	rows, err := database.QueryDb("select id,filepath,filename,status,createtime from album")
    21  	if err != nil {
    22  		return nil, err
    23  	}
    24  	var albums []Album
    25  	for rows.Next() {
    26  		id := 0
    27  		filepath := ""
    28  		filename := ""
    29  		status := 0
    30  		var createtime int64
    31  		createtime = 0
    32  		rows.Scan(&id, &filepath, &filename, &status, &createtime)
    33  		album := Album{id, filepath, filename, status, createtime}
    34  		albums = append(albums, album)
    35  	}
    36  	return albums, nil
    37  }