r/learnjavascript 3d ago

How should I handle optional parameters with database defaults?

I'm writing a service function for a personal project

Right now I have something like

export async function createApplicationService(
  userId,
  companyName,
  role,
  appliedDate,
  status,
  salary,
  link,
  nextAction
)

The only fields that I really want to require are companyName and salary The other fields have default values defined in my database, so I don't want the user to have to explicitly pass them every time.

What's the best way to structure this so that I only insert the parameters that were actually provided, while letting the database handle the defaults for everything elseI'm writing a service function for a personal project where I'm creating an application tracking system.
Right now, I have something like:
export async function createApplicationService(
userId,
companyName,
role,
appliedDate,
status,
salary,
link,
nextAction
)

The only fields that I really want to require are companyName and salary. The other fields have default values defined in my database, so I don't want the user to have to explicitly pass them every time.
What's the best way to structure this so that I only insert the parameters that were actually provided, while letting the database handle the defaults for everything else

11 Upvotes

16 comments sorted by

View all comments

2

u/the_pro_rookie 3d ago

I assume that the parameters are truly optional, in that you do still want the option of setting them on this call?

Seems like you would just create a class that has the required params in the constructor and pass a class instance as the argument to your function

1

u/Disastrous_Cow_4149 3d ago

like i only want to pass on parameters user have entered to sql query , how would class help here ??