Python SQLCommon Beispiele

Beispiel #1

def test_blob():
    common = SQLCommon(app_config,
                       table_name=BLOB_TABLE_NAME,
                       table_def=blob_fields)

    common.test_createtable()

    common.test_insert_blob(PostgreSQL96Dialect.make_blob)

Beispiel #2

def test_blob():
    common = SQLCommon(app_config,
                       inspect_cols_query=FIND_COLUMNS_STMT,
                       table_name=BLOB_TABLE_NAME.upper(),
                       table_def=blob_fields)

    common.test_createtable()

    common.test_insert_blob(None)

Beispiel #3

Datei: test_sqlite.py Projekt: lizhecht/resilient-community-apps

def test_blob():
    common = SQLCommon(app_config,
                       table_name=BLOB_TABLE_NAME,
                       inspect_cols_query=FIND_COLUMNS_STMT,
                       table_def=blob_fields,
                       baseClass=SQLiteFeedDestination)

    common.test_createtable()

    common.test_insert_blob(SqliteDialect.make_blob)

Beispiel #4

Datei: test_sqlite.py Projekt: lizhecht/resilient-community-apps

def test_insert_row():
    common = SQLCommon(app_config,
                       inspect_cols_query=FIND_COLUMNS_STMT,
                       baseClass=SQLiteFeedDestination)

    common.test_insert_row(result_payload)

Beispiel #5

Datei: test_sqlite.py Projekt: lizhecht/resilient-community-apps

def test_get_parameters():
    common = SQLCommon(app_config,
                       inspect_cols_query=FIND_COLUMNS_STMT,
                       baseClass=SQLiteFeedDestination)

    common.test_get_parameters()

Beispiel #6

def test_droptable():
    common = SQLCommon(app_config)

    common.test_droptable()

Beispiel #7

def test_altertable():
    common = SQLCommon(app_config)

    common.test_altertable()

Beispiel #8

def test_delete_row():
    common = SQLCommon(app_config)

    common.test_delete_row()

Beispiel #9

def test_insert_row():
    common = SQLCommon(app_config,
                       inspect_cols_query=FIND_COLUMNS_STMT,
                       table_name='ALL_TYPES')

    common.test_insert_row(result_payload)

Beispiel #10

def test_insert_row():
    common = SQLCommon(app_config, setup_stmt=SETUP_STMT)

    common.test_insert_row(result_payload)

Beispiel #11

def test_createtable():
    common = SQLCommon(app_config)

    common.test_createtable()

Beispiel #12

def test_get_parameters():
    common = SQLCommon(app_config)

    common.test_get_parameters()

Beispiel #13

def test_droptable():
    common = SQLCommon(app_config,
                       inspect_cols_query=FIND_COLUMNS_STMT,
                       table_name='ALL_TYPES')

    common.test_droptable()

Beispiel #14

def test_altertable():
    common = SQLCommon(app_config,
                       inspect_cols_query=FIND_COLUMNS_STMT,
                       table_name='ALL_TYPES')

    common.test_altertable(col_type='NVARCHAR2(2000)')

Beispiel #15

def test_update_row():
    common = SQLCommon(app_config,
                       inspect_cols_query=FIND_COLUMNS_STMT,
                       table_name='ALL_TYPES')

    common.test_update_row(MAX_TEXT_SIZE, result_payload)

Beispiel #16

Datei: test_sqlite.py Projekt: lizhecht/resilient-community-apps

def test_update_row():
    common = SQLCommon(app_config,
                       inspect_cols_query=FIND_COLUMNS_STMT,
                       baseClass=SQLiteFeedDestination)

    common.test_update_row(MAX_TEXT_SIZE, result_payload)

Beispiel #17

Datei: test_sqlite.py Projekt: lizhecht/resilient-community-apps

def test_altertable():
    common = SQLCommon(app_config,
                       inspect_cols_query=FIND_COLUMNS_STMT,
                       baseClass=SQLiteFeedDestination)

    common.test_altertable()

Beispiel #18

def test_update_row():
    common = SQLCommon(app_config, setup_stmt=SETUP_STMT)

    common.test_update_row(MAX_TEXT_SIZE, result_payload)