sqlite3

Index:
Articles
Classes
Hooks

Quick navigation:
cArrowEntity
cBeaconEntity
cBlockArea
cBlockEntity
cBlockEntityWithItems
cBlockInfo
cBoundingBox
cBrewingstandEntity
cChatColor
cChestEntity
cChunkDesc
cClientHandle
cCommandBlockEntity
cCompositeChat
cCraftingGrid
cCraftingRecipe
cCryptoHash
cCuboid
cDispenserEntity
cDropperEntity
cDropSpenserEntity
cEnchantments
cEntity
cEntityEffect
cExpBottleEntity
cFile
cFireChargeEntity
cFireworkEntity
cFloater
cFlowerPotEntity
cFurnaceEntity
cGhastFireballEntity
cHangingEntity
cHopperEntity
cIniFile
cInventory
cItem
cItemFrame
cItemGrid
cItems
cJson
cJukeboxEntity
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
cStatManager
cStringCompression
cTCPLink
cTeam
cThrownEggEntity
cThrownEnderPearlEntity
cThrownSnowballEntity
cTNTEntity
cTracer
cUDPEndpoint
cUrlClient
cUrlParser
cWebAdmin
cWindow
cWitherSkullEntity
cWorld
HTTPFormData
HTTPRequest
HTTPTemplateRequest
ItemCategory
lxp
sqlite3
TakeDamageInfo
tolua
Vector3d
Vector3f
Vector3i
Globals

Contents

sqlite3 class

Constants
NameValueNotes
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
NameParametersReturn valueNotes
complete string bool Returns true if the string sql comprises one or more complete SQL statements and false otherwise.
open FileName DBClass Opens (or creates if it does not exist) an SQLite database with name filename and returns its handle as userdata (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 Opens an SQLite database in memory and returns its handle as userdata. 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.)
version string Returns a string with SQLite version information, in the form 'x.y[.z]'.
Generated on 2016-08-22 23:53:06, Build ID Unknown, Commit approx: 2ed4af74edd14ae17e1c6c64d44caa7b7fc30d5a