FilesExpand file tree

 master

/

app.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

105 lines (91 loc) · 3.35 KB

 master

/

app.php

Copy path

Top

File metadata and controls

• Code
• Blame

105 lines (91 loc) · 3.35 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

<?php

/*

* Copyright 2020 Google LLC.

*

* Licensed under the Apache License, Version 2.0 (the "License");

* you may not use this file except in compliance with the License.

* You may obtain a copy of the License at

*

* http://www.apache.org/licenses/LICENSE-2.0

*

* Unless required by applicable law or agreed to in writing, software

* distributed under the License is distributed on an "AS IS" BASIS,

* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

* See the License for the specific language governing permissions and

* limitations under the License.

*/

declare(strict_types=1);

use Google\Cloud\Samples\CloudSQL\SQLServer\Votes;

use Pimple\Container;

use Pimple\Psr11\Container as Psr11Container;

use Slim\Factory\AppFactory;

use Slim\Views\Twig;

use Slim\Views\TwigMiddleware;

// Create and set the dependency injection container.

$container = new Container;

AppFactory::setContainer(new Psr11Container($container));

// add the votes manager to the container.

$container['votes'] = function (Container $container) {

return new Votes($container['db']);

};

// Setup the database connection in the container.

$container['db'] = function () {

$username = getenv('DB_USER');

$password = getenv('DB_PASS');

$db_name = getenv('DB_NAME');

$host = getenv('DB_HOST');

try {

# [START cloud_sql_sqlserver_pdo_create_tcp]

// $username = 'your_db_user';

// $password = 'yoursupersecretpassword';

// $db_name = 'your_db_name';

// $host = "127.0.0.1";

$dsn = sprintf('sqlsrv:server=%s;Database=%s', $host, $db_name);

// Connect to the database.

# [START cloud_sql_server_pdo_timeout]

// Here we set the connection timeout to five seconds and ask PDO to

// throw an exception if any errors occur.

$conn = new PDO($dsn, $username, $password, [

PDO::ATTR_TIMEOUT => 5,

PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION

]);

# [END cloud_sql_server_pdo_timeout]

# [END cloud_sql_server_pdo_create_tcp]

} catch (TypeError $e) {

throw new RuntimeException(

sprintf(

'Invalid or missing configuration! Make sure you have set ' .

'$username, $password, $db_name, and $host. ' .

'The PHP error was %s',

$e->getMessage()

),

$e->getCode(),

$e

);

} catch (PDOException $e) {

throw new RuntimeException(

sprintf(

'Could not connect to the Cloud SQL Database. Check that ' .

'your username and password are correct, that the Cloud SQL ' .

'proxy is running, and that the database exists and is ready ' .

'for use. For more assistance, refer to %s. The PDO error was %s',

'https://cloud.google.com/sql/docs/mysql/connect-external-app',

$e->getMessage()

),

(int) $e->getCode(),

$e

);

}

return $conn;

};

// Configure the templating engine.

$container['view'] = function () {

return Twig::create(__DIR__ . '/../views');

};

// Create the application.

$app = AppFactory::create();

// Add the twig middleware

$app->add(TwigMiddleware::createFromContainer($app));

// Setup error handlinmg

$app->addErrorMiddleware(true, false, false);

return $app;