# -*- coding: utf-8 -*-
##############################################################################
#
# Copyright (c) 2005 Nexedi SARL and Contributors. All Rights Reserved.
#                     Ivan Tyagov <ivan@nexedi.com>
#
# WARNING: This program as such is intended to be used by professional
# programmers who take the whole responsability of assessing all potential
# consequences resulting from its eventual inadequacies and bugs
# End users who are looking for a ready-to-use solution with commercial
# garantees and support are strongly adviced to contract a Free Software
# Service Company
#
# This program is Free Software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License
# as published by the Free Software Foundation; either version 2
# of the License, or (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
#
##############################################################################

import unittest
from Testing import ZopeTestCase
from Products.ERP5Type.tests.ERP5TypeTestCase import ERP5TypeTestCase
from Products.ERP5Type.tests.backportUnittest import expectedFailure
from AccessControl.SecurityManagement import newSecurityManager



class TestERP5CatalogSecurityUidOptimization(ERP5TypeTestCase):
  """
    TestERP5CatalogSecurityUidOptimization tests security_uid optmization.
    It is in a different test than TestERP5Catalog as it requires erp5_security_uid_innodb_catalog
    bt5 to be installed in advance.
    XXX: Inherit from TestERP5Catalog so we test default and security_uid optmization with same tests.
  """
    
  business_template_list = ['erp5_security_uid_innodb_catalog',
                            'erp5_full_text_myisam_catalog','erp5_base']

  def getBusinessTemplateList(self):
    return self.business_template_list
    
  def afterSetUp(self):
    self.login()
    portal = self.getPortal()

  def test_local_roles_group_id_on_role_information(self):
    """Test usage of local_roles_group_id when searching catalog.
    """
    sql_connection = self.getSQLConnection()
    sql_catalog = self.portal.portal_catalog.getSQLCatalog()

    # Add a catalog table (uid, alternate_security_uid)
    sql_connection.manage_test(
      """DROP TABLE IF EXISTS alternate_roles_and_users""")

    sql_connection.manage_test("""
CREATE TABLE alternate_roles_and_users (
  `uid` BIGINT UNSIGNED NOT NULL,
  `alternate_security_uid` INT UNSIGNED) """)

    # make it a search table
    current_sql_search_tables = sql_catalog.sql_search_tables
    sql_catalog.sql_search_tables = sql_catalog.sql_search_tables + [
      'alternate_roles_and_users']

    # Configure sql method to insert this table
    sql_catalog.manage_addProduct['ZSQLMethods'].manage_addZSQLMethod(
          id='z_catalog_alternate_roles_and_users_list',
          title='',
          connection_id='erp5_sql_connection',
          arguments="\n".join(['uid', 'alternate_security_uid']),
          template="""REPLACE INTO alternate_roles_and_users VALUES
<dtml-in prefix="loop" expr="_.range(_.len(uid))">
( <dtml-sqlvar expr="uid[loop_item]" type="int">,
  <dtml-sqlvar expr="alternate_security_uid[loop_item]" type="int" optional>
)<dtml-unless sequence-end>,</dtml-unless>
</dtml-in>""")

    current_sql_catalog_object_list = sql_catalog.sql_catalog_object_list
    sql_catalog.sql_catalog_object_list = \
      current_sql_catalog_object_list + \
         ('z_catalog_alternate_roles_and_users_list',)

    # configure Alternate local roles group id to go in alternate_security_uid
    current_sql_catalog_security_uid_columns =\
      sql_catalog.sql_catalog_security_uid_columns
    sql_catalog.sql_catalog_security_uid_columns = (
      ' | security_uid',
      'Alternate | alternate_security_uid', )

    # add category
    self.portal.portal_categories.local_role_group.newContent(
      portal_type='Category', 
      reference = 'Alternate',
      id = 'Alternate')

    # configure security on person, each user will be able to see his own
    # person thanks to an Auditor role on "Alternate" local roles group id.
    self.portal.portal_types.Person.newContent(
      portal_type='Role Information',
      role_name='Auditor',
      role_base_category_script_id='ERP5Type_getSecurityCategoryFromSelf',
      role_base_category='agent',
      local_role_group_value=self.portal.portal_categories.local_role_group.Alternate.getRelativeUrl())

    self.portal.portal_caches.clearAllCache()
    self.tic()

    try:
      # create two persons and users
      user1 = self.portal.person_module.newContent(portal_type='Person',
        reference='user1')
      user1.newContent(portal_type='Assignment').open()
      user1.updateLocalRolesOnSecurityGroups()
      self.assertEquals(user1.__ac_local_roles__.get('user1'), ['Auditor'])

      user2 = self.portal.person_module.newContent(portal_type='Person',
        reference='user2')
      user2.newContent(portal_type='Assignment').open()
      user2.updateLocalRolesOnSecurityGroups()
      self.assertEquals(user2.__ac_local_roles__.get('user2'), ['Auditor'])
      self.tic()

      # security_uid_dict in catalog contains entries for user1 and user2:
      user1_alternate_security_uid = sql_catalog.security_uid_dict[
        ('Alternate', ('user:user1', 'user:user1:Auditor'))]
      bob_alternate_security_uid = sql_catalog.security_uid_dict[
        ('Alternate', ('user:user2', 'user:user2:Auditor'))]

      # those entries are in alternate security table
      alternate_roles_and_users = sql_connection.manage_test(
        "SELECT * from alternate_roles_and_users").dictionaries()
      self.assertTrue(dict(uid=user1.getUid(),
                           alternate_security_uid=user1_alternate_security_uid) in
                      alternate_roles_and_users)
      self.assertTrue(dict(uid=user2.getUid(),
                           alternate_security_uid=bob_alternate_security_uid) in
                      alternate_roles_and_users)

      # low level check of the security query of a logged in user
      self.login('user1')
      security_query = self.portal.portal_catalog.getSecurityQuery()
      # This query is a complex query wrapping another complex query with a
      # criterion on altenate_security_uid. This check is quite low level and
      # is subject to change.
      security_uid_query = security_query.query_list[0]
      alternate_security_query, = [q for q in
          security_query.query_list[0].query_list if
          q.kw.get('alternate_security_uid')]
      self.assertEquals([user1_alternate_security_uid],
        alternate_security_query.kw['alternate_security_uid'])

      # high level check that that logged in user can see document
      self.assertEquals([user1],
        [o.getObject() for o in self.portal.portal_catalog(portal_type='Person')])
      # also with local_roles= argument which is used in worklists
      self.assertEquals([user1],
        [o.getObject() for o in self.portal.portal_catalog(portal_type='Person',
          local_roles='Auditor')])

      # searches still work for other users
      self.login('ERP5TypeTestCase')
      self.assertSameSet([user1, user2],
        [o.getObject() for o in
          self.portal.portal_catalog(portal_type='Person')])

    finally:
      # restore catalog configuration
      sql_catalog.sql_search_tables = current_sql_search_tables
      sql_catalog.sql_catalog_object_list = current_sql_catalog_object_list
      sql_catalog.sql_catalog_security_uid_columns =\
        current_sql_catalog_security_uid_columns
      self.portal.portal_types.Person.manage_delObjects(
        [role.getId() for role in
        self.portal.portal_types.Person.contentValues(
          portal_type='Role Information')])

def test_suite():
  suite = unittest.TestSuite()
  suite.addTest(unittest.makeSuite(TestERP5CatalogSecurityUidOptimization))
  return suite