Free select software for linux

Kbtsco is a Kommander script that help connection with bluetooth headset (tested with Sony Ericsson HBH-600) to use with XMMS, Audacity or Skype.

The features of this gui included the starting daemon sdpd, hcid and rfcomm and scan MAC address to use with BTSCO in order to select headphone as device

Text::Yats is Yet Another Template System.

SYNOPSIS

use Text::Yats;

my $template = < < ENDHTML;
< html >
< head >
< title >$title - $version< /title >
< /head >
< body >
< form >
< select name="names" >< !--{1}-- >
< option $selected >$list< /option >
< !--{2}-- >< /select >
< /form >
< /body >
< /html >
ENDHTML

my $result = "";
my $tpl = Text::Yats- >new(
level = > 1,
text = > $template);

$result .= $tpl- >section- >[0]- >replace(
title = > "Yats",
version = > "Development", );

$result .= $tpl- >section- >[1]- >replace(
list = > [hdias,anita,cubitos],
selected = > { value = > "selected",
array = > "list",
match = > "anita", } );

$result .= $tpl- >section- >[2]- >text;
print $result;

SQLizer is a Java utility library intended for generating sql from the search input.

Synopsis:

import stanford.netdb.utils.*;

String sql_1 = Feild2SQL.parseField(type,table, column, input_str, field_display_name, post_filter);

String sql_2 = Feild2SQL.parseStringField(table, column, input_str, field_display_name);

String sql_3 = Feild2SQL.parseIntField(table, column, line, field_display_name);

Given an input string it builds SQL select statement. It supports two types of inputs, numeric and string. The catch is that this library allows usage of operators in the input string. Supported operators are and, or and not. It also supports wildcards *, %, ? and _ in string searches. In case of numeric searches no wildcards are supported.

To accommodate searches by strings, which have wildcards in them, backslashes can be used to escape appropriate characters. Obviously to search for it needs to be escaped as well. Strings with spaces needs to be enclosed in double quotes. The other possibility is to do a regex search, which is accomplished by enclosing string in forward slashes. The resulting SQL is targeted toward Oracle regex expressions. For example, following input strings will be appropriately evaluated.

a or b
-> ( ( select id from Record where name = a ) UNION ( select id from Record where name = b ) )

not a and not b
-> ( ( select id from Record MINUS ( select id from Record where name = a ) ) INTERSECT ( select id from Record MINUS ( select id from Record where name = b ) ) )

"a b c" or a\*
-> ( ( select id from Record where name = a b c ) UNION ( select id from Record where name LIKE a\% ESCAPE ) )

/^.*[[:digit:]]$/
-> ( select id from Record where REGEXP_LIKE(name, ^.*[[:digit:]]$, i) )

We use unions and intersects in order to accomodate searches for objects with multi-value attributes.

Database Functions is a PHP class that can be used to build and execute MySQL database queries.

It can build SELECT, INSERT, UPDATE and DELETE queries from lists of parameters and values.

The class can also execute the generated queries and retrieve the SELECT query results into associative arrays.

SQLayer is a Perl interface to DB.

new(database => DBI:mysql:database=phorum;host=localhost;port=3306, user => user, passowrd => somepass);

my $PAllRowsArrayRef = $D -> all_rows("SELECT a, b FROM dum"); # pointer to array

my @AOneColumnArray = $D -> column("SELECT a FROM dum"); # array

$D -> commit; # is equal to $D -> proc("COMMIT");

my $NConnectStatus = $D -> connect_status; # returns 1 if connected

$D -> DEBUG(1); # warn query only
$D -> DEBUG($n); # set trace level to $n-1

$D -> enable_transactions; # enable transactions if possible
$D -> errstr; # returns error code

my %HHashNameById = $D -> hash_all("SELECT id, name FROM dum"); #

my $PHashOneByFieldsNameRef = $D -> hash_row("SELECT a, b, c FROM dum WHERE id = 1"); # pointer to hash

my %HHashOneByFieldsName = $D -> hash_var("SELECT a, b, c FROM dum WHERE id = 1"); # hash

$D -> nodebug; # No warn query and clear tracing

$NAffectedRowsNum = $D -> proc("DELETE FROM dum WHERE a = b"); # affected rows

my @AOneRowArray = $D -> row("SELECT a, b, c FROM dum WHERE id = 1"); # array
my $NVvalue = $D -> row("SELECT a FROM dum WHERE id = 1 "); # one value

my $PRowOfHashRef = $D -> row_hash("SELECT a, b, c FROM dum"); # pointer to array of hashes

$SQuoted = $D -> quote($SSomeVar); # same as DBI method