[Dbconfig-common-devel]
dbconfig-common/examples/db-example-2.0/upgrade-files
db-test-mysql-2.1.sql, NONE, 1.1 db-test-pgsql-2.1.sql, NONE,
1.1 mysql-upgrade-2.1.pl, NONE, 1.1
seanius at haydn.debian.org
seanius at haydn.debian.org
Sat Jul 30 08:08:19 UTC 2005
- Previous message: [Dbconfig-common-devel] dbconfig-common/examples/db-example-2.1
COPYING, NONE, 1.1 README, NONE, 1.1
- Next message: [Dbconfig-common-devel]
dbconfig-common/examples/db-example-2.1/debian changelog, NONE,
1.1 control, NONE, 1.1 copyright, NONE,
1.1 db-test-mysql-perl.config, NONE,
1.1 db-test-mysql-perl.dirs, NONE,
1.1 db-test-mysql-perl.postinst, NONE,
1.1 db-test-mysql-perl.postrm, NONE,
1.1 db-test-mysql-perl.preinst, NONE,
1.1 db-test-mysql-perl.prerm, NONE, 1.1 db-test-mysql.config,
NONE, 1.1 db-test-mysql.dirs, NONE, 1.1 db-test-mysql.postinst,
NONE, 1.1 db-test-mysql.postrm, NONE,
1.1 db-test-mysql.preinst, NONE, 1.1 db-test-mysql.prerm, NONE,
1.1 db-test-pgsql.config, NONE, 1.1 db-test-pgsql.dirs, NONE,
1.1 db-test-pgsql.postinst, NONE, 1.1 db-test-pgsql.postrm,
NONE, 1.1 db-test-pgsql.preinst, NONE, 1.1 db-test-pgsql.prerm,
NONE, 1.1 db-test.config, NONE, 1.1 db-test.dirs, NONE,
1.1 db-test.postinst, NONE, 1.1 db-test.postrm, NONE,
1.1 db-test.preinst, NONE, 1.1 db-test.prerm, NONE, 1.1 docs,
NONE, 1.1 rules, NONE, 1.1
- Messages sorted by:
[ date ]
[ thread ]
[ subject ]
[ author ]
Update of /cvsroot/dbconfig-common/dbconfig-common/examples/db-example-2.0/upgrade-files
In directory haydn:/org/alioth.debian.org/chroot/home/users/seanius/tmp/cvs-serv5607/db-example-2.0/upgrade-files
Added Files:
db-test-mysql-2.1.sql db-test-pgsql-2.1.sql
mysql-upgrade-2.1.pl
Log Message:
here's the sample reference packages, now included as part of
the main package.
--- NEW FILE: db-test-mysql-2.1.sql ---
-- this sql should automatically be sourced for upgrades from pre-1.2 versions
update mytable set version='1.2';
--- NEW FILE: db-test-pgsql-2.1.sql ---
-- this sql should automatically be sourced for upgrades from pre-1.2 versions
update mytable set version='1.2';
--- NEW FILE: mysql-upgrade-2.1.pl ---
#!/usr/bin/perl
use DBI;
use strict;
# this is the value of the config file passed to us by dbconfig-common
my $conffile = $ENV{'dbc_config_include'};
# these are the default names of the variables in the config file
our ($dbname, $dbuser, $dbpass, $dbserver, $dbtype);
# load 'er up.
require $conffile;
my $dsn = "DBI:$dbtype:database=$dbname;host=$dbserver";
# error checking here would be a plus.
my $dbh = DBI->connect($dsn, $dbuser, $dbpass);
# error checking here would be a plus too.
$dbh->do("UPDATE versiontable set version='2.1'");
$dbh->disconnect();
exit 0;
- Previous message: [Dbconfig-common-devel] dbconfig-common/examples/db-example-2.1
COPYING, NONE, 1.1 README, NONE, 1.1
- Next message: [Dbconfig-common-devel]
dbconfig-common/examples/db-example-2.1/debian changelog, NONE,
1.1 control, NONE, 1.1 copyright, NONE,
1.1 db-test-mysql-perl.config, NONE,
1.1 db-test-mysql-perl.dirs, NONE,
1.1 db-test-mysql-perl.postinst, NONE,
1.1 db-test-mysql-perl.postrm, NONE,
1.1 db-test-mysql-perl.preinst, NONE,
1.1 db-test-mysql-perl.prerm, NONE, 1.1 db-test-mysql.config,
NONE, 1.1 db-test-mysql.dirs, NONE, 1.1 db-test-mysql.postinst,
NONE, 1.1 db-test-mysql.postrm, NONE,
1.1 db-test-mysql.preinst, NONE, 1.1 db-test-mysql.prerm, NONE,
1.1 db-test-pgsql.config, NONE, 1.1 db-test-pgsql.dirs, NONE,
1.1 db-test-pgsql.postinst, NONE, 1.1 db-test-pgsql.postrm,
NONE, 1.1 db-test-pgsql.preinst, NONE, 1.1 db-test-pgsql.prerm,
NONE, 1.1 db-test.config, NONE, 1.1 db-test.dirs, NONE,
1.1 db-test.postinst, NONE, 1.1 db-test.postrm, NONE,
1.1 db-test.preinst, NONE, 1.1 db-test.prerm, NONE, 1.1 docs,
NONE, 1.1 rules, NONE, 1.1
- Messages sorted by:
[ date ]
[ thread ]
[ subject ]
[ author ]
More information about the Dbconfig-common-devel
mailing list