Package gnue :: Package common :: Package datasources :: Package drivers :: Package sql :: Package sqlite2 :: Module Behavior
[show private | hide private]

Module gnue.common.datasources.drivers.sql.sqlite2.Behavior

Schema support plugin for SQLite.
Classes
Behavior Behavior class for SQLite backends.

Exceptions
InvalidSQLCommand SQL command used to create the table cannot be parsed.
MissingTableError Table should be altered but original table cannot be found.

Variable Summary
SRE_Pattern _ALIGN = \s*\(\s*(.*?)\s*\)
SRE_Pattern _BLANKS = \s+
SRE_Pattern _CMD = (.*?)\((.*)\)(.*)
SRE_Pattern _CONSTRAINTS = .*?((UNIQUE|CHECK|PRIMARY KEY)\s*\(.*?\))...
SRE_Pattern _DEFAULT = .*\s+DEFAULT\s+(.*)
SRE_Pattern _INDEX = CREATE\s*(\w+)?\s*INDEX\s*(\w+)\s*ON\s*\w+\s*\(...
SRE_Pattern _LEN_SCALE = ^\s*(\w+)\s*\((\d+);?(\d*)\)\s*
SRE_Pattern _NOTNULL = (.*)(NOT NULL)(.*)
SRE_Pattern _PKFIELD = .*?PRIMARY\s+KEY\s*
SRE_Pattern _PRIMARYKEY = .*?PRIMARY KEY\s*\((.*?)\).*
SRE_Pattern _REPCOMMAS = \(\s*(\d+)\s*,\s*(\d+)\s*\)
SRE_Pattern _SQLCODE = \s*SELECT\s+(.*)\s+FROM\s+(\w+).*
SRE_Pattern _TEXTTYPE = .*(BLOB|CHAR|CLOB|TEXT){1}.*
SRE_Pattern _VIEWCODE = ^\s*CREATE\s+VIEW\s+\w+\s+AS\s+(.*)\s*$

Variable Details

_ALIGN

Type:
SRE_Pattern
Value:
\s*\(\s*(.*?)\s*\)                                                     

_BLANKS

Type:
SRE_Pattern
Value:
\s+                                                                    

_CMD

Type:
SRE_Pattern
Value:
(.*?)\((.*)\)(.*)                                                      

_CONSTRAINTS

Type:
SRE_Pattern
Value:
.*?((UNIQUE|CHECK|PRIMARY KEY)\s*\(.*?\)).*                            

_DEFAULT

Type:
SRE_Pattern
Value:
.*\s+DEFAULT\s+(.*)                                                    

_INDEX

Type:
SRE_Pattern
Value:
CREATE\s*(\w+)?\s*INDEX\s*(\w+)\s*ON\s*\w+\s*\((.*?)\).*               

_LEN_SCALE

Type:
SRE_Pattern
Value:
^\s*(\w+)\s*\((\d+);?(\d*)\)\s*                                        

_NOTNULL

Type:
SRE_Pattern
Value:
(.*)(NOT NULL)(.*)                                                     

_PKFIELD

Type:
SRE_Pattern
Value:
.*?PRIMARY\s+KEY\s*                                                    

_PRIMARYKEY

Type:
SRE_Pattern
Value:
.*?PRIMARY KEY\s*\((.*?)\).*                                           

_REPCOMMAS

Type:
SRE_Pattern
Value:
\(\s*(\d+)\s*,\s*(\d+)\s*\)                                            

_SQLCODE

Type:
SRE_Pattern
Value:
\s*SELECT\s+(.*)\s+FROM\s+(\w+).*                                      

_TEXTTYPE

Type:
SRE_Pattern
Value:
.*(BLOB|CHAR|CLOB|TEXT){1}.*                                           

_VIEWCODE

Type:
SRE_Pattern
Value:
^\s*CREATE\s+VIEW\s+\w+\s+AS\s+(.*)\s*$                                


GNUe Home

Private API

Developer's Corner