<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
In the mean time...<br>
<br>
The plugin I've been working on (<a
href="https://github.com/sblatnick/geany-plugins/tree/external-tools/external-tools/src">external-tool</a>)
<b>already allows you to run sql</b> <b>with a keyboard shortcut</b>.
You would just have to write a simple bash script and it can take
whatever is currently highlighted or the current document and output
the results to the bottom panel as text. Eventually, I'm planning
on adding a table to the potential output for the plugin. Using
this method would allow you to decide if you output to a buffer
(copy-able) or to a table, since there seems to be differences of
opinions on what would be correct behavior.<br>
<br>
At the very least, my plugin would be a good starting point for an
SQL-specific plugin.<br>
<br>
Here is my plugin "in action":<br>
<br>
<blockquote><img src="cid:part2.02010702.08010908@yahoo.com" alt=""></blockquote>
<br>
Here is the kind of script you could use:<br>
<blockquote><font face="Courier New, Courier, monospace">#!/bin/bash<br>
echo \"$GEANY_SELECTION\" > /tmp/temp.sql<br>
mysql -hdatabase -uroot -ppassword < /tmp/temp.sql >
/tmp/output.csv<br>
cat /tmp/output.csv<br>
</font></blockquote>
I hope this helps,<br>
<br>
Steve<br>
<br>
<div class="moz-cite-prefix">On 03/25/2014 05:33 PM, Matthew Brush
wrote:<br>
</div>
<blockquote cite="mid:53321231.90601@codebrainz.ca" type="cite">On
14-03-24 01:47 AM, Frank Lanitz wrote:
<br>
<blockquote type="cite">Hi folks,
<br>
<br>
A often wished feature at our boothes at e.g. Chemnitzer Linux
Tage were
<br>
to have some kind of a SQL plugin for Geany, supporting
executing
<br>
queries at the database.
<br>
As I'm also looking for something like this, I'm wondering what
do you
<br>
think such a plugin should be able to do in some global view. I
don't
<br>
think we will be able to build up another MySQLWorkbench or
PGAdmin --
<br>
and this is also not my goal for a Geany plugin -- but most
likley more
<br>
than an execution of queries might would be useful.
<br>
<br>
</blockquote>
<br>
This would be a good project for GeanyPy as it has all kinds of
modules to access various types of databases.
<br>
<br>
One idea for the UI would be to do like Devhelp plugin does to add
it's own help webview/notebook around Geany's, and then using
gtktreeview or some libgda stuff make a gridview type of thing
like is common in db/spreadsheet editors.
<br>
<br>
Cheers,
<br>
Matthew Brush
<br>
<br>
_______________________________________________
<br>
Devel mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Devel@lists.geany.org">Devel@lists.geany.org</a>
<br>
<a class="moz-txt-link-freetext" href="https://lists.geany.org/cgi-bin/mailman/listinfo/devel">https://lists.geany.org/cgi-bin/mailman/listinfo/devel</a>
<br>
</blockquote>
<br>
</body>
</html>