- create role
create role 'fleet-support-readonly';
- set password
ALTER USER user_name WITH PASSWORD 'new_password';
- grant login permission
| package dev.varaprasadh.app; | |
| import org.springframework.http.MediaType; | |
| import org.springframework.web.multipart.MultipartFile; | |
| import java.io.ByteArrayOutputStream; | |
| import java.io.File; | |
| import java.io.IOException; | |
| import java.io.ObjectOutputStream; | |
| import java.math.BigInteger; |
| File file = new ClassPathResource("logo.png").getFile(); | |
| HTTPRequestMultipartBody multipartBody = new HTTPRequestMultipartBody.Builder() | |
| .addPart("name", request.getName()) | |
| .addPart("file", request.getFile(), request.getFile().getContentType(), request.getFile().getOriginalFilename()) | |
| .addPart("file1", file, null , request.getFile().getOriginalFilename()) | |
| .build(); |
create role 'fleet-support-readonly';
ALTER USER user_name WITH PASSWORD 'new_password';
| # Add to postgresql.conf | |
| # Enable logging | |
| logging_collector = on | |
| log_directory = 'pg_log' # Directory where log files are written | |
| log_filename = 'postgresql-%Y-%m-%d.log' # Daily log files | |
| log_rotation_age = 1d # Rotate logs daily | |
| log_rotation_size = 100MB # Also rotate when file reaches 100MB | |
| # What to log |
import aiohttp
import asyncio
import random
from collections import defaultdict
import time
from typing import List, Dict
import loggingCreated: 7/23/2025 12:46
Updated: 7/23/2025 12:47
Exported: 7/23/2025 12:48
Link: https://claude.ai/chat/63be5a25-1e26-4592-a0b9-f9bf9aac3fde
Here are several ways to handle Map<key,value> storage in PostgreSQL with Spring Boot:
| warehouse_import_file_settings | |
| warehouseid fieldMapping | |
| 100. {productName: "pName", "productId": "pid", subCategory: "subCategory" } | |
| ------ | |
| @Entity | |
| class warehouseImportFileSettings { |