how to insert user in database for testing backend?

[frndxyz]

No description provided.

[SwimmingTiger]

There is no user database in the project. You may design any type of user database by yourself. And write a get-user-list web api to expose all username-uid pairs to pool's stratum server.

Only the username-uid pairs from the web api is needed for the pool backend.

For test, you may write a small script with static user list. There is an example:

get-user-list.php

<?php
header('Content-Type: application/json');

$last_id = (int) $_GET['last_id'];

$users = [
    'aaa' => 1,
    'bbb' => 2,
    'xxx' => 3,
    'mmm' => 4,
    'vvv' => 5,
    'ddd' => 6,
];

$requestedUsers = [];
foreach ($users as $name=>$id) {
    if ($id > $last_id) {
        $requestedUsers [$name] = $id;
    }
}

echo json_encode(
    [
        'err_no' => 0,
        'err_msg' => null,
        'data' => (object) $requestedUsers,
    ]
);

Then put it in a httpd server and edit /work/btcpool/build/run_sserver/sserver.cfg:

list_id_api_url = "http://localhost/get-user-list.php";

Then you can mining for aaa, bbb or xxx, etc. Its id 1, 2 or 3 will be recorded to tables in bpool_local_stats_db as column puid .