github.com/uber/kraken@v0.1.4/localdb/migrations/00002_writeback_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(up00002, down00002)
    24  }
    25  
    26  func up00002(tx *sql.Tx) error {
    27  	_, err := tx.Exec(`
    28  		CREATE TABLE IF NOT EXISTS writeback_task (
    29  			namespace    text      NOT NULL,
    30  			name         text      NOT NULL,
    31  			created_at   timestamp DEFAULT CURRENT_TIMESTAMP,
    32  			last_attempt timestamp NOT NULL,
    33  			status       text      NOT NULL,
    34  			failures     integer   NOT NULL,
    35  			delay        integer   NOT NULL,
    36  			PRIMARY KEY(namespace, name)
    37  		);
    38  	`)
    39  	return err
    40  }
    41  
    42  func down00002(tx *sql.Tx) error {
    43  	_, err := tx.Exec(`DROP TABLE writeback_task;`)
    44  	return err
    45  }