Questions tagged [table]
The table tag has no usage guidance.
62
questions
2
votes
1answer
23 views
how to get tables rows count in plugin
auto chain_plug = app().find_plugin<chain_plugin>();
eosio::chain_apis::read_only::get_table_by_scope_params param{N("eosio.token"), N("stat"), "EOS", "EOS&...
2
votes
1answer
23 views
Altering userres and delband tables after set_resource_limit(-1, -1, -1)
For a private network to remove ram net cpu i set the resource limit to unlimited for each newaccount created. By chaging set_resource_limits to set_resource_limits( newact, -1, -1, -1 ); //unlimited ...
0
votes
1answer
28 views
Wrong table name in scope response
My contract has two tables mcat and mcatmig.
Problem: scope request return wrong table name mcat........1 instead of mcatmig:
% cleos get scope teresacode
{
"rows": [{
"code": "teresacode",
"...
1
vote
1answer
51 views
cleos data getting inserted and deleted but table shows empty record
I have written one smart contract for insert, update and delete data. The smart contract is compiled and deployed to the two accounts. I insert data using calling the action upsert, this transaction ...
0
votes
1answer
31 views
Is it possible to add a secondary index to a table that already exists and contains entries?
If a table already exists in a smart contract on-chain and the table is full of entries, is it possible to make a secondary index for that table? Or would you have to create a new table and migrate ...
1
vote
0answers
18 views
unordered map in eosio-cpp
I want to have an unordered_map inside a table so that I can have O(1) entry and retrieval. Can someone please link me to a snippet which implements that? I am new to cpp.
0
votes
1answer
57 views
Is there way to retrieve auto incremented primary key after submission of transaction?
I'm working on sample dApp application to understand the working of multi_index table in EOS smart contract.
I have defined two multi_index table. The primary key of table1 is auto incremented using "...
1
vote
1answer
224 views
How can we retrieve table data with secondary Index in EOS table
this is my table
struct [[eosio::table]] payment_made
{
uint64_t pay_id;
uint64_t loan_id;
uint64_t pay_amunt;
time_point_sec pay_date_req;
time_point_sec pay_date_approve;
...
0
votes
1answer
32 views
Multi index table asks an unusual permission to emplace new row
Problem
I'm trying to emplace a new row in a multi-index table, but it tells me that I don't have the authotity of the row key name to do it.
Code
Multi-index table definition
struct [[eosio::...
0
votes
1answer
190 views
Can we store date on eosio table?
Is there any direct datatype in eosio to store date? and if not then how can we store dates in eosio table?
void mainloan::paymentConfirm(uint64_t pay_id,uint64_t pay_date,double pay_amunt,name from ...
1
vote
0answers
25 views
Which of the following is better for CRUD in a table?
I have two approaches to save data on blockchain, but I don't know which one is the best from time as well as space complexity perspectives. I want to store key value pairs in a table.
First Approach:...
1
vote
1answer
34 views
what are supported STL types in tables?
What are the supported STL types in tables? I'm specifically curious about std::pair
2
votes
0answers
34 views
Fetching More Table Rows via RPC
I have a contract with a table in it. I'm querying the contents of the table using the RPC interface, but I'm having trouble getting all the rows. To limit the memory usage of my application, I'm ...
1
vote
1answer
73 views
How to delete record on EOS if I forget table structure
I issue an EOS token for fun half a year ago and I'm planning to release my EOS ram recently.
The problem is that I forget the table structure I made before and I overwrite the contract and there is ...
2
votes
1answer
82 views
How to reclaim ram?
If a user is the authenticator when adding a row to a table, on chain, they supply the ram required to instantiate the new row.
In the case of certain tokens, mainly airdropped tokens, the contract ...
4
votes
2answers
469 views
Get Table Rows with Pagination
How do we get records from a table by pages?
My requirement: I have a table with 100 records and want to display all these records in my front-end-application with 10 records per page and if the user ...
0
votes
1answer
38 views
why i get “uniqueness constraint was violated” on error on empty table?
i defined a table but i made a mistake putting the fields in wrong order within EOSLIB_SERIALIZE
EOSLIB_SERIALIZE( tablename,(field1)(field4)(field3)(field2));
i did some insertions with emplace ...
3
votes
1answer
195 views
Why does using available_primary_key() as scope for a table result in this behaviour?
Scenario:
Two tables, each using uint64_t as a primary key
Table A rows need to reference rows in Table B
Why? Relational database data duplication reasoning etc etc
Both table's primary keys are ...
0
votes
3answers
136 views
Smart contract - find on two columns
I am currently writing a blog PoC on EOS. I would like the ability to delete a post. Now deleting by the ID alone is simple, I have it implemented as follows:
whisper::post_index posts(_code, _code....
0
votes
2answers
202 views
Erasing records with for loops
if I want to erase a table:
orderbook b(_self, _self.value);
auto m = b.get_index<name("idxprod")>();
for (auto &i : m) {
m.erase(i);
}
I get the error:
Error 3160005: The table ...
4
votes
1answer
247 views
How to sort a table?
I'm following this explanation https://developers.eos.io/eosio-cpp/v1.1.0/docs/multi-index-table-tutorial using v1.5.0 of the CDT. Here's what I've got:
struct [[eosio::table]] order_struct {
...
0
votes
1answer
42 views
What is the most reliable way to sync contact account tables?
I have a contract account which has some tables. I want to watch for onchain table changes and sync them to an offline database as soon as possible. What is the most reliable way to do this? I have ...
1
vote
2answers
38 views
Is there a way to check the histroy of a contract's table?
Is there a way to check the history after deleting the information in the table? For example, check yesterday's table information.
0
votes
1answer
246 views
Indexing a table by asset symbol — how to find?
suppose I declare:
struct [[eosio::table]] tst {
asset component;
uint64_t primary_key() const {
return component.symbol.code().raw();
}
};
where I mean to keep a list of assets. ...
1
vote
0answers
21 views
tables of eosio.token are not generated in abi file
I am using "server_version_string": "v1.2.3". And I am trying to compile and customize the eosio.token contract, but the tables are accounts and currency_stats table are not generated in abi file.
How ...
0
votes
1answer
172 views
Can we typecast string to use it as a id in table?
I need to use a string as a id of table in my smart contract. Initially i found some answers that string can't be use as primary key. But i use string as a key in table as given below:
//@abi table ...
2
votes
1answer
91 views
Multiple Inheritance within ABI files
I have various classes that use multiple inheritance, i.e.:
class A
{
};
class B
{
};
class C : public A, public B
{
};
Single inheritance in an ABI file is possible using the base layer as ...
1
vote
1answer
994 views
scope in the get table command
What is the meaning of scope argument in the get table command?
For example, in the todo_contract, (https://developers.eos.io/eosio-cleos/reference#cleos-get-table)
we have
cleos --wallet-url http:...
2
votes
1answer
158 views
Is it possible to have a secondary index as unique?
As per title, I'm using a key256 as a datatype for a secondary index on a multi-index table and want it to be unique. Can't find any documentation on it. TIA.
1
vote
1answer
168 views
How can I create a table in an .hpp for a general contract? (Using the CDT)
THE STRUCTURE OF MY PROJECT
I am working in mycontract.cpp, which imports myheader.hpp
WHAT I WANT
I want to create a table in myheader.hpp, for a generic contract, "IN THEORY" as follows:
struct [...
1
vote
3answers
973 views
How to properly use cleos get table with --key-type sha256 / secondary index (failing on 1.4.2)
I am not able to filter a hash correctly, using get table / get_table_rows. Also I noticed that the abi is not generating a secondary index, although I am assuming this is not the problem, since ...
1
vote
1answer
48 views
Are table lookups, like get_table_rows, included in CPU/NET resource calculation?
If a smart contract includes user data, would our smart contract be charged CPU/NET resources to do lookups on those tables, or is it only charged for transfers and actions etc.
4
votes
1answer
96 views
BUG when two accounts send action at the same time to modify multiindex table
It took me several days to find the bug.
I got a table like this
TABLE t {uint64_t key, name player1, name player2, uint64_t status};
When the contract received the specific action, it will go ...
3
votes
2answers
381 views
Is it possible to use a type other than uint64_t for a table primary key?
I want to use a uint128_t as a primary key in a multi_index table. Is this possible? If so, how should the ABI file be written to accomodate it?
1
vote
1answer
353 views
Trying to pass a sha256 hash to my contract and store it
I'm new to the EOS platform.
For my use case I'm trying to pass a sha256 hash to a function in my contract and store it in a table which is indexed by that hash.
I've realized you can't have the ...
0
votes
1answer
158 views
Contract Table Query Exception
As i was following eosio developers documentation
#include <eosiolib/eosio.hpp>
#include <eosiolib/print.hpp>
using namespace eosio;
using namespace std;
class addressbook : public ...
1
vote
1answer
595 views
Assertion failure after updating a smart contract with tables
Before the update
Before the update of the code of my c++ smart contract, this uses to work absolutely fine. Data storing on the table and actions execution were done successfully.
After the update
...
1
vote
1answer
67 views
Same name table of different contracts got merged
I wrote a contract, suppose C defining the multi-index table T. Table struct has two parameter suppose x and y. x was the primary key. I made some entries in T and when i tried to access it back, I ...
2
votes
1answer
46 views
Can we store documents in a table.If yes, Is this a right approach?
I want to store some documents in my smart contract that some users upload.
Can I use table for storage? But second thing is table resides in RAM and this doesn't seems good to store data in Ram.
Is ...
5
votes
2answers
215 views
Where should tables be created? In the contract or in each action?
In the simple blog dapp (https://github.com/EOSIO/eosio-project-demux-example) the table (for posts) was defined in the contract but is not instantiated as a field.
What are the advantages/...
2
votes
2answers
146 views
ignore //abi table comment
I have general header, which I wanna include in different contracts:
ent.h:
//@abi table entities i64
struct entity {
entity() {};
uint64_t id;
uint64_t primary_key() const { return ...
3
votes
2answers
419 views
How can I know if I pay ram for a row in a table?
I am creating a non-fungible token. While I own the token, I pay ram for it. After transfer of the token the new owner should pay for it. My token contract updates the payer as soon as the new owner ...
7
votes
1answer
513 views
Can we add the permission to access the table?
I know how to declare ,initialize and get,set values in a table .My question is Can we add permission to access the table to a particular user inside our smart contract ?
1
vote
1answer
440 views
How to list all tables I have on main-net account, and how do I see the table keys?
I am struggling with listing all tables that exist on my account, as well as listing all the keys that I got in each table.
What would be the cleos command ? Should I need to publish a contract, ...
1
vote
1answer
157 views
How to retrieve historical EOS supply?
I know $ cleos get currency stats eosio.token EOS reports the current supply in the blockchain, but how can I get the supply through time?
2
votes
1answer
474 views
multi_index query [WHERE]
How do we query tables in EOS? Specifically like the WHERE clause in SQL Database?
I see examples that uses iterator to find if the record exists, however I don't see it as the right approach ...
2
votes
2answers
1k views
HOWTO: auto increment primary key?
How do we do this in EOSIO multi_index table? Want to define a table with an auto increment primary key id.
1
vote
0answers
102 views
How do I see how many objects are in the multi_index table? [duplicate]
Is there a simple way to get how large the table is?
like: table.size()
3
votes
1answer
2k views
Get table rows HTTP API in JSON
When I try to get table using
curl --request POST \
--url http://bp.cryptolions.io:8888/v1/chain/...
9
votes
1answer
2k views
Delete all multi_index records without iterator?
I am running a multi_index in my contract and want to include an abi action that will clear it. Is there a clever way to delete all records? At the moment I am using something like this:
//@abi ...