github.com/goravel/framework@v1.13.9/database/console/migrate_stubs.go (about)

     1  package console
     2  
     3  type MysqlStubs struct {
     4  }
     5  
     6  // CreateUp Create up migration content.
     7  func (receiver MysqlStubs) CreateUp() string {
     8  	return `CREATE TABLE DummyTable (
     9    id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    10    created_at datetime(3) NOT NULL,
    11    updated_at datetime(3) NOT NULL,
    12    PRIMARY KEY (id),
    13    KEY idx_DummyTable_created_at (created_at),
    14    KEY idx_DummyTable_updated_at (updated_at)
    15  ) ENGINE = InnoDB DEFAULT CHARSET = DummyDatabaseCharset;
    16  `
    17  }
    18  
    19  // CreateDown Create down migration content.
    20  func (receiver MysqlStubs) CreateDown() string {
    21  	return `DROP TABLE IF EXISTS DummyTable;
    22  `
    23  }
    24  
    25  // UpdateUp Update up migration content.
    26  func (receiver MysqlStubs) UpdateUp() string {
    27  	return `ALTER TABLE DummyTable ADD column varchar(255) COMMENT '';
    28  `
    29  }
    30  
    31  // UpdateDown Update down migration content.
    32  func (receiver MysqlStubs) UpdateDown() string {
    33  	return `ALTER TABLE DummyTable DROP COLUMN column;
    34  `
    35  }
    36  
    37  type PostgresqlStubs struct {
    38  }
    39  
    40  // CreateUp Create up migration content.
    41  func (receiver PostgresqlStubs) CreateUp() string {
    42  	return `CREATE TABLE DummyTable (
    43    id SERIAL PRIMARY KEY NOT NULL,
    44    created_at timestamp NOT NULL,
    45    updated_at timestamp NOT NULL
    46  );
    47  `
    48  }
    49  
    50  // CreateDown Create down migration content.
    51  func (receiver PostgresqlStubs) CreateDown() string {
    52  	return `DROP TABLE IF EXISTS DummyTable;
    53  `
    54  }
    55  
    56  // UpdateUp Update up migration content.
    57  func (receiver PostgresqlStubs) UpdateUp() string {
    58  	return `ALTER TABLE DummyTable ADD column varchar(255) NOT NULL;
    59  `
    60  }
    61  
    62  // UpdateDown Update down migration content.
    63  func (receiver PostgresqlStubs) UpdateDown() string {
    64  	return `ALTER TABLE DummyTable DROP COLUMN column;
    65  `
    66  }
    67  
    68  type SqliteStubs struct {
    69  }
    70  
    71  // CreateUp Create up migration content.
    72  func (receiver SqliteStubs) CreateUp() string {
    73  	return `CREATE TABLE DummyTable (
    74    id integer PRIMARY KEY AUTOINCREMENT NOT NULL,
    75    created_at datetime NOT NULL,
    76    updated_at datetime NOT NULL
    77  );
    78  `
    79  }
    80  
    81  // CreateDown Create down migration content.
    82  func (receiver SqliteStubs) CreateDown() string {
    83  	return `DROP TABLE IF EXISTS DummyTable;
    84  `
    85  }
    86  
    87  // UpdateUp Update up migration content.
    88  func (receiver SqliteStubs) UpdateUp() string {
    89  	return `ALTER TABLE DummyTable ADD column text;
    90  `
    91  }
    92  
    93  // UpdateDown Update down migration content.
    94  func (receiver SqliteStubs) UpdateDown() string {
    95  	return `ALTER TABLE DummyTable DROP COLUMN column;
    96  `
    97  }
    98  
    99  type SqlserverStubs struct {
   100  }
   101  
   102  // CreateUp Create up migration content.
   103  func (receiver SqlserverStubs) CreateUp() string {
   104  	return `CREATE TABLE DummyTable (
   105    id bigint NOT NULL IDENTITY(1,1),
   106    created_at datetime NOT NULL,
   107    updated_at datetime NOT NULL,
   108    PRIMARY KEY (id)
   109  );
   110  `
   111  }
   112  
   113  // CreateDown Create down migration content.
   114  func (receiver SqlserverStubs) CreateDown() string {
   115  	return `DROP TABLE IF EXISTS DummyTable;
   116  `
   117  }
   118  
   119  // UpdateUp Update up migration content.
   120  func (receiver SqlserverStubs) UpdateUp() string {
   121  	return `ALTER TABLE DummyTable ADD column varchar(255);
   122  `
   123  }
   124  
   125  // UpdateDown Update down migration content.
   126  func (receiver SqlserverStubs) UpdateDown() string {
   127  	return `ALTER TABLE DummyTable DROP COLUMN column;
   128  `
   129  }