SQL Storage Adapter

class chatterbot.storage.SQLStorageAdapter(**kwargs)

The SQLStorageAdapter allows ChatterBot to store conversation data in any database supported by the SQL Alchemy ORM.

All parameters are optional, by default a sqlite database is used.

It will check if tables are present, if they are not, it will attempt to create the required tables.

Parameters:

database_uri (str) – eg: sqlite:///database_test.sqlite3’, The database_uri can be specified to choose database driver.

count()

Return the number of entries in the database.

create(text, in_response_to=None, tags=None, search_text=None, search_in_response_to=None, **kwargs)

Creates a new statement matching the keyword arguments specified. Returns the created statement.

create_database()

Populate the database with the tables.

create_many(statements)

Creates multiple statement entries.

drop()

Drop the database.

filter(**kwargs)

Returns a list of objects from the database. The kwargs parameter can contain any number of attributes. Only objects which contain all listed attributes and in which all values match for all listed attributes will be returned.

get_random()

Returns a random statement from the database.

get_statement_model()

Return the statement model.

get_tag_model()

Return the conversation model.

remove(statement_text)

Removes the statement that matches the input text. Removes any responses from statements where the response text matches the input text.

update(statement)

Modifies an entry in the database. Creates an entry if one does not exist.

Ask a question under the chatterbot tag	Report an issue on GitHub
Subscribe to the ChatterBot Newsletter Email Address