forked from FISCO-BCOS/python-sdk
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathAddrTableWorker.sol
More file actions
102 lines (86 loc) · 3.06 KB
/
AddrTableWorker.sol
File metadata and controls
102 lines (86 loc) · 3.06 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
pragma solidity ^0.4.24;
import "./Table.sol";
contract AddrTableWorker {
event permissionEvent(int256 ret, address sender,address orgin,string memo);
event createEvent(int256 ret, string name, uint256 balance,address city,string memo);
// event transferEvent(int256 ret, string from, string to, uint256 amount,string memo);
string tableName;
constructor() public {
// 构造函数中创建t_asset表
tableName = "t_itemdata";
createTable();
}
function createTable() private {
TableFactory tf = TableFactory(0x1001);
//表字段列： name，balance ,city
tf.createTable(tableName, "name", "balance,city");
}
function openTable() private returns(Table) {
TableFactory tf = TableFactory(0x1001);
Table table = tf.openTable(tableName);
return table;
}
function select(string name) public constant returns(int256,uint256,address) {
// 打开表
Table table = openTable();
// 查询
Entries entries = table.select(name, table.newCondition());
if (0 == uint256(entries.size())) {
return (-1, 0,0x0);
} else {
Entry entry = entries.get(0);
address addr = address(entry.getInt("city") );
return (999, uint256(entry.getInt("balance")),addr );
}
}
function is_exist(string name) public constant returns(int256 )
{
Table table = openTable();
Entries entries = table.select(name, table.newCondition());
uint256 balance = 0;
if (0 == uint256(entries.size())) {
return (0);
} else {
Entry entry = entries.get(0);
return (1);
}
}
function create(string name, uint256 balance,address city) public returns(int256){
int256 ret_code = 0;
int256 ret= 0;
uint256 temp_balance = 0;
Table table = openTable();
// 查询账号是否存在
ret = is_exist(name);
if(ret != 0) {
ret_code = -1;
emit createEvent(ret_code, name,0,0x0,"name exists ,can't create again");
return ret_code;
}
Entry entry = table.newEntry();
entry.set("name", name);
entry.set("balance", int256(balance));
entry.set("city", int(city) );
int count = table.insert(name, entry);
if (count == 1) {
ret_code = 0;
emit createEvent(ret_code, name, balance,city,"create success");
} else {
ret_code = -2;
emit createEvent(count, name, balance,city,"create error");
}
return ret_code;
}
function dectectAddr() public returns(int256)
{
require(msg.sender == tx.origin);
if(msg.sender != address(0x156dff526b422b17c4f576e6c0b243179eaa8407) )
{
emit permissionEvent(-1, msg.sender, tx.origin,"not the address 0x156dff526b422b17c4f576e6c0b243179eaa8407");
return -1;
}else{
emit permissionEvent(0, msg.sender, tx.origin,"match the address 0x156dff526b422b17c4f576e6c0b243179eaa8407");
return 0;
}
}
}