6a9hYVTr

1using System;
2using System.Data.SqlClient;
3using Dapper;
4
5namespace api
6{
7    public static class Bootstrapper
8    {
9        public static void Init()
10        {
11            var server = Db.ConnectionString = Environment.GetEnvironmentVariable("DB_SERVER") ?? @".\SQLEXPRESS2012";
12            var database = Db.ConnectionString = Environment.GetEnvironmentVariable("DB_DATABASE") ?? "Test";
13            var user = Db.ConnectionString = Environment.GetEnvironmentVariable("DB_USER_NAME") ?? "sa";
14            var pass = Db.ConnectionString = Environment.GetEnvironmentVariable("DB_PASSWORD") ?? "sa";
15            Db.ConnectionString = $"server={server};database=master;User Id={user};Password={pass};";
16            using (var conn = new SqlConnection(Db.ConnectionString))
17            {
18                var sql = $"IF db_id('{database}') is null create database [{database}];";
19                conn.Execute(sql);
20            }
21            Db.ConnectionString = $"server={server};database={database};User Id={user};Password={pass};";
22            using (var conn = new SqlConnection(Db.ConnectionString))
23            {
24                const string sql = @"
25                    if not exists (select * from sysobjects where name='Projects' and xtype='U')
26                    create table Projects(
27                      Id int identity not null,
28                      Name nvarchar(50) not null,
29                      constraint PK_Projects primary key(id)
30                    )";
31                conn.Execute(sql);
32            }
33        }
34    }
35
36    public static class Db
37    {
38        public static string ConnectionString { get; set; }
39    }
40}