';
$sqlcommandform = true;
/** @var $DBI helper_plugin_sqlite */
$DBI = plugin_load('helper', 'sqlite');
if($INPUT->str('version') == 'sqlite2') {
if(helper_plugin_sqlite_adapter::isSqlite3db($conf['metadir'].'/'.$INPUT->str('db').'.sqlite')) {
msg('This is a database in sqlite3 format.', 2);
msg(
'This plugin needs your database file has the extension ".sqlite3"
instead of ".sqlite" before it will be recognized as sqlite3 database.', 2
);
$form = new Doku_Form(array('method'=> 'post'));
$form->addHidden('page', 'sqlite');
$form->addHidden('sqlite_rename', 'go');
$form->addHidden('db', $INPUT->str('db'));
$form->addElement(form_makeButton('submit', 'admin', sprintf($this->getLang('rename2to3'), hsc($INPUT->str('db')))));
$form->printForm();
if($DBI->existsPDOSqlite()) $sqlcommandform = false;
} else {
msg(
'Before PDO sqlite can handle this format, it needs a conversion to the sqlite3 format.
Because PHP sqlite extension is no longer supported,
you should manually convert "'.hsc($INPUT->str('db')).'.sqlite" in the meta directory to "'.hsc($INPUT->str('db')).'.sqlite3".
See for info about the conversion '.$this->external_link('http://www.sqlite.org/version3.html').'.', -1
);
}
} else {
if(!$DBI->existsPDOSqlite()) {
$sqlcommandform = false;
msg('A database in sqlite3 format needs the PHP PDO sqlite plugin.', -1);
}
}
if($sqlcommandform) {
echo '
';
echo '' . $form->toHTML() . ' ';
echo ' ';
/** @var $helper helper_plugin_sqlite */
$sqlite_db = plugin_load('helper', 'sqlite');
$sqlite_db->init('sqlite', DOKU_PLUGIN . 'sqlite/db/');
if($INPUT->str('action') == 'save') {
$ok = true;
if(empty($INPUT->str('sql'))) {
msg($this->getLang('validation query_required'), -1);
$ok = false;
}
if(empty($INPUT->str('name'))) {
msg($this->getLang('validation query_name_required'), -1);
$ok = false;
}
if($ok) {
$sqlite_db->storeEntry('queries', array(
'db' => $INPUT->str('db'),
'name' => $INPUT->str('name'),
'sql' => $INPUT->str('sql')
));
msg($this->getLang('success query_saved'), 1);
}
} elseif($INPUT->str('action') == 'delete') {
$sqlite_db->query("DELETE FROM queries WHERE id=?;", $INPUT->int('query_id'));
msg($this->getLang('success query_deleted'), 1);
}
$form = new Doku_Form(array('class'=> 'sqliteplugin', 'action' => wl($ID, '', true, '&')));
$form->startFieldset('SQL Command');
$form->addHidden('id', $ID);
$form->addHidden('do', 'admin');
$form->addHidden('page', 'sqlite');
$form->addHidden('db', $INPUT->str('db'));
$form->addHidden('version', $INPUT->str('version'));
$form->addElement('
');
$form->addElement('
');
$form->addElement('
'.$this->getLang('query_name').': ');
$form->addElement('
'.$this->getLang('save_query').' ');
$form->endFieldset();
$form->printForm();
// List saved queries
$res = $sqlite_db->query("SELECT id, name, sql FROM queries WHERE db=?", $INPUT->str('db'));
$result = $sqlite_db->res2arr($res);
if(count($result) > 0) {
echo '
' . $this->getLang('saved_queries') . ' ';
echo '
';
echo '
';
echo '';
echo 'name ';
echo 'sql ';
echo ' ';
foreach($result as $row) {
echo '';
echo ''.hsc($row['name']).' ';
$link = wl($ID, array( 'do'=> 'admin',
'page'=> 'sqlite',
'db'=> $INPUT->str('db'),
'version'=> $INPUT->str('version'),
'sql' => $row['sql'],
'sectok'=> getSecurityToken()));
echo ''.hsc($row['sql']).' delete ';
}
echo '
';
echo '
';
}
if($INPUT->has('sql')) {
if(!$DBI->init($INPUT->str('db'), '')) return;
print '
Query results ';
$sql = $DBI->SQLstring2array($INPUT->str('sql'));
foreach($sql as $s) {
$s = preg_replace('!^\s*--.*$!m', '', $s);
$s = trim($s);
if(!$s) continue;
$time_start = microtime(true);
$res = $DBI->query("$s;");
if($res === false) continue;
$result = $DBI->res2arr($res);
$time_end = microtime(true);
$time = $time_end - $time_start;
$cnt = $DBI->res2count($res);
msg($cnt.' affected rows in '.($time < 0.0001 ? substr($time, 0, 5).substr($time, -3) : substr($time, 0, 7)).' seconds', 1);
if(!$cnt) continue;
echo '
';
$ths = array_keys($result[0]);
echo '
';
echo '';
foreach($ths as $th) {
echo ''.hsc($th).' ';
}
echo ' ';
foreach($result as $row) {
echo '';
$tds = array_values($row);
foreach($tds as $td) {
if($td === null) $td='␀';
echo ''.hsc($td).' ';
}
echo ' ';
}
echo '
';
echo '
';
}
}
}
echo '