RuneHive-Game
Loading...
Searching...
No Matches
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.

9 {
10 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";
11
12 ItemDefinition.createParser().run();
13
14 try {
15 JdbcSession session = new JdbcSession(PostgreService.getConnectionPool()).autocommit(false);
16 System.out.println("Starting");
17
18 for (int index = 21708; index < ItemDefinition.DEFINITIONS.length; index++) {
19 ItemDefinition definition = ItemDefinition.get(index);
20
21 if (definition.getName() != null && !definition.getName().equals("null")) {
22 continue;
23 }
24
25 session
26 .sql(query)
27 .set(definition.getId())
28 .set(definition.getName())
29 .set(definition.getValue())
30 .execute();
31 }
32
33 session.commit();
34 System.out.println("Success");
35 } catch (Exception e) {
36 e.printStackTrace();
37 }
38 }
val index

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: