use Time::HiRes;
use JSON::XS;
use URI::Escape;
+use Tie::Persistent;
+use DBI;
+use DBD::Pg;
require 'Position.pm';
require 'Engine.pm';
require 'config.pm';
my $tb_lookup_running = 0;
my $last_written_json = undef;
-# TODO: Persist (parts of) this so that we can restart.
-my %clock_target_for_pos = ();
+# Persisted so we can restart.
+# TODO: Figure out an appropriate way to deal with database restarts
+# and/or Postgres going away entirely.
+my $dbh = DBI->connect($remoteglotconf::dbistr, $remoteglotconf::dbiuser, $remoteglotconf::dbipass)
+ or die DBI->errstr;
+$dbh->{RaiseError} = 1;
$| = 1;
$json->{'id'} = $engine->{'id'};
$json->{'score'} = long_score($info, $pos_calculating, '');
$json->{'short_score'} = short_score($info, $pos_calculating, '');
+ $json->{'plot_score'} = plot_score($info, $pos_calculating, '');
$json->{'nodes'} = $info->{'nodes'};
$json->{'nps'} = $info->{'nps'};
}
$json->{'refutation_lines'} = \%refutation_lines;
- my $encoded = JSON::XS::encode_json($json);
+ # Piece together historic score information, to the degree we have it.
+ if (!$historic_json_only && exists($pos_calculating->{'pretty_history'})) {
+ my %score_history = ();
+
+ my $q = $dbh->prepare('SELECT * FROM scores WHERE id=?');
+ my $pos = Position->start_pos('white', 'black');
+ my $halfmove_num = 0;
+ for my $move (@{$pos_calculating->{'pretty_history'}}) {
+ my $id = id_for_pos($pos, $halfmove_num);
+ my $ref = $dbh->selectrow_hashref($q, undef, $id);
+ if (defined($ref)) {
+ $score_history{$halfmove_num} = [
+ $ref->{'plot_score'},
+ $ref->{'short_score'}
+ ];
+ }
+ ++$halfmove_num;
+ ($pos) = $pos->make_pretty_move($move);
+ }
+ $q->finish;
+
+ # If at any point we are missing 10 consecutive moves,
+ # truncate the history there. This is so we don't get into
+ # a situation where we e.g. start analyzing at move 45,
+ # but we have analysis for 1. e4 from some completely different game
+ # and thus show a huge hole.
+ my $consecutive_missing = 0;
+ my $truncate_until = 0;
+ for (my $i = $halfmove_num; $i --> 0; ) {
+ if ($consecutive_missing >= 10) {
+ delete $score_history{$i};
+ next;
+ }
+ if (exists($score_history{$i})) {
+ $consecutive_missing = 0;
+ } else {
+ ++$consecutive_missing;
+ }
+ }
+
+ $json->{'score_history'} = \%score_history;
+ }
+
+ my $json_enc = JSON::XS->new;
+ $json_enc->canonical(1);
+ my $encoded = $json_enc->encode($json);
unless ($historic_json_only || !defined($remoteglotconf::json_output) ||
(defined($last_written_json) && $last_written_json eq $encoded)) {
atomic_set_contents($remoteglotconf::json_output, $encoded);
if (exists($pos_calculating->{'pretty_history'}) &&
defined($remoteglotconf::json_history_dir)) {
- my $filename = $remoteglotconf::json_history_dir . "/" . id_for_pos($pos_calculating) . ".json";
+ my $id = id_for_pos($pos_calculating);
+ my $filename = $remoteglotconf::json_history_dir . "/" . $id . ".json";
# Overwrite old analysis (assuming it exists at all) if we're
# using a different engine, or if we've calculated deeper.
# nodes is used as a tiebreaker. Don't bother about Multi-PV
# data; it's not that important.
- my ($old_engine, $old_depth, $old_nodes) = get_json_analysis_stats($filename);
+ my ($old_engine, $old_depth, $old_nodes) = get_json_analysis_stats($id);
my $new_depth = $json->{'depth'} // 0;
my $new_nodes = $json->{'nodes'} // 0;
if (!defined($old_engine) ||
$new_depth > $old_depth ||
($new_depth == $old_depth && $new_nodes >= $old_nodes)) {
atomic_set_contents($filename, $encoded);
+ if (defined($json->{'plot_score'})) {
+ local $dbh->{AutoCommit} = 0;
+ $dbh->do('DELETE FROM scores WHERE id=?', undef, $id);
+ $dbh->do('INSERT INTO scores (id, plot_score, short_score, engine, depth, nodes) VALUES (?,?,?,?,?,?)', undef,
+ $id, $json->{'plot_score'}, $json->{'short_score'},
+ $json->{'id'}{'name'}, $new_depth, $new_nodes);
+ $dbh->commit;
+ }
}
}
}
}
sub id_for_pos {
- my $pos = shift;
+ my ($pos, $halfmove_num) = @_;
- my $halfmove_num = scalar @{$pos->{'pretty_history'}};
+ $halfmove_num //= scalar @{$pos->{'pretty_history'}};
(my $fen = $pos->fen()) =~ tr,/ ,-_,;
return "move$halfmove_num-$fen";
}
sub get_json_analysis_stats {
- my $filename = shift;
-
- my ($engine, $depth, $nodes);
-
- open my $fh, "<", $filename
- or return undef;
- local $/ = undef;
- eval {
- my $json = JSON::XS::decode_json(<$fh>);
- $engine = $json->{'id'}{'name'} // die;
- $depth = $json->{'depth'} // 0;
- $nodes = $json->{'nodes'} // 0;
- };
- close $fh;
- if ($@) {
- warn "Error in decoding $filename: $@";
- return undef;
+ my $id = shift;
+ my $ref = $dbh->selectrow_hashref('SELECT * FROM scores WHERE id=?', undef, $id);
+ if (defined($ref)) {
+ return ($ref->{'engine'}, $ref->{'depth'}, $ref->{'nodes'});
+ } else {
+ return ('', 0, 0);
}
- return ($engine, $depth, $nodes);
}
sub uciprint {
return undef;
}
+# For graphs; a single number in centipawns, capped at +/- 500.
+sub plot_score {
+ my ($info, $pos, $mpv) = @_;
+
+ my $invert = ($pos->{'toplay'} eq 'B');
+ if (defined($info->{'score_mate' . $mpv})) {
+ my $mate = $info->{'score_mate' . $mpv};
+ if ($invert) {
+ $mate = -$mate;
+ }
+ if ($mate > 0) {
+ return 500;
+ } else {
+ return -500;
+ }
+ } else {
+ if (exists($info->{'score_cp' . $mpv})) {
+ my $score = $info->{'score_cp' . $mpv};
+ if ($invert) {
+ $score = -$score;
+ }
+ $score = 500 if ($score > 500);
+ $score = -500 if ($score < -500);
+ return int($score);
+ }
+ }
+
+ return undef;
+}
+
my %book_cache = ();
sub book_info {
my ($fen, $board, $toplay) = @_;
}
my $id = id_for_pos($pos);
- if (exists($clock_target_for_pos{$id})) {
+ my $clock_info = $dbh->selectrow_hashref('SELECT * FROM clock_info WHERE id=?', undef, $id);
+ if (defined($clock_info)) {
+ $pos->{'white_clock'} //= $clock_info->{'white_clock'};
+ $pos->{'black_clock'} //= $clock_info->{'black_clock'};
if ($pos->{'toplay'} eq 'W') {
- $pos->{'white_clock_target'} = $clock_target_for_pos{$id};
+ $pos->{'white_clock_target'} = $clock_info->{'white_clock_target'};
} else {
- $pos->{'black_clock_target'} = $clock_target_for_pos{$id};
+ $pos->{'black_clock_target'} = $clock_info->{'black_clock_target'};
}
return;
}
return;
}
my $time_left = $pos->{$key};
- $clock_target_for_pos{$id} = time + $time_left;
+ my ($white_clock_target, $black_clock_target);
if ($pos->{'toplay'} eq 'W') {
- $pos->{'white_clock_target'} = $clock_target_for_pos{$id};
- delete $pos->{'black_clock_target'};
+ $white_clock_target = $pos->{'white_clock_target'} = time + $time_left;
} else {
- $pos->{'black_clock_target'} = $clock_target_for_pos{$id};
- delete $pos->{'white_clock_target'};
+ $black_clock_target = $pos->{'black_clock_target'} = time + $time_left;
}
+ local $dbh->{AutoCommit} = 0;
+ $dbh->do('DELETE FROM clock_info WHERE id=?', undef, $id);
+ $dbh->do('INSERT INTO clock_info (id, white_clock, black_clock, white_clock_target, black_clock_target)', undef,
+ $id, $pos->{'white_clock'}, $pos->{'black_clock'}, $white_clock_target, $black_clock_target);
+ $dbh->commit;
}
sub schedule_tb_lookup {