are the past notification are some where saved ?

[perry]

Hello,

Does anyone know if the past notifications will be saved and where?

greetings perry

[speeduploop]

They must be saved someone because they 're-fire' on a reboot if you didn't open them...
(at least the unread notifications...)

But I can't say where.

[PuriShnit]

I would try:

-Change date to a later date.
-Send myself a SMS etc.
-Now execute 'find /data/ -mmin -2'

Then, we can easily pinpoint the file-location...

[perry]

adb shell do not support  -mmin

[PuriShnit]

I recently did it with adb in 8110 with Gerda recovery.

However, some 'find' applets don't contain this function, so you could try adding 'busybox' at the beginning of the command, as busybox should definitely contain this function...

[perry]

thanks @PuriShnit with busybox find -mmin works

the notifications are saved in different sqlite db's

[speeduploop]

Yes - Android (and therefore KaiOS) are trying to get rid of 'busybox' because of it's license... so they implement more and more applets in their own 'toybox' -- so once they implemeted all commands they need they can stop shipping busybox.

But the applets of toybox are often simpler or even broken...

Good examples are find, sed or even ps.

(toybox sed can easily kill files because it's 'in-place' option doesn't work as expected...)

But 'busybox mount' doesn't work sometimes on the 8110 - so here it's better to use the built-in 'mount'.

[speeduploop]

There is a 'sqlite3' binary usable in 8110's shell in my cloud-drive if you're in need.

(but be carefull: if you only want to 'look' use the '-readonly' flag to be sure you can't accidently mess something up)

[perry]

@speeduploop how to use sylite3 binary ?

[speeduploop]

It's an unmodified sqlite3 -- so all tutorials/how-tos on the web are matching...

You have copy it to your device... and don't forget exec-rights.

./sqlite3 -readonly /path/to/the/db.sqlite

will open it read-only.

Then it's sqlite commands (starting with a 'dot') -- or SQL to work with the db...

[perry]

I would try to write a script to get the next coming events from the calendar app.

It is right all event are downloaded and saved in a sqlite db ?

[speeduploop]

How about inspecting the DBs of the calender app? Then you would know... ;)

[perry]

okay it's new stuff to learn for me :-)

I think the data is saved in table: object_data -> data

Can I use a js library to read out the sqlite db ?

[speeduploop]

I thinks it's only sqlite on the low-level -- it's indexdb on the higher-level...

I really can't say if it's allowed/possible to open indexdb of another app.

(but IIRC there was such an import/export app for FFOS so there probably is a way to do it)

And yes: developing is reading/learning most of the time...

--> one of my tutors long time ago said: read, read, read, think, think, write... :D

[ProgrammAbel]

I believe the import/export app for Firefox OS simply copied the .sqlite databases somewhere, and then downloaded them onto the new device.

[perry]

I try this api: https://developer.mozilla.org/en-US/docs/Archive/B2G_OS/API/Data_Store_API/Using_the_Data_Store_API

[perry]

to work with database is new for me,

what kind of database are used in FirefoxOS ?

https://stackoverflow.com/questions/23821082/can-i-use-sqlite-in-developing-firefox-os-applications-instead-of-indexeddb

[speeduploop]

as already mentioned...

-- sqlite on backend
-- indexedDB on frontend (javascript)

[perry]

so the indexDB pass the data to sqlite or that are not connected ?

[speeduploop]

The official API on javascript-side is IndexedDB - the browser implements it in sqlite...

(this is only an implementation-detail... they could have choosen any other way to store this data)

[perry]

do you think the calendar events are saved in the indexDB ?

I tried to busybox find /data -name indexDB but without success

[speeduploop]

You still didn't get it...

-- on the javascript-side --> indexedDB API

-- on the linux-side (at least for this version of firefox) --> sqlite-files because the browser uses sqlite to store the date to disk.

(so the browser 'translates' - transparently for the js-devloper - between indexedDB and sqlite)

A normal app would use the indexedDB-API.

(which is a standard API all recent browsers implement and it's well documented - you should probably read the docs)

-- only if this isn't possible you would use sqlite directly - but that's more or less a hack.

[perry]

okay in my case I must use indexDB to read the calendar data,

I dont know the name of the indexDB of the calendar app, 

To open the db : window.indexedDB.open("????", 1);

[speeduploop]

So how about actually reading in calendar.app's sources?

--> should be in there...

[perry]

I tried to read out  indexedDB b2g-calendar but without success, I guess security reason.

But what about to do it with node.js ?

http://www.sqlitetutorial.net/sqlite-nodejs/connect/

/perry

[speeduploop]

First you should check if you need additional permissions to use IndexedDB... WebIDE will show you all possible permissions for the runtime of your phone -- if you find something related to DBs you should try it.

For sqlite from NodeJS you would need to port the NodeJS/sqlite3-module to your phone - then it might work.

(it doesn't seem to be an inbuilt module of NodeJS - so you have to port and provide it to the NodeJS-Runtime on your phone)

[perry]

Is it not the security concept of indexedDb only the app that created the db can read/write it ?

https://developer.mozilla.org/en-US/docs/Web/API/IndexedDB_API/Using_IndexedDB#Security

[speeduploop]

It's your job to read the docs - not mine ;)

But yes and no --> it seems to be restricted - not to the app which created the DB but to appS served from the same domain...

(so if you use an app-path in gaiamobile's domain it could work -- won't get into official store but might work :D )

The browser on the device is quite outdated - so you can't say what works and what not without testing...

-- when it comes to such things you might have to write 5 apps until one works... ;)