Chris Winters > SPOPS > SPOPS::Export::SQL

Download:
SPOPS-0.87.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  1
Open  0
View/Report Bugs
Module Version: 3.03   Source  

NAME ^

SPOPS::Export::SQL - Export SPOPS objects as a series of SQL statements

SYNOPSIS ^

 # See SPOPS::Export

DESCRIPTION ^

Implement SQL output for SPOPS::Export.

PROPERTIES ^

table_name

The name of the table to use in the export. If not set we use the table used by the object class. If we cannot find a table name in the object class (via a method table_name()) then we die.

record_delimiter

The string to use to delimit SQL statements. Default is ';', but you might want to use '\g' or other string depeneding on your database.

METHODS ^

create_record( $object, $fields )

Return a SQL statement suitable for importing into a database to create a record using an 'INSERT'.

serialize_field_data( $data )

Return a quoted, escaped string suitable for putting into a runnable SQL statement. For example:

 my $value = $exporter->serialize_field_data( "O'Reilly and Associates" );

Returns by default:

 'O\'Reilly and Associates'

Just subclass this class and override the method of your database uses different quoting schemes.

BUGS ^

None known.

TO DO ^

Nothing known.

SEE ALSO ^

COPYRIGHT ^

Copyright (c) 2001-2004 intes.net, inc.. All rights reserved.

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

AUTHORS ^

Chris Winters <chris@cwinters.com>

syntax highlighting: