yovesmlmt
19/05/16, 10:38:10
Creo que sería algo así la busqueda.
sqlite3 /data/data/com.xiaomi.hm.health/databases/origen.db SELECT summary FROM date_data ORDER BY id DESC
y devuleve esto:
summary
{"v":5,"slp":{"st":1463611380,"ed":1463636640,"dp":86,"lt":335,"wk":0},"stp":{"ttl":1527,"dis":1065,"cal":85,"wk":16,"rn":0,"runDist":0,"runCal":0},"goal":8000}
{"v":5,"slp":{"st":1463529600,"ed":1463550540,"dp":103,"lt":246,"wk":0},"stp":{"ttl":8245,"dis":5875,"cal":469,"wk":108,"rn":0,"runDist":0,"runCal":0},"goal":8000}
{"slp":{"lt":0,"st":1431986400,"wk":0,"dp":0,"ed":1431986400},"v":5,"goal":8000,"stp":{"rn":3,"cal":371,"runDist":264,"wk":84,"ttl":6749,"runCal":20,"dis":4700}}
{"slp":{"lt":227,"st":1432073280,"wk":0,"dp":265,"ed":1432102800},"v":5,"goal":8000,"stp":{"rn":9,"cal":826,"runDist":1185,"wk":175,"ttl":14720,"runCal":90,"dis":10767}}
{"slp":{"lt":206,"st":1432161600,"wk":0,"dp":220,"ed":1432187160},"v":5,"goal":8000,"stp":{"rn":2,"cal":519,"runDist":211,"wk":125,"ttl":9527,"runCal":16,"dis":6660}}
{"slp":{"lt":138,"st":1432249320,"wk":0,"dp":299,"ed":1432275540},"v":5,"goal":8000,"stp":{"rn":4,"cal":387,"runDist":474,"wk":84,"ttl":6760,"runCal":37,"dis":4829}}
{"slp":{"lt":243,"st":1432339860,"wk":0,"dp":256,"ed":1432369800},"v":5,"goal":8000,"stp":{"rn":3,"cal":555,"runDist":267,"wk":137,"ttl":10042,"runCal":21,"dis":6947}}
{"slp":{"lt":244,"st":1432422360,"wk":0,"dp":286,"ed":1432454160},"v":5,"goal":8000,"stp":{"rn":6,"cal":729,"runDist":681,"wk":170,"ttl":13304,"runCal":50,"dis":9467}}
{"slp":{"lt":257,"st":1432506180,"wk":0,"dp":219,"ed":1432534740},"v":5,"goal":8000,"stp":{"rn":18,"cal":595,"runDist":2806,"wk":87,"ttl":8742,"runCal":268,"dis":6946}}
{"slp":{"lt":212,"st":1432595340,"wk":0,"dp":217,"ed":1432621080},"v":5,"goal":8000,"stp":{"rn":4,"cal":388,"runDist":366,"wk":93,"ttl":7039,"runCal":28,"dis":4893}}
{"slp":{"lt":227,"st":1432682820,"wk":0,"dp":107,"ed":1432702860},"v":5,"goal":8000,"stp":{"rn":7,"cal":585,"runDist":762,"wk":126,"ttl":10599,"runCal":57,"dis":7676}}
{"slp":{"lt":165,"st":1432769100,"wk":0,"dp":220,"ed":1432792200},"v":5,"goal":8000,"stp":{"rn":5,"cal":583,"runDist":458,"wk":133,"ttl":10636,"runCal":35,"dis":7455}}
{"slp":{"lt":238,"st":1432853940,"wk":0,"dp":202,"ed":1432880340},"v":5,"goal":8000,"stp":{"rn":3,"cal":483,"runDist":206,"wk":117,"ttl":8795,"runCal":16,"dis":6167}}
{"slp":{"lt":312,"st":1432944420,"wk":0,"dp":152,"ed":1432972260},"v":5,"goal":8000,"stp":{"rn":4,"cal":565,"runDist":418,"wk":146,"ttl":10188,"runCal":32,"dis":7085}}
{"slp":{"lt":181,"st":1433026980,"wk":0,"dp":341,"ed":1433058300},"v":5,"goal":8000,"stp":{"rn":2,"cal":429,"runDist":184,"wk":108,"ttl":7607,"runCal":14,"dis":5353}}
{"slp":{"lt":320,"st":1433112000,"wk":0,"dp":140,"ed":1433139600},"v":5,"goal":8000,"stp":{"rn":2,"cal":551,"runDist":190,"wk":131,"ttl":10029,"runCal":15,"dis":6962}}
{"slp":{"lt":178,"st":1433200680,"wk":37,"dp":195,"ed":1433225280},"v":5,"goal":8000,"stp":{"rn":1,"cal":276,"runDist":135,"wk":73,"ttl":4925,"runCal":10,"dis":3425}}
{"slp":{"lt":0,"st":1433282400,"wk":0,"dp":0,"ed":1433282400},"v":5,"goal":8000,"stp":{"rn":2,"cal":573,"runDist":220,"wk":141,"ttl":10555,"runCal":17,"dis":7319}}
{"slp":{"lt":250,"st":1433371080,"wk":0,"dp":210,"ed":1433398680},"v":5,"goal":8000,"stp":{"rn":1,"cal":372,"runDist":115,"wk":95,"ttl":6830,"runCal":9,"dis":4748}}
{"slp":{"lt":131,"st":1433458680,"wk":0,"dp":281,"ed":1433483400},"v":5,"goal":8000,"stp":{"rn":3,"cal":508,"runDist":327,"wk":115,"ttl":9036,"runCal":24,"dis":6511}}
{"slp":{"lt":272,"st":1433552760,"wk":0,"dp":137,"ed":1433577300},"v":5,"goal":8000,"stp":{"rn":3,"cal":441,"runDist":217,"wk":108,"ttl":7897,"runCal":17,"dis":5501}}
{"slp":{"lt":327,"st":1433636880,"wk":0,"dp":121,"ed":1433663760},"v":5,"goal":8000,"stp":{"rn":2,"cal":291,"runDist":128,"wk":82,"ttl":5133,"runCal":10,"dis":3574}}
{"slp":{"lt":167,"st":1433720640,"wk":0,"dp":198,"ed":1433742540},"v":5,"goal":8000,"stp":{"rn":1,"cal":382,"runDist":118,"wk":99,"ttl":6901,"runCal":9,"dis":4775}}
¿Hay alguna manera de que solo busque en la primera linea o en la última dependiendo del orden que utilices?
vBulletin® v3.8.1, Copyright ©2000-2025, Jelsoft Enterprises Ltd.