Enlighten
main 0d54602

Retrieve a random term from a specified termbase

Returns a random term from a specific termbase. You can define min length, max length and whether symbols are allowed

Request
Method: POST
Route: api/entry/random
Example: api/entry/random
Input Value
database teleterm
allow_symbols false
max_len_term_en 10
max_len_term_gr 10
Request Headers
host: localhost:8000
accept: application/json
user-agent: Symfony
content-type: application/json
accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
content-length: 87
accept-language: en-us,en;q=0.5

Response
200 JSON
Response Headers
date: Tue, 14 Oct 2025 08:48:15 GMT
content-type: application/json
cache-control: no-cache, private 
{
    "data": [
        {
            "RECNUM": 107507,
            "TERMEN": "donation",
            "TERMGR": "δωρεά",
            "MOTOVOC": "QL 11",
            "CODE": "30",
            "STAGE": "3",
            "ABBRGR": null,
            "STERMGR": null,
            "SECTION": null,
            "NOTEGR": null,
            "ABBREN": null,
            "STERMEN": "ELITE - CASE STUDY",
            "TERMFR": null,
            "ABBRFR": null,
            "TERMGE": null,
            "ABBRGE": null,
            "NOUN": null,
            "NOTEEN": null,
            "GRAECOEN": null,
            "GRAECOFR": null,
            "GRAECOGE": null,
            "SOURCES": null,
            "MARKING": 0,
            "MOTOVOC2": "QL 11",
            "DATEOFRECORD": null,
            "N-LECTICITY_EN": null,
            "N-LECTICITY_GR": null,
            "N-LECTICITY_FR": null,
            "SOURCE_UNIFORM": "QL 11",
            "LINK": null
        }
    ],
    "system": {
        "messages": [],
        "status": 200,
        "status_text": "OK",
        "errors": [],
        "error_code": 0
    },
    "metadata": {
        "termmaster_games": 2217,
        "database": "teleterm",
        "uid": 100107507,
        "request": {
            "database": "teleterm",
            "allow_symbols": false,
            "max_len_term_gr": 10,
            "max_len_term_en": 10
        },
        "count": 1
    }
}

Time: 224.84

 
select * from `TELETERM_TELETERM` where TERMEN REGEXP '^[A-Za-z ]+$' AND length(TERMEN) <= 10 AND length(TERMGR) <= 10 order by RAND() limit 1

Time: 0.5

 
select * from `GAME_STATISTICS` where `GAME_STATISTICS`.`id` = ? limit 1
Bindings
0: 1

Time: 2.46

 
update `GAME_STATISTICS` set `value` = `value` + 1 where `id` = ?
Bindings
0: 1

Request
Method: POST
Route: api/entry/random
Example: api/entry/random
Input Value
database teleterm
allow_symbols false
max_len_term_en 10
max_len_term_gr 10
Request Headers
host: localhost:8000
accept: application/json
user-agent: Symfony
content-type: application/json
accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
content-length: 87
accept-language: en-us,en;q=0.5