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

<?php
use ActiveRecord\Connection;

include 'helpers/config.php';

// Only use this to test static methods in Connection that are not specific
// to any database adapter.

class ConnectionTest extends SnakeCase_PHPUnit_Framework_TestCase
{
    /**
     * @expectedException ActiveRecord\DatabaseException
     */
    public function test_connection_info_from_should_throw_exception_when_no_host()
    {
        ActiveRecord\Connection::parse_connection_url('mysql://user:pass@');
    }

    public function test_connection_info()
    {
        $info = ActiveRecord\Connection::parse_connection_url('mysql://user:pass@127.0.0.1:3306/dbname');
        $this->assert_equals('mysql',$info->protocol);
        $this->assert_equals('user',$info->user);
        $this->assert_equals('pass',$info->pass);
        $this->assert_equals('127.0.0.1',$info->host);
        $this->assert_equals(3306,$info->port);
        $this->assert_equals('dbname',$info->db);
    }
    
    public function test_gh_103_sqlite_connection_string_relative()
    {
        $info = ActiveRecord\Connection::parse_connection_url('sqlite://../some/path/to/file.db');
        $this->assert_equals('../some/path/to/file.db', $info->host);
    }

    /**
     * @expectedException ActiveRecord\DatabaseException
     */
    public function test_gh_103_sqlite_connection_string_absolute()
    {
        $info = ActiveRecord\Connection::parse_connection_url('sqlite:///some/path/to/file.db');
    }

    public function test_gh_103_sqlite_connection_string_unix()
    {
        $info = ActiveRecord\Connection::parse_connection_url('sqlite://unix(/some/path/to/file.db)');
        $this->assert_equals('/some/path/to/file.db', $info->host);
           
        $info = ActiveRecord\Connection::parse_connection_url('sqlite://unix(/some/path/to/file.db)/');
        $this->assert_equals('/some/path/to/file.db', $info->host);
        
        $info = ActiveRecord\Connection::parse_connection_url('sqlite://unix(/some/path/to/file.db)/dummy');
        $this->assert_equals('/some/path/to/file.db', $info->host);
    }

    public function test_gh_103_sqlite_connection_string_windows()
    {
        $info = ActiveRecord\Connection::parse_connection_url('sqlite://windows(c%3A/some/path/to/file.db)');
        $this->assert_equals('c:/some/path/to/file.db', $info->host);
    }

    public function test_parse_connection_url_with_unix_sockets()
    {
        $info = ActiveRecord\Connection::parse_connection_url('mysql://user:password@unix(/tmp/mysql.sock)/database');
        $this->assert_equals('/tmp/mysql.sock',$info->host);
    }

    public function test_parse_connection_url_with_decode_option()
    {
        $info = ActiveRecord\Connection::parse_connection_url('mysql://h%20az:h%40i@127.0.0.1/test?decode=true');
        $this->assert_equals('h az',$info->user);
        $this->assert_equals('h@i',$info->pass);
    }

    public function test_encoding()
    {
        $info = ActiveRecord\Connection::parse_connection_url('mysql://test:test@127.0.0.1/test?charset=utf8');
        $this->assert_equals('utf8', $info->charset);
    }
}
?>