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

 # See SPOPS::Export

Implement SQL output for SPOPS::Export.

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.

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.

None known.

Nothing known.

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.

Chris Winters <chris@cwinters.com>