Searched refs:sth (Results 1 - 25 of 79) sorted by relevance

1234

/macosx-10.9.5/CPANInternal-140/DBIx-ContextualFetch/t/
H A D01.t27 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 D01.t27 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 DContextualFetch.pm18 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 DContextualFetch.pm18 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 DCursor.pm9 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 DDB2.pm12 my $sth = $dbh->prepare_cached('VALUES(IDENTITY_VAL_LOCAL())', {}, 3);
13 $sth->execute();
15 my @res = $sth->fetchrow_array();
H A DInformix.pm14 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 Dadd.c140 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 Dproto-sql.h187 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 Ddelete.c90 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 Dmodrdn.c37 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 Dentry-id.c121 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 Dsql-wrap.c36 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 DDBI.pm115 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 DDBI.pm115 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 DImaDBI.pm89 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 DMSSQL.pm41 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 DSybase.pm73 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 DDB2.pm49 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 DMSSQL.pm41 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 DSybase.pm73 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 DDB2.pm49 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 DDBI.pm214 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 DDB2_400_SQL.pm15 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 DSQLite.pm65 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...]

Completed in 221 milliseconds

1234