DeveloperBreeze

Filter SQLAlchemy Query for Records Created Between Specific Dates

January 26, 2024

python

#Backend development #Database query #Filtering records #Date range

results = Model.query.filter(
    Model.created_at.between('2022-12-25', '2022-12-30')
).all()

Continue Reading

Handpicked posts just for you — based on your current read.

Connecting a Node.js Application to an SQLite Database Using sqlite3

SQLite is a self-contained, high-reliability, embedded, full-featured, public-domain SQL database engine. Unlike traditional database management systems (DBMS) like MySQL or PostgreSQL, SQLite doesn't require a separate server process. Instead, it reads and writes directly to ordinary disk files, making it an ideal choice for:

Embedded Systems: Devices with limited resources.
Small to Medium Applications: Applications that don't require the scalability of larger DBMS.
Development and Testing: Rapid prototyping without the overhead of managing a separate database server.

Oct 24, 2024 Tutorial

MySQL Cheatsheet: Comprehensive Guide with Examples

No preview available for this content.

Aug 20, 2024 Cheatsheet

Integrating Laravel and React with Vite: Using Databases and PHP in a Full-Stack Project

use App\Http\Controllers\PostController;

Route::get('/posts', [PostController::class, 'index']);
Route::get('/posts/{id}', [PostController::class, 'show']);
Route::post('/posts', [PostController::class, 'store']);
Route::put('/posts/{id}', [PostController::class, 'update']);
Route::delete('/posts/{id}', [PostController::class, 'destroy']);

These routes handle listing, creating, viewing, updating, and deleting posts.

Aug 14, 2024 Tutorial

Building a RESTful API with Go and Gorilla Mux

func getBooks(w http.ResponseWriter, r *http.Request) {
	w.Header().Set("Content-Type", "application/json")
	json.NewEncoder(w).Encode(books)
}

Add the getBook function to main.go:

Aug 12, 2024 Tutorial

Building a GraphQL API with Node.js and Apollo Server

Variables

{
  "title": "1984"
}

Aug 12, 2024 Tutorial

GraphQL API Server with Node.js and Apollo Server

Open a browser and go to http://localhost:4000/graphql. You'll see the Apollo GraphQL Playground, where you can test your queries and mutations.

Fetch Books

Aug 12, 2024 Code

Retrieve All Data from Database Table in Laravel

No preview available for this content.

Jan 26, 2024 Code

Querying Data from Database Table in Laravel

No preview available for this content.

Jan 26, 2024 Code

Generate List of Dates Between Two Dates

# Import required modules
from datetime import datetime, timedelta

# Define start and end dates
start_date = datetime(2023, 1, 1)
end_date = datetime(2023, 1, 10)

# Generate a list of dates between the start and end dates
dates = [start_date + timedelta(days=i) for i in range((end_date - start_date).days + 1)]

Jan 26, 2024 Code