On Thu, 14 Jan 2021 at 14:28, 'Praveen Kumar Singh' via Ansible
Project <[email protected]> wrote:
>
> Hello All,
>
> I am trying to create a new database on sql server using the below mentioned
> ansible playbook.
>
> But when I am executing the playbook and in the prompt option putting the
> database name.
>
> It is not taking that database name of the prompt and instead creating the
> database mentioned in the SQL query (in this case creating database TestDB).
That is what you tell it to do, so this is expected behavior.
> So needed help in how I can create the database dynamically by putting the
> Database name in the prompt option.
>
> ---
> - hosts: SQLSERVER
> vars_prompt:
> - name: DB Config
> prompt: DbName
> default:
> tasks:
> - name: DB config
> win_shell: |
> $sql = "DECLARE @Query VARCHAR(MAX)=''
> DECLARE @DbName VARCHAR(400) = 'TestDB'
This is where you declare the var in windows language (or whatever you
call that).
> DECLARE @DbFilePath VARCHAR(400) = 'E:\Database\'
> SET @Query = @Query + 'CREATE DATABASE '+@DbName +' ON
> PRIMARY '
> SET @Query = @Query + '( NAME = '''+@DbName +''', FILENAME
> = '''+@DbFilePath+@DbName +'.mdf'' , SIZE = 3072KB , MAXSIZE = UNLIMITED,
> FILEGROWTH = 1024KB ) '
> SET @Query = @Query + ' LOG ON '
> SET @Query = @Query + '( NAME = '''+@DbName +'_log'',
> FILENAME = '''+@DbFilePath+@DbName +'_log.ldf'' , SIZE = 1024KB , MAXSIZE =
> 2048GB , FILEGROWTH = 10%)'
> print @query
> exec(@query)"
> Invoke-SqlCmd -Query $sql
Try jinja syntax, ie.
{{ DbName }}
instead of
@DbName
--
Dick Visser
Trust & Identity Service Operations Manager
GÉANT
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/CAL8fbwN%3D9gvs5OsPtmZby%3DU_iLHhnK-9EOdv0A-LwThyR7K7ig%40mail.gmail.com.
