Dictionaries in python are similar to “associative arrays” in some other languages. Dictionaries are indexed by keys, which can be any immutable type, e.g strings and numbers. Creating a dictionary Accessing a dictionary Does dictionary key exist?
All posts by
LIMIT
Limit example
ORDER BY
ORDER BY example
SELECT queries
SELECT query example Single row result Returning results as a dictionary
Global
Variables and objects created outside of a function are global and can be read (not written) by any function The global keyword can be used to create a global object inside a function. The global keyword must be used inside a function if it wants to change the value of a global object inside the […]
Null
There is no Null in Python. None The closest equivalent is the None object that Python programmers use to define null objects and variables. NOTE THOUGH that None it is not defined to be 0 or any other value. None in Python is an object and a FIRST-CLASS CITIZEN.
INSERT queries
INSERT Example Important note about sanitised parameters – providing only one parameter If you are providing just a single parameter you must include a trailing comma like below, this is to make sure the parameter field is seen as a tuple of length one. INSERT and get Auto Increment value
DateTime
SQLite does not have a storage class set aside for storing dates and/or times. Instead, the built-in Date And Time Functions of SQLite are capable of storing dates and times as INTEGER, TEXT or REAL values: INTEGER as Unix Time, the number of seconds since 1970-01-01 00:00:00 UTC. TEXT as ISO8601 strings (“YYYY-MM-DD HH:MM:SS.SSS”).REAL as Julian […]
.Columns General
See our C# page here.
Creating tables
Example create/open a database and return it ready to be used