SPOPS::Export::SQL - Export SPOPS objects as a series of SQL statements
# See SPOPS::Export
Implement SQL output for SPOPS::Export.
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.
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.
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 <firstname.lastname@example.org>