0.8.103 • Published 1 year ago

@enterprise_search/indexing_mysql v0.8.103

Weekly downloads
-
License
MIT
Repository
github
Last release
1 year ago
mysql-index:
   type: mysql
   scan:
      sql:   `SELECT * FROM person where last_updated > {sinceDate}` # Note the templating. If ignored always same
      connection:
          host: localhost
          port: 3306 # defaults to this anyway
          user: someName
          password: env variable name of password
          database: test

For testing mysql

CREATE DATABASE test;
USE test;


CREATE TABLE person (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    date_of_birth DATE,
    last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);


INSERT INTO person (first_name, last_name, email, date_of_birth)
VALUES ('John', 'Doe', 'john.doe@example.com', '1980-01-01');

INSERT INTO person (first_name, last_name, email, date_of_birth)
VALUES ('Jane', 'Smith', 'jane.smith@example.com', '1990-02-15');

INSERT INTO person (first_name, last_name, email, date_of_birth)
VALUES ('Michael', 'Johnson', 'michael.johnson@example.com', '1985-05-30');

INSERT INTO person (first_name, last_name, email, date_of_birth)
VALUES ('Emily', 'Davis', 'emily.davis@example.com', '1992-07-22');

INSERT INTO person (first_name, last_name, email, date_of_birth)
VALUES ('William', 'Brown', 'william.brown@example.com', '1975-12-05');

INSERT INTO person (first_name, last_name, email, date_of_birth)
VALUES ('Jessica', 'Williams', 'jessica.williams@example.com', '1988-11-10');

INSERT INTO person (first_name, last_name, email, date_of_birth)
VALUES ('David', 'Jones', 'david.jones@example.com', '1995-03-14');

INSERT INTO person (first_name, last_name, email, date_of_birth)
VALUES ('Sophia', 'Garcia', 'sophia.garcia@example.com', '1993-09-08');

INSERT INTO person (first_name, last_name, email, date_of_birth)
VALUES ('James', 'Martinez', 'james.martinez@example.com', '1982-06-25');

INSERT INTO person (first_name, last_name, email, date_of_birth)
VALUES ('Olivia', 'Hernandez', 'olivia.hernandez@example.com', '1991-01-20');
indexing
@laoban/utils@laoban/variablesmysql2@itsmworkbench/utils@enterprise_search/indexing@enterprise_search/indexconfig@enterprise_search/indexing_jira@enterprise_search/indexing_entraiddebug
@enterprise_search/indexall
0.8.89

1 year ago

0.8.88

1 year ago

0.8.85

1 year ago

0.8.84

1 year ago

0.8.87

1 year ago

0.8.86

1 year ago

0.8.81

1 year ago

0.8.80

1 year ago

0.8.83

1 year ago

0.8.78

1 year ago

0.8.77

1 year ago

0.8.79

1 year ago

0.8.74

1 year ago

0.8.73

1 year ago

0.8.76

1 year ago

0.8.75

1 year ago

0.8.70

1 year ago

0.8.72

1 year ago

0.8.71

1 year ago

0.8.67

1 year ago

0.8.66

1 year ago

0.8.69

1 year ago

0.8.68

1 year ago

0.8.62

1 year ago

0.8.65

1 year ago

0.8.61

1 year ago

0.8.60

1 year ago

0.8.56

1 year ago

0.8.55

2 years ago

0.8.58

1 year ago

0.8.57

1 year ago

0.8.52

2 years ago

0.8.51

2 years ago

0.8.54

2 years ago

0.8.53

2 years ago

0.8.50

2 years ago

0.8.102

1 year ago

0.8.101

1 year ago

0.8.100

1 year ago

0.8.99

1 year ago

0.8.96

1 year ago

0.8.95

1 year ago

0.8.98

1 year ago

0.8.97

1 year ago

0.8.92

1 year ago

0.8.91

1 year ago

0.8.94

1 year ago

0.8.93

1 year ago

0.8.90

1 year ago

0.8.103

1 year ago

0.8.45

2 years ago

0.8.44

2 years ago

0.8.47

2 years ago

0.8.46

2 years ago

0.8.41

2 years ago

0.8.40

2 years ago

0.8.43

2 years ago

0.8.42

2 years ago

0.8.49

2 years ago

0.8.48

2 years ago

0.8.34

2 years ago

0.8.33

2 years ago

0.8.36

2 years ago

0.8.35

2 years ago

0.8.30

2 years ago

0.8.32

2 years ago

0.8.31

2 years ago

0.8.37

2 years ago

0.8.39

2 years ago

0.8.23

2 years ago

0.8.22

2 years ago

0.8.25

2 years ago

0.8.24

2 years ago

0.8.21

2 years ago

0.8.20

2 years ago

0.8.27

2 years ago

0.8.26

2 years ago

0.8.29

2 years ago

0.8.28

2 years ago

0.8.19

2 years ago

0.8.18

2 years ago

0.8.17

2 years ago

0.8.16

2 years ago

0.8.15

2 years ago

0.8.12

2 years ago

0.8.14

2 years ago

0.8.11

2 years ago

0.8.10

2 years ago

0.8.9

2 years ago

0.8.8

2 years ago

0.8.7

2 years ago

0.8.6

2 years ago

0.8.3

2 years ago

0.8.2

2 years ago

0.8.1

2 years ago

0.8.0

2 years ago

0.7.71

2 years ago

0.7.70

2 years ago

0.7.69

2 years ago

0.7.67

2 years ago

0.7.66

2 years ago

0.7.65

2 years ago

0.7.64

2 years ago

0.7.63

2 years ago

0.7.62

2 years ago

0.7.61

2 years ago

0.7.60

2 years ago

0.7.59

2 years ago

0.7.58

2 years ago

0.7.57

2 years ago

0.7.56

2 years ago

0.7.55

2 years ago

0.7.54

2 years ago

0.7.53

2 years ago

0.7.52

2 years ago

0.7.51

2 years ago

0.7.50

2 years ago

0.7.49

2 years ago

0.7.48

2 years ago

0.7.47

2 years ago

0.7.46

2 years ago

0.7.45

2 years ago

0.7.44

2 years ago

0.7.43

2 years ago

0.7.42

2 years ago

0.7.41

2 years ago

0.7.40

2 years ago

0.7.39

2 years ago

0.7.38

2 years ago

0.7.37

2 years ago

0.7.36

2 years ago

0.7.35

2 years ago

0.7.34

2 years ago

0.7.33

2 years ago

0.7.32

2 years ago

0.7.31

2 years ago

0.7.30

2 years ago

0.7.29

2 years ago

0.7.28

2 years ago

0.7.27

2 years ago

0.7.26

2 years ago

0.7.25

2 years ago

0.7.24

2 years ago

0.7.23

2 years ago

0.7.22

2 years ago

0.7.21

2 years ago

0.7.20

2 years ago

0.7.19

2 years ago

0.7.18

2 years ago

0.7.17

2 years ago

0.7.16

2 years ago

0.7.15

2 years ago

0.7.14

2 years ago

0.7.13

2 years ago

0.7.12

2 years ago

0.7.11

2 years ago

0.7.10

2 years ago

0.7.9

2 years ago

0.7.8

2 years ago

0.7.7

2 years ago

0.7.6

2 years ago

0.7.5

2 years ago

0.7.4

2 years ago

0.7.3

2 years ago

0.7.2

2 years ago

0.7.0

2 years ago

0.6.5

2 years ago

0.6.4

2 years ago

0.6.3

2 years ago

0.6.2

2 years ago

0.6.1

2 years ago

0.6.0

2 years ago

0.5.5

2 years ago

0.5.4

2 years ago

0.5.3

2 years ago

0.5.2

2 years ago

0.5.1

2 years ago

0.5.0

2 years ago

0.4.34

2 years ago

0.4.33

2 years ago

0.4.32

2 years ago

0.4.31

2 years ago

0.4.30

2 years ago

0.4.29

2 years ago

0.4.28

2 years ago

0.4.27

2 years ago

0.4.26

2 years ago

0.4.25

2 years ago

0.4.24

2 years ago

0.4.23

2 years ago

0.4.22

2 years ago

0.4.20

2 years ago

0.4.19

2 years ago

0.4.17

2 years ago

0.4.16

2 years ago

0.4.15

2 years ago

0.4.14

2 years ago

0.4.13

2 years ago

0.4.12

2 years ago

0.4.11

2 years ago

0.4.10

2 years ago

0.4.9

2 years ago

0.4.8

2 years ago

0.4.7

2 years ago

0.4.6

2 years ago

0.4.5

2 years ago

0.4.4

2 years ago

0.4.3

2 years ago

0.4.2

2 years ago

0.4.1

2 years ago

0.4.0

2 years ago

0.3.1

2 years ago

0.3.0

2 years ago

0.2.3

2 years ago

0.2.1

2 years ago

0.2.0

2 years ago

0.1.3

2 years ago

0.1.2

2 years ago

0.1.1

2 years ago

0.1.0

2 years ago

0.0.9

2 years ago

0.0.8

2 years ago

0.0.7

2 years ago

0.0.6

2 years ago

0.0.5

2 years ago

0.0.4

2 years ago

0.0.3

2 years ago

0.0.1

2 years ago