Example #1
0
def fetch_row(conn_config,sql):
    
    start_time=helper_regex.get_time_clock_time()
    start_time_str=helper_regex.get_time_str_now()
    script_file_name=helper_regex.get_script_file_name()

    try:
        conn = get_db(conn_config)
        helper_mysql.log_execution_info(script_file_name,sql,start_time,error_msg='',start_time_str=start_time_str)
        return conn.execute_row(sql)
    except Exception,e:
        print 'failed:'+str(e)
        print "Unexpected error:", sys.exc_info()[0]
        print sql
        print 'SQL Server error happened !!!'
        helper_mysql.log_execution_info(script_file_name,sql,start_time,error_msg=sys.exc_info()[0],start_time_str=start_time_str)
        return -1
Example #2
0
def execute(conn_config,sql,log_sql=True):
    conn = get_db(conn_config)
    
    start_time=helper_regex.get_time_clock_time()
    start_time_str=helper_regex.get_time_str_now()
    script_file_name=helper_regex.get_script_file_name()

    #print dir(conn)
    conn.execute_non_query(sql)
    if log_sql:
        helper_mysql.log_execution_info(script_file_name,sql,start_time,error_msg='',start_time_str=start_time_str)
    return conn.identity or conn.rows_affected
    try:
        pass
    except Exception,e:
        print 'failed:'+str(e)
        print "Unexpected error:", sys.exc_info()[0]
        print sql
        print 'SQL Server error happened !!!'
        helper_mysql.log_execution_info(script_file_name,sql,start_time,error_msg=sys.exc_info()[0],start_time_str=start_time_str)
        return -1
Example #3
0
def fetch_joined_array(conn_config,sql,seperator=''):
    
    start_time=helper_regex.get_time_clock_time()
    start_time_str=helper_regex.get_time_str_now()
    script_file_name=helper_regex.get_script_file_name()

    try:
        conn = get_db(conn_config)
        rows=conn.execute_query(sql)
        helper_mysql.log_execution_info(script_file_name,sql,start_time,error_msg='',start_time_str=start_time_str)

        array=[]
        for row in conn:
            array.append(row[0])
                
        return seperator.join(array)
    except Exception,e:
        print 'failed:'+str(e)
        print "Unexpected error:", sys.exc_info()[0]
        print sql
        print 'SQL Server error happened !!!'
        helper_mysql.log_execution_info(script_file_name,sql,start_time,error_msg=sys.exc_info()[0],start_time_str=start_time_str)
        return -1
Example #4
0
def fetch_rows_dict(conn_config,sql,key_name=0):
    
    start_time=helper_regex.get_time_clock_time()
    start_time_str=helper_regex.get_time_str_now()
    script_file_name=helper_regex.get_script_file_name()

    try:
        conn = get_db(conn_config)
        rows=conn.execute_query(sql)
        helper_mysql.log_execution_info(script_file_name,sql,start_time,error_msg='',start_time_str=start_time_str)
        dict={}
        for row in conn:
            dict[str(row[key_name])]=row
                
        return dict

    except Exception,e:
        print 'failed:'+str(e)
        print "Unexpected error:", sys.exc_info()[0]
        print sql
        print 'SQL Server error happened !!!'
        helper_mysql.log_execution_info(script_file_name,sql,start_time,error_msg=sys.exc_info()[0],start_time_str=start_time_str)
        return -1
Example #5
0
def fetch_set(conn_config,sql):
    
    start_time=helper_regex.get_time_clock_time()
    start_time_str=helper_regex.get_time_str_now()
    script_file_name=helper_regex.get_script_file_name()

    conn = get_db(conn_config)
    rows=conn.execute_query(sql)
    helper_mysql.log_execution_info(script_file_name,sql,start_time,error_msg='',start_time_str=start_time_str)
    ret=set([])
    for row in conn:
        ret.add(row[0])
    return ret

    try:
        pass
    except Exception,e:
        print 'failed:'+str(e)
        print "Unexpected error:", sys.exc_info()[0]
        print sql
        print 'SQL Server error happened !!!'
        helper_mysql.log_execution_info(script_file_name,sql,start_time,error_msg=sys.exc_info()[0],start_time_str=start_time_str)
        return -1
Example #6
0
def fetch_dict(conn_config,sql,key_name=0,value_name=1,use_interger_key=False):
    
    start_time=helper_regex.get_time_clock_time()
    start_time_str=helper_regex.get_time_str_now()
    script_file_name=helper_regex.get_script_file_name()

    sql=str(sql)

    conn = get_db(conn_config)
    rows=conn.execute_query(sql)
    helper_mysql.log_execution_info(script_file_name,sql,start_time,error_msg='',start_time_str=start_time_str)
    dict={}
    counter=0
    if use_interger_key:
        for row in conn:
            dict[row[key_name]]=row[value_name]
            #counter+=1
            #if counter % 100000 ==0:
            #    print counter
            
    else:
        for row in conn:
            dict[str(row[key_name])]=row[value_name]
            #counter+=1
            #if counter % 100000 ==0:
            #    print counter
            
    return dict
    try:
        pass
    except Exception,e:
        print 'failed:'+str(e)
        print "Unexpected error:", sys.exc_info()[0]
        print sql
        print 'SQL Server error happened !!!'
        helper_mysql.log_execution_info(script_file_name,sql,start_time,error_msg=sys.exc_info()[0],start_time_str=start_time_str)
        return -1