SqliteChatStorage

SqliteChatStorage

new SqliteChatStorage(name, dbpath, length)

Source:
Chat storage. Storage method (sqlite)
Parameters:
Name Type Default Description
name string name of table in sqlite database
dbpath string chat.db path to sqlite database
length integer | false false number of stored messages

Members

messages

Source:
Get all messages in sqlite table

name

Source:
Get name of sqlite table

time

Source:
Get current time in format YYYY-MM-DD HH:MM:SS

Methods

addmessage(user, message, time)

Source:
Adds a message to sqlite table
Parameters:
Name Type Description
user string user who sent the message
message string the message the user sent
time string | none time when the message was sent if none then time = current time
Returns:
promise

delete(where)

Source:
Deletes a message(s) by condition
Parameters:
Name Type Description
where string sql condition
Returns:
promise

deletemessage(id)

Source:
Deletes a message by id
Parameters:
Name Type Description
id integer message id (constructor.messages[*].id)
Returns:
promise

erase()

Source:
Erases the sqlite table
Returns:
promise

getBdId(index)

Source:
Parameters:
Name Type Description
index integer
Returns:
id of message from index (constructor.messages[index].id)

prepare()

Source:
Preparing and initializing the table
Returns:
promise

replacemessage(id, message)

Source:
Replace a message by id
Parameters:
Name Type Description
id integer message id (constructor.messages[*].id)
message string message to replace
Returns:
promise

select(what, where)

Source:
Select a message(s) by sql-query
Parameters:
Name Type Description
what string sql column
where string | none sql condition
Returns:
promise(err|row)

sqlite_all(query)

Source:
Runs the SQL query with the specified parameters.
Parameters:
Name Type Description
query string SQLite query
Returns:
promise(err|row)