[source storage] refactor source sql generation and results handling to allow repository side callbacks for instance with the BytesFileSystemStorage, before this change: * fspath, _fsopen function were stored procedures executed on the database -> files had to be available both on the repository *and* the database host * we needed implementation for each handled database Now, those function are python callbacks executed when necessary on the repository side, on data comming from the database. The litle cons are: * you can't do anymore restriction on mapped attributes * you can't write queries which will return in the same rset column some mapped attributes (or not mapped the same way) / some not This seems much acceptable since: * it's much more easy to handle when you start having the db on another host than the repo * BFSS works seemlessly on any backend now * you don't bother that much about the cons (at least in the bfss case): you usually don't do any restriction on Bytes... Bonus points: BFSS is more efficient (no queries under the cover as it was done in the registered procedure) and we have a much nicer/efficient fspath implementation. IMO, that rocks :D

     1

"""

     2

     3

:organization: Logilab

     4

:copyright: 2001-2009 LOGILAB S.A. (Paris, FRANCE), license is LGPL v2.

     5

:contact: http://www.logilab.fr/ -- mailto:contact@logilab.fr

     6

:license: GNU Lesser General Public License, v2.1 - http://www.gnu.org/licenses

     7

"""

     8

from logilab.common.testlib import unittest_main

     9

from cubicweb.devtools.testlib import CubicWebTC

    10

    11

class BookmarkHooksTC(CubicWebTC):

    12

    13

    14

    def test_auto_delete_bookmarks(self):

    15

        beid = self.execute('INSERT Bookmark X: X title "hop", X path "view", X bookmarked_by U '

    16

                            'WHERE U login "admin"')[0][0]

    17

        self.execute('SET X bookmarked_by U WHERE U login "anon"')

    18

        self.commit()

    19

        self.execute('DELETE X bookmarked_by U WHERE U login "admin"')

    20

        self.commit()

    21

        self.failUnless(self.execute('Any X WHERE X eid %(x)s', {'x': beid}, 'x'))

    22

        self.execute('DELETE X bookmarked_by U WHERE U login "anon"')

    23

        self.commit()

    24

        self.failIf(self.execute('Any X WHERE X eid %(x)s', {'x': beid}, 'x'))

    25

    26

if __name__ == '__main__':

    27

    unittest_main()