OpenInteract2::SQLInstall OpenInteract2::SQLInstall Perl module offers a dispatcher for installing various SQL data from packages to database.
Download

OpenInteract2::SQLInstall Ranking & Summary

OpenInteract2::SQLInstall Tags

database SQL Perl module dispatcher install SQL data SQL installation

OpenInteract2::SQLInstall Description

OpenInteract2::SQLInstall Perl module offers a dispatcher for installing various SQL data from packages to database. OpenInteract2::SQLInstall Perl module offers a dispatcher for installing various SQL data from packages to database.SYNOPSIS # PACKAGE AUTHORS # Define a SQLInstaller for your package package OpenInteract2::SQLInstall::MyPackage; use strict; use base qw( OpenInteract2::SQLInstall ); # We only define one object in this package sub get_structure_set { return 'myobj'; } # Since we only have one set we can ignore it sub get_structure_file { my ( $self, $set, $type ) = @_; return 'myobj_sybase.sql' if ( $type eq 'Sybase' ); return if ( $type eq 'Oracle' ); return 'myobj.sql'; } # INSTALLER USERS # See the management tasks for doing this for you, but you can also # use this class in a separate program use OpenInteract2::Context qw( CTX ); use OpenInteract2::SQLInstall; my $package = CTX->repository->fetch_package( 'mypackage' );; my $installer = OpenInteract2::SQLInstall->new_from_package( $package ); # Do one at a time $installer->install_structure; # ..and restrict to processing a single file $installer->install_structure( 'table-A.sql' ); $installer->install_data; $installer->install_security; # ... or all at once $installer->install_all;_ # ... or migrate from an old package $installer->install_structure; $installer->migrate_data( 'old_datasource_name' ); Requirements: · Perl

OpenInteract2::SQLInstall Related Software