com.runehive.util.tools.ItemDBdefUpdate Class Reference

Static Public Member Functions
static void	main (String[] args)

Detailed Description

Definition at line 7 of file ItemDBdefUpdate.java.

Member Function Documentation

main()

void com.runehive.util.tools.ItemDBdefUpdate.main ( String[] args )

static

Definition at line 9 of file ItemDBdefUpdate.java.

                                           {
        String query = "INSERT INTO lookup.item_lookup(id, name, value) VALUES (?, ?, ?) ON CONFLICT (id) DO UPDATE SET id = excluded.id, name = excluded.name, value = excluded.value";
 
        ItemDefinition.createParser().run();
 
        try {
            JdbcSession session = new JdbcSession(PostgreService.getConnectionPool()).autocommit(false);
            System.out.println("Starting");
 
            for (int index = 21708; index < ItemDefinition.DEFINITIONS.length; index++) {
                ItemDefinition definition = ItemDefinition.get(index);
 
                if (definition.getName() != null && !definition.getName().equals("null")) {
                    continue;
                }
 
                session
                    .sql(query)
                    .set(definition.getId())
                    .set(definition.getName())
                    .set(definition.getValue())
                .execute();
            }
 
            session.commit();
            System.out.println("Success");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

References com.runehive.game.world.items.ItemDefinition.createParser(), com.runehive.game.world.items.ItemDefinition.DEFINITIONS, com.runehive.game.world.items.ItemDefinition.get(), com.runehive.game.service.PostgreService.getConnectionPool(), com.runehive.game.world.items.ItemDefinition.getId(), com.runehive.game.world.items.ItemDefinition.getName(), and com.runehive.util.parser.GenericParser.run().

Here is the call graph for this function:

---

The documentation for this class was generated from the following file:

• java/com/runehive/util/tools/ItemDBdefUpdate.java