java - Android SQLite greater than query isn't working how I expect it to -

-

okay i'm missing fundamental here can't figure out is.

the problem:

i'm writing unit test database query search shifts have happened after date (the dates i'm storing in epoch milliseconds) logic dictates construct query shift start dates greater than specified date, seems simple enough yet test failing, , weirdly when flip greater lesser test passes o_o.

this query:

public cursor getautoclockedshifts(long datesince) {     string sortorder = col_start_date + " desc";     string selection = col_added_manually + " = " + "?" + " , " + col_start_date + " > " + "?";     string[] selectionargs = {"0", datesince.tostring()};     cursor = database.query(false, gettablename(), null, selection, selectionargs, null, null, sortorder, null);      return cursor; }

this fake data i'm using unit test:

private hashmap<string, ?> createshifthashmap(){     hashmap<string, object> values = new hashmap<>();     values.put(shiftdb.col_added_manually, 0);     values.put(shiftdb.col_start_date, 1478871347000l);//human readable = 11/11/2016, 13:35:47     return values;  }

and unit test i've put together:

    @test public void tesgetautomaticallyaddedshifts() throws exception {     long result = shiftdb.create(createshifthashmap());     cursor c = shiftdb.get(result);      assertequals(1478871347000l, c.getlong(c.getcolumnindex(shiftdb.col_start_date)));     asserttrue(1478871347000l > 1447421747000l);     asserttrue(c.getlong(c.getcolumnindex(shiftdb.col_start_date)) > 1447421747000l);      cursor c1 = shiftdb.getautoclockedshifts(1447421747000l);//human readable = 13/11/2015, 13:35:47     assertnotequals(0, c1.getcount()); }

i made sure data thought commenting out last 2 lines , verifying first 3 asserts pass (which do) last assert keeps on failing message:

java.lang.assertionerror: values should different. actual: 0

i know can't case android/java/sqlite making maths mistake, i'm @ loss whats wrong here, mentioned above test passes if flip greater lesser makes no sense start date value greater specified date.

please help.


Comments

Post a Comment

Popular posts from this blog

jsf - "PropertyNotWritableException: Illegal Syntax for Set Operation" error when setting value in bean -

-
this question has answer here: how send form input values , invoke method in jsf bean 1 answer i error when trying send values jsf page bean. i want set values fields in bean, create airplane instance , add database. error telling me use illegal syntax setter part of bean. why error? didnt find on site helped me problem. here jsf part: <h4>add plane</h4> <c:if test="#{not empty listairplanebb.error}"> <div class="alert alert-danger"> <span class="glyphicon glyphicon-remove"></span> <h:outputtext value="#{listairplanebb.error}" /> </div> </c:if> <h:form> <table class="table"> <thead> ...
Read more

arrays - Algorithm to find ideal starting spot in a circle -

-
so problem have been debating such: your given array of integers representing circle. then, have pick spot in circle start. place start, compare value @ array number of steps took there , if steps less or equal number, include in final set. find place start have elements in set. ex, a=[0, 1, 2] if start @ index=0, then: a[0]=0 < =0 0 included a[1]=1 < =1 1 included a[2]=2 < =2 2 included final set: {0,1,2} if start @ index=1, then: a[1]=1 > 0 1 not included a[2]=2 > 1 2 not included here loop around a[0]=0 > 2 0 included final set: {0} if start @ index=2, then: a[2]=2 > 0 2 not included, here loop around a[0]=0 < = 1 0 included a[1]=1 < = 2 1 included final set: {0,1} so in trivial case, starting position index=0 best position results in final set elements. brute force method of finding obvious, trying find more efficient method. attempts far have been examine trying find max intersect of viable starting ranges calculated each element in arr...
Read more

php - Autoloader issue not returning Class -

-
problem? bootloader (autoloader) not seem working properly, or i'm missing something. here simplified code. the code below returns class "skeleton" not exist. on index.php file. index.php <?php include 'bootloader.php'; use skeleton\html\loginheader; $tool = new skeleton/html/loginheader(); bootloader.php <?php function boot($classname) { $filename = ''; $namespace = ''; // sets include path "src" directory $includepath = dirname(__file__).directory_separator.'src'; if (false !== ($lastnspos = strripos($classname, '\\'))) { $namespace = substr($classname, 0, $lastnspos); $classname = substr($classname, $lastnspos + 1); $filename = str_replace('\\', directory_separator, $namespace) . directory_separator; } $filename .= str_replace('_', directory_separator, $classname) . '.php'...
Read more