Esempi in Python per buildComlunmnsStrForInit

Esempio n. 1

File: reload_as_all_qp.py Progetto: starshineman/frank_python_toolbox

def buildQuerySql(jsonobj,qp_dt):

    importType = jsonobj["sqoop.import-type"]

    if importType == "inc":

        tableName=etl_utils.buildSrcTableName(jsonobj)
        (colsStr,joinColumns,keyColumns) =  etl_utils.buildComlunmnsStrForInit(jsonobj)

        importType = jsonobj["sqoop.import-type"]

        query_template  = sqoop_import_sqlDic[importType]
        qp_dtStr = "'%s'"%(qp_dt,)
        query_sql = query_template%(qp_dtStr,colsStr,tableName)

        print "query_sql:" + query_sql

    return query_sql

Esempio n. 2

File: init_table_data.py Progetto: tanghanerla/frank_python_toolbox

def buildQuerySql(jsonobj):

    importType = jsonobj["sqoop.import-type"]

    if importType == "inc":

        tableName=jsonobj["db.table_name"]

        (colsStr,joinColumns,keyColumns) =  etl_utils.buildComlunmnsStrForInit(jsonobj)

        importType = jsonobj["sqoop.import-type"]

        query_template  = sqoop_import_sqlDic[importType]

        query_sql = query_template%(colsStr,tableName)

        print "query_sql:" + query_sql

    return query_sql

Esempio n. 3

File: load_as_qp.py Progetto: starshineman/frank_python_toolbox

def buildQuerySql(jsonobj):

    importType = jsonobj["sqoop.import-type"]

    if importType == "inc":

        tableName = jsonobj["db.table_name"]

        (colsStr, joinColumns,
         keyColumns) = etl_utils.buildComlunmnsStrForInit(jsonobj)

        importType = jsonobj["sqoop.import-type"]

        query_template = sqoop_import_sqlDic[importType]

        query_sql = query_template % (colsStr, tableName)

        print "query_sql:" + query_sql

    return query_sql