Merge branch '4.2' of https://github.com/southpawtech/TACTIC-DEV into southpawtech-4.2

Conflicts:
	src/pyasm/search/search.py
4.2-105:
  added python tag feature in plugin
BRANCH 4.2-105:
  made sType Creation create a unique constraint instead of index
Merge branch '4.2-105' of https://github.com/southpawtech/TACTIC-DEV into 4.2-105
BRANCH 4.2-105:
   renamed the variable from my.commit to my.commit_now
    Patch for src/pyasm/biz/expression.py bug fetching wrong SObjects in many to many handling

    Affected versions: 4.1.0v03, 4.1.0v04 are the ones I tested

    How to reproduce:
    To be sure there were no site or project specific interferences I dowloaded the 4.1.0.v03 VMware Image from http://community.southpawtech.com/downloads and used the VFX project.
    The easiest way to show the bug is using the Shot planner. Connect to Tactic and open the VFX project, in the sidebar click on "Tools"->"Shot Planner", see the assets and shots section loading into the shot planner tab. Click on "Tools"->Shot Planner" again and keep cliking, at some point, usually after 3 to 5 reloads you'll see a duplicated asset for a specific shot into the "Asset Drop" column. The bug appears randomly every 2 to 5 reloads but gets much worse when the shots and assets number gets higher. Note that the duplicated asset is really referring to another asset, on a shot having "camera001, set001, vehicle001" but showing "camera001, camera001, vehicle001" in the Asset drop if you "click to remove" on the second camera001 it will remove set001

    P.S.
        This was quite a long debug session, took me many hours to follow the flow of tactic code in the pyasm namespace. Tactic's code is huge and I'm not sure I understand all of the implications for this patch.
Merge pull request #11 from southpawtech/4.2

4.2
Patch for src/tactic/ui/table/drop_element_wdg.py bug fetching wrong SObjects in many to many handling

Affected versions: 4.1.0v03, 4.1.0v04 are the ones I tested

How to reproduce:
To be sure there were no site or project specific interferences I dowloaded the 4.1.0.v03 VMware Image from http://community.southpawtech.com/downloads and used the VFX project.
The easiest way to show the bug is using the Shot planner. Connect to Tactic and open the VFX project, in the sidebar click on "Tools"->"Shot Planner", see the assets and shots section loading into the shot planner tab. Click on "Tools"->Shot Planner" again and keep cliking, at some point, usually after 3 to 5 reloads you'll see a duplicated asset for a specific shot into the "Asset Drop" column. The bug appears randomly every 2 to 5 reloads but gets much worse when the shots and assets number gets higher. Note that the duplicated asset is really referring to another asset, on a shot having "camera001, set001, vehicle001" but showing "camera001, camera001, vehicle001" in the Asset drop if you "click to remove" on the second camera001 it will remove set001

As oboreo suggested I'm moving the clear_cache() call from src/pyasm/biz/expression.py to src/tactic/ui/table/drop_element_wdg.py
BRANCH 4.2-105:
   made basic local table keyword search not use a sub select resulting in a faster query
BRANCH 4.2-105:
  made it to alert the user the session has expired followed by a redirection to the login page (page reload)
BRANCH 4.2-105:
  added the missing sthpw/custom_script stype to the search_sobject table
  added this to the upgrade script
BRANCH 4.2-105:
  added support for ' in type for 2 different snapshot instance methods to get file_code or use_naming by type
Merge pull request #12 from southpawtech/4.2-105_signout

4.2 105 signout
from tactic 4.0.1.v04 when trying to save/update a template project an exception is thrown:

SObjectValueException: Column [project_type_code] does not exist in search_object type [sthpw/project]

the "code" column in sthpw/project is expected to be named "project_type_code" because of the sobject_code relation between sthpw/project and sthpw/project_type.
expliciting the from_col in src/pyasm/biz/schema.py solve the problem...
Merge pull request #10 from diegocortassa/master

Patch for src/pyasm/biz/expression.py bug fetching wrong SObjects in many to many handling
BRANCH 4.2-51_delete_trigger:
   added support of delete|<sType> client trigger
   added search_type access rule check when deleting entries
4.2-105:
  added python tag feature in plugin
BRANCH 4.2-105:
  made sType Creation create a unique constraint instead of index
BRANCH 4.2-105:
   renamed the variable from my.commit to my.commit_now
BRANCH 4.2-105:
   made basic local table keyword search not use a sub select resulting in a faster query