annotate frontends/src/tools/xmltools.py @ 853:c2f6ada7858f

core (sqlite): automatic database update: - new Updater class check database consistency (by calculating a hash on the .schema), and updates base if necessary - database now has a version (1 for current, 0 will be for 0.3's database), for each change this version will be increased - creation statements and update statements are in the form of dict of dict with tuples. There is a help text at the top of the module to explain how it works - if we are on a development version, the updater try to update the database automaticaly (without deleting table or columns). The Updater.generateUpdateData method can be used to ease the creation of update data (i.e. the dictionary at the top, see the one for the key 1 for an example). - if there is an inconsistency, an exception is raised, and a message indicate the SQL statements that should fix the situation. - well... this is rather complicated, a KISS method would maybe have been better. The future will say if we need to simplify it :-/ - new DatabaseError exception
author Goffi <goffi@goffi.org>
date Sun, 23 Feb 2014 23:30:32 +0100
parents 1fe00f0c9a91
children 069ad98b360d
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
675
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
1 #!/usr/bin/python
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
2 # -*- coding: utf-8 -*-
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
3
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
4 # SAT: a jabber client
811
1fe00f0c9a91 dates update
Goffi <goffi@goffi.org>
parents: 796
diff changeset
5 # Copyright (C) 2009, 2010, 2011, 2012, 2013, 2014 Jérôme Poisson (goffi@goffi.org)
675
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
6
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
7 # This program is free software: you can redistribute it and/or modify
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
8 # it under the terms of the GNU Affero General Public License as published by
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
9 # the Free Software Foundation, either version 3 of the License, or
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
10 # (at your option) any later version.
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
11
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
12 # This program is distributed in the hope that it will be useful,
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
13 # but WITHOUT ANY WARRANTY; without even the implied warranty of
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
15 # GNU Affero General Public License for more details.
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
16
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
17 # You should have received a copy of the GNU Affero General Public License
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
18 # along with this program. If not, see <http://www.gnu.org/licenses/>.
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
19
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
20 """This library help manage XML used in SàT frontends """
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
21
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
22 # we don't import minidom as a different class can be used in frontends
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
23 # (e.g. NativeDOM in Libervia)
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
24
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
25
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
26 def inlineRoot(doc):
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
27 """ make the root attribute inline
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
28 @param root_node: minidom's Document compatible class
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
29 @return: plain XML
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
30 """
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
31 root_elt = doc.documentElement
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
32 if root_elt.hasAttribute('style'):
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
33 styles_raw = root_elt.getAttribute('style')
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
34 styles = styles_raw.split(';')
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
35 new_styles = []
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
36 for style in styles:
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
37 try:
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
38 key, value = style.split(':')
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
39 except ValueError:
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
40 continue
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
41 if key.strip().lower() == 'display':
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
42 value = 'inline'
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
43 new_styles.append('%s: %s' % (key.strip(), value.strip()))
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
44 root_elt.setAttribute('style', "; ".join(new_styles))
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
45 else:
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
46 root_elt.setAttribute('style', 'display: inline')
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
47 return root_elt.toxml()
abb9a5104de8 new xml tools module (sat.tools.frontends.xml):
Goffi <goffi@goffi.org>
parents:
diff changeset
48