Ejemplo n.º 1
0
    def query_data_from_mysql(db_path, port, db_name, user_name, pass_wd, table_name,
                              check_list, unique_id_col, unique_id_value):
        """
        mysql conditional query
        return : result DataFrame
        catch all exceptions

        """
        _query_col = ",".join(check_list)
        try:
            _con = ConnectMysql.mysql_connection(db_path, port, user_name, pass_wd, db_name)
            _query_sql = "select %s from %s where %s = %s" % (_query_col, table_name, unique_id_col, unique_id_value)
            data_from_mysql = pd.read_sql(_query_sql, con=_con)
            _con.close()
        except Exception, ex:
            print Exception, ":", ex
            data_from_mysql = pd.DataFrame()
Ejemplo n.º 2
0
    def query_data_from_mysql_mc(db_path, port, db_name, user_name, pass_wd, query_sql):
        """
        mysql conditional query    (query by SQL)
        return : result DataFrame
        catch all exceptions
        usage: pass

        """
        # _query_col = ",".join(check_list)
        try:
            _con = ConnectMysql.mysql_connection(db_path, port, user_name, pass_wd, db_name)
            _query_sql = query_sql
            _data_from_mysql = pd.read_sql(_query_sql, con=_con)
            _con.close()
        except Exception, ex:
            print Exception, ":", ex
            _data_from_mysql = pd.DataFrame()
Ejemplo n.º 3
0
    def query_data_from_mysql_mq(db_path, port, db_name, user_name, pass_wd, table_name, check_list, unique_id_col,
                                 value_list):
        """
        mysql conditional query    use in (multi conditional subquery)
        return : result DataFrame
        catch all exceptions
        usage: pass

        """
        _query_col = ",".join(check_list)
        value_tuple = str(tuple(value_list))
        try:
            _con = ConnectMysql.mysql_connection(db_path, port, user_name, pass_wd, db_name)
            _query_sql = "select %s from %s where %s in %s" % (_query_col, table_name, unique_id_col, value_tuple)
            data_from_mysql = pd.read_sql(_query_sql, con=_con)
            _con.close()
        except Exception, ex:
            print Exception, ":", ex
            data_from_mysql = pd.DataFrame()