Example #1
0
func (this *User) Save() error {
	this.CreateTime = time.Now().UnixNano()
	this.LastUpdateTime = this.CreateTime
	_, err := repo.Run().Exec(`INSERT INTO "user"(username, password, nickname, status, email, createtime, lastupdatetime, salt, authority) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9);`,
		this.Username, this.Password, this.Nickname, this.Status, this.Email, this.CreateTime, this.LastUpdateTime, this.Salt, this.Authority)
	return err
}
Example #2
0
func (userUtil) GetAllUsers() ([]*User, error) {
	rows, err := repo.Run().Query(`SELECT id, username, password, nickname, status, email, createtime, lastupdatetime, salt, authority FROM "user";`)
	if err != nil {
		return nil, err
	}
	defer func() {
		e := rows.Close()
		if e != nil {
			log.Println(e)
		}
	}()
	l := list.New()
	for rows.Next() {
		user, err := wrapUser(rows)
		if err != nil {
			return nil, err
		}
		l.PushBack(user)
	}
	if l.Len() > 0 {
		result := make([]*User, l.Len())
		idx := 0
		for e := l.Front(); e != nil; e = e.Next() {
			result[idx] = e.Value.(*User)
			idx++
		}
		return result, nil
	} else {
		return []*User{}, nil
	}
}
Example #3
0
func (postUtil) GetIndexPosts() ([]*Post, error) {
	// record limit is 10
	rows, err := repo.Run().Query(`
SELECT id, title, abstract, content, status, posttime, lastupdatetime, userid FROM post where status = 0 order by posttime desc limit 10;
	`)
	if err != nil {
		return nil, err
	}
	defer func() {
		e := rows.Close()
		if e != nil {
			log.Println(e)
		}
	}()
	l := list.New()
	for rows.Next() {
		post, err := WrapPost(rows)
		if err != nil {
			return nil, err
		}
		l.PushBack(post)
	}
	if l.Len() > 0 {
		result := make([]*Post, l.Len())
		idx := 0
		for e := l.Front(); e != nil; e = e.Next() {
			result[idx] = e.Value.(*Post)
			idx++
		}
		return result, nil
	} else {
		return []*Post{}, nil
	}
}
Example #4
0
func (this *Post) FillPostById() error {
	var userId int64 = -1
	r := repo.Run().QueryRow(`
SELECT title, abstract, content, status, posttime, lastupdatetime, userid FROM post where id = $1;
	`, this.Id)
	e := r.Scan(&this.Title, &this.Abstract, &this.Content, &this.Status, &this.PostTime, &this.LastUpdateTime, &userId)
	if e != nil {
		if e == sql.ErrNoRows {
			return NO_SUCH_RECORD
		} else {
			return e
		}
	}
	if userId <= 0 {
		return NO_USER_RELATED
	}
	user := NewUser()
	user.Id = userId
	err := user.FillUserById()
	if err != nil {
		return err
	}
	this.PostUser = user
	return nil
}
Example #5
0
func (this *Post) Save() error {
	this.PostTime = time.Now().UnixNano()
	this.LastUpdateTime = this.PostTime
	_, err := repo.Run().Exec(`
INSERT INTO post(title, abstract, content, status, posttime, lastupdatetime, userid)
VALUES ($1, $2, $3, $4, $5, $6, $7);
	`, this.Title, this.Abstract, this.Content, this.Status, this.PostTime, this.LastUpdateTime, this.PostUser.Id)
	return err
}
Example #6
0
func (this *User) FillUserByUsername() error {
	r := repo.Run().QueryRow(`SELECT id, password, nickname, status, email, createtime, lastupdatetime, salt, authority FROM "user" where username = $1;`, this.Username)
	e := r.Scan(&this.Id, &this.Password, &this.Nickname, &this.Status, &this.Email, &this.CreateTime, &this.LastUpdateTime, &this.Salt, &this.Authority)
	if e != nil {
		if e == sql.ErrNoRows {
			return NO_SUCH_RECORD
		} else {
			return e
		}
	} else {
		return nil
	}
}
Example #7
0
func (userUtil) UserExists(username string) (bool, error) {
	id := int64(-1)
	r := repo.Run().QueryRow(`SELECT id FROM "user" where username = $1;`, username)
	e := r.Scan(&id)
	if e != nil {
		if e == sql.ErrNoRows {
			return false, nil
		} else {
			return false, e
		}
	} else {
		return true, nil
	}
}