/dports/databases/p5-SQL-Abstract-Plugin-InsertMulti/SQL-Abstract-Plugin-InsertMulti-0.04/t/ |
H A D | 02_insert_multi.t | 28 q|INSERT INTO app_data ( app_id, created_on, guid, name, updated_on, value ) | 58 q|INSERT IGNORE app_data ( app_id, created_on, guid, name, updated_on, value ) | 76 [qw/app_id guid name value created_on updated_on/], 87 q|INSERT INTO app_data ( app_id, guid, name, value, created_on, updated_on ) | 130 q|INSERT INTO app_data ( app_id, created_on, guid, name, updated_on, value ) | 132 … created_on ), guid = VALUES( guid ), name = VALUES( name ), updated_on = VALUES( updated_on ), va… 155 +{ update => +{ updated_on => $now }, } 160 q|INSERT INTO app_data ( app_id, created_on, guid, name, updated_on, value ) | 162 . q|ON DUPLICATE KEY UPDATE updated_on = ?|, 191 q|INSERT INTO app_data ( app_id, created_on, guid, name, updated_on, value ) | [all …]
|
/dports/security/pbnj/pbnj-2.04/t/todo/ |
H A D | 04change.t | 85 my $updated = $href->{updated_on}; 121 tests => [ updated_on => $updated ], 145 my $updated = $href->{updated_on}; 178 tests => [ updated_on => $updated ], 190 updated_on => 'Sat May 27 19:02:53 2006', 200 updated_on => 'Sat May 27 19:02:53 2006', 210 updated_on => 'Sat May 27 19:02:53 2006', 239 updated_on => 'Sat May 27 19:02:53 2006', 249 updated_on => 'Sat May 27 19:02:53 2006', 259 updated_on => 'Sat May 27 19:02:53 2006', [all …]
|
H A D | 04change.t-backup | 85 my $updated = $href->{updated_on}; 121 tests => [ updated_on => $updated ], 145 my $updated = $href->{updated_on}; 178 tests => [ updated_on => $updated ], 190 updated_on => 'Sat May 27 19:02:53 2006', 200 updated_on => 'Sat May 27 19:02:53 2006', 210 updated_on => 'Sat May 27 19:02:53 2006', 239 updated_on => 'Sat May 27 19:02:53 2006', 249 updated_on => 'Sat May 27 19:02:53 2006', 259 updated_on => 'Sat May 27 19:02:53 2006', [all …]
|
/dports/security/pbnj/pbnj-2.04/t/ |
H A D | 04change.t | 74 my $updated = $href->{updated_on}; 116 tests => [ updated_on => $updated ], 141 my $updated = $href->{updated_on}; 174 tests => [ updated_on => $updated ], 186 updated_on => 'Sat May 27 19:02:53 2006', 196 updated_on => 'Sat May 27 19:02:53 2006', 206 updated_on => 'Sat May 27 19:02:53 2006', 236 updated_on => 'Sat May 27 19:02:53 2006', 246 updated_on => 'Sat May 27 19:02:53 2006', 256 updated_on => 'Sat May 27 19:02:53 2006', [all …]
|
H A D | query.yaml | 47 select S.updated_on,M.host,S.service,S.state,S.version from 61 select updated_on,service,banner from services where 67 select updated_on,service,version from services where 113 services as S where updated_on = (select updated_on from 114 services ORDER BY updated_on DESC limit 1) ORDER BY s.port; 120 services as S,machines as M where updated_on = (select updated_on from 121 services ORDER BY updated_on DESC limit 1) and M.mid = S.mid 127 services as S,machines as M where updated_on = (select updated_on from 128 services ORDER BY updated_on DESC limit 1) and M.mid = S.mid 157 S,machines as M where updated_on = (select updated_on from services ORDER [all …]
|
/dports/security/pbnj/pbnj-2.04/t/long/ |
H A D | 04change.t | 96 my $updated = $href->{updated_on}; 138 tests => [ updated_on => $updated ], 163 my $updated = $href->{updated_on}; 196 tests => [ updated_on => $updated ], 208 updated_on => 'Sat May 27 19:02:53 2006', 218 updated_on => 'Sat May 27 19:02:53 2006', 228 updated_on => 'Sat May 27 19:02:53 2006', 258 updated_on => 'Sat May 27 19:02:53 2006', 268 updated_on => 'Sat May 27 19:02:53 2006', 278 updated_on => 'Sat May 27 19:02:53 2006', [all …]
|
/dports/security/pbnj/pbnj-2.04/t/mysql/ |
H A D | 04change3-mysql.t | 32 updated_on => 'Sat May 27 19:02:53 2006', 42 updated_on => 'Sat May 27 19:02:53 2006', 52 updated_on => 'Sat May 27 19:02:53 2006', 63 updated_on => 'Sat May 27 19:03:24 2006', 73 updated_on => 'Sat May 27 20:00:10 2006', 84 updated_on => 'Sat May 27 20:00:10 2006', 94 updated_on => 'Sat May 27 20:00:10 2006', 121 my $updated = $href->{updated_on}; 157 tests => [ updated_on => $updated ], 178 my $updated = $href->{updated_on}; [all …]
|
H A D | 04change2-mysql.t | 32 updated_on => 'Sat May 27 19:02:53 2006', 42 updated_on => 'Sat May 27 19:02:53 2006', 52 updated_on => 'Sat May 27 19:02:53 2006', 63 updated_on => 'Sat May 27 19:03:24 2006', 81 die "testService: updated_on not defined" unless defined $href->{updated_on}; 90 my $updated = $href->{updated_on}; 126 tests => [ updated_on => $updated ], 139 die "testService: updated_on not defined" unless defined $href->{updated_on}; 147 my $updated = $href->{updated_on}; 180 tests => [ updated_on => $updated ],
|
H A D | 04change-mysql.t | 32 updated_on => 'Sat May 27 19:02:53 2006', 42 updated_on => 'Sat May 27 19:02:53 2006', 52 updated_on => 'Sat May 27 19:02:53 2006', 70 die "testService: updated_on not defined" unless defined $href->{updated_on}; 79 my $updated = $href->{updated_on}; 115 tests => [ updated_on => $updated ],
|
/dports/security/pbnj/pbnj-2.04/t/postgres/ |
H A D | 04change3-pg.t | 32 updated_on => 'Sat May 27 19:02:53 2006', 42 updated_on => 'Sat May 27 19:02:53 2006', 52 updated_on => 'Sat May 27 19:02:53 2006', 63 updated_on => 'Sat May 27 19:03:24 2006', 73 updated_on => 'Sat May 27 20:00:10 2006', 84 updated_on => 'Sat May 27 20:00:10 2006', 94 updated_on => 'Sat May 27 20:00:10 2006', 121 my $updated = $href->{updated_on}; 157 tests => [ updated_on => $updated ], 178 my $updated = $href->{updated_on}; [all …]
|
H A D | 04change2-pg.t | 32 updated_on => 'Sat May 27 19:02:53 2006', 42 updated_on => 'Sat May 27 19:02:53 2006', 52 updated_on => 'Sat May 27 19:02:53 2006', 63 updated_on => 'Sat May 27 19:03:24 2006', 81 die "testService: updated_on not defined" unless defined $href->{updated_on}; 90 my $updated = $href->{updated_on}; 126 tests => [ updated_on => $updated ], 139 die "testService: updated_on not defined" unless defined $href->{updated_on}; 147 my $updated = $href->{updated_on}; 180 tests => [ updated_on => $updated ],
|
H A D | 04change-pg.t | 32 updated_on => 'Sat May 27 19:02:53 2006', 42 updated_on => 'Sat May 27 19:02:53 2006', 52 updated_on => 'Sat May 27 19:02:53 2006', 70 die "testService: updated_on not defined" unless defined $href->{updated_on}; 79 my $updated = $href->{updated_on}; 115 tests => [ updated_on => $updated ],
|
/dports/databases/p5-SQL-Maker/SQL-Maker-1.21/t/ |
H A D | 01_insert.t | 18 …is $sql, qq{INSERT INTO "foo"\n("bar", "john", "created_on", "updated_on", "expires")\nVALUES (?, … 25 …is $sql, qq{INSERT INTO "foo"\n("bar", "john", "created_on", "updated_on", "expires")\nVALUES (?, … 32 …is $sql, qq{INSERT IGNORE "foo"\n("bar", "john", "created_on", "updated_on")\nVALUES (?, ?, dateti… 39 …is $sql, qq{INSERT IGNORE "foo"\n("bar", "john", "created_on", "updated_on")\nVALUES (?, ?, dateti… 45 …bar => 'baz', john => 'man', created_on => sql_raw("datetime('now')"), updated_on => sql_raw("date… 46 …is $sql, qq{INSERT INTO "foo"\n("bar", "john", "created_on", "updated_on")\nVALUES (?, ?, datetime… 55 …is $sql, qq{INSERT INTO `foo`\n(`bar`, `john`, `created_on`, `updated_on`, `expires`)\nVALUES (?, … 62 …is $sql, qq{INSERT INTO `foo`\n(`bar`, `john`, `created_on`, `updated_on`, `expires`)\nVALUES (?, … 69 …is $sql, qq{INSERT IGNORE `foo`\n(`bar`, `john`, `created_on`, `updated_on`)\nVALUES (?, ?, NOW(),… 76 …is $sql, qq{INSERT IGNORE `foo`\n(`bar`, `john`, `created_on`, `updated_on`)\nVALUES (?, ?, NOW(),… [all …]
|
H A D | 01_update.t | 64 …my ($sql, @binds) = $builder->update( 'foo', [ user_id => 100, updated_on => \['datetime(?)', 'now… 65 … is $sql, qq{UPDATE "foo" SET "user_id" = ?, "updated_on" = datetime(?), "counter" = counter + 1}; 70 …my ($sql, @binds) = $builder->update( 'foo', [ user_id => 100, updated_on => sql_raw('datetime(?)'… 71 … is $sql, qq{UPDATE "foo" SET "user_id" = ?, "updated_on" = datetime(?), "counter" = counter + 1}; 126 …my ($sql, @binds) = $builder->update( 'foo', [ user_id => 100, updated_on => \['FROM_UNIXTIME(?)',… 127 …is $sql, qq{UPDATE `foo` SET `user_id` = ?, `updated_on` = FROM_UNIXTIME(?), `counter` = counter +… 132 …my ($sql, @binds) = $builder->update( 'foo', [ user_id => 100, updated_on => sql_raw('FROM_UNIXTIM… 133 …is $sql, qq{UPDATE `foo` SET `user_id` = ?, `updated_on` = FROM_UNIXTIME(?), `counter` = counter +… 188 …my ($sql, @binds) = $builder->update( 'foo', [ user_id => 100, updated_on => \['FROM_UNIXTIME(?)',… 189 … is $sql, qq{UPDATE foo SET user_id = ?, updated_on = FROM_UNIXTIME(?), counter = counter + 1}; [all …]
|
/dports/security/pbnj/pbnj-2.04/ |
H A D | query.yaml | 47 select S.updated_on,M.host,S.service,S.state,S.version from 61 select updated_on,service,banner from services where 67 select updated_on,service,version from services where 113 services as S where updated_on = (select updated_on from 114 services ORDER BY updated_on DESC limit 1) ORDER BY s.port; 120 services as S,machines as M where updated_on = (select updated_on from 121 services ORDER BY updated_on DESC limit 1) and M.mid = S.mid 127 services as S,machines as M where updated_on = (select updated_on from 128 services ORDER BY updated_on DESC limit 1) and M.mid = S.mid 157 S,machines as M where updated_on = (select updated_on from services ORDER [all …]
|
H A D | outputpbnj | 1035 select S.updated_on,M.host,S.service,S.state,S.version from 1049 select updated_on,service,banner from services where 1055 select updated_on,service,version from services where 1101 services as S where updated_on = (select updated_on from 1102 services ORDER BY updated_on DESC limit 1) ORDER BY s.port; 1108 services as S,machines as M where updated_on = (select updated_on from 1109 services ORDER BY updated_on DESC limit 1) and M.mid = S.mid 1115 services as S,machines as M where updated_on = (select updated_on from 1116 services ORDER BY updated_on DESC limit 1) and M.mid = S.mid 1145 S,machines as M where updated_on = (select updated_on from services ORDER [all …]
|
/dports/databases/p5-SQL-Maker/SQL-Maker-1.21/t/plugins/insert_multi/ |
H A D | 01_insert_multi.t | 63 updated_on => \[ "UNIX_TIMESTAMP(?)", "2011-04-12" ], 70 updated_on => \[ "UNIX_TIMESTAMP(?)", "2011-04-13" ], 78 updated_on => \[ "UNIX_TIMESTAMP(?)", "2011-04-14" ], 85 (`bar`, `john`, `created_on`, `updated_on`, `expires`) 101 updated_on => sql_raw("UNIX_TIMESTAMP(?)", "2011-04-12"), 107 updated_on => sql_raw("UNIX_TIMESTAMP(?)", "2011-04-13"), 114 updated_on => sql_raw("UNIX_TIMESTAMP(?)", "2011-04-14"), 120 (`bar`, `john`, `created_on`, `updated_on`) 154 'foo' => [qw/bar john created_on updated_on/], 169 updated_on => \[ "UNIX_TIMESTAMP(?)", "2011-04-14" ], [all …]
|
/dports/databases/p5-Test-Fixture-DBI/Test-Fixture-DBI-0.09/t/mysql/ |
H A D | construct_fixture.t | 42 updated_on => '2010-06-28 12:35:00', 53 updated_on => '2010-06-28 12:35:00', 64 updated_on => '2010-06-28 12:35:00', 99 updated_on => '2010-06-28 12:35:00', 199 'updated_on' => '2010-06-28 12:35:00' 210 'updated_on' => '2010-06-28 12:35:00' 221 'updated_on' => '2010-06-28 12:35:00' 232 'updated_on' => '2010-06-28 13:35:00' 243 'updated_on' => '2010-06-28 14:35:00' 254 'updated_on' => '2010-06-28 15:35:00'
|
/dports/databases/p5-Test-Fixture-DBI/Test-Fixture-DBI-0.09/t/ |
H A D | friend_fixture.yaml | 7 updated_on: 2010-06-28 13:35:00 15 updated_on: 2010-06-28 14:35:00 23 updated_on: 2010-06-28 15:35:00
|
H A D | people_fixture_001.yaml | 7 updated_on: 2010-06-28 12:35:00 15 updated_on: 2010-06-28 12:35:00 23 updated_on: 2010-06-28 12:35:00
|
/dports/databases/p5-Test-Fixture-DBI/Test-Fixture-DBI-0.09/t/sqlite/ |
H A D | construct_fixture.t | 22 updated_on => '2010-06-28 12:35:00', 33 updated_on => '2010-06-28 12:35:00', 44 updated_on => '2010-06-28 12:35:00', 57 updated_on => '2010-06-28 12:35:00', 69 'updated_on' => '2010-06-28 13:35:00' 80 'updated_on' => '2010-06-28 14:35:00' 91 'updated_on' => '2010-06-28 15:35:00'
|
/dports/deskutils/py-bugwarrior/bugwarrior-1.7.0/bugwarrior/services/ |
H A D | redmine.py | 139 updated_on = self.record.get('updated_on') 150 if updated_on: 151 updated_on = self.parse_date(updated_on).replace(microsecond=0) 180 self.UPDATED_ON: updated_on,
|
/dports/databases/p5-DBIx-Skinny-InflateColumn-DateTime/DBIx-Skinny-InflateColumn-DateTime-0.06/t/ |
H A D | 100_inflate.t | 40 isa_ok $author->updated_on, 'DateTime'; 43 is $author->updated_on->ymd, '2009-02-02', 'updated_on inflate ok';
|
H A D | 200_auto_inflate.t | 40 isa_ok $author->updated_on, 'DateTime'; 43 is $author->updated_on->ymd, '2009-02-02', 'updated_on inflate ok';
|
/dports/www/p5-Jifty/Jifty-1.50430/t/TestApp-Plugin-ActorMetadata/t/ |
H A D | actormetadata.t | 33 ok( abs( $post->updated_on->epoch - $now->epoch < 2 ), 'created_on is set' ); 44 ok( abs( $post->updated_on->epoch - Jifty::DateTime->now->epoch ) < 1 , 57 ok( $post->updated_on->epoch >= $now->epoch, 74 for my $method (qw/created_by created_on updated_by updated_on/) {
|