06-20-2013
Create a simple web portal/GUI to execute scripts?
Very new to this.....
What I would like to do:
Create a simple GUI/Web portal with 3 buttons and 1 text field
The three buttons need to take the input into the text field and use that as the variable to execute scripts located on a server
Problem:
How can i get the buttons on the page to ssh to the server and kick off the scripts?
I can create the scripts easily enough as they are comprised of simple SQL update statements, but I'm at a loss as to how they would communicate with the portal/gui page (what programming language etc should I be looking into to achieve this?)
Any pointers would help, just really looking for a direction ie this can be achieved by using ______.
Goal:
Instead of having to run these update stmnts from the command line or in workbench etc, the main goal is to have a page I can leave open in the browser at all times and just plug a variable into the text field and select the correct button for what i want it to update.
flow im thinking of click button > ssh to correct server > kick off shell script with the update SQL using the variable provided
Is this possible/efficient? Or is there an easier way?
---------- Post updated at 11:16 PM ---------- Previous update was at 10:42 PM ----------
should have started searching old topics in the forum before posting, pretty confident ill be able to find something after checking a few of these topics
but if any has any feedback please feel free to post
10 More Discussions You Might Find Interesting
1. Linux
dear experts,
i m newbies of linux. i found that my linux server does not support the webportal links, causing the filing system in the webportal dissapear as well. i suspect 1st: configuration of linux not set properly, 2nd: access link lost for the filing system.
please give me a rough idea... (1 Reply)
Discussion started by: clemeot
1 Replies
2. Shell Programming and Scripting
I want to create a GUI which runs shell scripts in the background. What should I use for creating that GUI. I would be nice if you could point me to some resources where I can learn to create a GUI (2 Replies)
Discussion started by: lassimanji
2 Replies
3. Shell Programming and Scripting
Hello everyone!
I'm looking for a way to build a GUI for various bash scripts I've written.
Is there any "good" way to do it?
I've heard about python/gtk+,qt and other stuff, but I've absolutely no idea where I should look at.
Thanks a lot in advance!
Regards,
xenator
EDIT:
... (1 Reply)
Discussion started by: xenator
1 Replies
4. Shell Programming and Scripting
Hi all! Im wondering if its possible to create a GUI for a shell script I just got done writing as the people that will be using it dont like the command line all to well. Just something simple with radio buttons to select options, maybe a text field to enter a location to save the file generated... (1 Reply)
Discussion started by: Grizzly
1 Replies
5. Solaris
I am using Solaris 10, and would like a web gui for mail or can replace the mail server if needed, it doesnt need to be anything elaborate, just something where i can view mail via a web browser rather than command line and hitting 'd' a 1000 times to delete all my cron job mails etc :p
I've... (8 Replies)
Discussion started by: ippy98
8 Replies
6. Shell Programming and Scripting
Hi,
I want to know whether it is possible to use GUI for cshell scripts?
Thanks
Sarbjit (0 Replies)
Discussion started by: sarbjit
0 Replies
7. Shell Programming and Scripting
what GUI can be used with shell scripting
for example if i want to say hello in prompted window
thnx in advance (3 Replies)
Discussion started by: semosam
3 Replies
8. Fedora
hi all,
this is my first post here...i hope that this is the correct section to write my question.
I have a distro linux without gui, only text mode.
So, it's possible run automatically a command or a program as "top" or "ping" and get the result on the main shell , after the boot and after... (6 Replies)
Discussion started by: gangiaemi
6 Replies
9. Shell Programming and Scripting
Hello Experts,
In my current job I need to upgrade a web GUI to execute Unix commands in a server....I am completely new to programming--So can anyone here help me out with initial steps...
Please notice that statement completely new to programming means-I never did it, SO I might keep on coming... (1 Reply)
Discussion started by: mhadi
1 Replies
10. Shell Programming and Scripting
Hello all!
This is my first post and I'm very new to programming. I would like help creating a simple perl or bash script that I will be using in my work as a junior bioinformatician.
Essentially, I would like to take a tab-delimted or .csv text with 3 columns and write them to a "3D" matrix:
... (16 Replies)
Discussion started by: torchij
16 Replies
LEARN ABOUT CENTOS
spi_cursor_open_with_args
SPI_CURSOR_OPEN_WITH_ARGS(3) PostgreSQL 9.2.7 Documentation SPI_CURSOR_OPEN_WITH_ARGS(3)
NAME
SPI_cursor_open_with_args - set up a cursor using a query and parameters
SYNOPSIS
Portal SPI_cursor_open_with_args(const char *name,
const char *command,
int nargs, Oid *argtypes,
Datum *values, const char *nulls,
bool read_only, int cursorOptions)
DESCRIPTION
SPI_cursor_open_with_args sets up a cursor (internally, a portal) that will execute the specified query. Most of the parameters have the
same meanings as the corresponding parameters to SPI_prepare_cursor and SPI_cursor_open.
For one-time query execution, this function should be preferred over SPI_prepare_cursor followed by SPI_cursor_open. If the same command is
to be executed with many different parameters, either method might be faster, depending on the cost of re-planning versus the benefit of
custom plans.
The passed-in parameter data will be copied into the cursor's portal, so it can be freed while the cursor still exists.
ARGUMENTS
const char * name
name for portal, or NULL to let the system select a name
const char * command
command string
int nargs
number of input parameters ($1, $2, etc.)
Oid * argtypes
an array containing the OIDs of the data types of the parameters
Datum * values
an array of actual parameter values
const char * nulls
an array describing which parameters are null
If nulls is NULL then SPI_cursor_open_with_args assumes that no parameters are null.
bool read_only
true for read-only execution
int cursorOptions
integer bit mask of cursor options; zero produces default behavior
RETURN VALUE
Pointer to portal containing the cursor. Note there is no error return convention; any error will be reported via elog.
PostgreSQL 9.2.7 2014-02-17 SPI_CURSOR_OPEN_WITH_ARGS(3)