#!/usr/bin/env python
# -*- encoding: utf-8 -*-
-""" Pour trouver les chèque dupliqués sur la note. """
+""" Pour trouver les chèques dupliqués sur la note. """
import psycopg2
import psycopg2.extras
import subprocess
import argparse
+import base
import pretty_print
-def getcursor():
- con = psycopg2.connect(database="note")
- con.set_client_encoding("utf-8")
- return (con, con.cursor(cursor_factory = psycopg2.extras.DictCursor))
def get_data(cur, delai='1 minute', date='1970-01-01'):
"""
c.pseudo AS destp,
t1.description AS desc1,
t2.description AS desc2
- FROM credits t1,credits t2, comptes c
+ FROM credits t1, credits t2, comptes c
WHERE t1.destinataire = c.idbde
AND t1.date >= %(date)s AND t2.date >= %(date)s
AND t1.type='crédit'
args = parser.parse_args()
- con, cur = getcursor()
+ con, cur = base.getcursor()
data = get_data(cur, delai=args.deltat, date=args.date)
blocks = sort_by_blocks(data)
interactive(blocks, cur, args)