Implements the xonsh history backend via sqlite3.

class xonsh.history.sqlite.SqliteHistory(gc=True, filename=None, save_cwd=None, **kwargs)[source]#

Xonsh history backend implemented with sqlite3.

Represents a xonsh session’s history.

sessionidint, uuid, str, optional

Current session identifier, will generate a new sessionid if not set.

all_items(newest_first=False, session_id=None)[source]#

Display all history items.


Append a command item into history.

cmd: dict

This dict contains information about the command that is to be added to the history list. It should contain the keys inp, rtn and ts. These key names mirror the same names defined as instance variables in the HistoryEntry class.


Clears the current session’s history from both memory and disk.


Flush the history items to disk from a buffer.


A collection of information about the shell history.

dict or collections.OrderedDict

Contains history information as str key pairs.


Determines if a history item should be added to the event history. Call this in your append method.

cmd: dict

The prospective item to append (structure is the same as the append method).


True if the item should be appended, False if not.


Display history items of current session.

run_gc(size=None, blocking=True)[source]#

Run the garbage collector.

size: None or tuple of a int and a string

Determines the size and units of what would be allowed to remain.

blocking: bool

If set blocking, then wait until gc action finished.

property ignore_regex#
class xonsh.history.sqlite.SqliteHistoryGC(wait_for_shell=True, size=None, filename=None, *args, **kwargs)[source]#

Shell history garbage collection.

Thread responsible for garbage collecting old history.

May wait for shell (and for xonshrc to have been loaded) to start work.


Return a string used for identification purposes only.

This method is deprecated, use the name attribute instead.


Return whether this thread is a daemon.

This method is deprecated, use the daemon attribute instead.


Return whether the thread is alive.

This method returns True just before the run() method starts until just after the run() method terminates. See also the module function enumerate().


Wait until the thread terminates.

This blocks the calling thread until the thread whose join() method is called terminates – either normally or through an unhandled exception or until the optional timeout occurs.

When the timeout argument is present and not None, it should be a floating point number specifying a timeout for the operation in seconds (or fractions thereof). As join() always returns None, you must call is_alive() after join() to decide whether a timeout happened – if the thread is still alive, the join() call timed out.

When the timeout argument is not present or None, the operation will block until the thread terminates.

A thread can be join()ed many times.

join() raises a RuntimeError if an attempt is made to join the current thread as that would cause a deadlock. It is also an error to join() a thread before it has been started and attempts to do so raises the same exception.


Method representing the thread’s activity.

You may override this method in a subclass. The standard run() method invokes the callable object passed to the object’s constructor as the target argument, if any, with sequential and keyword arguments taken from the args and kwargs arguments, respectively.


Set whether this thread is a daemon.

This method is deprecated, use the .daemon property instead.


Set the name string for this thread.

This method is deprecated, use the name attribute instead.


Start the thread’s activity.

It must be called at most once per thread object. It arranges for the object’s run() method to be invoked in a separate thread of control.

This method will raise a RuntimeError if called more than once on the same thread object.

property daemon#

A boolean value indicating whether this thread is a daemon thread.

This must be set before start() is called, otherwise RuntimeError is raised. Its initial value is inherited from the creating thread; the main thread is not a daemon thread and therefore all threads created in the main thread default to daemon = False.

The entire Python program exits when only daemon threads are left.

property ident#

Thread identifier of this thread or None if it has not been started.

This is a nonzero integer. See the get_ident() function. Thread identifiers may be recycled when a thread exits and another thread is created. The identifier is available even after the thread has exited.

property name#

A string used for identification purposes only.

It has no semantics. Multiple threads may be given the same name. The initial name is set by the constructor.

property native_id#

Native integral thread ID of this thread, or None if it has not been started.

This is a non-negative integer. See the get_native_id() function. This represents the Thread ID as reported by the kernel.

xonsh.history.sqlite.xh_sqlite_append_history(cmd, sessionid, store_stdout, filename=None, remove_duplicates=False)[source]#
xonsh.history.sqlite.xh_sqlite_delete_items(size_to_keep, filename=None)[source]#
xonsh.history.sqlite.xh_sqlite_get_count(sessionid=None, filename=None)[source]#
xonsh.history.sqlite.xh_sqlite_items(sessionid=None, filename=None, newest_first=False)[source]#
xonsh.history.sqlite.xh_sqlite_wipe_session(sessionid=None, filename=None)[source]#

Wipe the current session’s entries from the database.