Python delete_table 예제들

예제 #1

    def setUp(self):
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_CHECK_HISTORY):
            db_utils.delete_table(Tables.PM_CHECK_HISTORY)

        # create table
        mock_pm_checkHistory.create_table()

예제 #2

    def setUp(self):
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_EMAIL_CHANGE_APPLY):
            db_utils.delete_table(Tables.PM_EMAIL_CHANGE_APPLY)

        # create PM_EmailChangeApply table
        mock_pm_emailChangeApply.create_table()

예제 #3

    def setUp(self):
        super().setUp()

        # truncate data old table
        if db_utils.check_table_exist(Tables.PM_USER_ATTRIBUTE):
            db_utils.delete_table(Tables.PM_USER_ATTRIBUTE)

        # create pm_userAttribute table
        mock_pm_userAttribute.create_table()

예제 #4

    def setUp(self):
        super().setUp()

        # truncate data old table
        if db_utils.check_table_exist(Tables.PM_EMAIL_CHANGE_APPLY):
            db_utils.delete_table(Tables.PM_EMAIL_CHANGE_APPLY)

        # create pm_emailchangeapply table
        mock_pm_emailchangeapply.create_table()

예제 #5

    def setUp(self):
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_AWSACCOUNTCOOPS):
            db_utils.delete_table(Tables.PM_AWSACCOUNTCOOPS)

        # create table
        mock_pm_awsAccountCoops.create_table()

예제 #6

파일: test_check_cis_item_1_22.py 프로젝트: phamkhachoa/prjs_sample

    def setUp(self):
        super().setUp()
        global session
        global excluded_resources

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_EXCLUSION_RESOURCES):
            db_utils.delete_table(Tables.PM_EXCLUSION_RESOURCES)

        # create pm_userAttribute table
        mock_pm_exclusionResources.create_table()

        # create record query
        # create resource for check code item 1.22 resource type = "user"
        data_pm_exclusion_resources[
            'ExclusionResourceID'] = "aa4fee9c-790f-478d-9f5d-7aeef688d541"
        data_pm_exclusion_resources['CheckItemCode'] = check_item_code
        data_pm_exclusion_resources['RegionName'] = region_global
        data_pm_exclusion_resources['ResourceType'] = resource_type_users
        data_pm_exclusion_resources[
            'ResourceName'] = "insightwatch-190611-ContentProtectedReadOnlyPolicy-YDBNQDSP9W1M,PolicyUsers1"
        data_pm_exclusion_resources['OrganizationID'] = organization_id
        data_pm_exclusion_resources['ProjectID'] = project_id
        data_pm_exclusion_resources['AWSAccount'] = aws_account
        data_pm_exclusion_resources['AccountRefineCode'] = account_refine_code
        data_pm_exclusion_resources[
            'CheckItemRefineCode'] = check_item_refine_code
        mock_pm_exclusionResources.create(data_pm_exclusion_resources)

        # create resource for check code item 1.22 resource type = "group"
        data_pm_exclusion_resources[
            'ExclusionResourceID'] = "aa4fee9c-790f-478d-9f5d-7aeef688d542"
        data_pm_exclusion_resources[
            'ResourceName'] = "insightwatch-190611-ContentProtectedReadOnlyPolicy-YDBNQDSP9W1M,PolicyGroups2"
        data_pm_exclusion_resources['ResourceType'] = resource_type_groups
        mock_pm_exclusionResources.create(data_pm_exclusion_resources)

        # create resource for check code item 1.22 resource type = "role"
        data_pm_exclusion_resources[
            'ExclusionResourceID'] = "aa4fee9c-790f-478d-9f5d-7aeef688d543"
        data_pm_exclusion_resources[
            'ResourceName'] = "insightwatch-190611-ContentProtectedReadOnlyPolicy-YDBNQDSP9W1M,PolicyRoles3"
        data_pm_exclusion_resources['ResourceType'] = resource_type_roles
        mock_pm_exclusionResources.create(data_pm_exclusion_resources)

        # create resource for check code item other
        data_pm_exclusion_resources[
            'ExclusionResourceID'] = "aa4fee9c-790f-478d-9f5d-7aeef688d544"
        data_pm_exclusion_resources['CheckItemCode'] = "CHECK_CIS12_ITEM_OTHER"
        mock_pm_exclusionResources.create(data_pm_exclusion_resources)

        # get data excluded resource
        excluded_resources = mock_pm_exclusionResources.query_account_refine_index(
            trace_id, account_refine_code)

        if session is None:
            session = sts_utils.create_session()

예제 #7

파일: test_pm_checkResultItems.py 프로젝트: phamkhachoa/prjs_sample

    def setUp(self):
        # parent setUp()
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_CHECK_RESULT_ITEMS):
            db_utils.delete_table(Tables.PM_CHECK_RESULT_ITEMS)

        # create pm_checkResultItems table
        mock_pm_checkResultItems.create_table()

예제 #8

    def setUp(self):
        # parent setUp()
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_EXCLUSION_RESOURCES):
            db_utils.delete_table(Tables.PM_EXCLUSION_RESOURCES)

        # create pm_exclusionResources table
        mock_pm_exclusionResources.create_table()

예제 #9

파일: test_execute_security_check_webhook_handler.py 프로젝트: phamkhachoa/prjs_sample

    def setUp(self):
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_SECURITY_CHECK_WEBHOOK):
            db_utils.delete_table(Tables.PM_SECURITY_CHECK_WEBHOOK)
        if db_utils.check_table_exist(
                Tables.PM_SECURITY_CHECK_WEBHOOK_CALL_HISTORY):
            db_utils.delete_table(
                Tables.PM_SECURITY_CHECK_WEBHOOK_CALL_HISTORY)
        if db_utils.check_table_exist(Tables.PM_PROJECTS):
            db_utils.delete_table(Tables.PM_PROJECTS)
        if db_utils.check_table_exist(Tables.PM_CHECK_HISTORY):
            db_utils.delete_table(Tables.PM_CHECK_HISTORY)

        # create table
        mock_pm_projects.create_table()
        mock_pm_checkHistory.create_table()
        mock_pm_securityCheckWebhook.create_table()
        mock_pm_securityCheckWebhookCallHistory.create_table()

        # create data table pm_project
        mock_pm_projects.create(data_pm_project)

        # create data pm_security_check_webhooks
        for data_pm_security_check_webhooks in list_data_pm_security_check_webhooks:
            mock_pm_securityCheckWebhook.create(
                data_pm_security_check_webhooks)

        # create data pm_securityCheckWebhookCallHistory
        for data_pm_security_check_webhook_call_history in list_data_pm_security_check_webhook_call_historys:
            mock_pm_securityCheckWebhookCallHistory.create(
                data_pm_security_check_webhook_call_history)

예제 #10

파일: test_execute_send_checkerror_email_handler.py 프로젝트: phamkhachoa/prjs_sample

    def setUp(self):
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_PROJECTS):
            db_utils.delete_table(Tables.PM_PROJECTS)
        if db_utils.check_table_exist(Tables.PM_ORGANIZATIONS):
            db_utils.delete_table(Tables.PM_ORGANIZATIONS)

        # create table
        mock_pm_projects.create_table()
        mock_pm_organizations.create_table()

        # create data table
        mock_pm_projects.create(data_pm_project)
        mock_pm_organizations.create(data_pm_organization)

예제 #11

파일: test_check_cis_item_2_08.py 프로젝트: phamkhachoa/prjs_sample

    def setUp(self):
        super().setUp()

        global session
        global excluded_resources
        global kms_client_connect
        if not session:
            session = sts_utils.create_session()

        if not kms_client_connect:
            kms_client_connect = kms_utils.client_connect()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_EXCLUSION_RESOURCES):
            db_utils.delete_table(Tables.PM_EXCLUSION_RESOURCES)

        # create pm_exclusionResources table
        mock_pm_exclusionResources.create_table()

        # create record query
        # create resource for check code item 2.08
        data_pm_exclusion_resources[
            'ExclusionResourceID'] = "aa4fee9c-790f-478d-9f5d-7aeef688d541"
        data_pm_exclusion_resources['CheckItemCode'] = check_item_code
        data_pm_exclusion_resources['RegionName'] = region_name
        data_pm_exclusion_resources['ResourceType'] = resource_type
        data_pm_exclusion_resources['ResourceName'] = resource_name_test
        data_pm_exclusion_resources['OrganizationID'] = organization_id
        data_pm_exclusion_resources['ProjectID'] = project_id
        data_pm_exclusion_resources['AWSAccount'] = aws_account
        data_pm_exclusion_resources['AccountRefineCode'] = account_refine_code
        data_pm_exclusion_resources[
            'CheckItemRefineCode'] = check_item_refine_code
        mock_pm_exclusionResources.create(data_pm_exclusion_resources)

        # create resource for check code item other
        data_pm_exclusion_resources[
            'ExclusionResourceID'] = "aa4fee9c-790f-478d-9f5d-7aeef688d542"
        data_pm_exclusion_resources['CheckItemCode'] = "CHECK_CIS12_ITEM_OTHER"
        mock_pm_exclusionResources.create(data_pm_exclusion_resources)

        # get data excluded resource
        excluded_resources = mock_pm_exclusionResources.query_account_refine_index(
            trace_id, account_refine_code)

예제 #12

파일: test_get_check_awsaccounts_handler.py 프로젝트: phamkhachoa/prjs_sample

    def setUp(self):
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_CHECK_HISTORY):
            db_utils.delete_table(Tables.PM_CHECK_HISTORY)
        if db_utils.check_table_exist(Tables.PM_PROJECTS):
            db_utils.delete_table(Tables.PM_PROJECTS)
        if db_utils.check_table_exist(Tables.PM_AWSACCOUNTCOOPS):
            db_utils.delete_table(Tables.PM_AWSACCOUNTCOOPS)
        if db_utils.check_table_exist(Tables.PM_ORGANIZATIONS):
            db_utils.delete_table(Tables.PM_ORGANIZATIONS)
        if db_utils.check_table_exist(Tables.PM_CHECK_RESULTS):
            db_utils.delete_table(Tables.PM_CHECK_RESULTS)

        # create table
        mock_pm_checkHistory.create_table()
        mock_pm_projects.create_table()
        mock_pm_awsAccountCoops.create_table()
        mock_pm_organizations.create_table()
        mock_pm_checkResults.create_table()

예제 #13

    def setUp(self):
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_AFFILIATION):
            db_utils.delete_table(Tables.PM_AFFILIATION)
        if db_utils.check_table_exist(Tables.PM_AWSACCOUNTCOOPS):
            db_utils.delete_table(Tables.PM_AWSACCOUNTCOOPS)
        if db_utils.check_table_exist(Tables.PM_CHECK_RESULT_ITEMS):
            db_utils.delete_table(Tables.PM_CHECK_RESULT_ITEMS)
        if db_utils.check_table_exist(Tables.PM_LATEST_CHECK_RESULT):
            db_utils.delete_table(Tables.PM_LATEST_CHECK_RESULT)

        # create table
        mock_pm_affiliation.create_table()
        mock_pm_awsAccountCoops.create_table()
        mock_pm_checkResultItems.create_table()
        mock_pm_latestCheckResult.create_table()

예제 #14

    def setUp(self):
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_AFFILIATION):
            db_utils.delete_table(Tables.PM_AFFILIATION)
        if db_utils.check_table_exist(Tables.PM_AWSACCOUNTCOOPS):
            db_utils.delete_table(Tables.PM_AWSACCOUNTCOOPS)
        if db_utils.check_table_exist(Tables.PM_ASSESSMENT_ITEMS):
            db_utils.delete_table(Tables.PM_ASSESSMENT_ITEMS)

        # create table
        mock_pm_affiliation.create_table()
        mock_pm_awsAccountCoops.create_table()
        mock_pm_assessmentItems.create_table()

예제 #15

    def setUp(self):
        super().setUp()

        # truncate data old table
        if db_utils.check_table_exist(Tables.PM_AFFILIATION):
            db_utils.delete_table(Tables.PM_AFFILIATION)
        if db_utils.check_table_exist(Tables.PM_EXCLUSION_RESOURCES):
            db_utils.delete_table(Tables.PM_EXCLUSION_RESOURCES)
        if db_utils.check_table_exist(Tables.PM_AWSACCOUNTCOOPS):
            db_utils.delete_table(Tables.PM_AWSACCOUNTCOOPS)

        # create table
        mock_pm_affiliation.create_table()
        mock_pm_awsAccountCoops.create_table()
        mock_pm_exclusionResources.create_table()

예제 #16

파일: test_delete_project.py 프로젝트: phamkhachoa/prjs_sample

    def setUp(self):
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_AWSACCOUNTCOOPS):
            db_utils.delete_table(Tables.PM_AWSACCOUNTCOOPS)

        if db_utils.check_table_exist(Tables.PM_SECURITY_CHECK_WEBHOOK):
            db_utils.delete_table(Tables.PM_SECURITY_CHECK_WEBHOOK)

        if db_utils.check_table_exist(
                Tables.PM_SECURITY_CHECK_WEBHOOK_CALL_HISTORY):
            db_utils.delete_table(
                Tables.PM_SECURITY_CHECK_WEBHOOK_CALL_HISTORY)

        if db_utils.check_table_exist(Tables.PM_REPORTS):
            db_utils.delete_table(Tables.PM_REPORTS)

        # create pm_awsAccountCoops table
        mock_pm_awsAccountCoops.create_table()
        # create data table pm_awsAccountCoops
        for data_pm_aws_account_coops in list_data_pm_aws_account_coops:
            mock_pm_awsAccountCoops.create(data_pm_aws_account_coops)

예제 #17

파일: test_execute_change_email_handler.py 프로젝트: phamkhachoa/prjs_sample

    def setUp(self):
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_EMAIL_CHANGE_APPLY):
            db_utils.delete_table(Tables.PM_EMAIL_CHANGE_APPLY)

        if db_utils.check_table_exist(Tables.PM_AFFILIATION):
            db_utils.delete_table(Tables.PM_AFFILIATION)

        if db_utils.check_table_exist(Tables.PM_ORG_NOTIFY_MAIL_DESTINATIONS):
            db_utils.delete_table(Tables.PM_ORG_NOTIFY_MAIL_DESTINATIONS)

        # create PM_Affiliation table
        mock_pm_affiliation.create_table()
        # create PM_EmailChangeApply table
        mock_pm_emailChangeApply.create_table()
        # create PM_OrgNotifyMailDestinations table
        mock_pm_orgNotifyMailDestinations.create_table()

예제 #18

    def setUp(self):
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_AFFILIATION):
            db_utils.delete_table(Tables.PM_AFFILIATION)
        if db_utils.check_table_exist(Tables.PM_PROJECTS):
            db_utils.delete_table(Tables.PM_PROJECTS)
        if db_utils.check_table_exist(Tables.PM_CHECK_HISTORY):
            db_utils.delete_table(Tables.PM_CHECK_HISTORY)

        # create table
        mock_pm_affiliation.create_table()
        mock_pm_projects.create_table()
        mock_pm_checkHistory.create_table()

        # create data table
        mock_pm_projects.create(data_pm_project)
        mock_pm_affiliation.create(data_pm_affiliation)

예제 #19

    def setUp(self):
        super().setUp()

        # truncate old data in the table
        if db_utils.check_table_exist(Tables.PM_AFFILIATION):
            db_utils.delete_table(Tables.PM_AFFILIATION)
        if db_utils.check_table_exist(Tables.PM_PROJECTS):
            db_utils.delete_table(Tables.PM_PROJECTS)
        if db_utils.check_table_exist(Tables.PM_ASSESSMENT_ITEMS):
            db_utils.delete_table(Tables.PM_ASSESSMENT_ITEMS)
        if db_utils.check_table_exist(Tables.PM_EXCLUSION_ITEMS):
            db_utils.delete_table(Tables.PM_EXCLUSION_ITEMS)
        if db_utils.check_table_exist(Tables.PM_EXCLUSION_RESOURCES):
            db_utils.delete_table(Tables.PM_EXCLUSION_RESOURCES)
        if db_utils.check_table_exist(Tables.PM_AWSACCOUNTCOOPS):
            db_utils.delete_table(Tables.PM_AWSACCOUNTCOOPS)

        # create table
        mock_pm_affiliation.create_table()
        mock_pm_projects.create_table()
        mock_pm_awsAccountCoops.create_table()
        mock_pm_assessmentItems.create_table()
        mock_pm_exclusionItems.create_table()
        mock_pm_exclusionResources.create_table()