Spaces:

cuatrolabs
/

cuatrolabs-scm-ms

Runtime error

cuatrolabs-scm-ms / scripts /drop_functions.py

feat(po-returns): make warehouse_id optional and refactor validation logic

d5f79b7 8 months ago

620 Bytes

import asyncio
from app.sql import connect_to_database, async_session
from sqlalchemy import text

async def drop_functions():
    await connect_to_database()
    async with async_session() as session:
        print("Dropping functions...")
        await session.execute(text("DROP FUNCTION IF EXISTS trans.fn_get_po_items_for_purchase_return(uuid, character varying);"))
        await session.execute(text("DROP FUNCTION IF EXISTS trans.fn_get_po_items_for_purchase_return(uuid, uuid);"))
        await session.commit()
        print("Functions dropped.")

if __name__ == "__main__":
    asyncio.run(drop_functions())


	import asyncio
	from app.sql import connect_to_database, async_session
	from sqlalchemy import text

	async def drop_functions():
	await connect_to_database()
	async with async_session() as session:
	print("Dropping functions...")
	await session.execute(text("DROP FUNCTION IF EXISTS trans.fn_get_po_items_for_purchase_return(uuid, character varying);"))
	await session.execute(text("DROP FUNCTION IF EXISTS trans.fn_get_po_items_for_purchase_return(uuid, uuid);"))
	await session.commit()
	print("Functions dropped.")

	if __name__ == "__main__":
	asyncio.run(drop_functions())