Update the keywords and functions in completer.

1 files changed, 178 insertions, 145 deletions

diff --git a/litecli/sqlcompleter.py b/litecli/sqlcompleter.py
index e31a14f..4fcd862 100644
--- a/litecli/sqlcompleter.py
+++ b/litecli/sqlcompleter.py
@@ -16,154 +16,187 @@ _logger = logging.getLogger(__name__)
 
 class SQLCompleter(Completer):
     keywords = [
-        "ACCESS",
-        "ADD",
-        "ALL",
-        "ALTER TABLE",
-        "AND",
-        "ANY",
-        "AS",
-        "ASC",
-        "AUTO_INCREMENT",
-        "BEFORE",
-        "BEGIN",
-        "BETWEEN",
-        "BINARY",
-        "BY",
-        "CASE",
-        "CHAR",
-        "CHECK",
-        "COLUMN",
-        "COMMENT",
-        "COMMIT",
-        "CONSTRAINT",
-        "CHANGE MASTER TO",
-        "CHARACTER SET",
-        "COLLATE",
-        "CREATE",
-        "CURRENT",
-        "CURRENT_TIMESTAMP",
-        "DATABASE",
-        "DATE",
-        "DECIMAL",
-        "DEFAULT",
-        "DELETE FROM",
-        "DELIMITER",
-        "DESC",
-        "DESCRIBE",
-        "DROP",
-        "ELSE",
-        "END",
-        "ENGINE",
-        "ESCAPE",
-        "EXISTS",
-        "FILE",
-        "FLOAT",
-        "FOR",
-        "FOREIGN KEY",
-        "FORMAT",
-        "FROM",
-        "FULL",
-        "FUNCTION",
-        "GRANT",
-        "GROUP BY",
-        "HAVING",
-        "HOST",
-        "IDENTIFIED",
-        "IN",
-        "INCREMENT",
-        "INDEX",
-        "INSERT INTO",
-        "INTEGER",
-        "INTO",
-        "INTERVAL",
-        "IS",
-        "JOIN",
-        "KEY",
-        "LEFT",
-        "LEVEL",
-        "LIKE",
-        "LIMIT",
-        "LOCK",
-        "LOGS",
-        "LONG",
-        "MASTER",
-        "MODE",
-        "MODIFY",
-        "NOT",
-        "NULL",
-        "NUMBER",
-        "OFFSET",
-        "ON",
-        "OPTION",
-        "OR",
-        "ORDER BY",
-        "OUTER",
-        "OWNER",
-        "PASSWORD",
-        "PORT",
-        "PRIMARY",
-        "PRIVILEGES",
-        "PROCESSLIST",
-        "PURGE",
-        "REFERENCES",
-        "REGEXP",
-        "RENAME",
-        "REPAIR",
-        "RESET",
-        "REVOKE",
-        "RIGHT",
-        "ROLLBACK",
-        "ROW",
-        "ROWS",
-        "ROW_FORMAT",
-        "SELECT",
-        "SESSION",
-        "SET",
-        "SHARE",
-        "SLAVE",
-        "SMALLINT",
-        "START",
-        "STOP",
-        "TABLE",
-        "THEN",
-        "TO",
-        "TRANSACTION",
-        "TRIGGER",
-        "TRUNCATE",
-        "UNION",
-        "UNIQUE",
-        "UNSIGNED",
-        "UPDATE",
-        "USE",
-        "USER",
-        "USING",
-        "VALUES",
-        "VARCHAR",
-        "VIEW",
-        "WHEN",
-        "WHERE",
-        "WITH",
+        "ABORT"
+        "ACTION"
+        "ADD"
+        "AFTER"
+        "ALL"
+        "ALTER"
+        "ANALYZE"
+        "AND"
+        "AS"
+        "ASC"
+        "ATTACH"
+        "AUTOINCREMENT"
+        "BEFORE"
+        "BEGIN"
+        "BETWEEN"
+        "BY"
+        "CASCADE"
+        "CASE"
+        "CAST"
+        "CHECK"
+        "COLLATE"
+        "COLUMN"
+        "COMMIT"
+        "CONFLICT"
+        "CONSTRAINT"
+        "CREATE"
+        "CROSS"
+        "CURRENT"
+        "CURRENT_DATE"
+        "CURRENT_TIME"
+        "CURRENT_TIMESTAMP"
+        "DATABASE"
+        "DEFAULT"
+        "DEFERRABLE"
+        "DEFERRED"
+        "DELETE"
+        "DESC"
+        "DETACH"
+        "DISTINCT"
+        "DO"
+        "DROP"
+        "EACH"
+        "ELSE"
+        "END"
+        "ESCAPE"
+        "EXCEPT"
+        "EXCLUSIVE"
+        "EXISTS"
+        "EXPLAIN"
+        "FAIL"
+        "FILTER"
+        "FOLLOWING"
+        "FOR"
+        "FOREIGN"
+        "FROM"
+        "FULL"
+        "GLOB"
+        "GROUP"
+        "HAVING"
+        "IF"
+        "IGNORE"
+        "IMMEDIATE"
+        "IN"
+        "INDEX"
+        "INDEXED"
+        "INITIALLY"
+        "INNER"
+        "INSERT"
+        "INSTEAD"
+        "INTERSECT"
+        "INTO"
+        "IS"
+        "ISNULL"
+        "JOIN"
+        "KEY"
+        "LEFT"
+        "LIKE"
+        "LIMIT"
+        "MATCH"
+        "NATURAL"
+        "NO"
+        "NOT"
+        "NOTHING"
+        "NOTNULL"
+        "NULL"
+        "OF"
+        "OFFSET"
+        "ON"
+        "OR"
+        "ORDER"
+        "OUTER"
+        "OVER"
+        "PARTITION"
+        "PLAN"
+        "PRAGMA"
+        "PRECEDING"
+        "PRIMARY"
+        "QUERY"
+        "RAISE"
+        "RANGE"
+        "RECURSIVE"
+        "REFERENCES"
+        "REGEXP"
+        "REINDEX"
+        "RELEASE"
+        "RENAME"
+        "REPLACE"
+        "RESTRICT"
+        "RIGHT"
+        "ROLLBACK"
+        "ROW"
+        "ROWS"
+        "SAVEPOINT"
+        "SELECT"
+        "SET"
+        "TABLE"
+        "TEMP"
+        "TEMPORARY"
+        "THEN"
+        "TO"
+        "TRANSACTION"
+        "TRIGGER"
+        "UNBOUNDED"
+        "UNION"
+        "UNIQUE"
+        "UPDATE"
+        "USING"
+        "VACUUM"
+        "VALUES"
+        "VIEW"
+        "VIRTUAL"
+        "WHEN"
+        "WHERE"
+        "WINDOW"
+        "WITH"
+        "WITHOUT"
     ]
 
     functions = [
-        "AVG",
-        "CONCAT",
-        "COUNT",
-        "DISTINCT",
-        "FIRST",
-        "FORMAT",
-        "LAST",
-        "LCASE",
-        "LEN",
-        "MAX",
-        "MIN",
-        "MID",
-        "NOW",
-        "ROUND",
-        "SUM",
-        "TOP",
-        "UCASE",
+        "abs"
+        "changes"
+        "char"
+        "coalesce"
+        "glob"
+        "hex"
+        "ifnull"
+        "instr"
+        "last_insert_rowid"
+        "length"
+        "like"
+        "like"
+        "likelihood"
+        "likely"
+        "load_extension"
+        "load_extension"
+        "lower"
+        "ltrim"
+        "ltrim"
+        "max"
+        "min"
+        "nullif"
+        "printf"
+        "quote"
+        "random"
+        "randomblob"
+        "replace"
+        "round"
+        "round"
+        "rtrim"
+        "rtrim"
+        "soundex"
+        "sqlite_compileoption_get"
+        "sqlite_compileoption_used"
+        "sqlite_offset"
+        "sqlite_source_id"
+        "sqlite_version"
+        "substr"
+        "substr"
+        "total_changes"
+        "trim"
+        "trim"
     ]
 
     change_items = [