sqlite - Strange order when retrieves data from android database -

-

i trying data database using sqldatabase.query method:

public cursor getlist() {     dataprovider.dbhelper mdbhelper = dataprovider.getdbhelper();     sqlitedatabase db = mdbhelper.getwritabledatabase();     return db.query(shotstable.table_name,                      new string[]{shotstable.json},                      null,                      null,                      null,                      null,                      shotstable.views + " desc"); }   private list<shots> getallfromdb() {     gson gson = new gson();     cursor cursor = new shotsdatahelper().getlist();     list<shots> data = new arraylist<>();     if (cursor.movetofirst()) {         {             data.add(gson.fromjson(cursor.getstring(cursor.getcolumnindex(shotsdatahelper.shotstable.json)),             shots.class);         } while (cursor.movetonext());     }     cursor.close();     return data; }   public void insert(shots shots) {     contentvalues contentvalues = new contentvalues();     contentvalues.put(shotstable.id, shots.getid());     contentvalues.put(shotstable.views, integer.valueof(shots.getviews_count()));     contentvalues.put(shotstable.comments, integer.valueof(shots.getcomments_count()));     contentvalues.put(shotstable.likes, integer.valueof(shots.getlikes_count()));     contentvalues.put(shotstable.json, shots.getjson());     insert(contentvalues);      // insert database using getcontentresolver().insert(getcontenturi(), contentvalues); }

and table:

sqlitetable table = new sqlitetable(table_name)                     .addcolumn(id, column.datatype.text)                     .addcolumn(views, column.datatype.integer)                     .addcolumn(comments, column.datatype.integer)                     .addcolumn(likes, column.datatype.integer)                     .addcolumn(json, column.datatype.text);

however, when application loads data database, retrieved data successfully, order here strange(ordered views think), , list looks this(views listed below, returned method getallfromdb() above):

976

958

956

927

925

903

2115

1978

1936

1589

1574

1487

1363

1298

1265

1210

1130

1106

1104

1081

and cursor in getlist() contains mquery: "sqlitequery: select json shots order views desc"

i wonder whether wrong operation database, desc order of data here strange, datas views_count smaller 1000, have desc order , datas views_count greater 1000, have desc order too.

you should post little more, query return output. output paste suit data order id in case string (i don't recommend (long more suitable type, if know doing ok)).

so displayed numbers alphabetically sorted; order work correctly. because asci value of '1' lover value of '9' number 19999 appeare before number 9.


Comments

Post a Comment

Popular posts from this blog

ios - RestKit 0.20 — CoreData: error: Failed to call designated initializer on NSManagedObject class (again) -

-
this error has shown on many times, seems. prominent answer issue seems restkit 0.20 — coredata: error: failed call designated initializer on nsmanagedobject class however, solution posted doesn't work me. let's start beginning: i want upload file server. want parse response make sure uploaded. if not, try again later. model has boolean variable called nsnumber *senttoserver purpose (in coredata, bool saved nsnumber ) . because don't know whether sending going successful, save entity coredata model first before sending via restkit. when post request successful, server returns json string this: {"id":14,"created":true} notice that, of course, id not set on coredata model yet, both id , created new informations model. here's model: @interface recording : nsmanagedobject @property (nonatomic, retain) nsstring * audiofilepath; @property (nonatomic, retain) nsdate * createdat; @property (nonatomic, retain) nsstring * deviceid; @...
Read more

java - Digest auth with Spring Security using javaconfig -

-
so i'm trying create digest authentication spring following documentation trying translate xml "requirements" in java requirements. let's have xml in docs: <bean id="digestfilter" class= "org.springframework.security.web.authentication.www.digestauthenticationfilter"> <property name="userdetailsservice" ref="jdbcdaoimpl"/> <property name="authenticationentrypoint" ref="digestentrypoint"/> <property name="usercache" ref="usercache"/> </bean> <bean id="digestentrypoint" class= "org.springframework.security.web.authentication.www.digestauthenticationentrypoint"> <property name="realmname" value="contacts realm via digest authentication"/> <property name="key" value="acegi"/> <property name="noncevalidityseconds" value="10"/> </b...
Read more

laravel - PDOException in Connector.php line 55: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) -

-
my .env: app_env=local app_debug=true app_key=myappkey app_url=http://localhost db_connection=mysql db_host=localhost db_port=3306 db_database=gestiontaller db_username=root db_password='root' cache_driver=file session_driver=file queue_driver=sync redis_host=127.0.0.1 redis_password=null redis_port=6379 mail_driver=smtp mail_host=mailtrap.io mail_port=2525 mail_username=null mail_password=null mail_encryption=null i've tried password ", ' , without, restarting server every time. i've tried changing localhost 172.0.0.1. yes, password correct, running mysql -u root -p introducing password root in prompt can go mysql. users table: +------------------+-----------+ | user | host | +------------------+-----------+ | debian-sys-maint | localhost | | mysql.sys | localhost | | root | localhost | | root1 | localhost | +------------------+-----------+ i've added homestead.yaml this: database_port: 3306 ...
Read more