/macosx-10.9.5/CPANInternal-140/DBIx-ContextualFetch/t/ |
H A D | 01.t | 27 my $sth = $dbh->prepare($sql); 28 return $sth; 32 (my $sth = make_sth("SELECT * FROM foo ORDER BY id"))->execute; 33 my @got1 = $sth->fetch; 35 my $got2 = $sth->fetch; 40 (my $sth = make_sth("SELECT * FROM foo ORDER BY id"))->execute; 41 my %got1 = $sth->fetch_hash; 43 my $got2 = $sth->fetch_hash; 45 my %got3 = eval { $sth->fetch_hash }; 51 (my $sth [all...] |
/macosx-10.9.5/CPANInternal-140/DBIx-ContextualFetch-1.03/t/ |
H A D | 01.t | 27 my $sth = $dbh->prepare($sql); 28 return $sth; 32 (my $sth = make_sth("SELECT * FROM foo ORDER BY id"))->execute; 33 my @got1 = $sth->fetch; 35 my $got2 = $sth->fetch; 40 (my $sth = make_sth("SELECT * FROM foo ORDER BY id"))->execute; 41 my %got1 = $sth->fetch_hash; 43 my $got2 = $sth->fetch_hash; 45 my %got3 = eval { $sth->fetch_hash }; 51 (my $sth [all...] |
/macosx-10.9.5/CPANInternal-140/DBIx-ContextualFetch/lib/DBIx/ |
H A D | ContextualFetch.pm | 18 my ($sth) = shift; 22 # Allow $sth->execute(\@param, \@cols) and 23 # $sth->execute(undef, \@cols) syntax. 28 $rv = $sth->_untaint_execute(@$bind_params); 29 $sth->SUPER::bind_columns(@$bind_cols); 31 $sth->_disallow_references(@_); 32 $rv = $sth->_untaint_execute(@_); 47 # local $sth->{Taint} leaks in old perls :( 49 my $sth = shift; 50 my $old_value = $sth [all...] |
/macosx-10.9.5/CPANInternal-140/DBIx-ContextualFetch-1.03/lib/DBIx/ |
H A D | ContextualFetch.pm | 18 my ($sth) = shift; 22 # Allow $sth->execute(\@param, \@cols) and 23 # $sth->execute(undef, \@cols) syntax. 28 $rv = $sth->_untaint_execute(@$bind_params); 29 $sth->SUPER::bind_columns(@$bind_cols); 31 $sth->_disallow_references(@_); 32 $rv = $sth->_untaint_execute(@_); 47 # local $sth->{Taint} leaks in old perls :( 49 my $sth = shift; 50 my $old_value = $sth [all...] |
/macosx-10.9.5/CPANInternal-140/DBIx-Class/lib/DBIx/Class/Storage/DBI/ |
H A D | Cursor.pm | 9 qw/sth/ 80 $self->sth->finish if $self->sth->{Active}; 81 $self->sth(undef); 85 unless ($self->sth) { 86 $self->sth(($storage->_select(@{$self->{args}}))[1]); 89 $self->sth->fetch for 1 .. $offset; 93 my @row = $self->sth->fetchrow_array; 97 $self->sth(undef); 127 $self->sth [all...] |
H A D | DB2.pm | 12 my $sth = $dbh->prepare_cached('VALUES(IDENTITY_VAL_LOCAL())', {}, 3); 13 $sth->execute(); 15 my @res = $sth->fetchrow_array();
|
H A D | Informix.pm | 14 my ($rv, $sth, @rest) = $self->next::method(@_); 16 $self->__last_insert_id($sth->{ix_sqlerrd}[1]); 18 return (wantarray ? ($rv, $sth, @rest) : $rv);
|
/macosx-10.9.5/OpenLDAP-491.1/OpenLDAP/servers/slapd/back-sql/ |
H A D | add.c | 140 SQLHSTMT sth = SQL_NULL_HSTMT; local 143 rc = backsql_Prepare( dbh, &sth, at->bam_delete_proc, 0 ); 152 sth, rc ); 161 rc = backsql_BindParamInt( sth, 1, 169 sth, rc ); 170 SQLFreeStmt( sth, SQL_DROP ); 178 rc = backsql_BindParamID( sth, pno + 1 + po, 186 sth, rc ); 187 SQLFreeStmt( sth, SQL_DROP ); 205 rc = backsql_BindParamStr( sth, pn 422 SQLHSTMT sth = SQL_NULL_HSTMT; local 581 SQLHSTMT sth = SQL_NULL_HSTMT; local 737 SQLHSTMT sth = SQL_NULL_HSTMT; local 908 SQLHSTMT sth = SQL_NULL_HSTMT; local [all...] |
H A D | proto-sql.h | 187 RETCODE backsql_Prepare( SQLHDBC dbh, SQLHSTMT *sth, const char* query, int timeout ); 189 #define backsql_BindParamStr( sth, par_ind, io, str, maxlen ) \ 190 SQLBindParameter( (sth), (SQLUSMALLINT)(par_ind), \ 195 #define backsql_BindParamBerVal( sth, par_ind, io, bv ) \ 196 SQLBindParameter( (sth), (SQLUSMALLINT)(par_ind), \ 202 #define backsql_BindParamInt( sth, par_ind, io, val ) \ 203 SQLBindParameter( (sth), (SQLUSMALLINT)(par_ind), \ 207 #define backsql_BindParamNumID( sth, par_ind, io, val ) \ 208 SQLBindParameter( (sth), (SQLUSMALLINT)(par_ind), \ 213 #define backsql_BindParamID( sth, par_in [all...] |
H A D | delete.c | 90 SQLHSTMT sth = SQL_NULL_HSTMT; local 96 sth = *sthp; 104 rc = backsql_Prepare( dbh, &sth, eid->eid_oc->bom_delete_proc, 0 ); 110 backsql_PrintErrors( bi->sql_db_env, dbh, sth, rc ); 120 rc = backsql_BindParamInt( sth, 1, SQL_PARAM_OUTPUT, &prc ); 127 sth, rc ); 128 SQLFreeStmt( sth, SQL_DROP ); 137 rc = backsql_BindParamID( sth, pno + 1, SQL_PARAM_INPUT, &eid->eid_keyval ); 144 sth, rc ); 145 SQLFreeStmt( sth, SQL_DRO 406 SQLHSTMT sth = SQL_NULL_HSTMT; local [all...] |
H A D | modrdn.c | 37 SQLHSTMT sth = SQL_NULL_HSTMT; local 279 SQLFreeStmt( sth, SQL_DROP ); 290 rc = backsql_Prepare( dbh, &sth, bi->sql_renentry_stmt, 0 ); 296 sth, rc ); 304 rc = backsql_BindParamBerVal( sth, 1, SQL_PARAM_INPUT, &realnew_dn ); 311 sth, rc ); 312 SQLFreeStmt( sth, SQL_DROP ); 320 rc = backsql_BindParamID( sth, 2, SQL_PARAM_INPUT, &n_id.eid_id ); 327 sth, rc ); 328 SQLFreeStmt( sth, SQL_DRO [all...] |
H A D | entry-id.c | 121 SQLHSTMT sth = SQL_NULL_HSTMT; local 188 rc = backsql_Prepare( dbh, &sth, bi->sql_id_query, 0 ); 194 backsql_PrintErrors( bi->sql_db_env, dbh, sth, rc ); 243 rc = backsql_BindParamBerVal( sth, 1, SQL_PARAM_INPUT, &tbbDN ); 249 backsql_PrintErrors( bi->sql_db_env, dbh, sth, rc ); 254 rc = SQLExecute( sth ); 259 backsql_PrintErrors( bi->sql_db_env, dbh, sth, rc ); 264 backsql_BindRowAsStrings_x( sth, &row, op->o_tmpmemctx ); 265 rc = SQLFetch( sth ); 373 if ( sth ! 392 SQLHSTMT sth = SQL_NULL_HSTMT; local 512 SQLHSTMT sth = SQL_NULL_HSTMT; local [all...] |
H A D | sql-wrap.c | 36 backsql_PrintErrors( SQLHENV henv, SQLHDBC hdbc, SQLHSTMT sth, int rc ) argument 45 for ( ; rc = SQLError( henv, hdbc, sth, state, &iSqlCode, msg, 55 backsql_Prepare( SQLHDBC dbh, SQLHSTMT *sth, const char *query, int timeout ) argument 59 rc = SQLAllocStmt( dbh, sth ); 91 rc = SQLSetStmtOption( *sth, SQL_CONCURRENCY, 98 backsql_PrintErrors( SQL_NULL_HENV, dbh, *sth, rc ); 99 SQLFreeStmt( *sth, SQL_DROP ); 110 rc = SQLSetStmtOption( *sth, SQL_QUERY_TIMEOUT, timeout ); 112 backsql_PrintErrors( SQL_NULL_HENV, dbh, *sth, rc ); 113 SQLFreeStmt( *sth, SQL_DRO 127 backsql_BindRowAsStrings_x( SQLHSTMT sth, BACKSQL_ROW_NTS *row, void *ctx ) argument 280 backsql_BindRowAsStrings( SQLHSTMT sth, BACKSQL_ROW_NTS *row ) argument [all...] |
/macosx-10.9.5/CPANInternal-140/DBIx-Class-Schema-Loader/lib/DBIx/Class/Schema/Loader/ |
H A D | DBI.pm | 115 my $sth = $self->_sth_for($table, undef, \'1 = 0'); 116 $sth->execute; 169 my $sth = $dbh->prepare($self->schema->storage->sql_maker 172 return $sth; 179 my $sth = $self->_sth_for($table, undef, \'1 = 0'); 180 $sth->execute; 181 my $retval = \@{$sth->{NAME_lc}}; 182 $sth->finish; 210 my $sth = $dbh->statistics_info(undef, $self->db_schema, $table, 1, 1); 211 while(my $row = $sth [all...] |
/macosx-10.9.5/CPANInternal-140/DBIx-Class-Schema-Loader-0.05003/lib/DBIx/Class/Schema/Loader/ |
H A D | DBI.pm | 115 my $sth = $self->_sth_for($table, undef, \'1 = 0'); 116 $sth->execute; 169 my $sth = $dbh->prepare($self->schema->storage->sql_maker 172 return $sth; 179 my $sth = $self->_sth_for($table, undef, \'1 = 0'); 180 $sth->execute; 181 my $retval = \@{$sth->{NAME_lc}}; 182 $sth->finish; 210 my $sth = $dbh->statistics_info(undef, $self->db_schema, $table, 1, 1); 211 while(my $row = $sth [all...] |
/macosx-10.9.5/CPANInternal-140/DBIx-Class/lib/DBIx/Class/CDBICompat/ |
H A D | ImaDBI.pm | 89 return $class->storage->sth($class->transform_sql($sql, @_)); 97 my $sth = $class->$sql_name; 98 return $class->sth_to_objects($sth, \@args); 104 my ($class, $sth, $execute_args) = @_; 106 $sth->execute(@$execute_args); 109 while (my $row = $sth->fetchrow_hashref) { 132 my $sth = shift; 133 my $old_value = $sth->{Taint}; 134 $sth->{Taint} = 0; 138 $ret = $sth [all...] |
/macosx-10.9.5/CPANInternal-140/DBIx-Class-Schema-Loader/lib/DBIx/Class/Schema/Loader/DBI/ |
H A D | MSSQL.pm | 41 my $sth = $dbh->prepare(qq{sp_pkeys '$table'}); 42 $sth->execute; 46 while (my $row = $sth->fetchrow_hashref) { 58 my $sth = $dbh->prepare(qq{sp_fkeys \@FKTABLE_NAME = '$table'}); 59 $sth->execute; 61 while (my $row = $sth->fetchrow_hashref) { 83 my $sth = $dbh->prepare(qq{SELECT CCU.CONSTRAINT_NAME, CCU.COLUMN_NAME FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CCU 87 $sth->execute; 89 while (my $row = $sth->fetchrow_hashref) { 106 my $sth [all...] |
H A D | Sybase.pm | 73 my $sth = $dbh->prepare(qq{sp_pkeys @{[ $dbh->quote($table) ]}}); 74 $sth->execute; 78 while (my $row = $sth->fetchrow_hashref) { 94 my $sth = $dbh->prepare(qq{sp_fkeys \@fktable_name = @{[ $dbh->quote($table) ]}}); 95 $sth->execute; 96 my $row = $sth->fetchrow_hashref; 101 $sth->finish; 105 $sth->finish; 117 my $sth = $dbh->prepare(qq{sp_fkeys \@fktable_name = @{[ $dbh->quote($table) ]}}); 118 $sth [all...] |
H A D | DB2.pm | 49 my $sth = $self->{_cache}->{db2_uniq} ||= $dbh->prepare( 56 $sth->execute($self->db_schema, uc $table) or die $DBI::errstr; 59 while(my $row = $sth->fetchrow_arrayref) { 69 $sth->finish; 117 my $sth = $dbh->prepare_cached( 125 $sth->execute($self->db_schema, $table, $column); 126 if ($sth->fetchrow_array) {
|
/macosx-10.9.5/CPANInternal-140/DBIx-Class-Schema-Loader-0.05003/lib/DBIx/Class/Schema/Loader/DBI/ |
H A D | MSSQL.pm | 41 my $sth = $dbh->prepare(qq{sp_pkeys '$table'}); 42 $sth->execute; 46 while (my $row = $sth->fetchrow_hashref) { 58 my $sth = $dbh->prepare(qq{sp_fkeys \@FKTABLE_NAME = '$table'}); 59 $sth->execute; 61 while (my $row = $sth->fetchrow_hashref) { 83 my $sth = $dbh->prepare(qq{SELECT CCU.CONSTRAINT_NAME, CCU.COLUMN_NAME FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CCU 87 $sth->execute; 89 while (my $row = $sth->fetchrow_hashref) { 106 my $sth [all...] |
H A D | Sybase.pm | 73 my $sth = $dbh->prepare(qq{sp_pkeys @{[ $dbh->quote($table) ]}}); 74 $sth->execute; 78 while (my $row = $sth->fetchrow_hashref) { 94 my $sth = $dbh->prepare(qq{sp_fkeys \@fktable_name = @{[ $dbh->quote($table) ]}}); 95 $sth->execute; 96 my $row = $sth->fetchrow_hashref; 101 $sth->finish; 105 $sth->finish; 117 my $sth = $dbh->prepare(qq{sp_fkeys \@fktable_name = @{[ $dbh->quote($table) ]}}); 118 $sth [all...] |
H A D | DB2.pm | 49 my $sth = $self->{_cache}->{db2_uniq} ||= $dbh->prepare( 56 $sth->execute($self->db_schema, uc $table) or die $DBI::errstr; 59 while(my $row = $sth->fetchrow_arrayref) { 69 $sth->finish; 117 my $sth = $dbh->prepare_cached( 125 $sth->execute($self->db_schema, $table, $column); 126 if ($sth->fetchrow_array) {
|
/macosx-10.9.5/CPANInternal-140/DBIx-Class-Schema-Loader-0.07033/lib/DBIx/Class/Schema/Loader/ |
H A D | DBI.pm | 214 my $sth = $self->_sth_for($table, undef, \'1 = 0'); 215 $sth->execute; 249 my $sth = $self->dbh->prepare($self->schema->storage->sql_maker 252 return $sth; 259 my $sth = $self->_sth_for($table, undef, \'1 = 0'); 260 $sth->execute; 262 my $retval = [ map $self->_lc($_), @{$sth->{NAME}} ]; 264 $sth->finish; 305 my $sth = $self->dbh->statistics_info(undef, $table->schema, $table->name, 1, 1); 306 while(my $row = $sth [all...] |
/macosx-10.9.5/CPANInternal-140/DBIx-Class/lib/DBIx/Class/Storage/DBI/ODBC/ |
H A D | DB2_400_SQL.pm | 15 my $sth = $dbh->prepare_cached( 17 $sth->execute(); 19 my @res = $sth->fetchrow_array();
|
/macosx-10.9.5/CPANInternal-140/DBIx-Class-Schema-Loader-0.07033/lib/DBIx/Class/Schema/Loader/DBI/ |
H A D | SQLite.pm | 65 my $sth = $self->dbh->prepare( 68 $sth->execute; 69 my $cols = $sth->fetchall_hashref('name'); 107 my $sth = $self->dbh->prepare( 110 $sth->execute; 113 while (my $fk = $sth->fetchrow_hashref) { 139 $sth->finish; 203 my $sth = $self->dbh->prepare( 206 $sth->execute; 209 while (my $idx = $sth [all...] |