HYTOS

def make_sql_delete_drawing_data():

    import os

    sqlPath = os.path.join('E:\Projects\DTIPID\minorTools', 'clear.txt')

    #drawing_uids = ['1e40e611-cd83-4c99-9711-b45321c3641e', '98240e9a-8ac9-4968-8203-7db2ace5023a']

    drawing_uids = ['37f99bb8-9d4d-47f6-918a-4d0aadafba67', '38b003bc-3e46-45a8-8bdf-416110ccb084', \

                    '6fa42c26-b366-409c-b4b7-058d88c2abf0', '8331f923-57f6-4eaf-af8a-dcf13ea28286', '4b6672ad-40bc-4ef4-8f69-3fd28915ca9b', \

                    'd285f727-06c6-4406-ada3-8a923d065b04', 'd2881b09-8587-4e68-a26a-e8f629caa09a', 'd9cf86fb-d397-48c9-b164-d03deaafbf39', \

                    '3ae92a58-0fae-4c40-a92c-10431f1ca3b7', 'd212239f-4d47-4aeb-866c-2f4273d3b68f', '974ef07c-c285-4aaf-b363-61bdd34854fa', \

                    '92ddb680-1bd5-4772-bf7b-ea3a549692e1', 'f599f36d-0806-42e7-bd18-edfe430c2364', '95ab5d72-dbb5-4638-8431-82295d66cdd6']

    sqls = []

    for index in range(len(drawing_uids)):

        drawing_uid = drawing_uids[index]

        sql = []

        sql.append("delete from LINE_DATA_LIST where PNID_NO = '{}'".format(drawing_uid))

        sql.append("delete from TitleBlockValues where Drawings_UID = '{}'".format(drawing_uid))

        sql.append(f"delete from LineNoAttributes where Components_UID in " \

                      f"(select UID from Components where Drawings_UID='{drawing_uid}')")

        sql.append(f"delete from Attributes where Components_UID in " \

                      f"(select UID from Components where Drawings_UID='{drawing_uid}')")

        sql.append(f"delete from Associations where Components_UID in " \

                      f"(select UID from Components where Drawings_UID='{drawing_uid}')")

        sql.append(f"delete from Points where Components_UID in " \

                      f"(select UID from Components where Drawings_UID='{drawing_uid}')")

        sql.append(f"delete from PipeRunItems where PipeRuns_UID in " \

                      f"(select UID from PipeRuns where Drawings_UID='{drawing_uid}')")

        sql.append(f"delete from PipeRuns where Drawings_UID='{drawing_uid}'")

        sql.append("delete from Components where Drawings_UID='{}'".format(drawing_uid))

        sql.append("delete from Stream_Line_List where Drawing_UID='{}'".format(drawing_uid))

        sql.append("delete from Drawings where [UID]='{}'".format(drawing_uid))

        sqls.append(";\n".join(sql))

    #print(sqls)

    fw = open(sqlPath, 'w', encoding='utf8')

    fw.write(";\n\n".join(sqls))

    fw.close()

if __name__ == '__main__':

    selection = input("select fuction(clear = 1) : ")

    if selection == '1':

        make_sql_delete_drawing_data()