τϥϯβΫγϣϯ
ࠔ͍ͬͯͨ
▶ τϥϯβΫγϣϯॲཧΛ͍ͯ͠ͳ͔ͬͨ
▶ ࠷ॳ MyISAM ͩͬͨͷͰ...
▶ ෆ߹͕ى͖Δ͜ͱ͋ͬͨ
▶ JSON Λڝ߹ͯ͠ॻ͖ࠐΜͰ
ϑΟʔϧυ͕ফ͑Δͱ͔...
sub write_key_value { # ˞ࣜతͳίʔυ
my ($db, $obj id, $field, $value) = @ ;
my $row = $db->select_row(qq{
SELECT * FROM some_table WHERE id = ? }, [ $obj id ]);
my $json = $row->{json} ? decode json $row->{json} : {};
$json->{$field} = $value; # ॻ͖ࠐΉϑΟʔϧυ͍Ζ͍Ζ
$db->query(qq{
UPDATE some_table SET json = ?
WHERE id = ? }, [ encode json $json, $obj id ]); }