Beautiful Code

Google Pay India Diwali Offers- How to get a rangoli ?

2019-11-02T12:49:00.003-07:00

Even you are tired of not getting a Rangoli on Gpay?

Good News, Google just extended their scheme till 11th November 2019 for those who are yet to win assured reward of 251 INR by collecting all 5 gems.

But let me tell you, you might be doing it wrong, which might lower your probability of winning the most scantiest Rangoli.

Check the below steps if you have missed the clear instructions by google which ensures a good chance of winning a treasured Rangoli on any rainy day.

Follow the below steps:

Method 1:

Do a DTH Recharge

Click on start a payment & select DTH payment.
Select your DTH operator.
Enter your customer ID or mobile number.
Enter the amount.
Proceed to Payment.
You've earned a scratch Card and if lucky then Rangoli or Flower Gem.

Method 2:

Pay an Electricity bill

Click on start a payment & select Electricity payment.
Type in the name of a biller.
From the search results, tap the name of the biller Make payment.
Select an account.

You'll see one of the following:

Pay a custom amount: Tap Make Payment and enter the amount that you’d like to pay.
Pay an available bill: On the bill, tap Pay Bill.

Follow the instructions on the screen.
When done, view the bill to confirm that the payment was successful.

Note: It usually takes up to 3 business days for payments to show up in your account.

7. You've earned a scratch Card and if lucky then Rangoli or Flower Gem.

How to export a Mysql table to a csv file? -BASH - Linux

2019-06-28T12:51:00.002-07:00

We are going over MySQL which is a lot more widely used especially for websites and

stuff, but let's say you, you had a MySQL database and you wanted to put that into a CSV format for whatever reason for importing into another program that doesn't accept my SQL just for a simple

text backup or for whatever reason that may be.

Someone you're working with on a MySQL database someone else created and you

decide, you know what "I just want to is stick with CSV", you can export it to CSV

and that's what we're gonna do today.

There are two wonderful method to do this.

Using MYSQLDUMP
Using mysql OUTFILE query

1) Using MYSQLDUMP

You can dump your file into any format you want, but here we are going to focus on CSV format.

Your system should be installed already with MySql, and i am using a linux machine.

Where, -u = username

-p = password

-T = write command
/tmp/ = folder to write in
filmsbykris = database name
users = table name we want to import
--fields-terminated-by = character you want to separate your fields by so traditionally it would be a comma
--fields-enclosed-by= for appropriate data handling we can also mention this

Result:

As you can see, on printing the standard output of the file we just made,

We can deduce that it seems pretty much normal and executable now in csv readable foramat.

2) Using OUTFILE sql query.

Now coming to the traditional sql query method:

One has to first login to the database of the table, they need to import as a csv.

Log in to mysql

select the database you want to copy data from

run the query to dump data into required folder

Query bifurcation:

Select * = select all the columns

INTO OUTFILE = specify the dumping folder, with the file name.

fields escaped by = to determine new cell

fields terminated by = to determine the line break

How to access a Protected Variable and Function out of the Parent Class in Object Oriented Programming?

2019-06-27T13:43:00.002-07:00

To access a Protected Variable or a Function out of the Parent Class, there is a small workaround one has to do to access it seamlessly.

Firstly, what is a Protected Property or a Method?
A protected method is a method which can only be accessed inside a class or an inherited class.

So the Question is how can we access these Properties and Methods outside the class?

In order to access it, outside that class, one must call another public method which directly calls required the protected method.

Three easy steps to follow.

FInd any Protected Method you need to call outside that class.
Define a Public Method which calls the same Protected Method.
Create an instance of the same class and call the Public method.

Thankyou!