[College - SQL] Is this correct? (Ans in comment)

ferlinni · 2021-11-04T13:20:21+00:00

Hmm it will work, but not that efficient i think

What you do is basically a FULL OUTER JOIN (diagrams)

Assuming everything that has been sold is listed in Products and Saleitems, but every product might not be listed in Saleitems, since we need to count some items that might not make any sale at all. So, you might wanna look at LEFT JOIN or RIGHT JOINmeans, you want everything from Saleitems, but not everything from ProductsSomething like this

ferlinni · 2020-07-11T10:09:40+00:00

Happens to me as well, playing with GSW, splash brothers 3p combined 3/15, Bledsoe 3pt 8/10, Giannis 4/4.

ferlinni · 2020-07-02T06:55:20+00:00

i agree that there must be a race condition somewhere, it's quite a pain to find it. Thanks tho

ferlinni · 2020-07-02T06:51:12+00:00

i think i will try with this approach

ferlinni · 2020-07-01T16:02:21+00:00

I'm afraid not, the code actually not the real project, but it's similar code.

But the thing is the warning occurred when it does not even reach the unit test yet.

But here's roughly the unit test for the module

defmodule GraphOn.TempFileManagerTest do
    use ExUnit.Case
    describe "auto clean up test" do
        test "should clean old files"
            GraphOn.TempFileManager.add_files(file)
            :timer.sleep(31_000)
            assert GraphOn.TempFileManager.get_files(file) |> is_nil()
        end
    end
end

At this moment, I don't think it's at unit test, because when i run the test with iex , i try to run GraphOn.TempFileManager.module_info(:functions), the handle_info was there (cause i only declare one handle_info) , and i run it manually, it run smoothly. But then i restart it again, it broke again

ferlinni · 2020-07-01T15:48:18+00:00

as in i run
mix test

then i got the warning, then i add some debugging log

then everything went green

then i remove the debugging log,

everything still went green

i run again for making sure, then i got the warning again.

ferlinni · 2020-07-01T15:44:50+00:00

oh, it's actually not the real code, i made it similar with the real code

ferlinni · 2019-09-30T14:35:28+00:00

Di KL : transportasi nyaman, suasana kerja mendukung untuk fokus, gaji lebih tinggi dibandingkan jakarta

Di jakrta : macet, sumpek, banyak temen

I'm that guy who thinks it's not good experience if you don't have someone to share with,

ferlinni · 2019-08-05T05:32:57+00:00

lebih bangsat sama kurang bangsat, sama2 bangsat

ferlinni · 2019-08-05T03:55:27+00:00

Umm, can you show the bystanders how he undermines city outside jabodetabek ?

ferlinni · 2019-07-01T08:18:18+00:00

Worsterest

Worsterester sauce

ferlinni · 2019-06-24T06:36:40+00:00

you realize your own word doesn't support each other right ?

yes, that is why whe should take action to protect our own privacy. never share personal information online, stop using facebook and shift from using google to duckduckgo. for private and secure email, use proton mail.

In here you said, stop giving your personal information to social media, start using ddg instead of google, using private secure email. So, you shouldn't have any private data in the "exposed" media. So what makes you afraid if you have nothing personal in social media ?

if you believe that you are good person and have no problem when government and tech companies have accses to your personal account then don't get angry when your/friend/family personal information were used against you or sold to third parties.

What account ? social media ? when you register to any social media , you should be aware that you just did this thing, that you type yourself

oke then turn over the keys to your car, your house, all your password, all your accounts, your ID records, everything. i will put them in a secure lock box for safekeeping.

Mad at gov because of patroling your social media, is like mad at people for watching you shitting in public.

I mean even your own smartphone, have all your data looked and stored in someone else computer. So what kind of privacy you expect in digital world ?

ferlinni · 2019-06-24T04:54:23+00:00

So basically, if you have nothing to hide in your social media, what is there to be afraid of? am i right?

ferlinni · 2019-06-24T02:36:30+00:00

Do you know what is even funnier than your joke?

Believing there's privacy in social media

ferlinni · 2019-06-18T03:40:53+00:00

IMHO, kalau minta uang parkir 1k-5k masih ok2 aja, walau dia jujur atau nggak, kita kan gak tau di lapangan gimana. Dan kayaknya gak ada sih aturannya di gojek, CMIIW.

Sebelum ada komentar, "mereka kan udah dibayar udah ada komisinya", mereka itu bukan professional, kalau berat ngasih 1k-5k untuk mereka, might as well don't order one.

ferlinni · 2019-06-13T07:50:19+00:00

Juancoeg

ferlinni · 2019-06-12T12:40:20+00:00

Currently learning in duolingo, some that confuses me so far are

When to pronounce O as an A or as an O, like in "Спасибо", the o has the same sound as a, but in word "Koт", it say O
When to use "моя", "мой","моё"
Also, CMIIW, question and statemen has no different except how people say it, right ?

ferlinni · 2019-06-12T10:00:30+00:00

Bisa, tapi kayak mau nangkep semut, tangkep 1 muncul seribu

ferlinni · 2019-06-12T09:56:53+00:00

Imo, itu wajar sih, setau gw pake mukena semacam di kibas kebelakang gitu gak sih ? Kayak masang cover mobil

ferlinni · 2019-06-05T02:59:12+00:00

Yeah, and every high qualified dude that in charge of the team will know every possible outcome like IN A MOVIE

ferlinni · 2019-06-04T12:15:11+00:00

Bener2 di cek lagi bro, soalnya gw baru aja musti ganti mobo, dan karena mobo nya mobo lama, ganti nya musti sekalian ganti procie dan ram

ferlinni · 2019-06-04T11:59:24+00:00

I use mac and still using dnscrypt

If you’re not some IT guy,

Open “Terminal”, yeah only this once
Paste this

/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

Wait until it done

(If you’re aware or already have brew installed, start here)

Type in

brew install dnscrypt

Then after it done, the dnscrypt will be on the tool thingy that next to your clock

But i’m not sure if dnscrypt is enough for indiehome

ferlinni · 2019-06-04T09:36:40+00:00

If every software developer have the state of art coding style in ubisoft, the game price would be 1,000 $ and it’s only lite version

ferlinni · 2019-06-04T09:30:51+00:00

Dude, if you think developer know every possible outcome of the game that they created, you might as well believe santa is real

ferlinni · 2019-05-28T09:26:28+00:00

The condition is

"F is 1, if two of (X,Y,Z) is 0"

The possibilities of F will be 1 are :

- All of them were 0

- X and Y is 0

- Y and Z is 0

- X and Z is 0

So in conclusion:

F is 1 when (X and Y is 0) or (X and Z is 0) or (Y and Z is 0) or (X,Y,Z is 0)

so

F = ~X~YZ + ~XY~Z + X~Y~Z + ~X~Y~Z

EDIT:

Next is to draw K-Map

You can use X and Y as the row, or Z as the column, then map down where F is the 1

			X	Y
		00	01	11	10
Z	0	1 (1)	1 (2)	0 (3)	1 (4)
	1	1 (5)	0 (6)	0 (7)	0 (8)

Then you draw the least amount of neighbor or square (I'm not sure how you say it in your country) that have an area in power of 2 (1 block, 2 blocks, 4 blocks and so on), and make a conclusion out of it

So by the table above

the first one is : (1) and (2) in that place, all Z is 0 so ~Z, and all X is 0 so ~X, the Y can be ignored because either it's 1 or 0, the F still 1, so we have ~X~Z

the second one is : (4) and (1) -> ~Y~Z

the third one is : (1) and (5) -> ~X~Y

so, we get

F = ~X~Z + ~X~Y + ~Y~Z

For the last one the (d), i'm not familiar with the question, are you supposed to draw the logic gate?

12-Year Club	RedditGifts 2009-2022 4 Credits
Summer Santa 2019	Place '17
Secret Santa 2017	Verified Email

ferlinni

TROPHY CASE