I am grabbing the related meetings with each Department, hence I would like to have a pagination for each meetings list. I currently have this in my Inertia Middleware to have it available in my frontend: 'auth' => [ 'user'…
need help on a server action on my Next.js applicastion, giving me a type error and can't pinpoint the reason, it appears when there are 3 values on the db.insert for the orderProduct and it always errors out the first…
$orderId = 319769; $sql = ShipOrderModel::query()->where('order_id', (string)$orderId); // select * from `hr_ship_order` where `order_id` = 319769 $sql = ShipOrderModel::query()->where('order_id', '319769'); // select * from `hr_ship_order` where `order_id` = 319769 $sql = ShipOrderModel::query()->whereRaw('order_id = "?"', $orderId); //select * from `hr_ship_order` where…
Postgresql allows NaN values in numeric columns according to its documentation here. When defining Postgres tables using Django ORM, a DecimalField is translated to numeric column in Postgres. Even if you define the column as bellow: from django.db import models…
I have a some problem... ORM When I use php artisan tinker, use App\Models\User $u = new User(); $u->title = 'sale'; $u->content = 'auto ...'; $u->price = 2500; HERE ARE GOOD EVERYTHING, BUT... when I type command $u->save(); I see…
I want to find data between 2 month, for example data between months 8 and 9. Edit: The issue is in this line else if ($bulan1 != "semua" && $bulan2 != "semua") { $query->whereBetween(DB::raw('MONTH(kred_kep_aktf_kompetensi.mulai)'), [8, 9]); } And this is…
I have a mongoengine document such as: from mongoengine.document import Document from mongoengine import StringField class Class_A(Document): field_a = StringField() field_b = StringField() I'd like to lock field_b so it cannot be altered, e.g. var = <fetch Class_a document from…
There is a model: class Categories(models.Model): name = models.CharField(max_length=150, unique=True, verbose_name='Name') slug = models.SlugField(max_length=200, unique=True, blank=True, null=True, verbose_name='URL') class Products(models.Model): name = models.CharField(max_length=150, unique=True, verbose_name='Name') slug = models.SlugField(max_length=200, unique=True, blank=True, null=True, verbose_name='URL') category = models.ForeignKey(to=Categories, on_delete=models.PROTECT, verbose_name='Categoy') I don't understand…
I have a schema as follows: model Player { id String @id @default(auto()) @map("_id") @db.ObjectId steam_id String @unique name String level Int @default(1) elo Float @default(1500) games Game[] @relation(fields: [game_ids], references: [id]) game_ids String[] @db.ObjectId clients Client[] user User? @relation(fields:…
This is the error: java.sql.SQLException: Field 'userid' doesn't have a default value at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130) ~[mysql-connector-j-8.3.0.jar:8.3.0] This is my Entity class: @Entity @Table(name = "users") public class Users { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private int userId; } Table: CREATE TABLE `users`…