DEV Community: ilya

Is it possible to call one function continuously in while loop?

ilya — Mon, 24 Jul 2023 18:26:50 +0000

I am wondering whether it is possible or not to realize multi threads in javascript while loop.
for example,
`while(1){
sample(param1, param2)
}

function sample(param1, param2){
// some code here
console.log("some result")
}
`
I tried with it but it does not show console.log result.
I think it happens because while() call function again before the sample() function execute some code and so sample() function start from scratch again.
How can I realize multi thread in javascript?

how to convert sql query to laravel model style without DB?

ilya — Mon, 22 Mar 2021 18:53:00 +0000

->join(array(\DB::expr('(select SUM(p.amount) as paid, p.case_id
from payments p
where p.status_id = 3
group by p.case_id)'),'p'), 'LEFT')->on('p.case_id','=','c.id')
this is sql query of fuelphp
i am going to convert it to laravel query style to not use DB.
DB means illumiate\Fascade\DB;
how?

laravel eloquent relation

ilya — Sat, 20 Mar 2021 14:24:18 +0000

This is table relation

 $result = Event::select('events.*', 'events.at as datatime', 'events.end_time as endtime','event_types.name as event_type_name')
        ->from('events')
        ->leftJoin('event_types', 'event_types.id', 'events.type_id')
        ->where('events.id', $id)
        ->where('events.user_id', 350)
        ->get()
        ->toArray();
    return $result;

i want to change it to eloquent relation.
for example, i think we can use with() method instead of select method of query.

Rename column in laravel migration

ilya — Wed, 17 Mar 2021 13:01:35 +0000

php artisan make:migration rename_fields_to_chat_messages_table --table=chat_message
You can created migration file with above command.
You can rename column as follow.

public function up()
{
    Schema::table('chat_message', function (Blueprint $table) {
        $table->renameColumn('created_date', 'created_at');
    });
}

/**
 * Reverse the migrations.
 *
 * @return void
 */
public function down()
{
    Schema::table('chat_message', function (Blueprint $table) {
        $table->renameColumn('created_at', 'created_date');
    });
}

you can update as follow

public function up()
{
Schema::table('chat_message', function (Blueprint $table) {
$table->unsignedInteger('user_id')->change();
$table->unsignedInteger('doc_id')->change();
$table->unsignedInteger('created_by')->nullable();
$table->unsignedInteger('updated_by')->nullable()->after('created_by');
$table->timestamp('created_at')->nullable()->change();
$table->timestamp('updated_at')->nullable()->after('created_at');
});
}

/**
 * Reverse the migrations.
 *
 * @return void
 */
public function down()
{
    Schema::table('chat_message', function (Blueprint $table) {
        $table->dateTime('created_date')->change();
        $table->dropColumn('created_by');
        $table->dropColumn('updated_by');
        $table->dropColumn('updated_at');
    });
}

Hello, Please help me in laravel model

ilya — Tue, 09 Mar 2021 20:20:06 +0000

i am changing query to laravel model.
but only one problem...
->join(array(\DB::expr('(select SUM(p.amount) as paid, p.case_id
from payments p
where p.status_id = 3
group by p.case_id)'),'p'), 'LEFT')->on('p.case_id','=','c.id')
this is leftjoin subquery but i have to change to laravel model type.
Please help me.

Hi, everyone!

ilya — Sat, 06 Mar 2021 18:27:18 +0000

I am a web developer. Want good relation with you.
I have one problem.
Db::last_query();
this is grammar in fuelphp
but i am going to migrate fuelphp to laravel.
how do i have to do?
Please help me.