JavaScript IDE & Open APIsAqua Data Studio offers a full-fledged Integrated Development Environment (IDE) with a set of programming interfaces called Aqua Open APIs that access built-in functionalities such as database access, schema DDL generation, grid and pivot charts, compare tools, version control and much more. Developers can invoke Aqua Open APIs via AquaScript — a simple JavaScript based programming language supported both in Aqua Data Studio and Aqua Data Server. The IDE also provides tools for executing and debugging AquaScripts and deploying the scripts to Aqua Data Server. AquaScripts have full access to the Java APIs and any proprietary Java libraries that you include in the Aqua Data Studio classpath. |
|
Aqua Data Studio scripting IDE includes the following functions:
Create AquaProjects to organize tasks
The Aqua Data Studio Tree Panel contains the Project Browser. Within the Projects Browser, right click and select New Project to create an AquaProject. Every project has an AquaScripts directory, a Servers directory and a User Files directory. You can register a database server and create, debug and execute a set of AquaScripts that work on it. AquaProjects allow you to organize your software development tasks into self contained programming units. Once a project is completed you can export, share with your team or deploy it to Aqua Data Server. Create AquaScripts to automate tasks
Use Open APIs to write AquaScripts and build fully automated end-to-end solutions based on your business requirements. To create a new AquaScript select the AquaScripts folder from your AquaProject and use the Insert key to create a new AquaScript. AquaScripts are identified by their .xjs file extension. All of the Open APIs are available through the global variable named "aqua", which is an instance of the "AQAqua" class. AquaScripts may also access any other proprietary or Open Source Java libraries included in the Java Virtual Machine (JVM) classpath. AquaScripts are executed within Aqua Data Studio using the Mozilla Rhino1 engine. AquaScript Editor
The fully functional editor for AquaScripts provides autocompletion, syntax coloring, bookmarks, abbreviations, find/replace, incremental search and more. Execute AquaScripts
Execute AquaScripts with Ctrl+E. Invoke the debugger using Ctrl+Alt+Enter. The debugger allows you to step through, pause and set breakpoints in the code. The debugger highlights the breakpoints and indicates which breakpoint paused the execution. This makes it easy to evaluate variables and conditional flow of code. Debug in Browser
The AquaScript Editor debugs an AquaScript in a browser with Aqua Data Studio's embedded web server. Form input and page interaction within this browser can dynamically interact with your AquaScripts. Deploy AquaProject to Aqua Data Server
You can deploy AquaProjects to Aqua Data Server, our specialized application server. Aqua Data Server is a software framework that implements the JavaScript2 engine and the Aqua Open API library for ETL, Reporting and Data Analysis. This functionality is possible because AquaScripts allow database access and schema DDL generation3. To deploy a project, right click on the AquaProject and select the option Deploy. The deploy URL can be obtained by logging in to Aqua Data Server, browsing into the project that you want to deploy to and then navigating to Settings-> Import Project Package. Export AquaProject
AquaProjects can be exported to disk as zip files. They may then be imported into Aqua Data Server using the web interface. Version Control Integration
Aqua Data Studio provides integration of AquaProjects with several Version Control Systems like CVS, Subversion (SVN), Git and Perforce. AquaScripts associated with a version control repository can be edited and saved in the AquaScripts Editor. |
Context-sensitive Help
The editor provides context-sensitive
help as you write your scripts. Simply press Shift-F1 and the API documentation
of the object you are currently working on (or have selected) will open in your
web browser. List of Aqua Data Studio/Server Open APIs:
|
