github.com/uber/kraken@v0.1.4/localdb/migrations/00001_tagreplication_init.go (about)

     1  // Copyright (c) 2016-2019 Uber Technologies, Inc.
     2  //
     3  // Licensed under the Apache License, Version 2.0 (the "License");
     4  // you may not use this file except in compliance with the License.
     5  // You may obtain a copy of the License at
     6  //
     7  //     http://www.apache.org/licenses/LICENSE-2.0
     8  //
     9  // Unless required by applicable law or agreed to in writing, software
    10  // distributed under the License is distributed on an "AS IS" BASIS,
    11  // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    12  // See the License for the specific language governing permissions and
    13  // limitations under the License.
    14  package migrations
    15  
    16  import (
    17  	"database/sql"
    18  
    19  	"github.com/pressly/goose"
    20  )
    21  
    22  func init() {
    23  	goose.AddMigration(up00001, down00001)
    24  }
    25  
    26  func up00001(tx *sql.Tx) error {
    27  	_, err := tx.Exec(
    28  		`CREATE TABLE IF NOT EXISTS replicate_tag_task (
    29  		tag          text      NOT NULL,
    30  		digest       blob      NOT NULL,
    31  		dependencies blob      NOT NULL,
    32  		destination  text      NOT NULL,
    33  		created_at   timestamp DEFAULT CURRENT_TIMESTAMP,
    34  		last_attempt timestamp NOT NULL,
    35  		status       text      NOT NULL,
    36  		failures     integer   NOT NULL,
    37  		delay        integer   NOT NULL,
    38  		PRIMARY KEY(tag, destination)
    39  	);`)
    40  	return err
    41  }
    42  
    43  func down00001(tx *sql.Tx) error {
    44  	_, err := tx.Exec(`DROP TABLE replicate_tag_task;`)
    45  	return err
    46  }