1DBIx::Class::Storage::DUBsIe:r:SCQoLnittrei(b3u)ted PerlDBDIoxc:u:mCelnatsast:i:oSntorage::DBI::SQLite(3)
2
3
4

NAME

6       DBIx::Class::Storage::DBI::SQLite - Automatic primary key class for
7       SQLite
8

SYNOPSIS

10         # In your table classes
11         use base 'DBIx::Class::Core';
12         __PACKAGE__->set_primary_key('id');
13

DESCRIPTION

15       This class implements autoincrements for SQLite.
16
17   Known Issues
18       RT79576
19            NOTE - This section applies to you only if ALL of these are true:
20
21             * You are or were using DBD::SQLite with a version lesser than 1.38_01
22
23             * You are or were using DBIx::Class versions between 0.08191 and 0.08209
24               (inclusive) or between 0.08240-TRIAL and 0.08242-TRIAL (also inclusive)
25
26             * You use objects with overloaded stringification and are feeding them
27               to DBIC CRUD methods directly
28
29           An unfortunate chain of events led to DBIx::Class silently hitting
30           the problem described in RT#79576
31           <https://rt.cpan.org/Public/Bug/Display.html?id=79576>.
32
33           In order to trigger the bug condition one needs to supply more than
34           one bind value that is an object with overloaded stringification
35           (numification is not relevant, only stringification is). When this
36           is the case the internal DBIx::Class call to "$sth->bind_param"
37           would be executed in a way that triggers the above-mentioned
38           DBD::SQLite bug. As a result all the logs and tracers will contain
39           the expected values, however SQLite will receive all these bind
40           positions being set to the value of the last supplied stringifiable
41           object.
42
43           Even if you upgrade DBIx::Class (which works around the bug
44           starting from version 0.08210) you may still have
45           corrupted/incorrect data in your database.  DBIx::Class warned
46           about this condition for several years, hoping to give anyone
47           affected sufficient notice of the potential issues. The warning was
48           removed in 2015/v0.082820.
49

METHODS

51   connect_call_use_foreign_keys
52       Used as:
53
54           on_connect_call => 'use_foreign_keys'
55
56       In connect_info to turn on foreign key (including cascading) support
57       for recent versions of SQLite and DBD::SQLite.
58
59       Executes:
60
61         PRAGMA foreign_keys = ON
62
63       See <http://www.sqlite.org/foreignkeys.html> for more information.
64

FURTHER QUESTIONS?

66       Check the list of additional DBIC resources.
67

69       This module is free software copyright by the DBIx::Class (DBIC)
70       authors. You can redistribute it and/or modify it under the same terms
71       as the DBIx::Class library.
72
73
74
75perl v5.36.0                      2022-07-2D2BIx::Class::Storage::DBI::SQLite(3)
Impressum