FilesExpand file tree

 develop

/

server-test.js

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

137 lines (114 loc) · 6.77 KB

 develop

/

server-test.js

Top

File metadata and controls

• Code
• Blame

137 lines (114 loc) · 6.77 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

'use strict'

const ChainsqlAPI = require('../src/index');

const r = new ChainsqlAPI();

// var path = require('path');

// var basePath = path.join(require.resolve('chainsql-lib-test'), '../common');

// var common = require(basePath);

var crypto = require('../src/lib/crypto');

const keypairs = require('chainsql-keypairs-test');

describe('server', () => {

it('server', async function(){

try {

// await r.connect('ws://192.168.0.14:6006');

// var cipher = crypto.eciesEncrypt("hello","03B7FBF1AC149B0D297B7407CAB9636792333B8D8B8A4036B2D4DE2E6D69D435B5");

// var keypair = keypairs.deriveKeypair("xxHgHoRAHdGZxy5gWUdMeUK7hWrgr");

// var plain = crypto.eciesDecrypt(cipher,keypair.privateKey);

// console.log(plain);

// //字段级加密

// console.log("multi encrypt test:");

// var listPublic = ["cBP7JPfSVPgqGfGXVJVw168sJU5HhQfPbvDRZyriyKNeYjYLVL8M", "cBPaLRSCwtsJbz4Rq4K2NvoiDZWJyL2RnfdGv5CQ2UFWqyJ7ekHM"];

// var cip = await crypto.encryptText("test",listPublic);

// console.log("cipher:" + cip);

// var text = await crypto.decryptText(cip,"xpvPjSRCtmQ3G99Pfu1VMDMd9ET3W");

// console.log("plain text:" + text);

// var text2 = await crypto.decryptText(cip,"xnHAcvtn1eVLDskhxPKNrhTsYKqde");

// console.log("plain text2:" + text2);

// console.log("AesPadding Test");

// var aesCipher = crypto.aesEncrypt("abcdefg","hello,world");

// console.log(aesCipher);

// var aesDecrypted = crypto.aesDecrypt("abcdefg",aesCipher);

// console.log(aesDecrypted);

// // 创建表

// let rs = await r.createTable("abc", [{

// "field": "id",

// "type": "int",

// "length": 11,

// "PK": 1,

// "NN": 1,

// "UQ": 1,

// "AI": 1

// }, {

// "field": "name",

// "type": "varchar",

// "length": 46,

// "default": "null"

// }],{confidential:false})

// .submit();

// console.log(rs)

// 删除表

// let rs = await r.drop(tb);

// 重命名

// let rs = await r.rename(tb,'users');

// 授权权限

// let rs = await r.assign(tb, 'rETMNdu2UgPhLZzbnDUVRHhB6NEDahj53c', [r.perm.insert],'0330E7FC9D56BB25D6893BA3F317AE5BCF33B3291BD63DB32654A313222F7FD02');

// console.log(rs)

//取消授权

// let rs = await r.assignCancle('users', 'rHb9CJAWyB4rj91VRWn96DkukG4bwdtyTh', ['lsfUpdate']);

// 插入数据

//let rs = await r.table(tb).insert({name:'xiaopeng'}).submit();

// let rs = await r.table(tb).insert({name:'feipeng1'}).submit();

//删除数据

// let rs = await r.table(tb).get({id:1}).delete().submit();

// 获取数据

//let rs = await r.table(tb).get(['id','name']).submit();

// 测试一个条件的情况

//let rs = await r.table(tb).get({id:{$ge:1}}).withFields(['id','name']).submit();

// // 测试 or 条件

//let rs = await r.table(tb).get({id:{$eq:1}},{name:'feipeng1'}).withFields(['id','name']).submit();

//let rs = await r.table(tb).get({id:{$eq:1}},{name:{$eq:'feipeng1'}}).withFields(['id','name']).submit();

//let rs = await r.table(tb).get({$or:[{id:{$ge:1}},{name:'feipeng1'}]}).withFields(['id','name']).submit();

// 测试 and 条件

//let rs = await r.table(tb).get({$and:[{id:{$ge:1}},{name:'feipeng1'}]}).withFields(['id','name']).submit();

//let rs = await r.table(tb).get([{id:{$ge:1},name:'feipeng1'}]).withFields(['id','name']).submit();

//let rs = await r.table(tb).get([{id:{$ge:1},name:{$eq:'feipeng1'}}]).withFields(['id','name']).submit();

// 测试 limit

//let rs = await r.table(tb).get({id:{$eq:1}},{name:'feipeng1'},{$limit:{index:0,total:1}}).withFields(['id','name']).submit();

// order by asc

//let rs = await r.table(tb).get({id:{$eq:1}},{name:'feipeng1'},{$limit:{index:0,total:2},$order:[{id:1}]}).withFields(['id','name']).submit();

// order by desc

// let rs = await r.table(tb).get({id:{$eq:1}},{name:'feipeng1'},{$limit:{index:0,total:2},$order:[{id:-1}]}).withFields(['id','name']).submit();

//更新数据

// let rs = await r.table(tb).update({name:'xiaopeng'},{id:2}).submit();

// 获取所有交易

// let rs = await r.getTransactions({limit:10,types:['sqlStatement']});

//

// console.log(rs)

// 事务操作

/*var raw ='[{"OpType":1,"TableName":"ExampleName","Raw":[{"field":"id","type":"int","length":11,"PK":1,"NN":1,"UQ":1,"AI":1},{"field":"age","type":"int"}],"$IsExisted":1},{"OpType":2,"TableName":"ExampleName","$IsExisted":0},{"OpType":6,"TableName":"ExampleName","Raw":[{"id":1,"age":1},{"id":2,"age":2}],"$RowCount":1,"Cond":{"id":1,"name":"test"}},{"OpType":8,"TableName":"ExampleName","Raw":[{"id":3,"age":2},{"id":2,"age":2}],"$RowCount":1,"Cond":{"id":3,"age":2}},{"OpType":9,"TableName":"ExampleName","Raw":[{"id":1,"age":1}],"$RowCount":0,"Cond":{"id":1,"age":1}}]';*/

/*var raw ='[{"OpType":1,"TableName":"ExampleName","Raw":[{"field":"id","type":"int","length":11,"PK":1,"NN":1,"UQ":1,"AI":1},{"field":"age","type":"int"}],"$IsExisted":1},{"OpType":6,"TableName":"ExampleName","Raw":[{"id":1,"age":1},{"id":2,"age":2}],"$RowCount":1,"Cond":{"id":1,"name":"test"}},{"OpType":8,"TableName":"ExampleName","Raw":[{"id":3,"age":2},{"id":2,"age":2}],"$RowCount":1,"Cond":{"id":3,"age":2}},{"OpType":9,"TableName":"ExampleName","Raw":[{"id":1,"age":1}],"$RowCount":0,"Cond":{"id":1,"age":1}}]';*/

// var raw = '[{"OpType":1,"Account":"rHb9CJAWyB4rj91VRWn96DkukG4bwdtyTh","Secret":"snoPBrXtMeMyMHUVTgbuqAfg1SUTb","TableName":"ExampleName","Raw":[{"field":"id","type":"int","length":11,"PK":1,"NN":1,"UQ":1,"AI":1},{"field":"age","type":"int"}],"$IsExisted":1},{"OpType":6,"Account":"rHb9CJAWyB4rj91VRWn96DkukG4bwdtyTh","Secret":"snoPBrXtMeMyMHUVTgbuqAfg1SUTb","Owner":"rHb9CJAWyB4rj91VRWn96DkukG4bwdtyTh","TableName":"ExampleName","Raw":[{"id":1,"age":1},{"id":2,"age":2}],"$RowCount":1,"Cond":{"id":1,"name":"test"}},{"OpType":8,"Account":"rHb9CJAWyB4rj91VRWn96DkukG4bwdtyTh","Secret":"snoPBrXtMeMyMHUVTgbuqAfg1SUTb","Owner":"rHb9CJAWyB4rj91VRWn96DkukG4bwdtyTh","TableName":"ExampleName","Raw":[{"id":3,"age":2},{"id":2,"age":2}],"$RowCount":1,"Cond":{"id":3,"age":2}},{"OpType":9,"TableName":"ExampleName","Account":"rHb9CJAWyB4rj91VRWn96DkukG4bwdtyTh","Secret":"snoPBrXtMeMyMHUVTgbuqAfg1SUTb","Owner":"rHb9CJAWyB4rj91VRWn96DkukG4bwdtyTh","Raw":[{"id":1,"age":1}],"$RowCount":0,"Cond":{"id":1,"age":1}}]';

// console.log(rs)

// r.beginTran();

// r.create('user0144s4000', [{

// "field": "id",

// "type": "int",

// "length": 11,

// "PK": 1,

// "NN": 1,

// "UQ": 1,

// "AI": 1

// }, {

// "field": "name",

// "type": "varchar",

// "length": 46,

// "default": "null"

// }],{confidential:true});

// r.table(tb).insert({id:33,name:'xiaopeng454'});

// r.table(tb).insert({id:34,name:'feipeng14544'});

// var data = await r.commit();

// console.log('data',data)

} catch (e) {

console.log(e)

}

})

})