Check-in [e1a97c62e1]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Updated to log queries that fail and why they fail
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:e1a97c62e11e3a8e2b0a7809e2d951ecc58cfdc2
User & Date: rkeene 2016-11-22 19:29:56
Context
2017-03-16
15:41
Updated to create new repositories as SHA1 for compatibility with older Fossil versions check-in: 1ab71c2b65 user: rkeene tags: trunk
2016-11-22
19:29
Updated to log queries that fail and why they fail check-in: e1a97c62e1 user: rkeene tags: trunk
18:22
Updated to ensure that no non-default SSH command is used for a pull check-in: f79eaca9ca user: rkeene tags: trunk
Changes

Changes to nano/db.php.

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
        self::$_db = null;
        self::init();
    }

    public static function execute($sql, $bind = array())
    {
        $res = self::$_db->prepare($sql);





        if ($res->execute($bind)) {
            return true;
        }

        return false;
    }

    public static function query($sql, $bind = array())
    {
        $res = self::$_db->prepare($sql);





        if ($res->execute($bind)) {
            if ($result = $res->fetchAll(PDO::FETCH_ASSOC)) {
                return $result;
            }
        }

        return false;
    }
}

Nano_Db::init();







>
>
>
>











>
>
>
>












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
        self::$_db = null;
        self::init();
    }

    public static function execute($sql, $bind = array())
    {
        $res = self::$_db->prepare($sql);

	if ($res === false) {
            error_log("Unable to prepare (for execution): {$sql}: " . implode(self::$_db->errorInfo()));
	}

        if ($res->execute($bind)) {
            return true;
        }

        return false;
    }

    public static function query($sql, $bind = array())
    {
        $res = self::$_db->prepare($sql);

	if ($res === false) {
            error_log("Unable to prepare (for query): {$sql}: " . implode(self::$_db->errorInfo()));
	}

        if ($res->execute($bind)) {
            if ($result = $res->fetchAll(PDO::FETCH_ASSOC)) {
                return $result;
            }
        }

        return false;
    }
}

Nano_Db::init();