wehub-resource-sync
82 lines
3.3 KiB
Go
82 lines
3.3 KiB
Go
/*
|
|
* Licensed to the Apache Software Foundation (ASF) under one
|
|
* or more contributor license agreements. See the NOTICE file
|
|
* distributed with this work for additional information
|
|
* regarding copyright ownership. The ASF licenses this file
|
|
* to you under the Apache License, Version 2.0 (the
|
|
* "License"); you may not use this file except in compliance
|
|
* with the License. You may obtain a copy of the License at
|
|
*
|
|
* http://www.apache.org/licenses/LICENSE-2.0
|
|
*
|
|
* Unless required by applicable law or agreed to in writing,
|
|
* software distributed under the License is distributed on an
|
|
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
|
|
* KIND, either express or implied. See the License for the
|
|
* specific language governing permissions and limitations
|
|
* under the License.
|
|
*/
|
|
|
|
package migrations
|
|
|
|
import (
|
|
"context"
|
|
"fmt"
|
|
"time"
|
|
|
|
"github.com/apache/answer/internal/entity"
|
|
"github.com/segmentfault/pacman/log"
|
|
"xorm.io/xorm"
|
|
)
|
|
|
|
type QuestionPostTime struct {
|
|
ID string `xorm:"not null pk BIGINT(20) id"`
|
|
CreatedAt time.Time `xorm:"not null default CURRENT_TIMESTAMP TIMESTAMP created_at"`
|
|
UpdatedAt time.Time `xorm:"updated_at TIMESTAMP"`
|
|
UserID string `xorm:"not null default 0 BIGINT(20) INDEX user_id"`
|
|
LastEditUserID string `xorm:"not null default 0 BIGINT(20) last_edit_user_id"`
|
|
Title string `xorm:"not null default '' VARCHAR(150) title"`
|
|
OriginalText string `xorm:"not null MEDIUMTEXT original_text"`
|
|
ParsedText string `xorm:"not null MEDIUMTEXT parsed_text"`
|
|
Status int `xorm:"not null default 1 INT(11) status"`
|
|
Pin int `xorm:"not null default 1 INT(11) pin"`
|
|
Show int `xorm:"not null default 1 INT(11) show"`
|
|
ViewCount int `xorm:"not null default 0 INT(11) view_count"`
|
|
UniqueViewCount int `xorm:"not null default 0 INT(11) unique_view_count"`
|
|
VoteCount int `xorm:"not null default 0 INT(11) vote_count"`
|
|
AnswerCount int `xorm:"not null default 0 INT(11) answer_count"`
|
|
CollectionCount int `xorm:"not null default 0 INT(11) collection_count"`
|
|
FollowCount int `xorm:"not null default 0 INT(11) follow_count"`
|
|
AcceptedAnswerID string `xorm:"not null default 0 BIGINT(20) accepted_answer_id"`
|
|
LastAnswerID string `xorm:"not null default 0 BIGINT(20) last_answer_id"`
|
|
PostUpdateTime time.Time `xorm:"post_update_time TIMESTAMP"`
|
|
RevisionID string `xorm:"not null default 0 BIGINT(20) revision_id"`
|
|
}
|
|
|
|
func (QuestionPostTime) TableName() string {
|
|
return "question"
|
|
}
|
|
|
|
func updateQuestionPostTime(ctx context.Context, x *xorm.Engine) error {
|
|
questionList := make([]QuestionPostTime, 0)
|
|
err := x.Context(ctx).Find(&questionList, &entity.Question{})
|
|
if err != nil {
|
|
return fmt.Errorf("get questions failed: %w", err)
|
|
}
|
|
for _, item := range questionList {
|
|
if item.PostUpdateTime.IsZero() {
|
|
if !item.UpdatedAt.IsZero() {
|
|
item.PostUpdateTime = item.UpdatedAt
|
|
} else if !item.CreatedAt.IsZero() {
|
|
item.PostUpdateTime = item.CreatedAt
|
|
}
|
|
if _, err = x.Context(ctx).Update(item, &QuestionPostTime{ID: item.ID}); err != nil {
|
|
log.Errorf("update %+v config failed: %s", item, err)
|
|
return fmt.Errorf("update question failed: %w", err)
|
|
}
|
|
}
|
|
}
|
|
|
|
return nil
|
|
}
|