com.google.cloud.spanner.Database Java Examples
The following examples show how to use
com.google.cloud.spanner.Database.
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example #1
| Source File: SpannerTasks.java From java-docs-samples with Apache License 2.0 | 6 votes |
|
private static void createDatabase(PrintWriter pw)
throws InterruptedException, ExecutionException {
Iterable<String> statements =
Arrays.asList(
"CREATE TABLE Singers (\n"
+ " SingerId INT64 NOT NULL,\n"
+ " FirstName STRING(1024),\n"
+ " LastName STRING(1024),\n"
+ " SingerInfo BYTES(MAX)\n"
+ ") PRIMARY KEY (SingerId)",
"CREATE TABLE Albums (\n"
+ " SingerId INT64 NOT NULL,\n"
+ " AlbumId INT64 NOT NULL,\n"
+ " AlbumTitle STRING(MAX)\n"
+ ") PRIMARY KEY (SingerId, AlbumId),\n"
+ " INTERLEAVE IN PARENT Singers ON DELETE CASCADE");
Database db =
SpannerClient.getDatabaseAdminClient()
.createDatabase(
SpannerClient.getInstanceId(), SpannerClient.getDatabaseId(), statements)
.get();
pw.println("Created database [" + db.getId() + "]");
}
Example #2
| Source File: SpannerTasks.java From java-docs-samples with Apache License 2.0 | 6 votes |
|
private static void createDatabase(PrintWriter pw)
throws InterruptedException, ExecutionException {
Iterable<String> statements =
Arrays.asList(
"CREATE TABLE Singers (\n"
+ " SingerId INT64 NOT NULL,\n"
+ " FirstName STRING(1024),\n"
+ " LastName STRING(1024),\n"
+ " SingerInfo BYTES(MAX)\n"
+ ") PRIMARY KEY (SingerId)",
"CREATE TABLE Albums (\n"
+ " SingerId INT64 NOT NULL,\n"
+ " AlbumId INT64 NOT NULL,\n"
+ " AlbumTitle STRING(MAX)\n"
+ ") PRIMARY KEY (SingerId, AlbumId),\n"
+ " INTERLEAVE IN PARENT Singers ON DELETE CASCADE");
Database db =
SpannerClient.getDatabaseAdminClient()
.createDatabase(
SpannerClient.getInstanceId(), SpannerClient.getDatabaseId(), statements)
.get();
pw.println("Created database [" + db.getId() + "]");
}
Example #3
| Source File: SpannerDatabaseAdminTemplate.java From spring-cloud-gcp with Apache License 2.0 | 5 votes |
|
/**
* Returns true if the configured database ID refers to an existing database. False
* otherwise.
* @return true if the database exists, and false if it does not.
*/
public boolean databaseExists() {
for (Database db : this.databaseAdminClient.listDatabases(getInstanceId())
.getValues()) {
if (getDatabase().equals(db.getId().getDatabase())) {
return true;
}
}
return false;
}
Example #4
| Source File: SpannerDatabaseAdminTemplateTests.java From spring-cloud-gcp with Apache License 2.0 | 5 votes |
|
@Test
public void executeDdlStrings_createsDatabaseIfMissing() throws Exception {
when(this.mockDatabasePage.getValues()).thenReturn(Arrays.asList(
new Database(this.databaseId, State.READY, this.databaseAdminClient)));
OperationFuture<Void, UpdateDatabaseDdlMetadata> mockFuture = mock(OperationFuture.class);
when(this.databaseAdminClient.updateDatabaseDdl("fakeinstance", "fakedb", this.ddlList, null)).thenReturn(mockFuture);
when(mockFuture.get()).thenReturn(null);
this.spannerDatabaseAdminTemplate.executeDdlStrings(this.ddlList, true);
verify(this.databaseAdminClient, times(0)).createDatabase("fakeinstance", "fakedb", Arrays.asList("describe Something"));
verify(this.databaseAdminClient).updateDatabaseDdl("fakeinstance", "fakedb", this.ddlList, null);
}
Example #5
| Source File: SpannerDatabaseAdminTemplateTests.java From spring-cloud-gcp with Apache License 2.0 | 5 votes |
|
@Test
public void executeDdlStrings_doesNotCreateDatabaseIfAlreadyPresent() throws Exception {
when(this.mockDatabasePage.getValues()).thenReturn(Arrays.asList());
OperationFuture<Database, CreateDatabaseMetadata> mockFuture = mock(OperationFuture.class);
when(this.databaseAdminClient.createDatabase("fakeinstance", "fakedb", this.ddlList)).thenReturn(mockFuture);
when(mockFuture.get()).thenReturn(null);
this.spannerDatabaseAdminTemplate.executeDdlStrings(this.ddlList, true);
verify(this.databaseAdminClient).createDatabase("fakeinstance", "fakedb", Arrays.asList("describe Something"));
verify(this.databaseAdminClient, times(0)).updateDatabaseDdl("fakeinstance", "fakedb", this.ddlList, null);
}
Example #6
| Source File: SpannerReadIT.java From beam with Apache License 2.0 | 5 votes |
|
@Before
public void setUp() throws Exception {
PipelineOptionsFactory.register(SpannerTestPipelineOptions.class);
options = TestPipeline.testingPipelineOptions().as(SpannerTestPipelineOptions.class);
project = options.getInstanceProjectId();
if (project == null) {
project = options.as(GcpOptions.class).getProject();
}
spanner = SpannerOptions.newBuilder().setProjectId(project).build().getService();
databaseName = generateDatabaseName();
databaseAdminClient = spanner.getDatabaseAdminClient();
// Delete database if exists.
databaseAdminClient.dropDatabase(options.getInstanceId(), databaseName);
OperationFuture<Database, CreateDatabaseMetadata> op =
databaseAdminClient.createDatabase(
options.getInstanceId(),
databaseName,
Collections.singleton(
"CREATE TABLE "
+ options.getTable()
+ " ("
+ " Key INT64,"
+ " Value STRING(MAX),"
+ ") PRIMARY KEY (Key)"));
op.get();
makeTestData();
}
Example #7
| Source File: SpannerWriteIT.java From beam with Apache License 2.0 | 5 votes |
|
@Before
public void setUp() throws Exception {
PipelineOptionsFactory.register(SpannerTestPipelineOptions.class);
options = TestPipeline.testingPipelineOptions().as(SpannerTestPipelineOptions.class);
project = options.getInstanceProjectId();
if (project == null) {
project = options.as(GcpOptions.class).getProject();
}
spanner = SpannerOptions.newBuilder().setProjectId(project).build().getService();
databaseName = generateDatabaseName();
databaseAdminClient = spanner.getDatabaseAdminClient();
// Delete database if exists.
databaseAdminClient.dropDatabase(options.getInstanceId(), databaseName);
OperationFuture<Database, CreateDatabaseMetadata> op =
databaseAdminClient.createDatabase(
options.getInstanceId(),
databaseName,
Collections.singleton(
"CREATE TABLE "
+ options.getTable()
+ " ("
+ " Key INT64,"
+ " Value STRING(MAX) NOT NULL,"
+ ") PRIMARY KEY (Key)"));
op.get();
}
Example #8
| Source File: DatabaseAdminClientSnippets.java From google-cloud-java with Apache License 2.0 | 5 votes |
|
/** Example to getDatabase. */
// [TARGET getDatabase(String, String)]
// [VARIABLE my_instance_id]
// [VARIABLE my_database_id]
public Database getDatabase(String instanceId, String databaseId) {
// [START getDatabase]
Database db = dbAdminClient.getDatabase(instanceId, databaseId);
// [END getDatabase]
return db;
}
Example #9
| Source File: DatabaseAdminClientSnippets.java From google-cloud-java with Apache License 2.0 | 5 votes |
|
/** Example to get the list of Cloud Spanner database in the given instance. */
// [TARGET listDatabases(String, ListOption...)]
// [VARIABLE my_instance_id]
public List<Database> listDatabases(String instanceId) {
// [START listDatabases]
Page<Database> page = dbAdminClient.listDatabases(instanceId, Options.pageSize(1));
List<Database> dbs = new ArrayList<>();
while (page != null) {
Database db = Iterables.getOnlyElement(page.getValues());
dbs.add(db);
page = page.getNextPage();
}
// [END listDatabases]
return dbs;
}
Example #10
| Source File: CreateDatabase.java From quetzal with Eclipse Public License 2.0 | 5 votes |
|
static void createDatabase(DatabaseAdminClient dbAdminClient, DatabaseId id) {
Operation<Database, CreateDatabaseMetadata> op = dbAdminClient.createDatabase(
id.getInstanceId().getInstance(), id.getDatabase(),
Arrays.asList("CREATE TABLE DPH (\n" + " subject STRING(MAX) NOT NULL,\n"
+ " col_0 ARRAY<STRING(MAX)>, \n" + " col_1 ARRAY<STRING(MAX)>, \n"
+ " col_2 STRING(MAX), \n" + " col_3 STRING(MAX), \n" + " col_4 STRING(MAX), \n"
+ " col_5 STRING(MAX), \n" + " col_6 STRING(MAX), \n"
+ " col_7 ARRAY<STRING(MAX)>, \n" + " col_8 STRING(MAX), \n"
+ " col_9 STRING(MAX), \n" + " col_10 STRING(MAX), \n" + " col_11 STRING(MAX), \n"
+ " col_12 STRING(MAX), \n" + " col_13 STRING(MAX), \n"
+ " col_14 ARRAY<STRING(MAX)>, \n" + " col_15 STRING(MAX), \n"
+ " col_16 STRING(MAX)) \n" + " PRIMARY KEY (subject)"));
Database db = op.waitFor().getResult();
System.out.println("Created database [" + db.getId() + "]");
}
Example #11
| Source File: SpannerGroupWriteIT.java From java-docs-samples with Apache License 2.0 | 4 votes |
|
@Before
public void setUp() throws Exception {
instanceId = System.getProperty("spanner.test.instance");
databaseId = "df-spanner-gwrite-it-" + random.nextInt(1000000000);
spannerOptions = SpannerOptions.getDefaultInstance();
spanner = spannerOptions.getService();
DatabaseAdminClient adminClient = spanner.getDatabaseAdminClient();
try {
adminClient.dropDatabase(instanceId, databaseId);
} catch (SpannerException e) {
// Does not exist, ignore.
}
OperationFuture<Database, CreateDatabaseMetadata> op =
adminClient.createDatabase(
instanceId,
databaseId,
Arrays.asList(
"CREATE TABLE users ("
+ "id STRING(MAX) NOT NULL, state STRING(MAX) NOT NULL) PRIMARY KEY (id)",
"CREATE TABLE PendingReviews (id INT64, action STRING(MAX), "
+ "note STRING(MAX), userId STRING(MAX),) PRIMARY KEY (id)"));
op.get();
DatabaseClient dbClient = getDbClient();
List<Mutation> mutations = new ArrayList<>();
for (int i = 0; i < 20; i++) {
mutations.add(
Mutation.newInsertBuilder("users")
.set("id")
.to(Integer.toString(i))
.set("state")
.to("ACTIVE")
.build());
}
TransactionRunner runner = dbClient.readWriteTransaction();
runner.run(
new TransactionRunner.TransactionCallable<Void>() {
@Nullable
@Override
public Void run(TransactionContext tx) {
tx.buffer(mutations);
return null;
}
});
String content =
IntStream.range(0, 10).mapToObj(Integer::toString).collect(Collectors.joining("\n"));
tempPath = Files.createTempFile("suspicious-ids", "txt");
Files.write(tempPath, content.getBytes());
}
Example #12
| Source File: SpannerReadIT.java From java-docs-samples with Apache License 2.0 | 4 votes |
|
@Before
public void setUp() throws InterruptedException, ExecutionException {
instanceId = System.getProperty("spanner.test.instance");
databaseId = "df-spanner-read-it-" + random.nextInt(1000000000);
spannerOptions = SpannerOptions.getDefaultInstance();
spanner = spannerOptions.getService();
DatabaseAdminClient adminClient = spanner.getDatabaseAdminClient();
try {
adminClient.dropDatabase(instanceId, databaseId);
} catch (SpannerException e) {
// Does not exist, ignore.
}
OperationFuture<Database, CreateDatabaseMetadata> op =
adminClient.createDatabase(
instanceId,
databaseId,
Arrays.asList(
"CREATE TABLE Singers "
+ "(singerId INT64 NOT NULL, firstName STRING(MAX) NOT NULL, "
+ "lastName STRING(MAX) NOT NULL,) PRIMARY KEY (singerId)",
"CREATE TABLE Albums (singerId INT64 NOT NULL, albumId INT64 NOT NULL, "
+ "albumTitle STRING(MAX) NOT NULL,) PRIMARY KEY (singerId, albumId)"));
op.get();
List<Mutation> mutations =
Arrays.asList(
Mutation.newInsertBuilder("singers")
.set("singerId")
.to(1L)
.set("firstName")
.to("John")
.set("lastName")
.to("Lennon")
.build(),
Mutation.newInsertBuilder("singers")
.set("singerId")
.to(2L)
.set("firstName")
.to("Paul")
.set("lastName")
.to("Mccartney")
.build(),
Mutation.newInsertBuilder("singers")
.set("singerId")
.to(3L)
.set("firstName")
.to("George")
.set("lastName")
.to("Harrison")
.build(),
Mutation.newInsertBuilder("singers")
.set("singerId")
.to(4L)
.set("firstName")
.to("Ringo")
.set("lastName")
.to("Starr")
.build(),
Mutation.newInsertBuilder("albums")
.set("singerId")
.to(1L)
.set("albumId")
.to(1L)
.set("albumTitle")
.to("Imagine")
.build(),
Mutation.newInsertBuilder("albums")
.set("singerId")
.to(2L)
.set("albumId")
.to(1L)
.set("albumTitle")
.to("Pipes of Peace")
.build());
DatabaseClient dbClient = getDbClient();
TransactionRunner runner = dbClient.readWriteTransaction();
runner.run(
new TransactionRunner.TransactionCallable<Void>() {
@Nullable
@Override
public Void run(TransactionContext tx) {
tx.buffer(mutations);
return null;
}
});
}
Example #13
| Source File: SpannerWriteIT.java From java-docs-samples with Apache License 2.0 | 4 votes |
|
@Before
public void setUp() throws Exception {
instanceId = System.getProperty("spanner.test.instance");
databaseId = "df-spanner-write-it-" + random.nextInt(1000000000);
spannerOptions = SpannerOptions.getDefaultInstance();
spanner = spannerOptions.getService();
DatabaseAdminClient adminClient = spanner.getDatabaseAdminClient();
try {
adminClient.dropDatabase(instanceId, databaseId);
} catch (SpannerException e) {
// Does not exist, ignore.
}
OperationFuture<Database, CreateDatabaseMetadata> op =
adminClient.createDatabase(
instanceId,
databaseId,
Arrays.asList(
"CREATE TABLE Singers "
+ "(singerId INT64 NOT NULL, "
+ "firstName STRING(MAX) NOT NULL, lastName STRING(MAX) NOT NULL,) "
+ "PRIMARY KEY (singerId)",
"CREATE TABLE Albums (singerId INT64 NOT NULL, "
+ "albumId INT64 NOT NULL, albumTitle STRING(MAX) NOT NULL,) "
+ "PRIMARY KEY (singerId, albumId)"));
op.get();
String singers =
Stream.of("1\tJohn\tLennon", "2\tPaul\tMccartney", "3\tGeorge\tHarrison", "4\tRingo\tStarr")
.collect(Collectors.joining("\n"));
singersPath = Files.createTempFile("singers", "txt");
Files.write(singersPath, singers.getBytes());
String albums =
Stream.of("1\t1\tImagine", "2\t1\tPipes of Peace", "3\t1\tDark Horse")
.collect(Collectors.joining("\n"));
albumsPath = Files.createTempFile("albums", "txt");
Files.write(albumsPath, albums.getBytes());
}
