Skip to content

Instantly share code, notes, and snippets.

View jtnix's full-sized avatar
🏠
Working from home

Jolyon Terwilliger jtnix

🏠
Working from home
View GitHub Profile
@jtnix
jtnix / tracsvn2JiraFisheyeLinkConverter.php
Created April 2, 2018 19:26
PHP and SQL scripts to convert a trac ticket database w/SVN linked entries to JIRA consumable import
<?php
// tracsvn2JiraFisheyeLinkConverter.php
// (c) 2014 J Terwilliger
// free to reuse and modify
$_DEBUG = true;
class TracDB extends SQLite3 {
@jtnix
jtnix / ZendDbSelectForceIndex.patch
Last active April 2, 2018 19:28
Patch for Zend Framework 1.14 to allow use of FORCE INDEX MySQL hinting command in SELECT queries
Index: library/Zend/Db/Select.php
IDEA additional info:
Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP
<+>UTF-8
===================================================================
--- library/Zend/Db/Select.php (revision 4524)
+++ library/Zend/Db/Select.php (revision )
@@ -47,6 +47,7 @@
const DISTINCT = 'distinct';
const COLUMNS = 'columns';
@jtnix
jtnix / ZendDbStatementPdoError.patch
Created April 2, 2018 19:24
Improved PDO Exception messaging
Index: library/Zend/Db/Statement/Pdo.php
IDEA additional info:
Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP
<+>UTF-8
===================================================================
--- library/Zend/Db/Statement/Pdo.php (revision 4524)
+++ library/Zend/Db/Statement/Pdo.php (revision )
@@ -231,7 +231,12 @@
}
} catch (PDOException $e) {