Example Data

The examples in this reference are based on the Adaptor for MySQL databases prototype deployed to Google AppEngine.

The prototype is connected to a database with the following tables and data:

Car Table

Column NameMySql Data Type
_idvarchar(36)
_ownervarchar(36)
date_addeddatetime
makevarchar(100)
modelvarchar(100)
yearint

Car Table Data

_id_ownermakemodelyeardate_added
86cbf595-d369-48bb-8649-c6c082c003ca81c9168e-95b8-47fd-8e6a-ad9fdf71b38eFordMustang19952001-06-07 21:00:00.0
95953ca3-5fe5-4ce7-9cca-9bcc1ba64ba681c9168e-95b8-47fd-8e6a-ad9fdf71b38eToyotaCorolla20192020-09-30 21:30:00.0
1e68ce9c-a7bc-4440-a9d4-7ce6b42e5be881c9168e-95b8-47fd-8e6a-ad9fdf71b38eMercedes-BenzE Coupe20202020-06-16 21:30:00.0
6d04fb52-f317-4d7b-bc23-46dd1c74d5a881c9168e-95b8-47fd-8e6a-ad9fdf71b38eHyundaiTuscon20052020-08-31 21:00:00.0
f551864f-4022-430e-b311-0215b9c9ac3881c9168e-95b8-47fd-8e6a-ad9fdf71b38eHyundaiI2020182018-07-31 21:00:00.0
295f6831-ce44-429d-aeb9-e3a91cdfc6e081c9168e-95b8-47fd-8e6a-ad9fdf71b38eNissanMaxima20122012-07-31 21:00:00.0
20cd8f8d-1a0f-4530-91df-6d31fe9e83a581c9168e-95b8-47fd-8e6a-ad9fdf71b38eFerrari812GTS20202020-03-31 21:00:00.0
4b0841dc-2355-4351-9cbc-2b6c9cf53cec81c9168e-95b8-47fd-8e6a-ad9fdf71b38eMazdaMX520032002-12-09 22:00:00.0

Manufacturer Table

Column NameMySql Data Type
namevarchar(100)
countryvarchar(100)
establisheddatetime
share_pricedecimal(10,2)
_idvarchar(36)
_ownervarchar(36)

Manufacturer Table Data

namecountryestablishedshare_price_id_owner
FordUSA1903-01-01 12:00:00.06abc-123
NissanJapan1933-12-06 12:00:00.04.12abc-124
Mercedes-BenzGermany1926-01-01 12:00:00.01.45abc-125
MazdaJapan1920-01-30 12:00:00.06.96abc-126
FerrariItaly1947-01-01 12:00:00.0152abc-127
CitroenFrance1919-01-01 00:00:00.02.34abc-128
HyundaiKorea1967-01-01 00:00:00.07.41abc-129
Was this helpful?
Yes
No