6:29 p.m.
Roger,
please remember to do group-replies.
On Mi, 2011-08-24 at 01:39 +1000, Roger KeIrad wrote:
To solve to the DB schema problem, it will be usefull to implement a
rapper that can be used by anyone who would like to synchronize using
sqlite backend. when the DB schema change only the rapper will
change .
My expectation is that the Synthesis sqlite datastore has a
configuration mechanism. Whether it covers the relevant mapping in this
case would have to be investigated.
can you explain to me what's the iCalendar import/export
mechanism ?
See MAKE/PARSETEXTWITHPROFILE() and how SyncSource uses it.
what 's the part that ensure the mapping from some higher-level
representation of calendar data to the schema ?
The mapping between the internal field list (which is kind of
higher-level) and the iCalendar text format is done via profiles. See
http://syncevolution.org/development/pim-data-synchronization-why-it-so-hard
How it is done with direct sqlite access I don't know. I have never used
or investigated that part. See SySync_config_reference.pdf and search it
for SQL.
--
Best Regards, Patrick Ohly
The content of this message is my personal opinion only and although
I am an employee of Intel, the statements I make here in no way
represent Intel's position on the issue, nor am I authorized to speak
on behalf of Intel on this matter.
8:44 a.m.
New subject: [SyncEvolution] sqlite backend calendar
Hello,
On Aug 23, 2011, at 20:29 , Patrick Ohly wrote:
My expectation is that the Synthesis sqlite datastore has a
configuration mechanism. Whether it covers the relevant mapping in this
case would have to be investigated.
libsynthesis has a SQLite backend built-in, which can be configured in detail. Simplest
form is just mapping elements of the internal field list to SQL table fields (see
<map> in the SySync_config_reference.pdf), but there's support for parent/child
relations (see <array>), programmatic mapping/conversion of special fields using the
built-in script language (<beforewritescript>, <afterreadscript> etc.),
finalisation to resolve inter-item dependencies (<finalisationscript>) at the end of
sync and more.
Have a look at src/sysync_SDK/configs/sunbird_client.xml for a reasonably complex SQLite
based libsynthesis config file. Altough experimental, it added SyncML sync to Mozialla
SunBird/Lightning (early versions only, in the meantime long outdated) without any coding
except for the scripts in the config.
So if your native data representation is SQLite, and you just want to sync that data via
SyncML (and have the engine handle all the iCalendar/vCalendar stuff, as well as all
change detection), just adding your own <datastore type="sql"> to the
config could do the trick.
On the other hand, the SyncEvolution architecture goes way beyond just that, for example
providing other types of sync mechanisms, embedding libsynthesis in a environment which
can communicate via http and OBEX/BT and much more. So it really depends what you're
up to do.
Best Regards,
Lukas Zeller
9:51 a.m.
New subject: [SyncEvolution] sqlite backend calendar
Hello,
i will try to add sqlite calendar management with the same manner than the
addressbook one.
i have a question here, when using ical or vcal synchronization, the
getSynthesisAPI()->getValue() function always return the ical representation
data .
Can this function return the vcalendar representation data when
synchronizing using vcalendar type ?
How can i manage the specific fields between vcalendar and icalendar ?
THX.
10:18 a.m.
New subject: [SyncEvolution] sqlite backend calendar
On Do, 2011-08-25 at 19:51 +1000, Roger KeIrad wrote:
Hello,
i will try to add sqlite calendar management with the same manner than
the addressbook one.
Which "addressbook one"?
i have a question here, when using ical or vcal synchronization, the
getSynthesisAPI()->getValue() function always return the ical
representation data .
I assume you talk about getValue("itemdata") here. That is the mechanism
used to convert the internal field list into a string again for the
backend and make it available.
The content is produced by:
itemdata = MAKETEXTWITHPROFILE(" << info.m_profile << ",
\"" << info.m_backendRule << "\");\n"
in SyncSourceBase::getDatastoreXML().
The MAKETEXTWITHPROFILE() takes a mode parameter which allows choosing
between legacy vCalendar 1.0 and current iCalendar 2.0.
This can be set as part of the info.m_profile value. Instead of
"\"vCalendar\", 2" use "\"vCalendar\", 1".
Can this function return the vcalendar representation data when
synchronizing using vcalendar type ?
How can i manage the specific fields between vcalendar and icalendar ?
They are mapped via the shared field list as defined in the profile.
--
Best Regards, Patrick Ohly
The content of this message is my personal opinion only and although
I am an employee of Intel, the statements I make here in no way
represent Intel's position on the issue, nor am I authorized to speak
on behalf of Intel on this matter.
10:22 a.m.
New subject: [SyncEvolution] sqlite backend calendar
I make a mistake, i mean the SQLiteContact source in sqlite backend .
3475
days inactive
3477
days old
syncevolution@synevolution.org
4 comments
3 participants
participants (3)
-
Lukas Zeller -
Patrick Ohly -
Roger KeIrad