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))
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))
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))
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)
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)