How to use Mysql function in Php Editor SET

khellendros74

Description of problem: theoretical question
with the following syntax i know how to extract data from a table field (example how im using it below) so it basically inject a mysql function while doing a get

here is the table essential definition

CREATE TABLE `collect_ip` (
  `uuid` binary(16) DEFAULT NULL,
  `router_ip` varbinary(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

to extract binary to string i use the following php code

,   Field::inst( "BIN_TO_UUID(collect_ip.uuid)", "collect_ip.uuid" )
,   Field::inst( "INET6_NTOA(collect_ip.router_ip)", "collect_ip.router_ip" )

but i cant manage to write data using mysql function that should be respectively (or haven't found the good example

UUID_TO_BIN("ST-RI-NG")
INET6_ATON("10.0.0.3")

the closet example are formatters but they refer to php function, and mostly respond to date format

so is there a way to push mysql function inside ?

Field::inst( "BIN_TO_UUID(collect_ip.uuid)", "collect_ip.uuid" )->setFormatter( Format::UuidToBin() )
Field::inst( "INET6_NTOA(collect_ip.router_ip)", "collect_ip.router_ip" )->setFormatter( Format::INET6_ATON() )

allan

Unfortunately no, there isn't a way to use an SQL function along with submitted data as part of the set operation I'm afraid. That is something of an oversight and I'll need to look into how it might be possible to add something like that in future. Apologies.

Allan

khellendros74

thanks for your quick answer,
so i will modify your code to match my desire