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`…
I'm a learning developer in web technologies, particularly Angular, and I am currently working on the website of our computer science club. We plan to post some articles, cheatsheets, etc., and we would like to store them in a database…
I'm currently building an API assigned for an ecommerce project using Laravel framework. While getting help to build data migrations and Models, I got confused on how the product_categories, the intermediate table, can link a product and category as in…
How can i annotate field with RawSQL? sql_query = """ SELECT c.id, COALESCE(SUM((cm.temp_min + cm.temp_max) / 2 - %s), 0) AS gdd FROM agriculture_commune c LEFT JOIN agriculture_communemeteo cm ON c.id = cm.commune_id WHERE cm.date BETWEEN %s AND %s GROUP…
please help, I've been stuck here since then. I want to insert shipmentrequestitem from shipmentrequest model using update method public function update(UpdateShipmentRequestRequest $request, $id) { $shipmentRequest = ShipmentRequest::with( 'shipmentRequestItems', )->where('id',$id)->first(); $shipmentRequest->update($request->all()); $validatedData = $request->validated(); $shipmentRequestItems = $validatedData['shipmentRequestItems']; // $shipmentRequest =…
I'm pretty new to Sequelize and trying to learn all of the cool tricks you can use to format your queries, but have run into a bit of a wall. Basically I have a table "invoices". I have another table…