Examples with Database com.google.spanner.admin.database.v1.Database used on opensource projects

Example 41 with Database

use of com.google.spanner.admin.database.v1.Database in project java-spanner by googleapis.

the class DatabaseAdminClient method dropDatabase.

// AUTO-GENERATED DOCUMENTATION AND METHOD.
/**
 * Drops (aka deletes) a Cloud Spanner database. Completed backups for the database will be
 * retained according to their `expire_time`. Note: Cloud Spanner might continue to accept
 * requests for a few seconds after the database has been deleted.
 *
 * <p>Sample code:
 *
 * <pre>{@code
 * try (DatabaseAdminClient databaseAdminClient = DatabaseAdminClient.create()) {
 *   DatabaseName database = DatabaseName.of("[PROJECT]", "[INSTANCE]", "[DATABASE]");
 *   databaseAdminClient.dropDatabase(database);
 * }
 * }</pre>
 *
 * @param database Required. The database to be dropped.
 * @throws com.google.api.gax.rpc.ApiException if the remote call fails
 */
public final void dropDatabase(DatabaseName database) {
    DropDatabaseRequest request = DropDatabaseRequest.newBuilder().setDatabase(database == null ? null : database.toString()).build();
    dropDatabase(request);
}

Example 42 with Database

use of com.google.spanner.admin.database.v1.Database in project java-spanner by googleapis.

the class DatabaseAdminClient method dropDatabase.

// AUTO-GENERATED DOCUMENTATION AND METHOD.
/**
 * Drops (aka deletes) a Cloud Spanner database. Completed backups for the database will be
 * retained according to their `expire_time`. Note: Cloud Spanner might continue to accept
 * requests for a few seconds after the database has been deleted.
 *
 * <p>Sample code:
 *
 * <pre>{@code
 * try (DatabaseAdminClient databaseAdminClient = DatabaseAdminClient.create()) {
 *   String database = DatabaseName.of("[PROJECT]", "[INSTANCE]", "[DATABASE]").toString();
 *   databaseAdminClient.dropDatabase(database);
 * }
 * }</pre>
 *
 * @param database Required. The database to be dropped.
 * @throws com.google.api.gax.rpc.ApiException if the remote call fails
 */
public final void dropDatabase(String database) {
    DropDatabaseRequest request = DropDatabaseRequest.newBuilder().setDatabase(database).build();
    dropDatabase(request);
}

Example 43 with Database

use of com.google.spanner.admin.database.v1.Database in project molgenis-emx2 by molgenis.

the class TestEmx2Roles method setup.

@BeforeClass
public static void setup() {
    Database database = TestDatabaseFactory.getTestDatabase();
    schema = database.dropCreateSchema(TestEmx2Roles.class.getSimpleName());
}

Example 44 with Database

use of com.google.spanner.admin.database.v1.Database in project molgenis-emx2 by molgenis.

the class TestImportTableTask method setup.

@BeforeClass
public static void setup() {
    Database database = TestDatabaseFactory.getTestDatabase();
    schema = database.dropCreateSchema(TestImportTableTask.class.getSimpleName());
}

Example 45 with Database

use of com.google.spanner.admin.database.v1.Database in project molgenis-emx2 by molgenis.

the class Benchmark method testCopyInAndOut.

public void testCopyInAndOut() {
    Database database = TestDatabaseFactory.getTestDatabase();
    Schema schema = database.dropCreateSchema(Benchmark.class.getSimpleName());
    int aSize = 50;
    int bSize = 100000;
    Table a = schema.create(table("TableA").add(column("ID").setPkey()));
    List<String> values = new ArrayList<>();
    Table b = schema.create(table("TableB").add(column("ID").setPkey()).add(column("ref").setType(REF_ARRAY).setRefTable("TableA")));
    // Table c =
    // schema.create(
    // table("TableC")
    // .add(column("ID").setPkey())
    // .add(column("ref").setType(MREF).setRefTable("TableA")));
    StopWatch.start("benchmark started");
    List<Row> aRows = new ArrayList<>();
    for (int i = 0; i < aSize; i++) {
        aRows.add(new Row().set("ID", "row" + i));
        values.add("row" + i);
    }
    StopWatch.start("benchmark1");
    a.insert(aRows);
    StopWatch.print("inserted primary", aSize);
    aRows.clear();
    List<Row> bRows = new ArrayList<>();
    for (int i = 0; i < bSize; i++) {
        bRows.add(new Row().set("ID", "row" + i).set("ref", values));
    }
    StopWatch.start("benchmark2 started");
    b.insert(bRows);
    StopWatch.print("inserted ref_array", bSize);
    bRows.clear();
// List<Row> cRows = new ArrayList<>();
// for (int i = 0; i < bSize; i++) {
// cRows.add(new Row().set("ID", "row" + i).set("ref", values));
// }
// StopWatch.start("benchmark3 started");
// c.insert(cRows);
// StopWatch.print("inserted mref", bSize);
// cRows.clear();
// StopWatch.print("inserted mref", bSize);
// ref_array
}