1
2
3
4
5
6
7
8
9
10
11
12
13
|
import psycopg2
from datetime import date, datetime
from trac.util.datefmt import to_timestamp, utc
def add_ticket(self, dbinfo, summary, desc) :
conn = psycopg2.connect(dbinfo)
curs = conn.cursor()
created = to_timestamp(datetime.now(utc))
curs.execute("INSERT INTO ticket \
(type,time,changetime,component,priority,owner,reporter,cc,version,milestone,status,summary,description, keywords) \
VALUES \
('defect', %s, %s, 'other','major','somebody','Coccinelle','','next','','new','%s','%s', '')" % (created, created, summary, desc) )
conn.commit()
|
