budgaPlus-react-native/database.tsx at main · TheoSoko/budgaPlus-react-native · GitHub

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
import Realm from 'realm';

const incomeSchema = {
    name: 'Income',
    primaryKey: '_id_income',
    properties: {
      _id_income: 'int',
      amount: 'int',
      date: 'string',
      category: 'string',
      comment: 'string?',
    }
  }

const expenseSchema = {
  name: 'Expense',
  primaryKey: '_id_expense',
  properties: {
    _id_expense: 'int',
    amount: 'int',
    recipient: 'string',
    date: 'string',
    category: 'string',
    comment: 'string?',
  }
}

/*
const userSchema = {
    name: 'User',
    primaryKey: '_id',
    properties: {
        _id: 'number',
        incomes: '{ type: "list", objectType: "incomeSchema" }',
        expenses: '{ type: "list", objectType: "expenseSchema" }',
    }
}
*/


//Fonction Ajout de revenus à la base de données
function addIncomeData(values:any):void{

    const realm = new Realm({schema: [incomeSchema], schemaVersion: 3})

    realm.write(() => {
        realm.create('Income', {
            _id_income: parseInt('' + new Date().getTime() + Math.floor(Math.random()*1000)),
            amount: parseInt(values.amount.replace('.', '').replace(',', '').replace(' ', '')),
            date: values.date,
            category: values.category,
            comment: values.comment,
        })
    })

    console.warn(realm.objects<{_id_income:number}>('Income').sorted('_id_income', true))

    realm.close()

}

//Fonction Ajout de revenus à la base de données
function addExpenseData(values:any):void{

    const realm = new Realm({schema: [expenseSchema], schemaVersion: 3})

    realm.write(() => {
        realm.create('Expense', {
            _id_expense: parseInt('' + new Date().getTime() + Math.floor(Math.random()*1000)),
            amount: parseInt(values.amount.replace('.', '').replace(',', '').replace(' ', '')),
            recipient: values.recipient,
            date: values.date,
            category: values.category,
            comment: values.comment,
        })
    })

    console.warn(realm.objects('Expense'))

    realm.close()

}

//getAll
function getAllIncomes(){

    const realm = new Realm({schema: [incomeSchema], schemaVersion: 3})

    return realm.objects('Income').sorted('_id_income')

    realm.close()

}

function deletelastIncome(){
    const realm = new Realm({schema: [incomeSchema], schemaVersion: 3})

    let lastIncome =  realm.objects('Income').sorted('_id_income')[0]
    realm.write(() => {
        realm.delete(lastIncome)
    })
    realm.close()
}


export {addIncomeData, addExpenseData, getAllIncomes, deletelastIncome}