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.

COPYRIGHT

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>