sqlite3

Index:
Articles
Classes
Hooks

Quick navigation:
BannerPattern
BossBarColor
BossBarDivisionType
cArrowEntity
cBeaconEntity
cBedEntity
cBlockArea
cBlockEntity
cBlockEntityWithItems
cBlockInfo
cBoat
cBoundingBox
cBrewingstandEntity
cChatColor
cChestEntity
cChunkDesc
cClientHandle
cColor
cCommandBlockEntity
cCompositeChat
cCraftingGrid
cCraftingRecipe
cCryptoHash
cCuboid
cDispenserEntity
cDropperEntity
cDropSpenserEntity
cEnchantments
cEnderCrystal
cEntity
cEntityEffect
cExpBottleEntity
cExpOrb
cFallingBlock
cFile
cFireChargeEntity
cFireworkEntity
cFloater
cFlowerPotEntity
cFurnaceEntity
cGhastFireballEntity
cHangingEntity
cHopperEntity
cIniFile
cInventory
cItem
cItemFrame
cItemGrid
cItems
cJson
cJukeboxEntity
cLeashKnot
cLineBlockTracer
cLuaWindow
cMap
cMapManager
cMobHeadEntity
cMobSpawnerEntity
cMojangAPI
cMonster
cNetwork
cNoteEntity
cObjective
cPainting
cPawn
cPickup
cPlayer
cPlugin
cPluginLua
cPluginManager
cProjectileEntity
cRankManager
cRoot
cScoreboard
cServer
cServerHandle
cSignEntity
cSplashPotionEntity
cStringCompression
cTCPLink
cTeam
cThrownEggEntity
cThrownEnderPearlEntity
cThrownSnowballEntity
cTNTEntity
cUDPEndpoint
cUrlClient
cUrlParser
CustomStatistic
cUUID
cWebAdmin
cWindow
cWitherSkullEntity
cWorld
EffectID
HTTPFormData
HTTPRequest
HTTPTemplateRequest
ItemCategory
lxp
SmokeDirection
sqlite3
StatisticsManager
TakeDamageInfo
tolua
Vector3d
Vector3f
Vector3i
Globals

Constants
Functions

sqlite3 class

Constants

Name	Value	Notes
ABORT	4
ALTER_TABLE	26
ANALYZE	28
ATTACH	24
BLOB	4
BUSY	5
CANTOPEN	14
CONSTRAINT	19
CORRUPT	11
CREATE_INDEX	1
CREATE_TABLE	2
CREATE_TEMP_INDEX	3
CREATE_TEMP_TABLE	4
CREATE_TEMP_TRIGGER	5
CREATE_TEMP_VIEW	6
CREATE_TRIGGER	7
CREATE_VIEW	8
CREATE_VTABLE	29
DELETE	9
DETACH	25
DONE	101
DROP_INDEX	10
DROP_TABLE	11
DROP_TEMP_INDEX	12
DROP_TEMP_TABLE	13
DROP_TEMP_TRIGGER	14
DROP_TEMP_VIEW	15
DROP_TRIGGER	16
DROP_VIEW	17
DROP_VTABLE	30
EMPTY	16
ERROR	1
FLOAT	2
FORMAT	24
FULL	13
FUNCTION	31
INSERT	18
INTEGER	1
INTERNAL	2
INTERRUPT	9
IOERR	10
LOCKED	6
MISMATCH	20
MISUSE	21
NOLFS	22
NOMEM	7
NOTADB	26
NOTFOUND	12
NULL	5
OK	0
PERM	3
PRAGMA	19
PROTOCOL	15
RANGE	25
READ	20
READONLY	8
REINDEX	27
ROW	100
SAVEPOINT	32
SCHEMA	17
SELECT	21
TEXT	3
TOOBIG	18
TRANSACTION	22
UPDATE	23

Functions

Name

Parameters

Return value

Notes

complete

SQL

string

boolean

(STATIC) Returns true if the input string comprises one or more complete SQL statements.

open

FileName

string

DBClass

SQLite DB object

(STATIC) Opens (or creates if it does not exist) an SQLite database with name filename and returns its handle (the returned object should be used for all further method calls in connection with this specific database, see Database methods). Example:

-- open the database:
myDB = sqlite3.open('MyDatabaseFile.sqlite3')

-- do some database calls...

-- Close the database:
myDB:close()

open_memory

DBClass

SQLite DB object

(STATIC) Opens an SQLite database in memory and returns its handle. In case of an error, the function returns nil, an error code and an error message. (In-memory databases are volatile as they are never stored on disk.)

temp_directory

(undocumented)

version

string

(STATIC) Returns a string with SQLite version information, in the form 'x.y[.z]'.

Contents

sqlite3 class

Constants

Functions