Seed Database - TrackingChains/TrackingChain GitHub Wiki
This is an example of a seed with preset data to be able to use some smart contracts, node endpont and account already present on Shibuya Ink, Rococo Ink, Shibuya Evm and Moonbase Evm.
Provided accounts are already stocked with enough gas to perform all test transactions. However, the private keys are still missing, which will need to be replaced with the specific private keys listed on this other page to ensure security.
To install your favorite SQL client, you can choose from this list: SQL Tools Overview. For Windows users, it is highly recommended to use SQL Server Management Studio (SSMS).
In the configuration below, we use several chains:
Below is a configuration that allows you to use chains
- Contract Rococo
- Shibuya Substrate
- Shibuya EVM
- Moonbase EVM
Provided accounts are already stocked with enough gas to perform all test transactions. However, the private keys are still missing, which will need to be replaced with the specific private keys listed on this other page to ensure security.
-- Astar Test EVM
insert into [Accounts] (Id, ChainWriterAddress, ChainWatcherAddress, Name, PrivateKey) values
('4F8E591B-6A9C-486E-AB2B-2B42ABBF5B23','https://shibuya.blastapi.io/c8707e18-84fe-4b15-9665-a2897c0687df', 'https://shibuya.blastapi.io/c8707e18-84fe-4b15-9665-a2897c0687df', 'Astar Test EVM One', '4907f53615b76294a1238fbc9a9cd3d140beb9730b42085dc4c63e550a75357e');
insert into [Accounts] (Id, ChainWriterAddress, ChainWatcherAddress, Name, PrivateKey) values
('5F8E591B-6A9C-486E-AB2B-2B42ABBF5B23', 'https://shibuya.blastapi.io/7a2921d5-7c0c-411d-b687-4ba57cfbff25', 'https://shibuya.blastapi.io/7a2921d5-7c0c-411d-b687-4ba57cfbff25', 'Astar Test EVM Two', '7f73040cc57fbcaa07ce6234cc6c153b982c9c73b5c9983aff0b108f99e6988d');
insert into [Accounts] (Id, ChainWriterAddress, ChainWatcherAddress, Name, PrivateKey) values
('6F8E591B-6A9C-486E-AB2B-2B42ABBF5B23','https://shibuya.blastapi.io/c8707e18-84fe-4b15-9665-a2897c0687df', 'https://shibuya.blastapi.io/c8707e18-84fe-4b15-9665-a2897c0687df', 'Astar Test EVM Three', '21ff508926baa340d88a9157eeb03e969a676630951fa79e0d26a7a4a8288f68');
-- Moonbeam Test EVM
insert into [Accounts] (Id, ChainWriterAddress, ChainWatcherAddress, Name, PrivateKey) values
('8F8E591B-6A9C-486E-AB2B-2B42ABBF5B23','https://moonbase-alpha.blastapi.io/11cd5d86-565d-4b84-9cac-84cd08511215', 'https://moonbase-alpha.blastapi.io/11cd5d86-565d-4b84-9cac-84cd08511215', 'Moonbeam Test EVM One', 'f60b7f53ae9593503174f55f5e236170d26c75e5a9beaf60c479b49563256a18');
insert into [Accounts] (Id, ChainWriterAddress, ChainWatcherAddress, Name, PrivateKey) values
('9F8E591B-6A9C-486E-AB2B-2B42ABBF5B23','https://moonbase-alpha.blastapi.io/4e06bea6-56f2-40e0-a400-2e95f07a87e9', 'https://moonbase-alpha.blastapi.io/4e06bea6-56f2-40e0-a400-2e95f07a87e9', 'Moonbeam Test EVM Two', '7f4e1faf35cdbb5331fc52ed605ca3e9a341f65651c5be85651915be780b5c8f');
-- Astar Test Ink
insert into [Accounts] (Id, ChainWriterAddress, ChainWatcherAddress, Name, PrivateKey) values
('1F8E591B-6A9C-486E-AB2B-2B42ABBF5B23','wss://shibuya.blastapi.io/c8707e18-84fe-4b15-9665-a2897c0687df', 'https://shibuya.api.subscan.io|c5b981ec4efa4ad69a39578e81f1d583', 'Astar Test Ink', '0x4874841a4694f021ea71a08f5bedd26e6e5f3ecc3240d41d72dad937d20a9d14');
-- Contract Rococo Test Ink
insert into [Accounts] (Id, ChainWriterAddress, ChainWatcherAddress, Name, PrivateKey) values
('2F8E591B-6A9C-486E-AB2B-2B42ABBF5B23','wss://rococo-contracts-rpc.polkadot.io', '', 'Rococo Test Ink','0xe6191a72d53e2825ff5d379187c9b67f38241e9d70308603c759eaef6336b075');
-- SmartContract
insert into [SmartContract] (Address, ChainNumberId, ChainType, Currency, ExtraInfo, Name) values
('0xa0532A56179Eb1677D33709db82de6b5880f23c6', 81, 0, 'SBY', '{"WaitingSecondsForWatcherTx":90}', 'Shibuya Test Net EVM');
insert into [SmartContract] (Address, ChainNumberId, ChainType, Currency, ExtraInfo, Name) values
('0x55D64aB19C01e135b86429D9367DfCEE3EF615a3', 1287, 0, 'DEV', '{"WaitingSecondsForWatcherTx":90}', 'Moonbase Test Net');
insert into [SmartContract] (Address, ChainNumberId, ChainType, Currency, ExtraInfo, Name) values
('XqLt7FSZrn8nffSGkRYWZKn4JCWZBvHNH3sTRnQL4qDr2Dp', 101, 1, 'SBY', '{"InsertTrackSelectorValue":"0x1ba63d86","InsertTrackProofSize":125952,"InsertTrackRefTime":4793859072,"InsertTrackBasicWeight":14000000000000,"ByteWeight":10000000000000,"SupportedClient":0,"WaitingSecondsForWatcherTx":90,"WaitingForResult":false}', 'Shibuya Test Net INK');
insert into [SmartContract] (Address, ChainNumberId, ChainType, Currency, ExtraInfo, Name) values
('5C557tarfZcHfxAeCLd67wNjuQCiuvaJr23Qd56kPjUxn382', 9420, 1, 'ROC', '{"InsertTrackSelectorValue":"0x1ba63d86","InsertTrackProofSize":125952,"InsertTrackRefTime":4793859072,"InsertTrackBasicWeight":6750999942,"ByteWeight":39999999960000,"SupportedClient":1,"WaitingSecondsForWatcherTx":90,"WaitingForResult":true}', 'Contract Rococo Test Net INK');
-- Profile
insert into [ProfileGroups] (Id, AggregationCode, Authority, Category, Name, SmartContractId, Priority) values
('8F8E591B-6A9C-486E-AB2B-2B42ABBF5B23', NULL, NULL, 'Shibuya EVM', 'EVM Solidity Shibuya', 1, 0);
insert into [ProfileGroups] (Id, AggregationCode, Authority, Category, Name, SmartContractId, Priority) values
('DB909755-29D0-4AA4-8815-C77232743991', NULL, NULL, 'Moonbase EVM', 'EVM Solidity Moonbase', 2, 0);
insert into [ProfileGroups] (Id, AggregationCode, Authority, Category, Name, SmartContractId, Priority) values
('71D944E7-CC29-4CA2-9B4D-78A07A503A52', NULL, NULL, 'Shibuya Ink', 'Substrate Ink Shibuya', 3, 0);
insert into [ProfileGroups] (Id, AggregationCode, Authority, Category, Name, SmartContractId, Priority) values
('51D944E7-CC29-4CA2-9B4D-78A07A503A52', NULL, NULL, 'Rococo Ink', 'Substrate Ink Contract Rococo', 4, 0);
-- Profile Shibuya EVM
insert into [AccountProfileGroup] (Name, AccountId, ProfileGroupId, Priority) values
('First Shibuya EVM', '4F8E591B-6A9C-486E-AB2B-2B42ABBF5B23', '8F8E591B-6A9C-486E-AB2B-2B42ABBF5B23', 0);
insert into [AccountProfileGroup] (Name, AccountId, ProfileGroupId, Priority) values
('Second Shibuya EVM', '5F8E591B-6A9C-486E-AB2B-2B42ABBF5B23', '8F8E591B-6A9C-486E-AB2B-2B42ABBF5B23', 0);
insert into [AccountProfileGroup] (Name, AccountId, ProfileGroupId, Priority) values
('Last Shibuya EVM', '6F8E591B-6A9C-486E-AB2B-2B42ABBF5B23', '8F8E591B-6A9C-486E-AB2B-2B42ABBF5B23', 0);
-- Profile Moonbase EVM
insert into [AccountProfileGroup] (Name, AccountId, ProfileGroupId, Priority) values
('First Moonbase EVM', '8F8E591B-6A9C-486E-AB2B-2B42ABBF5B23', 'DB909755-29D0-4AA4-8815-C77232743991', 0);
insert into [AccountProfileGroup] (Name, AccountId, ProfileGroupId, Priority) values
('Second Moonbase EVM', '9F8E591B-6A9C-486E-AB2B-2B42ABBF5B23', 'DB909755-29D0-4AA4-8815-C77232743991', 0);
-- Profile Shibuya Ink
insert into [AccountProfileGroup] (Name, AccountId, ProfileGroupId, Priority) values
('Shibuya Ink', '1F8E591B-6A9C-486E-AB2B-2B42ABBF5B23', '71D944E7-CC29-4CA2-9B4D-78A07A503A52', 0);
-- Contract Rococo Ink
insert into [AccountProfileGroup] (Name, AccountId, ProfileGroupId, Priority) values
('Rococo Ink', '2F8E591B-6A9C-486E-AB2B-2B42ABBF5B23', '51D944E7-CC29-4CA2-9B4D-78A07A503A52', 0);
Note that in the rows relating to the Smart Contract table, a JSON object is present in the "ExtraInfo" column.
{
"InsertTrackSelectorValue": "0x1ba63d86",
"InsertTrackProofSize": 125952,
"InsertTrackRefTime": 4793859072,
"InsertTrackBasicWeight": 14000000000,
"ByteWeight": 1000000000,
"SupportedClient": 0,
"WaitingSecondsForWatcherTx": 90
}
Here are the values extracted during the deployment of the Ink smart contracts, i.e. ProofSize, RefTime, BasicWeight, ByteWeight in this case you won't have to do anything because correct values have already been entered.
Also, if you have correctly replaced the missing private keys with the ones specified in the dedicated page, allora siete pronti per procedere alla fase di lancio degli altri servizi.