new SqliteChatStorage(name, dbpath, length)
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
Get all messages in sqlite table
name
Get name of sqlite table
time
Get current time in format YYYY-MM-DD HH:MM:SS
Methods
addmessage(user, message, time)
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)
Deletes a message(s) by condition
Parameters:
Name | Type | Description |
---|---|---|
where |
string | sql condition |
Returns:
promise
deletemessage(id)
Deletes a message by id
Parameters:
Name | Type | Description |
---|---|---|
id |
integer | message id (constructor.messages[*].id) |
Returns:
promise
erase()
Erases the sqlite table
Returns:
promise
getBdId(index)
Parameters:
Name | Type | Description |
---|---|---|
index |
integer |
Returns:
id of message from index (constructor.messages[index].id)
prepare()
Preparing and initializing the table
Returns:
promise
replacemessage(id, message)
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)
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)
Runs the SQL query with the specified parameters.
Parameters:
Name | Type | Description |
---|---|---|
query |
string | SQLite query |
Returns:
promise(err|row)