@ConsoleCommand(splitInWords = false, description = "Alter a database property", onlineHelp = "SQL-Alter-Database") public void alterDatabase( @ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("alter", iCommandText, "\nDatabase updated successfully.\n", false); updateDatabaseInfo(); }
@ConsoleCommand(splitInWords = false, description = "Alter a class in the database schema") public void alterClass( @ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("alter", iCommandText, "\nClass updated successfully.\n", false); updateDatabaseInfo(); }
@ConsoleCommand(splitInWords = false, description = "Remove a property from a class", onlineHelp = "SQL-Drop-Property") public void dropProperty( @ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) throws IOException { sqlCommand("drop", iCommandText, "\nRemoved class property in %f sec(s).\n", false); updateDatabaseInfo(); }
@ConsoleCommand(splitInWords = false, description = "Create a new cluster in the current database. The cluster can be physical or memory") public void createCluster( @ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("create", iCommandText, "\nCluster created correctly with id #%d\n", true); updateDatabaseInfo(); }
@ConsoleCommand(splitInWords = false, description = "Drop a user", onlineHelp = "SQL-Drop-User") public void dropUser(@ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("drop", iCommandText, "\nUser dropped successfully.\n", false); updateDatabaseInfo(); }
@ConsoleCommand(splitInWords = false, description = "Remove a class from the schema", onlineHelp = "SQL-Drop-Class") public void dropClass(@ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) throws IOException { sqlCommand("drop", iCommandText, "\nRemoved class in %f sec(s).\n", false); updateDatabaseInfo(); }
@ConsoleCommand(splitInWords = false, description = "Alters a cluster in the current database. The cluster can be physical or memory") public void alterCluster( @ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("alter", iCommandText, "\nCluster updated successfully.\n", false); updateDatabaseInfo(); }
@ConsoleCommand(splitInWords = false, description = "Create a sequence in the database") public void createSequence( @ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("create", iCommandText, "\nSequence created successfully.\n", true); updateDatabaseInfo(); }
@ConsoleCommand(splitInWords = false, description = "Remove a sequence from the database") public void dropSequence( @ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("drop", iCommandText, "Sequence removed successfully.\n", false); updateDatabaseInfo(); }
@ConsoleCommand(splitInWords = false, description = "Create a user", onlineHelp = "SQL-Create-User") public void createUser( @ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("create", iCommandText, "\nUser created successfully.\n", false); updateDatabaseInfo(); }
@ConsoleCommand(splitInWords = false, description = "Alter a class property in the database schema", onlineHelp = "SQL-Alter-Property") public void alterProperty( @ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("alter", iCommandText, "\nProperty updated successfully.\n", false); updateDatabaseInfo(); }
@ConsoleCommand(description = "Reload the database schema") public void reloadSchema() throws IOException { message("\nreloading database schema..."); updateDatabaseInfo(); message("\n\nDone."); }
@ConsoleCommand(splitInWords = false, description = "Create a class", onlineHelp = "SQL-Create-Class") public void createClass( @ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("create", iCommandText, "\nClass created successfully.\n", true); updateDatabaseInfo(); }
@ConsoleCommand(splitInWords = false, description = "Alter an existent sequence in the database") public void alterSequence( @ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("alter", iCommandText, "\nSequence altered successfully.\n", true); updateDatabaseInfo(); }
@ConsoleCommand(splitInWords = false, description = "Create a property", onlineHelp = "SQL-Create-Property") public void createProperty( @ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("create", iCommandText, "\nProperty created successfully.\n", true); updateDatabaseInfo(); }
@ConsoleCommand(splitInWords = false, description = "Remove an index", onlineHelp = "SQL-Drop-Index") public void dropIndex(@ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) throws IOException { message("\n\nRemoving index..."); sqlCommand("drop", iCommandText, "\nDropped index in %f sec(s).\n", false); updateDatabaseInfo(); message("\n\nIndex removed successfully"); }
@ConsoleCommand(splitInWords = false, description = "Create an index against a property", onlineHelp = "SQL-Create-Index") public void createIndex(@ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) throws IOException { message("\n\nCreating index..."); sqlCommand("create", iCommandText, "\nCreated index successfully in %f sec(s).\n", false); updateDatabaseInfo(); message("\n\nIndex created successfully"); }
@ConsoleCommand(splitInWords = false, description = "Rebuild an index if it is automatic", onlineHelp = "SQL-Rebuild-Index") public void rebuildIndex( @ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) throws IOException { message("\n\nRebuilding index(es)..."); sqlCommand("rebuild", iCommandText, "\nRebuilt index(es). Found %d link(s) in %f sec(s).\n", true); updateDatabaseInfo(); message("\n\nIndex(es) rebuilt successfully"); }
@ConsoleCommand(splitInWords = false, description = "Update records in the database", onlineHelp = "SQL-Update") public void update(@ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("update", iCommandText, "\nUpdated record(s) '%s' in %f sec(s).\n", true); updateDatabaseInfo(); currentDatabase.getLocalCache().invalidate(); }
@ConsoleCommand(splitInWords = false, description = "Delete records from the database", onlineHelp = "SQL-Delete") public void delete(@ConsoleParameter(name = "command-text", description = "The command text to execute") String iCommandText) { sqlCommand("delete", iCommandText, "\nDelete record(s) '%s' in %f sec(s).\n", true); updateDatabaseInfo(); currentDatabase.getLocalCache().invalidate(); }