Ansible-Sybase

Plugins CI Roles CI Codecov FOSSA Status

Included content

  • Modules:

    • sybase_db: Database import/export using bcp wrapper, and removal/simple creation using pyodbc and FreeTDS python drivers.
    • sybase_isql: Run SQL scripts using isql64 or isql command wrapper.
    • sybase_query: Run SQL queries using pyodbc and FreeTDS python drivers.
  • Roles:

Cloning

This repository is designed as per Ansible Collections guidelines. It therere required to clone this repository in a specific directory structure.

mdkdir -p ansible_collections/sqlops/ && \
cd ansible_collections/sqlops/ && \
git clone "https://github.com/fjudith/ansible-sybase" sybase

Tested with Ansible

  • 2.9.x: Centos 7, Ubuntu Bionic (18.04 LTS), Ubuntu Focal (20.04 LTS)
  • 2.10.x: : Centos 7, Ubuntu Bionic (18.04 LTS), Ubuntu Focal (20.04 LTS)

Roadmap

Please refer to the ROADMAP for more details on the progress.

Technologies

  • Vagrant: Local development environment provisionning
  • Cloud-Init: Initial instance bootime provisionning
  • Ansible: Software provisionning and configuration management
  • Liquibase: Database operation management

Languages

  • Ansible: YAML based Domain-specific language (DSL) for configuration management
  • Ansible-Lint: Code style compliance processor
  • Bash: Language used for general shell scripting
  • Python: Language used to write unit tests and Ansible modules
  • PyODBC: Open source Python module that makes accessing ODBC databases simple
  • Powershell Core: Language used for Windows specific shell scripting (ref. hack)

License

FOSSA Status