GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
SPOPS::DBI::SQLite(3) User Contributed Perl Documentation SPOPS::DBI::SQLite(3)

SPOPS::DBI::SQLite -- SQLite-specific code for DBI collections

 myobject => {
   isa             => [ qw( SPOPS::DBI::SQLite SPOPS::DBI ) ],
   increment_field => 1,
   id_field        => 'id',
   no_insert       => [ 'id' ],
 };

This just implements some SQLite-specific routines so we can abstract them out.

One of these items is to auto-generate keys. SQLite supports auto-generated keys in one instance only -- when you specify the first column as an "integer" field (not "int", for some reason SQLite is sensitive to this) and as the primary key. For the value to be generated, you should not insert a value for it.

So to use auto-generated keys, just define your table:

 CREATE TABLE my_table (
   id integer not null primary key,
   ...
 )

or

 CREATE TABLE my_table (
   id integer not null,
   ...
   primary key ( id )
 )

And tell SPOPS you are using an auto-increment field:

 myobject => {
   isa             => [ qw( SPOPS::DBI::SQLite SPOPS::DBI ) ],
   increment_field => 1,
   id_field        => 'id',
   no_insert       => [ 'id' ],
 };

NOTE: Since SQLite is typeless, we assume for quoting purposes that everything is a "SQL_VARCHAR" type of field, overriding "db_discover_types" from SPOPS::SQLInterface with our own version.

None known.

Nothing known.

DBD::SQLite

DBI

Copyright (c) 2002-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>
2004-06-02 perl v5.32.1

Search for    or go to Top of page |  Section 3 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.