Hello guy !! :)
I want create module for connection and execution script sql in my database
MSSQL.
I have create programme python :
*#!/usr/bin/python*
*import pymssql*
*conn = pymssql.connect(host="my_host_database", user="my_user",
password="my_password", database="my_database")*
*cur = conn.cursor()*
*try:*
* with open('script_sql.sql') as f:*
* cur.execute(f.read().decode('utf-8'))*
* conn.commit()*
*except:*
* print("Il y a une erreur lors de l'execution du script")*
*cur.close()*
This programe works perfectly, but i want create module ansible for this
programme python.
For exemple, my goal is that my module name *mssql_query*:
- name: "Execute my new module"
mssql_query:
name: *my_host_database*
user: *my_user*
password: *my_password*
database: *my_database*
file_sql: *./script_sql.sql*
Someone can you help me for transform my program python in module ansible
please ?
Thanks you very much !! :)
Best regards,
Karther
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to ansible-project+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/c3c8934a-0da1-48df-9ed5-665247432724%40googlegroups.com.
