A dependency resolution library that performs conflict resolution to create a topological ordering for creating and destroying SQL objects such as views, functions and indexes.

Navigation

Verified details

These details have been verified by PyPI
Maintainers
Avatar for devmustafa from gravatar.com devmustafa

Unverified details

These details have not been verified by PyPI
Project links
Meta
  • License: MIT License (MIT License Copyright (c) 2022 Mustafa Mustafa Permission is hereby granted, free of charge, to any ...)
  • Author: Mustafa Mustafa
  • Tags sql , views , topological sort
Classifiers
Report project as malware

Project description

sql-dependency-resolution

A dependency resolution library that performs conflict resolution to create a topological ordering for creating and destroying SQL objects such as views, functions and indexes.

Installation

Install using pip install sql-dependency-resolver

Usage

  • import using from resolver import ViewDependencyResolver
  • use create_order and drop_order to retrieve dependency ordering.(currently only views are supported).

Caveats

  • assumes name of file is the name of view.
  • views must be pre-fixed with vw_ or mvw_.
  • dependecies are collected from join conditions.

Tests

Run tests with pytest

TODO

  • implement functions, procedures and indexes.
  • auto detect name from header using regex.

Project details

Verified details

These details have been verified by PyPI
Maintainers
Avatar for devmustafa from gravatar.com devmustafa

Unverified details

These details have not been verified by PyPI
Project links
Meta
  • License: MIT License (MIT License Copyright (c) 2022 Mustafa Mustafa Permission is hereby granted, free of charge, to any ...)
  • Author: Mustafa Mustafa
  • Tags sql , views , topological sort
Classifiers

Release history Release notifications | RSS feed

This version

1.1.0 yanked

1.0.0 yanked

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sql-dependency-resolver-1.1.0.tar.gz (4.6 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

sql_dependency_resolver-1.1.0-py3-none-any.whl (6.1 kB view details)

Uploaded Python 3

File details

Details for the file sql-dependency-resolver-1.1.0.tar.gz.

File metadata

  • Download URL: sql-dependency-resolver-1.1.0.tar.gz
  • Upload date:
  • Size: 4.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.1 CPython/3.8.9

File hashes

Hashes for sql-dependency-resolver-1.1.0.tar.gz
Algorithm Hash digest
SHA256 e23fc74d34978d27fcf71776b5eaff955031618695524407ee6df08bb45b9c54
MD5 8aba7b91757031d6b6f39d87ce6b7cae
BLAKE2b-256 547500364771b1088090114e0d432ea33671a48e3977d90f27e465517fa41bc5

See more details on using hashes here.

File details

Details for the file sql_dependency_resolver-1.1.0-py3-none-any.whl.

File metadata

File hashes

Hashes for sql_dependency_resolver-1.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 d44c09d1fc09d15bb74a53b742eee79c75ff9401e95ae38315d8f301b3e21754
MD5 2b3a6d71bc4aba8922825606f000b7a7
BLAKE2b-256 329e5b9451def36e6748284e51ac2d4f85c42319fb2a019ef70b075cab5d2bf2

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page