Projects tagged ‘storedprocedure’

PowerShell scripts that focus on generating PowerShell code.

This program intend to be a way to consume webservice created automatically from stored procedures write in any supported language from postgresql. Createad in c this project produce a fast web server ... [More] to do this and create a structure in database to administrate the details of acl. [Less]

JProcedure is a generic engine written completely in Java (1.5) for invoking stored procedures on variety of database platforms (Oracle, PostreSQL, MySQL, etc). It uses java annotations to describe ... [More] information necessary for a proper stored procedure call and lets you define whether the results should be cached or not. It also allows you to inject custom written interceptors to add specific logic to procedure invocation (you may find interceptors useful for logging or performance measuring purposes) [Less]

What is PgP Generator? PgP Generator (or Pg Square) is a utility written in PgSQL that generates stored procedures around tables. The stored procedures perform the following basic operations: ... [More] Insert into a given table Update a given table knowing the primary key Retrieving data: all records and by the table's primary key Why use PgP Generator? Written in PgSQL it will run anywhere PostgreSQL runs (Linux; Solaris and Windows) Eliminates time spent writting basic CRUD operations Increase productivity and focus on implementing business logic & security for the database Compared to other products this script is light-weight and free Available online Generator allows customized a script file appropriate for your system (setting owner, target schema, updates comments for your system). The current version is optimized and has been tested with PostgreSQL 7.x and 8.3 and is working well. Where is the source code ? The project is hosted here on google PgP-Generator is developed under GPL v3 and comes with NO WARRANTY or implied warranty. Feel free to change; and distribute at will (giving proper credit). Coming Soon Retrieve operations with foreign key support Code optimization Adding a package for logging `Enjoy. [Less]

jdbc-proc provides mappings from POJOs to stored procedures arguments. Main features: uses mapping specification of JPA with annotations: Entity, Column, OneToOne, ManyToOne, OneToMany ... [More] , JoinColumn creates stored procedures mapping code on the fly integrated with spring framework For step-by-step instructions, see Getting Started guide [Less]

This Perl module allow your program to process text files containing one or many commands that execute SQL statements sequentially following the procedure you define. Please keep in mind that ... [More] DBIx::Simple::Procedure is an alternative to database stored procedures and not a replacement or emulation of them. Essentially it is an interface to execute and return data from multiple queries. Here is an example of how to setup and process a (sql) text file. EXAMPLE: use DBIx::Simple::Procedure; my $db = DBIx::Simple::Procedure->new($path_to_sqlfiles, 'dbi:SQLite:dbname=file.dat'); $db->queue($sql_file)->process_queue(@sql_parameters); foreach my $result (@{$db->cache(0)}){ $result->{...}; } [Less]

The project is a teaching resource. Including: php(pear) mysql python web security javascript(jquery) css

External Language Stored Procedures for MySQL is a patch for MySQL to provide support for stored procedures written in an external languages. Stored procedures are declared in SQL using SQL standards ... [More] compliant syntax. Additional stored procedure languages are implemented as plug-ins to be installed at run time into the server. Currently, plugins for Java and Perl are implemented, as well as support for declaring XML-RPC requests as stored procedures. [Less]

A Sybase ASE 12.x SQL Parser & Object ModelAboutA Java 1.5 library for parsing Sybase ASE 12.x T-SQL queries and stored procedures into an object model. FeaturesFree & open source (available under ... [More] the LGPL licence) Parses a 'popular subset' of Sybase ASE 12.x T-SQL syntax Provides an extensive Java object model to inspect, analyse and manipluate Sybase syntax Object model is intuitive and easy to use (hand crafted, not auto generated from BNF) Provides a text renderer and an XML renderer (not yet available) Supports stored procedures as well as standalone SQL queries Pure Java (1.5) library (available as a jar) with no dependancies on external libraries Small library (~200KB), 97 classes, ~11,000 TLOC StatusThis project is currently in alpha status, meaning it is not yet feature complete and is not yet stable enough for use in a production environment. The parser and model are both fairly complete and should be able to cope with most queries and stored procedures. It has been validated against a set of over 1000 real stored procedures. VersionThe latest version available is 0.5.1.121 (alpha) which can be downloaded from this site. JavadocThe javadoc for the current release can be found at http://www.fairbait.com/sybaseparser_0.5.0.115_alpha/javadoc/ [Less]