sqlite Questions

MySQL datediff function not available in SQLite used for unit tests – Laravel

April 13, 2023
ehsan ranjbari
2 Answers

I have used the following Raw query in my Laravel project. $statisticsInRangeDate = $myModel->selectRaw( "floor(datediff(created_at, '{$dateInfo['currentRangeDate']}')". " / {$dateInfo['daysRange']}) * {$dateInfo['daysRange']} AS diff_days_range, count(*) as total_clicks, ". 'min(created_at) ,max(created_at)' ) ->groupByRaw('diff_days_range') ->orderByRaw('diff_days_range DESC') ->get(); The raw query is: select floor(datediff(created_at,…

VIEW QUESTION

Another CGI/shell question (receiving FORM data in script) – PHP Versions

April 6, 2023
OldStrummer
2 Answers

Briefly: After a long time away from web tech, I'm experimenting with it again as I prepare to retire. Thus, this is merely a sandbox experiment I'm trying on my local machine. I'm using the X1 version of Aprelium's Abyss…

VIEW QUESTION

Fetch Image from sqlite Database flutter

April 6, 2023
Edgar
2 Answers

Help me please, I have saved in sqlite image Uint8List as TEXT in database, now i want to display it and i dont know how to fetch with future builder. I have DBHElper with function, but dont know how to…

VIEW QUESTION

What should be entered into the username box to execute a SQLInjection attack on the following code and how should I mitigate that risk? – Javascript

April 5, 2023
BHughes
2 Answers

I know that I need to salt the hash, I'm just curious how a SQLInjection attack would be executed against this and I want to mitigate the risk if (username && password) { db.get(`SELECT * FROM users WHERE username =…

VIEW QUESTION

Visual Studio Code – sqlite3_bind_text does not work for me but bind-double works fine

March 30, 2023
James
2 Answers

I have written a little class to handle SQLite prepared queries. If my variable in the SQL is a double the code runs fine giving a list of values. But when I bind a string, I get no results because…

VIEW QUESTION

How do I load SQL.js WASM as base64 so that it can be loaded directly in HTML file – Javascript

March 25, 2023
SMUsamaShah
2 Answers

I am trying to load sql-wasm.wasm from https://github.com/sql-js/sql.js such that it does not need a server. Otherwise, trying to load wasm from HTML gives CORS error. I converted it to base64 (~800KB) which looks like this const SQLBASE64 = "AGFzbQEAAAABrQRHYAJ/fwF/YAF/AX....AAJ4BAEHwogQLA4AWUQ==";…

VIEW QUESTION

Visual Studio Code – C# add reference to sqlite.dll in class library project from another project

March 17, 2023
Vector
2 Answers

Here are the steps I used to build these two Projects ADBTest and DBControl. ADBTest was built first it implements SQLite DB CRUD functions I added System.Data.SQLite with NuGet. Ran the project everything functions great! Next I built the DBControl…

VIEW QUESTION

Android Studio – SQL table refusing to insert user input to columns

March 12, 2023
Hamzah Alkhateeb
2 Answers

I am making an app where I input a name and a number, and upon clicking SAVE, the name is saved in an SQLITE database named infinitecounter.db under the COUNTER_NAME column. After that, it saves the number in the CURRENT_CLICKS…

VIEW QUESTION

Laravel add column with a default value depending on a second column

February 24, 2023
noah1400
3 Answers

I have a User table I want to view each User by navigating /users/{slug}. e.g. for a User named John Doe the route would look like this /users/john-doe. Currently I am using the id to view a User (/users/1). To…

VIEW QUESTION

Return a list of options only if they exist in two Django Models – Postgresql

February 23, 2023
ladcode2022
3 Answers

I have two models in my models.py file: Flavour model: class Flavour(models.Model): flavour_choice = models.CharField(null=True, blank=True, max_length=254) def __str__(self): return self.flavour_choice and Product model: class Product(models.Model): category = models.ForeignKey( 'Category', null=True, blank=True, on_delete=models.SET_NULL ) slug = models.SlugField() sku = models.CharField(max_length=254,…

VIEW QUESTION