Just wanted to make sure that I'm understanding this right: designing UML-diagram we are talking about the relations between entities? in the context of SQL a table is a relation? I can remember that my teacher, for a while ago,…
I want to download Daily NAV (Net asset Value) from AMFI Website for all the schemes and store all of it in MongoDB. But with my current code it is taking too long almost 5 days to download and push…
drop procedure if exists AddValidBooking; DELIMITER // CREATE PROCEDURE AddValidBooking(IN booking_date DATE, IN table_number INT) BEGIN DECLARE booked BOOLEAN; START TRANSACTION; SELECT CASE WHEN EXISTS ( SELECT 1 FROM Bookings WHERE DATE(Booking_Date) = DATE(booking_date) AND Table_Number = table_number ) THEN…
I am trying to pick up the basics of SQL and my teacher has given us this block of code to cpy and paste to create a table: mysql> CREATE TABLE IF NOT EXISTS actors ( -> id SMALLINT UNSIGNED…
I'm working on Laravel 10 project and I want to add some data to database when I run the composer install <package_name>. To do that, I have created a custom PHP file and call that postPackageInstall function in composer.json file.…
Context: I've been creating a database for a class assignment, the assignment doesn't have detailed instructions, instead gives us a narrative in order to have us make our own assumptions and interpretations as to what to create for the database.…
useEffect(() => { console.log("this is first useEffect", "first"); }); useEffect(() => { console.log("this is second useEffect", "second"); }); useEffect(() => { const listen = onAuthStateChanged(auth, (user) => { setLoading(true); if (user) { setAuthUser(user); setLoading(false); console.log("this is third useEffect",user) } else…
I'm trying to update a table by using join. Also one of the join is self join. I need to update a column with the same column in the same table. SERVICE ID code value 123 QUANTITY1 2 123 QUANTITY2…
I'm a bit new to postgres and quite rusty with SQL. I have a users table with password_hash column which stores a hashed password through pgcrypto. id | name | email | password_hash | ----+------------+-----------------+------------------------------------+ 1 | john doe |…
This is my index.js file in cart folder for cart page import React from "react"; import { Link } from "react-router-dom"; import CartProducts from "./CartProducts"; import Layout from "../../components/Layout"; import { useCart } from "../../hooks/useCart"; import { formatNumber } from…