コード例 #1
0
def main(argv=sys.argv):
    pars = OptionParser()
    pars.add_option('', '--url', default=DEFAULT_URL,
        help='default ' + DEFAULT_URL)
    pars.add_option('', '--nop', default=DEFAULT_NOP,
        help='default ' + DEFAULT_NOP)
    pars.add_option('', '--tahun', default=DEFAULT_TAHUN,
        help='default ' + DEFAULT_TAHUN)
    pars.add_option('', '--user', default=DEFAULT_USER,
        help='default ' + DEFAULT_USER)
    option, remain = pars.parse_args(argv[2:])
    config_uri = argv[1]
    url = option.url
    nop = option.nop
    tahun = option.tahun
    username = option.user
    settings = get_appsettings(config_uri)
    engine = engine_from_config(settings, 'sqlalchemy.')
    DBSession.configure(bind=engine)
    q = DBSession.query(User).filter_by(user_name=username)
    user = q.first()
    p = dict(kode=nop, tahun=tahun)
    rows = [p]
    headers = json_rpc_header(username, user.user_password)
    params = dict(data=rows)
    #print('{h} {p}'.format(h=headers, p=pass_encrypted))
    data = get_dict('get_dop_bphtb', params)
    jsondata = json.dumps(data, ensure_ascii=False)
    print('Send to {url}'.format(url=url))
    print(jsondata)          
    rows = requests.post(url, data=jsondata, headers=headers)
    print('Result:')
    print(json.loads(rows.text))
コード例 #2
0
def main(argv=sys.argv):
    pars = OptionParser()
    pars.add_option('',
                    '--url',
                    default=DEFAULT_URL,
                    help='default ' + DEFAULT_URL)
    pars.add_option('',
                    '--nop',
                    default=DEFAULT_NOP,
                    help='default ' + DEFAULT_NOP)
    pars.add_option('',
                    '--tahun',
                    default=DEFAULT_TAHUN,
                    help='default ' + DEFAULT_TAHUN)
    pars.add_option('',
                    '--user',
                    default=DEFAULT_USER,
                    help='default ' + DEFAULT_USER)
    option, remain = pars.parse_args(argv[2:])
    config_uri = argv[1]
    url = option.url
    nop = option.nop
    tahun = option.tahun
    username = option.user
    settings = get_appsettings(config_uri)
    engine = engine_from_config(settings, 'sqlalchemy.')
    DBSession.configure(bind=engine)
    q = DBSession.query(User).filter_by(user_name=username)
    user = q.first()
    p = dict(kode=nop, tahun=tahun)
    rows = [p]
    headers = json_rpc_header(username, user.user_password)
    params = dict(data=rows)
    #print('{h} {p}'.format(h=headers, p=pass_encrypted))
    data = get_dict('get_dop_bphtb', params)
    jsondata = json.dumps(data, ensure_ascii=False)
    print('Send to {url}'.format(url=url))
    print(jsondata)
    rows = requests.post(url, data=jsondata, headers=headers)
    print('Result:')
    print(json.loads(rows.text))
コード例 #3
0
import json
from tools import json_rpc_header

argv = sys.argv

# def main(argv=sys.argv):
penerima = argv[1]
pesan = argv[2]
if argv[3:]:
    url = argv[3]
else:
    url = 'http://127.0.0.1:6543/ws/reklame'
if argv[5:]:
    username = argv[4]
    pass_encrypted = argv[5]
else:
    from config import (
        username,
        pass_encrypted,
    )
row_dicted = []
headers = json_rpc_header(username, pass_encrypted)
params = dict(data=row_dicted)
data = dict(jsonrpc='2.0', method='get_faktor_lain', params=params, id=1)
jsondata = json.dumps(data, ensure_ascii=False)
print('Send to {url}'.format(url=url))
print(jsondata)
rows = requests.post(url, data=jsondata, headers=headers)
print('Result:')
print(json.loads(rows.text))
コード例 #4
0
argv = sys.argv

# def main(argv=sys.argv):
penerima = argv[1]
pesan = argv[2]
if argv[3:]:
    url = argv[3]
else:
    url = 'http://127.0.0.1:6543/ws/reklame'
if argv[5:]:
    username = argv[4]
    pass_encrypted = argv[5]
else:
    from config import (
        username,
        pass_encrypted,
    )
row_dicted = []
headers = json_rpc_header(username, pass_encrypted)
params = dict(data=row_dicted)
data = dict(jsonrpc = '2.0',
            method = 'get_faktor_lain',
            params = params,
            id = 1)
jsondata = json.dumps(data, ensure_ascii=False)
print('Send to {url}'.format(url=url))
print(jsondata)          
rows = requests.post(url, data=jsondata, headers=headers)
print('Result:')
print(json.loads(rows.text))
コード例 #5
0
ファイル: export-pbb-sppt.py プロジェクト: aagusti/o-sipkd
               s.kd_kecamatan='{kd_kecamatan}' and
               s.kd_kelurahan='{kd_kelurahan}'
               AND s.tgl_terbit_sppt = TO_DATE('{tanggal}','YYYY-MM-DD')""")\
       .format(tanggal=tanggal,
               kd_propinsi=row_kel.kd_propinsi, 
               kd_dati2=row_kel.kd_dati2, 
               kd_kecamatan=row_kel.kd_kecamatan, 
               kd_kelurahan=row_kel.kd_kelurahan)
       
 rows = eng_src.execute(sql).fetchall()
 print row_kel.nm_kelurahan, len(rows)
 if len(rows)==0:
     continue
 row_dicted = [dict(row) for row in rows]
 #print row_dicted
 headers = json_rpc_header('admin','$2a$10$g4uTd8xjqP183whcYEGyOesblGljO9AErnpCTJDH0SEUBkHXTLM5C')
 datas={"data":row_dicted}
 data = {
       "jsonrpc": "2.0",
       "method": "set_invoice",
       "params": datas,
       "id":1
     }
     
 jsondata=json.dumps(data, ensure_ascii=False)        
 info('Mulai')          
 try:
     rows = requests.post(rpc_url, data=jsondata,headers=headers)
 except:
     sys.exit()
 row_dicted = json.loads(rows.text)
コード例 #6
0
    tanggal = datetime.now().strftime('%Y-%m-%d')

info('Tanggal {tanggal}'.format(tanggal=tanggal))
    
eng_src = create_engine(db_url_src)
eng_src.echo=True

sql = ("""SELECT tahun, kode rekening_kd, nama, '1.20.05' unit_kd, ref_kode, ref_nama, to_char(tanggal,'YYYY-MM-DD') tanggal, amount, 
              kecamatan_kd, kecamatan_nm, kelurahan_kd, kelurahan_nm, is_kota, 
              sumber_id, sumber_data
          FROM apbd.ar_invoice_item 
          WHERE tanggal = TO_DATE('{tanggal}','YYYY-MM-DD')""").format(tanggal=tanggal)
          
rows = eng_src.execute(sql)
row_dicted = [dict(row) for row in rows]
headers = json_rpc_header('admin','$2a$10$g4uTd8xjqP183whcYEGyOesblGljO9AErnpCTJDH0SEUBkHXTLM5C')
datas={"data":row_dicted}
data = {
      "jsonrpc": "2.0",
      "method": "set_invoice",
      "params": datas,
      "id":1
    }
    
jsondata=json.dumps(data, ensure_ascii=False)        
info('Mulai')          
rows = requests.post(rpc_url, data=jsondata,headers=headers)
row_dicted = json.loads(rows.text)
info("Invoice:", row_dicted)
info('Selesai')          
os.remove(pid_file)