[ViewVC] Diff of: ns_dev/Python/NinoCode/Tool

Comparing Python/NinoCode/Tool_Box/EclipseSQLLib.py (file contents):
Revision 670 by nino.borges, Thu Dec 12 20:43:50 2019 UTC vs.
Revision 671 by nino.borges, Mon Jan 20 22:42:16 2020 UTC

+class Eclipse_Connection(object):
+    """An Advanced Eclipse Connection Library and Toolkit"""
-<
+    version = '0.6.0'
->
+    version = '0.7.0'
->
+    sqlUserName = "eborges"
->
->
+    ## Only add when compiling!!!
->
+    sqlPassword = ''
->
->
+    def __init__(self):
+        self.caseMatrix = None
+        self.tagGroupToTagNameMatrix = None
+        self._UpdateCaseMatrix()
+        print "\nEclipse SQL Library Initialized.\n\nCreated by Emanuel Borges\nVersion %s\n\n"% self.version
-+
-+
+    def _GetNewCnxn(self, internalCaseName):
-+
+        """A simple funtion, not method and does not update any instance vars, to grab a new cnxn connection.  Just to have one place to keep this line updated"""
-+
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;Trusted_Connection=yes;"%internalCaseName)
-+
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;UID=%s;PWD=%s;Trusted_Connection=NO;"%(internalCaseName,self.sqlUserName, self.sqlPassword))
-+
+        return cnxn
+    def _UpdateCaseMatrix(self):
+        """Will normally run only once when initiated, which populates the case Matrix and the sorted case list."""
+        matrix = {}
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=AddConfig;""Trusted_Connection=yes;")
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=AddConfig;""Trusted_Connection=yes;")
->
+        cnxn = self._GetNewCnxn('AddConfig')
+        cursor = cnxn.cursor()
+        cursor.execute('select name,databasename from Enterprise.CaseProductEnvironment where ProductId=3')
+        batchSetList = []
+        internalCaseName = self.caseMatrix[self.currentDatabaseName]
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        cnxn = self._GetNewCnxn(internalCaseName)
+        cursor = cnxn.cursor()
+        cursor.execute('SELECT ReviewPassName FROM Review.ReviewPass ORDER BY ReviewPassName')
+        internalCaseName = self.caseMatrix[self.currentDatabaseName]
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        cnxn = self._GetNewCnxn(internalCaseName)
+        cursor = cnxn.cursor()
+        cursor.execute("SELECT TagGroups.TagGroupName, Tags.TagName, TagGroupsDetail.TagGroupId, TagGroupsDetail.TagId FROM TagGroups INNER JOIN TagGroupsDetail ON TagGroups.TagGroupId = TagGroupsDetail.TagGroupId INNER JOIN Tags ON TagGroupsDetail.TagId = Tags.TagId")
+        internalCaseName = self.caseMatrix[self.currentDatabaseName]
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        cnxn = self._GetNewCnxn(internalCaseName)
+        cursor = cnxn.cursor()
+        cursor.execute("SELECT Tags.TagName, Documents.DocumentKey FROM TagGroupsDetail INNER JOIN TagGroups ON TagGroupsDetail.TagGroupId = TagGroups.TagGroupId INNER JOIN Tags ON TagGroupsDetail.TagId = Tags.TagId INNER JOIN DocumentTags ON Tags.TagId = DocumentTags.TagId INNER JOIN Documents ON DocumentTags.DocId = Documents.DocId WHERE (Tags.TagName = '%s') ORDER BY DocumentKey"% tagName)
+        internalCaseName = self.caseMatrix[caseName]
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        cnxn = self._GetNewCnxn(internalCaseName)
+        cursor = cnxn.cursor()
+        cursor.execute('SELECT TableName, ColumnName, FieldName FROM vFieldDefinition')
+        internalCaseName = self.caseMatrix[self.currentDatabaseName]
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        cnxn = self._GetNewCnxn(internalCaseName)
+        cursor = cnxn.cursor()
+        internalTableName, internalFieldName = self.fieldMatrix[fieldName]
+        internalCaseName = self.caseMatrix[self.currentDatabaseName]
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        cnxn = self._GetNewCnxn(internalCaseName)
+        cursor = cnxn.cursor()
+        cursor.execute('Select  top 10000 b.CategoryName, c.DocumentKey, a.IsEntireDocument, a.DocumentText FROM Analytics.CategoryExemplarDocument a left join [Analytics].[Category] b on b.CategoryId=a.CategoryId left join dbo.documents c on c.docid=a.docid order by 2 asc')
+        """Returns the total production size, in GB, for a production with the volume of the voumeValue you give it. It rounds the number and, if you are under .01 it will just make it .01. Finally also returns 0.0 if the value was empty."""
+        internalCaseName = self.caseMatrix[self.currentDatabaseName]
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        cnxn = self._GetNewCnxn(internalCaseName)
+        cursor = cnxn.cursor()
+        internalProdVolTableName, internalProdVolFieldName = self.fieldMatrix[prodVolFieldName]
+        """Updates the endDocField, filtering by a tag, but only the null value ones, by copying from the evidoxID field"""
+        internalCaseName = self.caseMatrix[self.currentDatabaseName]
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        cnxn = self._GetNewCnxn(internalCaseName)
+        cursor = cnxn.cursor()
+        cursor.execute("SELECT Tags.TagName, Documents.DocumentKey FROM TagGroupsDetail INNER JOIN TagGroups ON TagGroupsDetail.TagGroupId = TagGroups.TagGroupId INNER JOIN Tags ON TagGroupsDetail.TagId = Tags.TagId INNER JOIN DocumentTags ON Tags.TagId = DocumentTags.TagId INNER JOIN Documents ON DocumentTags.DocId = Documents.DocId WHERE (Tags.TagName = '%s') ORDER BY DocumentKey"% tagName)
+        """Updates the batch reviewed status flag for a particular batch set by name. default is to query only, which wont actually do any updates and only return the count"""
+        internalCaseName = self.caseMatrix[self.currentDatabaseName]
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        cnxn = self._GetNewCnxn(internalCaseName)
+        cursor = cnxn.cursor()
+        """Generates a pipe delimited report from the saved searches"""
+        internalCaseName = self.caseMatrix[self.currentDatabaseName]
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        cnxn = self._GetNewCnxn(internalCaseName)
+        cursor = cnxn.cursor()
+        ##  First grab the parent folder matrix and prepopulate the -1 and 0 folders
+        """Runs a database defrag on the current database.  default is viewonly, which wont actually run it.  overide by setting to false to run"""
+        internalCaseName = self.caseMatrix[self.currentDatabaseName]
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        cnxn = self._GetNewCnxn(internalCaseName)
+        cursor = cnxn.cursor()
+        ##  with the db selected, now execute the sp_updatestats part
+        cnxn.close()
+        print "SP_UpdateStats finished."
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=evdxAdmin;""Trusted_Connection=yes;")
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=evdxAdmin;""Trusted_Connection=yes;")
->
+        cnxn = self._GetNewCnxn('evdxAdmin')
+        cursor = cnxn.cursor()
+        cursor.execute("exec ap_rebuildindexes @databasename = '%s'"%internalCaseName)
+        print "rebuildIndexes finished"
-<
+        cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        #cnxn = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};""Server=XIPRORVW01\XIPRORVW01;""Database=%s;""Trusted_Connection=yes;"%internalCaseName)
->
+        cnxn = self._GetNewCnxn(internalCaseName)
+        cursor = cnxn.cursor()
+        ##  Now read and run the rest by way of a blob.

Diff Legend

-–
+Removed lines
-+
+Added lines
-<
+Changed lines (old)
->
+Changed lines (new)

Comparing Python/NinoCode/Tool_Box/EclipseSQLLib.py (file contents): Revision 670 by nino.borges, Thu Dec 12 20:43:50 2019 UTC vs. Revision 671 by nino.borges, Mon Jan 20 22:42:16 2020 UTC

Diff Legend

Comparing Python/NinoCode/Tool_Box/EclipseSQLLib.py (file contents):
Revision 670 by nino.borges, Thu Dec 12 20:43:50 2019 UTC vs.
Revision 671 by nino.borges, Mon Jan 20 22:42:16 2020 UTC