# Helpers for accessing Oracle and handling tables
#
# kasemirk@ornl.gov
import sys
sys.path.append("/home/controls/css/lib/ojdbc6_g.jar")


import oracle.jdbc.driver.OracleDriver as Driver
import java.util.Properties

def connect():
    """Connect to Oracle"""
    url = "jdbc:oracle:thin:sns_reports/sns@snsoroda-scan.sns.gov:1521/scprod_controls"
    
    info = java.util.Properties()
    info.put("user", "sns_reports");
    info.put("password", "sns");
    
    return Driver().connect(url, info)


def strclean(txt):
    """Cleanup received text"""
    if txt is None:
        return ""
    return txt.replace("\n", " ").replace("\r", " ")



from java.lang import Runnable
from org.eclipse.jface.dialogs import MessageDialog

class ShowDialog(Runnable):
    """Runnable for displaying dialog off UI thread"""
    def __init__(self, message):
        self.message = message
    def run(self):
        MessageDialog.openInformation(None, "Debug", self.message)
        
class UpdateTable(Runnable):
    """Runnable for updating table off UI thread"""
    def __init__(self, table, data):
        self.table = table
        self.data = data
    def run(self):
        self.table.setContent(self.data)