DEV Community: Mahendra Choudhary

Need help with sql (_) !

Mahendra Choudhary — Wed, 18 Sep 2019 14:23:25 +0000

hi dev's

While working on a "hospital management system" demo project using rails.I stucked in a scenario where I need to pull "firstname" from users table. Here is detailed scenario ...

So Here are my tables :

table1 : appointments has following columns 
         id|patient_id|physician_id|

table2: patients table                  table3: physicians table
         id|user_id|...                      id|user_id|...

table4: users (note that users table as 4 types of user admim,patient,physician and nurse )

      id|firstname|lastname|role|.....

** Here user_id refers to users table primary key
** patient_id and physician_id refers to patients and physicians primary key

Now how can i fetch "firstname" from users table from appointments table????

As of now i am using following code to print appointments but this is to costly

# frozen_string_literal: true

module Admin
  # Appointment actions
  class AppointmentsController < ApplicationController
    before_action :new_user

    def index
      @appointments = paginate(fetch_records)
      respond_to do |format|
        format.html { @appointments }
      end
    end

   .
   .
   .

    private

    def fetch_records
      @appointments = current_user.admin? ? Appointment.all :    Appointment.current_user(current_user.physician)

      @appointments.collect do |appointment|
        [
          appointment.id, appointment.patient.user.firstname,
          appointment.physician.user.firstname, appointment.status,
          appointment.appointment_date
        ]
      end
    end
  end
end

rails --versin : rails 5.2.3
ruby --version: 2.6.3

Short bit and byte

Mahendra Choudhary — Tue, 20 Aug 2019 05:52:48 +0000

While scrolling down to my LinkedIn feeds this morning I found this short story (_) which summarizes lessons from all the success stories . So I just want to share with all my fellow devs .

2 stories to begin with

Nokia refused Android
Yahoo refused Google

Story over

Lessons learnt

Take risks
Embrace changes
If you refuse to change with time , you might perish

Ok 2 more stories

Facebook takes over whatsapp and instagram
Flipkart takes over myntra and flipkart owned Myntra takes over jabong & now Flipkart is taken over by Walmart

Story over

Lessons learnt

Become so powerful that your competitors become your allies .
Reach the top position and then eliminate the competition
keep innovating

2 more stories

Colonel sanders founded KFC at the age of 65 .
Jack Ma , who coudnt get job in kfc , founded ALibaba .

story over

Lesson learnt

Age is just a number .
Only those who keep trying succeeds .

Last but not least

1.Lamborghini was founded as result of revenge of a tractor owner who was insulted by Enzy Ferrari , the founder of ferrari

Story over

Lessons learnt
1.Never underestimate anyone , ever !! .
2.Success is the best revenge .

Things to know in rails?which help me to be a better rails developer

Mahendra Choudhary — Wed, 24 Jul 2019 05:13:16 +0000

I started out as a junior rails developer a month ago .I like to ask senior devs what tips you like to give to beginner . What things should I learn which will help me in future ?

DEV Community: Mahendra Choudhary

Need help with sql (*_*) !

Short bit and byte

Things to know in rails?which help me to be a better rails developer

Need help with sql (_) !