leromaro
29/08/19, 23:46:14
Hola, tengo una tarea para realizar consultas en el calendario, obtenida del foro, acá está el link https://www.htcmania.com/showthread.php?t=802260
con la solución de maid450 en el post 11.
Bueno me andaba perfectamente hasta Android Oreo, pero en Pie no funciona (tengo una rom no oficial Omnirom)
He buscado en internet y si no entendí mal, en Pie hay que poner distinto el directorio, pero no he encontrado la forma de hacerlo.
Al ejecutar la tarea
Prox Eventos Calendario (37)
<funciona con sqlite de magisk>
A1: Ejecutar consola [ Comando:sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > %TIMEMS ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}' Cuenta atrás (segundos):2 Usar Root:Encendido Almacenar Salida En:%calendario Almacenar Errores En:%Error Almacenar Resultado en: ]
A2: JavaScriptlet [ Código:var calendario = calendario.replace(/Mon/gi,"Lun"); var calendario = calendario.replace(/Tue/gi,"Mar"); var calendario = calendario.replace(/Wed/gi,"Mie"); var calendario = calendario.replace(/Thu/gi,"Jue"); var calendario = calendario.replace("Fri","Vie");
var calendario = calendario.replace(/Sat/gi,"Sab");
var calendario = calendario.replace(/Sun/gi,"Dom"); var calendario = calendario.replace(/Jan/gi,"Ene"); var calendario = calendario.replace(/Apr/gi,"Abr");
var calendario = calendario.replace(/Aug/gi,"Ago"); var calendario = calendario.replace(/Dec/gi,"Dic") Librerías: Salida Automática:Encendido Cuenta atrás (segundos):45 ]
A3: Flash [ Texto:%calendario Largo:Encendido ]
A4: Flash [ Texto:%calendario Largo:Encendido ]
da este error
18.41.30/E exe: Prox Eventos Calendario / Ejecutar consola [ Comando:sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > %TIMEMS ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}' Cuenta atrás (segundos):2 Usar Root:Encendido Almacenar Salida En:%calendario Almacenar Errores En:%Error Almacenar Resultado en: ]
18.41.30/Variables doreplresult: |sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > %TIMEMS ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}'| -> |sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > 1567114890140 ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}'|
18.41.30/Variables doreplresult: |sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > %TIMEMS ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}'| -> |sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > 1567114890140 ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}'|
18.41.30/E Ejecutar consola: %calendario -> %calendario
18.41.30/E Ejecutar consola: %Error -> %Error
18.41.30/E Ejecutar consola: ->
18.41.30/Shell runBackground sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > 1567114890140 ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}' root: true timeout: 2000
18.41.30/Shell start process-thread ID 90788
18.41.30/E add wait type Shell1 time 2147483647
18.41.30/E add wait type Shell1 done
18.41.30/E add wait task
18.41.30/E Error: 1
Y en la variable que puse %Error, me devuelve el error "No daemon is currently running"
Alguien sabe que puede estar pasando?
Gracias
con la solución de maid450 en el post 11.
Bueno me andaba perfectamente hasta Android Oreo, pero en Pie no funciona (tengo una rom no oficial Omnirom)
He buscado en internet y si no entendí mal, en Pie hay que poner distinto el directorio, pero no he encontrado la forma de hacerlo.
Al ejecutar la tarea
Prox Eventos Calendario (37)
<funciona con sqlite de magisk>
A1: Ejecutar consola [ Comando:sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > %TIMEMS ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}' Cuenta atrás (segundos):2 Usar Root:Encendido Almacenar Salida En:%calendario Almacenar Errores En:%Error Almacenar Resultado en: ]
A2: JavaScriptlet [ Código:var calendario = calendario.replace(/Mon/gi,"Lun"); var calendario = calendario.replace(/Tue/gi,"Mar"); var calendario = calendario.replace(/Wed/gi,"Mie"); var calendario = calendario.replace(/Thu/gi,"Jue"); var calendario = calendario.replace("Fri","Vie");
var calendario = calendario.replace(/Sat/gi,"Sab");
var calendario = calendario.replace(/Sun/gi,"Dom"); var calendario = calendario.replace(/Jan/gi,"Ene"); var calendario = calendario.replace(/Apr/gi,"Abr");
var calendario = calendario.replace(/Aug/gi,"Ago"); var calendario = calendario.replace(/Dec/gi,"Dic") Librerías: Salida Automática:Encendido Cuenta atrás (segundos):45 ]
A3: Flash [ Texto:%calendario Largo:Encendido ]
A4: Flash [ Texto:%calendario Largo:Encendido ]
da este error
18.41.30/E exe: Prox Eventos Calendario / Ejecutar consola [ Comando:sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > %TIMEMS ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}' Cuenta atrás (segundos):2 Usar Root:Encendido Almacenar Salida En:%calendario Almacenar Errores En:%Error Almacenar Resultado en: ]
18.41.30/Variables doreplresult: |sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > %TIMEMS ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}'| -> |sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > 1567114890140 ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}'|
18.41.30/Variables doreplresult: |sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > %TIMEMS ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}'| -> |sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > 1567114890140 ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}'|
18.41.30/E Ejecutar consola: %calendario -> %calendario
18.41.30/E Ejecutar consola: %Error -> %Error
18.41.30/E Ejecutar consola: ->
18.41.30/Shell runBackground sqlite3 -list /data/data/com.android.providers.calendar/databases/calendar.db "SELECT Instances.begin, Events.title FROM Instances JOIN Events ON Instances.event_id = Events._id WHERE begin > 1567114890140 ORDER BY Instances.begin ASC LIMIT 4;" | awk -F "|" '{printf strftime("%a %d de %b %H:%M",$1/1000)} {print "-",$2}' root: true timeout: 2000
18.41.30/Shell start process-thread ID 90788
18.41.30/E add wait type Shell1 time 2147483647
18.41.30/E add wait type Shell1 done
18.41.30/E add wait task
18.41.30/E Error: 1
Y en la variable que puse %Error, me devuelve el error "No daemon is currently running"
Alguien sabe que puede estar pasando?
Gracias