Home
last modified time | relevance | path

Searched refs:simple_query (Results 1 – 25 of 123) sorted by relevance

12345

/dports/databases/p5-Jifty-DBI/Jifty-DBI-0.78/t/
H A D03rename_column.t30 my $sth = $handle->simple_query(
35 ok $handle->simple_query("insert into test values(2,2)"), "inserted a record";
36 $sth = $handle->simple_query("select * from test");
40 $sth = $handle->simple_query("select * from test");
48 $handle->simple_query("insert into test(x) values(1)");
54 $handle->simple_query("insert into test(y) values(NULL)");
58 $handle->simple_query("delete from test");
59 ok $handle->simple_query("insert into test(a) values(1)"), "DEFAULT is still there";
60 is $handle->simple_query("select * from test")->fetchrow_hashref->{'y'},
H A D03rename_table.t32 $sth = $handle->simple_query("CREATE TABLE test (a int)");
35 ok $handle->simple_query("insert into test values(1)"), "inserted a record";
36 is $handle->simple_query("select * from test")->fetchrow_hashref->{'a'},
41 is $handle->simple_query("select * from test1")->fetchrow_hashref->{'a'},
47 $handle->simple_query("select * from test")
/dports/www/gitlab-workhorse/gitlab-foss-0a901d60f8ae4a60c04ae82e6e9c3a03e9321417/spec/support/prometheus/
H A Dmetric_builders.rb5 def simple_query(suffix = 'a', **opts) method
10 [simple_query, simple_query('b', label: 'label', unit: 'unit')]
13 def simple_metric(title: 'title', required_metrics: [], queries: [simple_query]) argument
20 simple_metric(required_metrics: [added_metric_name], queries: [simple_query('empty')]),
/dports/databases/p5-Jifty-DBI/Jifty-DBI-0.78/lib/Jifty/DBI/Handle/
H A DSQLite.pm149 my $indice_sth = $self->simple_query(
162 $self->simple_query($new_schema);
163 $self->simple_query("INSERT INTO $new_table SELECT $copy_columns FROM $table");
164 $self->simple_query("DROP TABLE $table");
165 $self->simple_query("ALTER TABLE $new_table RENAME TO $table");
166 $self->simple_query($_) for @indice_sql;
/dports/www/Stikked/Stikked-0.13.0/htdocs/system/database/drivers/mysql/
H A Dmysql_driver.php154 $this->simple_query('SET SESSION sql_mode = CONCAT(@@sql_mode, ",", "STRICT_ALL_TABLES")');
158 $this->simple_query(
297 $this->simple_query('SET AUTOCOMMIT=0');
298 return $this->simple_query('START TRANSACTION'); // can also be BEGIN or BEGIN WORK
310 if ($this->simple_query('COMMIT'))
312 $this->simple_query('SET AUTOCOMMIT=1');
328 if ($this->simple_query('ROLLBACK'))
330 $this->simple_query('SET AUTOCOMMIT=1');
/dports/www/codeigniter/CodeIgniter-3.1.11/system/database/drivers/mysql/
H A Dmysql_driver.php154 $this->simple_query('SET SESSION sql_mode = CONCAT(@@sql_mode, ",", "STRICT_ALL_TABLES")');
158 $this->simple_query(
297 $this->simple_query('SET AUTOCOMMIT=0');
298 return $this->simple_query('START TRANSACTION'); // can also be BEGIN or BEGIN WORK
310 if ($this->simple_query('COMMIT'))
312 $this->simple_query('SET AUTOCOMMIT=1');
328 if ($this->simple_query('ROLLBACK'))
330 $this->simple_query('SET AUTOCOMMIT=1');
/dports/www/drupal8/drupal-8.9.20/core/lib/Drupal/Core/Entity/Query/Sql/
H A DQuery.php106 $simple_query = TRUE;
108 $simple_query = FALSE;
161 $this->sqlQuery->addMetaData('simple_query', $simple_query);
195 $simple_query = $this->isSimpleQuery();
201 if (!$simple_query) {
213 if ($simple_query || isset($this->sqlGroupBy[$sql_alias])) {
/dports/databases/percona56-client/percona-server-5.6.51-91.0/tests/
H A Dfork_big2.pl310 $row_counts=simple_query($dbh, $count_query);
316 simple_query($dbh, "select id,info from $table where id=$id");
344 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
377 $row_counts=simple_query($dbh, $count_query);
383 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
418 $row_counts=simple_query($dbh, $count_query);
433 …$row=simple_query($dbh, "select count(*) from $t1, $t2 where $t1.id=$t2.id and $t1.id between $id1…
467 $row_counts=simple_query($dbh, $count_query);
505 $row_counts=simple_query($dbh, $count_query);
727 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
[all …]
H A Dfork_big.pl229 $row_counts=simple_query($dbh, $count_query);
235 simple_query($dbh, "select id,info from $table where id=$id");
263 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
296 $row_counts=simple_query($dbh, $count_query);
302 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
334 $row_counts=simple_query($dbh, $count_query);
372 $row_counts=simple_query($dbh, $count_query);
569 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
593 sub simple_query() subroutine
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/tests/
H A Dfork_big2.pl310 $row_counts=simple_query($dbh, $count_query);
316 simple_query($dbh, "select id,info from $table where id=$id");
344 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
377 $row_counts=simple_query($dbh, $count_query);
383 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
418 $row_counts=simple_query($dbh, $count_query);
433 …$row=simple_query($dbh, "select count(*) from $t1, $t2 where $t1.id=$t2.id and $t1.id between $id1…
467 $row_counts=simple_query($dbh, $count_query);
505 $row_counts=simple_query($dbh, $count_query);
727 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
[all …]
H A Dfork_big.pl229 $row_counts=simple_query($dbh, $count_query);
235 simple_query($dbh, "select id,info from $table where id=$id");
263 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
296 $row_counts=simple_query($dbh, $count_query);
302 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
334 $row_counts=simple_query($dbh, $count_query);
372 $row_counts=simple_query($dbh, $count_query);
569 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
593 sub simple_query() subroutine
/dports/databases/percona56-server/percona-server-5.6.51-91.0/tests/
H A Dfork_big2.pl310 $row_counts=simple_query($dbh, $count_query);
316 simple_query($dbh, "select id,info from $table where id=$id");
344 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
377 $row_counts=simple_query($dbh, $count_query);
383 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
418 $row_counts=simple_query($dbh, $count_query);
433 …$row=simple_query($dbh, "select count(*) from $t1, $t2 where $t1.id=$t2.id and $t1.id between $id1…
467 $row_counts=simple_query($dbh, $count_query);
505 $row_counts=simple_query($dbh, $count_query);
727 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
[all …]
H A Dfork_big.pl229 $row_counts=simple_query($dbh, $count_query);
235 simple_query($dbh, "select id,info from $table where id=$id");
263 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
296 $row_counts=simple_query($dbh, $count_query);
302 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
334 $row_counts=simple_query($dbh, $count_query);
372 $row_counts=simple_query($dbh, $count_query);
569 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
593 sub simple_query() subroutine
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/tests/
H A Dfork_big2.pl310 $row_counts=simple_query($dbh, $count_query);
316 simple_query($dbh, "select id,info from $table where id=$id");
344 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
377 $row_counts=simple_query($dbh, $count_query);
383 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
418 $row_counts=simple_query($dbh, $count_query);
433 …$row=simple_query($dbh, "select count(*) from $t1, $t2 where $t1.id=$t2.id and $t1.id between $id1…
467 $row_counts=simple_query($dbh, $count_query);
505 $row_counts=simple_query($dbh, $count_query);
727 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
[all …]
H A Dfork_big.pl229 $row_counts=simple_query($dbh, $count_query);
235 simple_query($dbh, "select id,info from $table where id=$id");
263 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
296 $row_counts=simple_query($dbh, $count_query);
302 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
334 $row_counts=simple_query($dbh, $count_query);
372 $row_counts=simple_query($dbh, $count_query);
569 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
593 sub simple_query() subroutine
/dports/databases/mariadb104-server/mariadb-10.4.24/tests/
H A Dfork_big2.pl303 $row_counts=simple_query($dbh, $count_query);
309 simple_query($dbh, "select id,info from $table where id=$id");
337 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
370 $row_counts=simple_query($dbh, $count_query);
376 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
411 $row_counts=simple_query($dbh, $count_query);
426 …$row=simple_query($dbh, "select count(*) from $t1, $t2 where $t1.id=$t2.id and $t1.id between $id1…
460 $row_counts=simple_query($dbh, $count_query);
498 $row_counts=simple_query($dbh, $count_query);
720 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
[all …]
H A Dfork_big.pl235 $row_counts=simple_query($dbh, $count_query);
241 simple_query($dbh, "select id,info from $table where id=$id");
269 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
302 $row_counts=simple_query($dbh, $count_query);
308 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
340 $row_counts=simple_query($dbh, $count_query);
378 $row_counts=simple_query($dbh, $count_query);
576 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
600 sub simple_query() subroutine
/dports/databases/mariadb104-client/mariadb-10.4.24/tests/
H A Dfork_big2.pl303 $row_counts=simple_query($dbh, $count_query);
309 simple_query($dbh, "select id,info from $table where id=$id");
337 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
370 $row_counts=simple_query($dbh, $count_query);
376 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
411 $row_counts=simple_query($dbh, $count_query);
426 …$row=simple_query($dbh, "select count(*) from $t1, $t2 where $t1.id=$t2.id and $t1.id between $id1…
460 $row_counts=simple_query($dbh, $count_query);
498 $row_counts=simple_query($dbh, $count_query);
720 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
[all …]
H A Dfork_big.pl235 $row_counts=simple_query($dbh, $count_query);
241 simple_query($dbh, "select id,info from $table where id=$id");
269 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
302 $row_counts=simple_query($dbh, $count_query);
308 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
340 $row_counts=simple_query($dbh, $count_query);
378 $row_counts=simple_query($dbh, $count_query);
576 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
600 sub simple_query() subroutine
/dports/databases/mariadb105-client/mariadb-10.5.15/tests/
H A Dfork_big2.pl303 $row_counts=simple_query($dbh, $count_query);
309 simple_query($dbh, "select id,info from $table where id=$id");
337 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
370 $row_counts=simple_query($dbh, $count_query);
376 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
411 $row_counts=simple_query($dbh, $count_query);
426 …$row=simple_query($dbh, "select count(*) from $t1, $t2 where $t1.id=$t2.id and $t1.id between $id1…
460 $row_counts=simple_query($dbh, $count_query);
498 $row_counts=simple_query($dbh, $count_query);
720 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
[all …]
/dports/databases/mariadb103-client/mariadb-10.3.34/tests/
H A Dfork_big2.pl303 $row_counts=simple_query($dbh, $count_query);
309 simple_query($dbh, "select id,info from $table where id=$id");
337 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
370 $row_counts=simple_query($dbh, $count_query);
376 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
411 $row_counts=simple_query($dbh, $count_query);
426 …$row=simple_query($dbh, "select count(*) from $t1, $t2 where $t1.id=$t2.id and $t1.id between $id1…
460 $row_counts=simple_query($dbh, $count_query);
498 $row_counts=simple_query($dbh, $count_query);
720 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
[all …]
/dports/databases/mariadb103-server/mariadb-10.3.34/tests/
H A Dfork_big2.pl303 $row_counts=simple_query($dbh, $count_query);
309 simple_query($dbh, "select id,info from $table where id=$id");
337 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
370 $row_counts=simple_query($dbh, $count_query);
376 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
411 $row_counts=simple_query($dbh, $count_query);
426 …$row=simple_query($dbh, "select count(*) from $t1, $t2 where $t1.id=$t2.id and $t1.id between $id1…
460 $row_counts=simple_query($dbh, $count_query);
498 $row_counts=simple_query($dbh, $count_query);
720 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
[all …]
/dports/databases/mysql56-client/mysql-5.6.51/tests/
H A Dfork_big2.pl310 $row_counts=simple_query($dbh, $count_query);
316 simple_query($dbh, "select id,info from $table where id=$id");
344 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
377 $row_counts=simple_query($dbh, $count_query);
383 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
418 $row_counts=simple_query($dbh, $count_query);
433 …$row=simple_query($dbh, "select count(*) from $t1, $t2 where $t1.id=$t2.id and $t1.id between $id1…
467 $row_counts=simple_query($dbh, $count_query);
505 $row_counts=simple_query($dbh, $count_query);
727 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
[all …]
/dports/databases/mysql55-client/mysql-5.5.62/tests/
H A Dfork_big2.pl303 $row_counts=simple_query($dbh, $count_query);
309 simple_query($dbh, "select id,info from $table where id=$id");
337 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
370 $row_counts=simple_query($dbh, $count_query);
376 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
411 $row_counts=simple_query($dbh, $count_query);
426 …$row=simple_query($dbh, "select count(*) from $t1, $t2 where $t1.id=$t2.id and $t1.id between $id1…
460 $row_counts=simple_query($dbh, $count_query);
498 $row_counts=simple_query($dbh, $count_query);
720 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/tests/
H A Dfork_big2.pl303 $row_counts=simple_query($dbh, $count_query);
309 simple_query($dbh, "select id,info from $table where id=$id");
337 …simple_query($dbh, "select count(distinct marker),count(distinct id),count(distinct info) from $ta…
370 $row_counts=simple_query($dbh, $count_query);
376 simple_query($dbh, "select $t1.id,$t2.info from $t1, $t2 where $t1.id=$t2.id and $t1.id=$id");
411 $row_counts=simple_query($dbh, $count_query);
426 …$row=simple_query($dbh, "select count(*) from $t1, $t2 where $t1.id=$t2.id and $t1.id between $id1…
460 $row_counts=simple_query($dbh, $count_query);
498 $row_counts=simple_query($dbh, $count_query);
720 $row=simple_query($dbh,"select * from $opt_db.$abort_table");
[all …]

12345