}); System.out.println("TPS: " + (nMax * nIds * 1000 / t)); System.out.println("" + ledger.getDb().queryOne("SELECT count(*) from ledger"));
@Test public void moveToTestnet() throws Exception { HashId hashId = HashId.createRandom(); StateRecord r = ledger.findOrCreate(hashId); r.save(); PreparedStatement ps = ledger.getDb().statement("select count(*) from ledger_testrecords where hash = ?",hashId.getDigest()); ResultSet rs = ps.executeQuery(); assertTrue(rs.next()); assertEquals(rs.getInt(1), 0); r.markTestRecord(); ps = ledger.getDb().statement("select count(*) from ledger_testrecords where hash = ?",hashId.getDigest()); rs = ps.executeQuery(); assertTrue(rs.next()); assertEquals(rs.getInt(1), 1); r.markTestRecord(); ps = ledger.getDb().statement("select count(*) from ledger_testrecords where hash = ?",hashId.getDigest()); rs = ps.executeQuery(); assertTrue(rs.next()); assertEquals(rs.getInt(1), 1); }
PreparedStatement st = ledger.getDb().statement("select count(*) from ledger where hash = ?", hash1.getDigest()); st = ledger.getDb().statement("select count(*) from ledger where hash = ?", hash2.getDigest()); st = ledger.getDb().statement("select count(*) from items where id in (select id from ledger where hash = ?)", hash2.getDigest());
@Test public void paymentSaveTest() throws Exception { try (PooledDb db = (PooledDb) ledger.getDb()) { try (PreparedStatement statement = db.statement("delete from payments_summary;") ) { statement.executeUpdate(); } } NodeStats stats = new NodeStats(); Config config = new Config(); stats.init(ledger,config); ZonedDateTime now = ZonedDateTime.now(); ZonedDateTime dateTime = now.minusDays(now.getDayOfMonth()-1).minusMonths(1); while (dateTime.isBefore(ZonedDateTime.now().plusSeconds(1))) { ledger.savePayment(100,dateTime); ledger.savePayment(100,dateTime); dateTime = dateTime.plusDays(1); } stats.collect(ledger,config); //assertEquals(stats.todayPaidAmount,200); //assertEquals(stats.yesterdayPaidAmount,200); //assertEquals(stats.thisMonthPaidAmount,200*now.getDayOfMonth()); //assertEquals(stats.lastMonthPaidAmount,200*now.minusMonths(1).getMonth().length(now.getYear() % 4 == 0)); }
PreparedStatement ps = ((PostgresLedger)n.getLedger()).getDb().statement( "select count(*) from contract_subscription where hash_id = ?", env.subscriptions().iterator().next().getContractId().getDigest()); ps = ((PostgresLedger)n.getLedger()).getDb().statement( "select count(*) from contract_subscription where hash_id = ?", env.subscriptions().iterator().next().getContractId().getDigest());
Db db = ((PostgresLedger) main.node.getLedger()).getDb(); try (PreparedStatement statement = db.statement("delete from keeping_items where origin = ?")) { statement.setBytes(1, origin.getDigest());
PostgresLedger pl = (PostgresLedger) ledger; try(Db db = pl.getDb()) { try(PreparedStatement ps = db.statement("select count(*) from ledger_testrecords where hash = ?",parcel.getPayloadContract().getId().getDigest());) { try(ResultSet rs = ps.executeQuery()) {
PostgresLedger pl = (PostgresLedger) ledger; try(Db db = pl.getDb()) { try(PreparedStatement ps = db.statement("select count(*) from ledger_testrecords where hash = ?",parcel.getPayloadContract().getId().getDigest());) { try(ResultSet rs = ps.executeQuery()) {
PostgresLedger pl = (PostgresLedger) ledger; try(Db db = pl.getDb()) { try(PreparedStatement ps = db.statement("select count(*) from ledger_testrecords where hash = ?", parcel.getPayloadContract().getId().getDigest());) { try(ResultSet rs = ps.executeQuery()) { PostgresLedger pl = (PostgresLedger) ledger; try(Db db = pl.getDb()) { try(PreparedStatement ps = db.statement("select count(*) from ledger_testrecords where hash = ?", parcel.getPayloadContract().getId().getDigest());) { try(ResultSet rs = ps.executeQuery()) {
PostgresLedger pl = (PostgresLedger) ledger; try(Db db = pl.getDb()) { try(PreparedStatement ps = db.statement("select count(*) from ledger_testrecords where hash = ?", parcel.getPayloadContract().getId().getDigest());) { try(ResultSet rs = ps.executeQuery()) { PostgresLedger pl = (PostgresLedger) ledger; try(Db db = pl.getDb()) { try(PreparedStatement ps = db.statement("select count(*) from ledger_testrecords where hash = ?", parcel.getPayloadContract().getId().getDigest());) { try(ResultSet rs = ps.executeQuery()) {
PreparedStatement ps = ((PostgresLedger)n.getLedger()).getDb().statement( "select count(*) from name_entry where origin=? or short_addr=? or long_addr=?", referencesContract.getId().getDigest(), ps = ((PostgresLedger)n.getLedger()).getDb().statement( "select count(*) from name_entry where origin=? or short_addr=? or long_addr=?", referencesContract.getId().getDigest(),