public function import(Sequence $sequence)
{
$id = $sequence->getNumericID();
$data = $sequence->getData();
$imported = $this->db->fetch('SELECT imported_at FROM sequence WHERE id = %i', [$id]);
$imported = $imported ?: date('Y-m-d H:i:s');
$this->db->delete('sequence', ['id' => $id]);
$this->db->insert('sequence', ['id' => $id, 'name' => $data['name'], 'eois_id' => isset($data['identification']['EOIS']) ? $data['identification']['EOIS'] : null, 'hois_id' => isset($data['identification']['HOIS']) ? $data['identification']['HOIS'] : null, 'offset_a' => isset($data['offset'][0]) ? $data['offset'][0] : 0, 'offset_b' => isset($data['offset'][1]) ? $data['offset'][1] : 0, 'imported_at' => $imported, 'updated_at' => date('Y-m-d H:i:s'), 'worker' => null]);
$this->db->insert('sequence_blob', ['sequence' => $id, 'name' => $data['name'], 'beginning' => implode(',', $data['beginning']), 'fulltext' => implode("\n", $sequence->getHTMLStrings())]);
foreach (array_keys($data['keywords']) as $keyword) {
$this->db->insert('sequence_keyword', ['sequence' => $id, 'keyword' => $keyword]);
}
foreach ($sequence->getUsers() as $slug => $name) {
$this->db->insert('person', ['id' => $slug, 'name' => $name]);
$this->db->insert('person_sequence', ['person' => $slug, 'sequence' => $id]);
}
foreach ($sequence->getSequences() as $mention) {
$this->db->insert('mention', ['sequence' => $id, 'mentions' => $mention]);
}
foreach ($sequence->getCrossrefSequences() as $ref) {
$this->db->insert('crossreference', ['from_sequence' => $id, 'to_sequence' => $ref]);
}
}
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
* the Free Software Foundation; either version 2 of the License, or *
* (at your option) any later version. *
* *
***************************************************************************/
include "prepend.inc.php";
$Server = getData("Server", "integer");
$User = getData("User");
$Sequencename = getData("Sequencename");
$html = "<H1> Database " . $DB->Name($Server) . " - Sequence " . $Sequencename . "</H1>";
if (isset($Sequencename)) {
$seq = new Sequence($Server);
$seq->setOwner($User);
$seq->setName($Sequencename);
$seq->getData();
$html .= "<table border=0><tr><th>Last Number</th><th>Min Value</th><th>Max Value</th><th>Increment by</th><th>Cycle</th><th>Order</th><th>Cache Size</th></tr>";
$html .= "<tr bgcolor=\"#DDDDDD\"><td>";
$html .= $seq->lastnumber;
$html .= "</td><td>";
$html .= $seq->minval;
$html .= "</td><td>";
$html .= $seq->maxval;
$html .= "</td><td>";
$html .= $seq->incrementval;
$html .= "</td><td>";
$html .= $seq->cycleflag;
$html .= "</td><td>";
$html .= $seq->orderflag;
$html .= "</td><td>";
$html .= $seq->cachesize;