Jifty::Upgrade(3pm) User Contributed Perl Documentation Jifty::Upgrade(3pm)NAME
Jifty::Upgrade - Superclass for schema/data upgrades to Jifty applications
SYNOPSIS
package MyApp::Upgrade;
use base qw/ Jifty::Upgrade /;
use Jifty::Upgrade qw/ since rename /;
since '0.7.4' => sub {
# Rename a column
rename table => 'cthulus', name => 'description',
to => 'mind_numbingly_horrible_word_picture';
};
since '0.6.1' => sub {
my @sizes = ('Huge', 'Gigantic', 'Monstrous', 'Really Big');
my @appearances = ('Horrible', 'Disgusting', 'Frightening', 'Evil');
# populate new columns with some random stuff
my $cthulus = MyApp::Model::CthuluCollection->new;
while (my $cthulu = $cthulus->next) {
$cthulu->set_size($sizes[ int(rand(@sizes)) ]);
$cthulu->set_appearance($appearances[ int(rand(@appearances)) ]);
}
};
DESCRIPTION
"Jifty::Upgrade" is an abstract base class to use to customize schema and data upgrades that happen.
since VERSION SUB
"since" is meant to be called by subclasses of "Jifty::Upgrade". Calling it signifies that SUB should be run when upgrading to version
VERSION, after tables and columns are added, but before tables and columns are removed. If multiple subroutines are given for the same
version, they are run in order that they were set up.
versions
Returns the list of versions that have been registered; this is called by the Jifty::Script::Schema tool to determine what to do while
upgrading.
upgrade_to VERSION
Runs the subroutine that has been registered for the given version; if no subroutine was registered, returns a no-op subroutine.
rename table => CLASS, [column => COLUMN,] to => NAME
Used in upgrade subroutines, this executes the necessary SQL to rename the table, or column in the table, to a new name.
SEE ALSO
Jifty::Manual::Upgrading
perl v5.14.2 2010-12-08 Jifty::Upgrade(3pm)
Check Out this Related Man Page
Jifty::DBI::Handle::SQLite(3pm) User Contributed Perl Documentation Jifty::DBI::Handle::SQLite(3pm)NAME
Jifty::DBI::Handle::SQLite -- A SQLite specific Handle object
SYNOPSIS DESCRIPTION
This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of SQLite.
METHODS
database_version
Returns the version of the SQLite library which is used, e.g., "2.8.0". SQLite can only return short variant.
insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported.
case_sensitive
Returns 1, since SQLite's searches are case sensitive by default. Note, however, SQLite's "like" operator is case insensitive.
distinct_count STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result count
rename_column ( table => $table, column => $old_column, to => $new_column )
rename column
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO perl(1), Jifty::DBI
perl v5.14.2 2010-09-21 Jifty::DBI::Handle::SQLite(3pm)
Man Page
15 More Discussions You Might Find Interesting
1. Post Here to Contact Site Administrators and Moderators
:confused:
Hello,
This week, I was tasked with updating the Maintenance Level from 1 to 8 on a pSeries 650 server running Aix 5.2. I used the alt_disk_install method via smit. Upon reboot after the upgrade, the LED reported back 0518 /USR MOUNT FAILED. We couldn't even get console access.... (9 Replies)
Hello,
A file named c15a is registered on my disc all 10 minutes.
I must rename that file with the actually Date and with an automatic increase number on 5 digits, so as : c15a.20070528.00001 and the next file will be : c15a.20070528.00002.
The next day so tomorrow the five digits must be... (6 Replies)
I want to copy column no 3 to the end of column
example :
alter table RECOVER_USR.MPULKIXD rename to
alter table RECOVER_USR.CS_ADV_PROMO rename to
alter table RECOVER_USR.BCH_HISTORY_TABLE rename to
alter table BILLOPS.HISHAM_DATAPLUS_FINAL rename to
alter table... (8 Replies)
i want to rename this files.
#ANTB.BHZ.KO
#ANTB.BHE.KO
#ANTB.BHN.KO
they have to be like this
#2010-10031749_ANTB.BHZ
#2010-10031749_ANTB.BHE
#2010-10031749_ANTB.BHN
plz help me:(
#ANTB.BHZ.KO
#2010-10031749_ANTB.BHZ (7 Replies)
Hi guys!
I need to upgrade the fw version of some T2000 servers, but unfortunately the image downloaded from the Oracle does not work...it seems that the image is not supported on the platform..
bash-3.00$ uname -a
SunOS adm01 5.10 Generic_141414-07 sun4v sparc SUNW,Sun-Fire-T200... (5 Replies)
Hi all,
i would like to know if it's possible upgrade AIX 5.3 to 6.1 on a LPAR without use the HMC.
so i would like to know if i must use the console to do it or i can do all from the up&running system on LPAR.
Thanks in advance.
Mario (4 Replies)
I have a power5 that I would like to update and bring everything forward.
I am wondering about trouble-free upgrades. Is it better to go 5.3 -> 7 or 5.3 ->6 ->7?
The power5 box is behind and hopefully can learn from experiences here.
Thanks. (6 Replies)
Anyone running Lion on their Mac?
I'm currently running Snow Leopard (v. 10.6.8) and have been hesitant to upgrade to 10.7.X.
Anyone at all running Lion? Any experiences good or bad to report?
Thanks! (7 Replies)
I have an HMC that I'm looking to upgrade from V7.3.4.0 SP2 to the latest version V7.7.6.0. I'm looking at the firmware levels of the systems attached to this HMC, and all of the systems have compatible firmware revisions but there are two that have been update recently and the platform IPL level... (10 Replies)
Dear Guys ..
I'm going to Upgrade one of the servers AIX 6.1
I want to stop rootvg mirror to save the mirror then upgrade to AIX 6.1 this is to help me in rollback if something goes wrong but ..
can anyone help me how to make sure that system is relay mirrored and how to know that second... (10 Replies)
Hi all,
I'm getting errors while booting AIX 7.1 after upgrade
I have used FLRT tool for the process with the following input values shown in the attached photo. titled FLRT
After reboot for the upgrade process system hangs and no response as shown in screenshot named AIX7.1-NormalBoot
I... (13 Replies)
I did an upgrade on Jan 3,2014 from CentOS 6.4 to 6.5 and noticed that there hasnt been any updates since then
Jan 03 11:45:05 Updated: 12:dhcp-common-4.1.1-38.P1.el6.centos.i686
Jan 03 11:45:06 Updated: hwdata-0.233-9.1.el6.noarch
Jan 03 11:45:11 Updated:... (4 Replies)
Hello Guys,
I was trying to upgrade the PowerHA from 6.1.0.9 to 7.1.3 in prod cluster. Have snapshot migration and run climgcheck.
1. Run climgcheck on node1(kul1pqcmur01) and it success
2. Upgrade the cluster sw
3. Run climgcheck on node2(kul1pqcmur02) and it failed with below errors
... (6 Replies)
In the below I am trying to rename the contents within each data subfolder in a specific run, based on a partial match of the IonCode_0000_ in each file in the data subdirectory to $1 in f1. There will be multiple runs in f1 but each run in $uniq is unique and will be found in f1 and the rename... (27 Replies)