[Everydevel-opers] SF.net SVN: everydevel: [955] trunk/ebase

[<pau...@us...>]

Revision: 955
          http://svn.sourceforge.net/everydevel/?rev=955&view=rev
Author:   paul_the_nomad
Date:     2007-05-22 16:11:06 -0700 (Tue, 22 May 2007)

Log Message:
-----------
FIX: call to correct sql function to fetch current date and fix in EveryAuth to
make it DB neutral.

Modified Paths:
--------------
    trunk/ebase/lib/Everything/Auth/EveryAuth.pm
    trunk/ebase/lib/Everything/DB/Test/sqlite.pm
    trunk/ebase/lib/Everything/DB/sqlite.pm

Property Changed:
----------------
    trunk/ebase/


Property changes on: trunk/ebase
___________________________________________________________________
Name: svk:merge
   - 16c2b9cb-492b-4d64-9535-64d4e875048d:/wip/ebase:979
a6810612-c0f9-0310-9d3e-a9e4af8c5745:/ebase/offline:17930
   + 16c2b9cb-492b-4d64-9535-64d4e875048d:/wip/ebase:981
a6810612-c0f9-0310-9d3e-a9e4af8c5745:/ebase/offline:17930

Modified: trunk/ebase/lib/Everything/Auth/EveryAuth.pm
===================================================================
--- trunk/ebase/lib/Everything/Auth/EveryAuth.pm	2007-05-22 23:10:00 UTC (rev 954)
+++ trunk/ebase/lib/Everything/Auth/EveryAuth.pm	2007-05-22 23:11:06 UTC (rev 955)
@@ -163,7 +163,7 @@
 
 	if ( $genCrypt eq $crpasswd )
 	{
-		$$user{lasttime} = $DB->sqlSelect("NOW()");
+		$$user{lasttime} = $DB->sqlSelect( $DB->now );
 		return $user;
 	}
 

Modified: trunk/ebase/lib/Everything/DB/Test/sqlite.pm
===================================================================
--- trunk/ebase/lib/Everything/DB/Test/sqlite.pm	2007-05-22 23:10:00 UTC (rev 954)
+++ trunk/ebase/lib/Everything/DB/Test/sqlite.pm	2007-05-22 23:11:06 UTC (rev 955)
@@ -407,7 +407,7 @@
 sub test_now : Test(2) {
     my $self = shift;
     can_ok( $self->{class}, 'now' ) || return;
-    ok( $self->{instance}->now, '... returns seconds since the epoch.' );
+    is( $self->{instance}->now, "datetime('now')", '... calls sqlite datetime function.' );
 }
 
 sub test_timediff : Test(2) {

Modified: trunk/ebase/lib/Everything/DB/sqlite.pm
===================================================================
--- trunk/ebase/lib/Everything/DB/sqlite.pm	2007-05-22 23:10:00 UTC (rev 954)
+++ trunk/ebase/lib/Everything/DB/sqlite.pm	2007-05-22 23:11:06 UTC (rev 955)
@@ -390,7 +390,7 @@
 	return @tables;
 }
 
-sub now { return time() }
+sub now { return "datetime('now')" }
 
 sub timediff { "$_[1] - $_[2]" }
 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.