.\" Automatically generated by Pod::Man 4.10 (Pod::Simple 3.35)
.\"
.\" Standard preamble:
.\" ========================================================================
.de Sp \" Vertical space (when we can't use .PP)
.if t .sp .5v
.if n .sp
..
.de Vb \" Begin verbatim text
.ft CW
.nf
.ne \\$1
..
.de Ve \" End verbatim text
.ft R
.fi
..
.\" Set up some character translations and predefined strings.  \*(-- will
.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
.\" double quote, and \*(R" will give a right double quote.  \*(C+ will
.\" give a nicer C++.  Capital omega is used to do unbreakable dashes and
.\" therefore won't be available.  \*(C` and \*(C' expand to `' in nroff,
.\" nothing in troff, for use with C<>.
.tr \(*W-
.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
.ie n \{\
.    ds -- \(*W-
.    ds PI pi
.    if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
.    if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\"  diablo 12 pitch
.    ds L" ""
.    ds R" ""
.    ds C` ""
.    ds C' ""
'br\}
.el\{\
.    ds -- \|\(em\|
.    ds PI \(*p
.    ds L" ``
.    ds R" ''
.    ds C`
.    ds C'
'br\}
.\"
.\" Escape single quotes in literal strings from groff's Unicode transform.
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\"
.\" If the F register is >0, we'll generate index entries on stderr for
.\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index
.\" entries marked with X<> in POD.  Of course, you'll have to process the
.\" output yourself in some meaningful fashion.
.\"
.\" Avoid warning from groff about undefined register 'F'.
.de IX
..
.nr rF 0
.if \n(.g .if rF .nr rF 1
.if (\n(rF:(\n(.g==0)) \{\
.    if \nF \{\
.        de IX
.        tm Index:\\$1\t\\n%\t"\\$2"
..
.        if !\nF==2 \{\
.            nr % 0
.            nr F 2
.        \}
.    \}
.\}
.rr rF
.\"
.\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2).
.\" Fear.  Run.  Save yourself.  No user-serviceable parts.
.    \" fudge factors for nroff and troff
.if n \{\
.    ds #H 0
.    ds #V .8m
.    ds #F .3m
.    ds #[ \f1
.    ds #] \fP
.\}
.if t \{\
.    ds #H ((1u-(\\\\n(.fu%2u))*.13m)
.    ds #V .6m
.    ds #F 0
.    ds #[ \&
.    ds #] \&
.\}
.    \" simple accents for nroff and troff
.if n \{\
.    ds ' \&
.    ds ` \&
.    ds ^ \&
.    ds , \&
.    ds ~ ~
.    ds /
.\}
.if t \{\
.    ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u"
.    ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u'
.    ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u'
.    ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u'
.    ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u'
.    ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u'
.\}
.    \" troff and (daisy-wheel) nroff accents
.ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V'
.ds 8 \h'\*(#H'\(*b\h'-\*(#H'
.ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#]
.ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H'
.ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u'
.ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#]
.ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#]
.ds ae a\h'-(\w'a'u*4/10)'e
.ds Ae A\h'-(\w'A'u*4/10)'E
.    \" corrections for vroff
.if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u'
.if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u'
.    \" for low resolution devices (crt and lpr)
.if \n(.H>23 .if \n(.V>19 \
\{\
.    ds : e
.    ds 8 ss
.    ds o a
.    ds d- d\h'-1'\(ga
.    ds D- D\h'-1'\(hy
.    ds th \o'bp'
.    ds Th \o'LP'
.    ds ae ae
.    ds Ae AE
.\}
.rm #[ #] #H #V #F C
.\" ========================================================================
.\"
.IX Title "Mojo::SQLite::Migrations 3pm"
.TH Mojo::SQLite::Migrations 3pm "2019-02-03" "perl v5.28.1" "User Contributed Perl Documentation"
.\" For nroff, turn off justification.  Always turn off hyphenation; it makes
.\" way too many mistakes in technical documents.
.if n .ad l
.nh
.SH "NAME"
Mojo::SQLite::Migrations \- Migrations
.SH "SYNOPSIS"
.IX Header "SYNOPSIS"
.Vb 1
\&  use Mojo::SQLite::Migrations;
\&
\&  my $migrations = Mojo::SQLite::Migrations\->new(sqlite => $sql);
\&  $migrations\->from_file(\*(Aq/home/dbook/migrations.sql\*(Aq)\->migrate;
.Ve
.SH "DESCRIPTION"
.IX Header "DESCRIPTION"
Mojo::SQLite::Migrations is used by Mojo::SQLite to allow database
schemas to evolve easily over time. A migration file is just a collection of
sql blocks, with one or more statements, separated by comments of the form
\&\f(CW\*(C`\-\- VERSION UP/DOWN\*(C'\fR.
.PP
.Vb 5
\&  \-\- 1 up
\&  create table messages (message text);
\&  insert into messages values (\*(AqI X Mojolicious!\*(Aq);
\&  \-\- 1 down
\&  drop table messages;
\&
\&  \-\- 2 up (...you can comment freely here...)
\&  create table stuff (whatever integer);
\&  \-\- 2 down
\&  drop table stuff;
.Ve
.PP
The idea is to let you migrate from any version, to any version, up and down.
Migrations are very safe, because they are performed in transactions and only
one can be performed at a time. If a single statement fails, the whole
migration will fail and get rolled back. Every set of migrations has a
\&\*(L"name\*(R", which is stored together with the currently active version in an
automatically created table named \f(CW\*(C`mojo_migrations\*(C'\fR.
.SH "ATTRIBUTES"
.IX Header "ATTRIBUTES"
Mojo::SQLite::Migrations implements the following attributes.
.SS "name"
.IX Subsection "name"
.Vb 2
\&  my $name    = $migrations\->name;
\&  $migrations = $migrations\->name(\*(Aqfoo\*(Aq);
.Ve
.PP
Name for this set of migrations, defaults to \f(CW\*(C`migrations\*(C'\fR.
.SS "sqlite"
.IX Subsection "sqlite"
.Vb 2
\&  my $sql     = $migrations\->sqlite;
\&  $migrations = $migrations\->sqlite(Mojo::SQLite\->new);
.Ve
.PP
Mojo::SQLite object these migrations belong to.
.SH "METHODS"
.IX Header "METHODS"
Mojo::SQLite::Migrations inherits all methods from Mojo::Base and
implements the following new ones.
.SS "active"
.IX Subsection "active"
.Vb 1
\&  my $version = $migrations\->active;
.Ve
.PP
Currently active version.
.SS "from_data"
.IX Subsection "from_data"
.Vb 3
\&  $migrations = $migrations\->from_data;
\&  $migrations = $migrations\->from_data(\*(Aqmain\*(Aq);
\&  $migrations = $migrations\->from_data(\*(Aqmain\*(Aq, \*(Aqfile_name\*(Aq);
.Ve
.PP
Extract migrations from a file in the \s-1DATA\s0 section of a class with
\&\*(L"data_section\*(R" in Mojo::Loader, defaults to using the caller class and
\&\*(L"name\*(R".
.PP
.Vb 7
\&  _\|_DATA_\|_
\&  @@ migrations
\&  \-\- 1 up
\&  create table messages (message text);
\&  insert into messages values (\*(AqI X Mojolicious!\*(Aq);
\&  \-\- 1 down
\&  drop table messages;
.Ve
.SS "from_file"
.IX Subsection "from_file"
.Vb 1
\&  $migrations = $migrations\->from_file(\*(Aq/home/dbook/migrations.sql\*(Aq);
.Ve
.PP
Extract migrations from a file.
.SS "from_string"
.IX Subsection "from_string"
.Vb 6
\&  $migrations = $migrations\->from_string(
\&    \*(Aq\-\- 1 up
\&     create table foo (bar integer);
\&     \-\- 1 down
\&     drop table foo;\*(Aq
\&  );
.Ve
.PP
Extract migrations from string.
.SS "latest"
.IX Subsection "latest"
.Vb 1
\&  my $version = $migrations\->latest;
.Ve
.PP
Latest version available.
.SS "migrate"
.IX Subsection "migrate"
.Vb 2
\&  $migrations = $migrations\->migrate;
\&  $migrations = $migrations\->migrate(3);
.Ve
.PP
Migrate from \*(L"active\*(R" to a different version, up or down, defaults to using
\&\*(L"latest\*(R". All version numbers need to be positive, with version \f(CW0\fR
representing an empty database.
.PP
.Vb 2
\&  # Reset database
\&  $migrations\->migrate(0)\->migrate;
.Ve
.SS "sql_for"
.IX Subsection "sql_for"
.Vb 1
\&  my $sql = $migrations\->sql_for(5, 10);
.Ve
.PP
Get \s-1SQL\s0 to migrate from one version to another, up or down.
.SH "DEBUGGING"
.IX Header "DEBUGGING"
You can set the \f(CW\*(C`MOJO_MIGRATIONS_DEBUG\*(C'\fR environment variable to get some
advanced diagnostics information printed to \f(CW\*(C`STDERR\*(C'\fR.
.PP
.Vb 1
\&  MOJO_MIGRATIONS_DEBUG=1
.Ve
.SH "BUGS"
.IX Header "BUGS"
Report any issues on the public bugtracker.
.SH "AUTHOR"
.IX Header "AUTHOR"
Dan Book, \f(CW\*(C`dbook@cpan.org\*(C'\fR
.SH "COPYRIGHT AND LICENSE"
.IX Header "COPYRIGHT AND LICENSE"
Copyright 2015, Dan Book.
.PP
This library is free software; you may redistribute it and/or modify it under
the terms of the Artistic License version 2.0.
.SH "SEE ALSO"
.IX Header "SEE ALSO"
Mojo::SQLite