1#
2# Database promises are introduced in CFEngine Community edition 3.3.0
3#
4
5body common control
6{
7      bundlesequence => { "databases" };
8}
9
10
11bundle agent databases
12
13{
14  databases:
15
16      "cfengine_db/users"
17
18      database_operation => "create",
19      database_type => "sql",
20      database_columns => {
21                            "username,varchar,50",
22                            "password,varchar,80",
23                            "email,varchar,20",
24      },
25      database_server => local_mysql("root", "");
26}
27
28
29body database_server local_mysql(username, password)
30{
31      db_server_owner => "$(username)";
32      db_server_password => "$(password)";
33      db_server_host => "localhost";
34      db_server_type => "mysql";
35      db_server_connection_db => "mysql";
36}
37
38
39body database_server local_postgresql(username, password)
40{
41      db_server_owner => "$(username)";
42      db_server_password => "$(password)";
43      db_server_host => "localhost";
44      db_server_type => "postgres";
45      db_server_connection_db => "postgres";
46}
47
48