Repository (code): https://github.com/JavascriptLearner815/spelta-discord-bot/tree/development I am creating a Discord bot with Discord.js. I wanted to add three DM commands for the bot: dm, reply, and followup. In order to reply to the last DM, I needed to use SQLITE. I made and required a database.js file t…
Tag: sqlite
Sequelize: column name to lowercase not working with included models
I have two models: Category and Bookmark. Bookmark is associated with category through categoryId column. Category also have name, createdAt, orderId columns; I can get category and all its bookmarks with: But now I want to change how bookmarks are ordered. Order type can be name, createdAt or orderId; It wor…
nodejs sqlite 3 “SQLITE_MISUSE: Database handle is closed” db.run within db.all
So I am trying the following: This results in “SQLITE_MISUSE: Database handle is closed” Apparently I cannot run the UPDATE query within the db.all callback. But why is that so? Answer You should put the second query as an argument to db.serialize(). Then it will wait for it to complete before ret…
SQLITE DELETE FROM row WHERE id IN (?) removes only firs item
I’m trying to delete multiple rows based on array of ids. The query is: However, it removes only first row with ID of the array and ignores the rest(2 and 3 are not removed); if I try to remove rows based on non-primary key like this everything works. What am I missing here? P.S. There […]
Sqlite .all() function returns an undefined promise. How can I use the result further?
I am just starting to work with JS and SQLite. And could not find any help for my specific question. I want to keep a return to use it as a foreign key in a second table. This is my function: What do I have to do so that promise does not stay undefined outside of the function? Rest of
AuthenticationController always throws error, TypeError: Cannot read property ‘create’ of undefined
I have an issue with the Authenticati onController used with sequelize and sqlite When I test the POST request using postman, it always gives status 400 with the response { error: ‘Something is wrong’ } This is the log ::1 – – [21/Jul/2020:15:40:33 +0000] “POST /register HTTP/1.1…
How can i persist data in react native application?
I want to create a React Native app that persists local data and then syncs to the server. Please help me to find a way for this. Answer React Native provides methods to persist data. Some are provided out of the box while others are libraries you have to install and use. Below are popular methods of persisti…
sqlite3 – insert – javascript object as values
What is the easiest solution to use a javascript object as values for a sqlite3 insert? The following code does not work. Answer First of all you need to write the SQL correctly. To insert into the columns name, age, language, you need to write the SQL like this: And pass the values of the 3 columns as parame…
Cordova SQLite save BLOB
I have a problem with Cordova SQLite plugin. How can I save BLOB image to SQLite? I have BLOB object in JS: And I trying to save it And when i trying to get this image: I get this string: How can i convert it to BLOB again? Also i trying to save images in base64, but i can’t save