fix postgresql

lsmith77 · lsmith77 · commit 79aad26ecaa2 · 2011-12-20T23:48:34.000+01:00
diff --git a/HelloWorld.php b/HelloWorld.php
@@ -14,15 +14,15 @@ public function __construct(PDO $pdo)
 
     public function hello($what = 'World')
     {
-        $sql = "INSERT INTO hello_world_test.hello VALUES (" . $this->pdo->quote($what) . ")";
+        $sql = "INSERT INTO hello VALUES (" . $this->pdo->quote($what) . ")";
         $this->pdo->query($sql);
         return "Hello $what";
     }
 
 
     public function what()
     {
-        $sql = "SELECT what FROM hello_world_test.hello";
+        $sql = "SELECT what FROM hello";
         $stmt = $this->pdo->query($sql);
         return $stmt->fetchColumn();
     }
diff --git a/Tests/HelloWorldTest.php b/Tests/HelloWorldTest.php
@@ -11,12 +11,12 @@ public function setUp()
     {
         $this->pdo = new PDO($GLOBALS['db_dsn'], $GLOBALS['db_username'], $GLOBALS['db_password']);
         $this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
-        $this->pdo->query("CREATE TABLE hello_world_test.hello (what VARCHAR(50) NOT NULL)");
+        $this->pdo->query("CREATE TABLE hello (what VARCHAR(50) NOT NULL)");
     }
 
     public function tearDown()
     {
-        $this->pdo->query("DROP TABLE hello_world_test.hello");
+        $this->pdo->query("DROP TABLE hello");
     }
 
     public function testHelloWorld()

Original file line number	Diff line number	Diff line change
`@@ -14,15 +14,15 @@ public function __construct(PDO $pdo)`
`14`	`14`
`15`	`15`	`public function hello($what = 'World')`
`16`	`16`	`{`
`17`		`- $sql = "INSERT INTO hello_world_test.hello VALUES (" . $this->pdo->quote($what) . ")";`
	`17`	`+ $sql = "INSERT INTO hello VALUES (" . $this->pdo->quote($what) . ")";`
`18`	`18`	`$this->pdo->query($sql);`
`19`	`19`	`return "Hello $what";`
`20`	`20`	`}`
`21`	`21`
`22`	`22`
`23`	`23`	`public function what()`
`24`	`24`	`{`
`25`		`- $sql = "SELECT what FROM hello_world_test.hello";`
	`25`	`+ $sql = "SELECT what FROM hello";`
`26`	`26`	`$stmt = $this->pdo->query($sql);`
`27`	`27`	`return $stmt->fetchColumn();`
`28`	`28`	`}`
Original file line number	Diff line number	Diff line change
`@@ -11,12 +11,12 @@ public function setUp()`
`11`	`11`	`{`
`12`	`12`	`$this->pdo = new PDO($GLOBALS['db_dsn'], $GLOBALS['db_username'], $GLOBALS['db_password']);`
`13`	`13`	`$this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);`
`14`		`- $this->pdo->query("CREATE TABLE hello_world_test.hello (what VARCHAR(50) NOT NULL)");`
	`14`	`+ $this->pdo->query("CREATE TABLE hello (what VARCHAR(50) NOT NULL)");`
`15`	`15`	`}`
`16`	`16`
`17`	`17`	`public function tearDown()`
`18`	`18`	`{`
`19`		`- $this->pdo->query("DROP TABLE hello_world_test.hello");`
	`19`	`+ $this->pdo->query("DROP TABLE hello");`
`20`	`20`	`}`
`21`	`21`
`22`	`22`	`public function testHelloWorld()`