わいえむねっと

• 初回導入時はドングルを挿したら そのまま東芝スタックが組み込まれた(はず)

sql = ("SELECT id, type, summary, owner, description, status, a.value, c.value from ticket t "
            "JOIN ticket_custom a ON a.ticket = t.id AND a.name = 'due_assign' "
            "JOIN ticket_custom c ON c.ticket = t.id AND c.name = 'due_close' "
            "WHERE ((a.value >= '%s' AND a.value <= '%s' ) "
            "OR (c.value >= '%s' AND c.value <= '%s')) %s %s" %
            (format_date(parse_date(first.isoformat())),
                format_date(parse_date(last.isoformat())),
                format_date(parse_date(first.isoformat())),
                format_date(parse_date(last.isoformat())),
                my_ticket_sql,
                selected_milestone_sql))

def format_date(t=None, format='%x', tzinfo=None):
    """Convenience method for formatting the date part of a `datetime` object.
    See `format_datetime` for more details.
    """
    if format == 'iso8601':
        format = 'iso8601date'
    return format_datetime(t, format, tzinfo=tzinfo)

from datetime import date
from trac.util.datefmt import parse_date, format_date

d = date.today().isoformat()
print d
print parse_date(d)
print format_date(parse_date(d))
print format_date(parse_date(d), '%x')
print format_date(parse_date(d), '%Y/%m/%d')
# 2010-06-10
# 2010-06-10 00:00:00+09:00
# 06/10/10
# 06/10/10
# 2010/06/10

--- ticketcalendar.py~
+++ ticketcalendar.py
@@ -69,10 +69,10 @@
                     "JOIN ticket_custom c ON c.ticket = t.id AND c.name = 'due_close' "
                     "WHERE ((a.value >= '%s' AND a.value <= '%s' ) "
                     "OR (c.value >= '%s' AND c.value <= '%s')) %s %s" %
-                    (format_date(parse_date(first.isoformat())),
-                        format_date(parse_date(last.isoformat())),
-                        format_date(parse_date(first.isoformat())),
-                        format_date(parse_date(last.isoformat())),
+                    (format_date(parse_date(first.isoformat(), '%Y/%m/%d')),
+                        format_date(parse_date(last.isoformat(), '%Y/%m/%d')),
+                        format_date(parse_date(first.isoformat(), '%Y/%m/%d')),
+                        format_date(parse_date(last.isoformat(), '%Y/%m/%d')),
                         my_ticket_sql,
                         selected_milestone_sql))

.active {
   background-color:#fff;
}
.holiday {
  background-color: #f6f7f8;
  color: black;
}
.today {
  background-color: #ffe0e0;
}

td.active {
   background-color:#fff;
}
.holiday {
  background-color: #f6f7f8;
  color: black;
}
.today {
  background-color: #ffe0e0;
}

$ ./felica_dump 
error

• error

$ gdb felica_dump 
GNU gdb 6.8-debian
Copyright (C) 2008 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "i486-linux-gnu"...
"/home/foo/libpafe-0.0.7/tests/felica_dump": not in executable format: File format not recognized
(gdb) b mainr
No symbol table is loaded.  Use the "file" command.
(gdb) r
Starting program:  
No executable file specified.
Use the "file" or "exec-file" command.

• not in executable format: File format not recognized

$ libtool --mode=execute gdb felica_dump
./felica_dump: line 61: Xfelica_dump: command not found
GNU gdb 6.8-debian
Copyright (C) 2008 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "i486-linux-gnu"...
(gdb) b main
Breakpoint 1 at 0x8048d89: file felica_dump.c, line 176.
(gdb) r
Starting program: /home/foo/libpafe-0.0.7/tests/.libs/lt-felica_dump 

Breakpoint 1, main () at felica_dump.c:176
176   p = pasori_open();

• pasori_open()のusb_set_configuration()でこけてた。権限の問題か。