0.8.103 • Published 11 months ago

@enterprise_search/indexing_mysql v0.8.103

Weekly downloads
-
License
MIT
Repository
github
Last release
11 months 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

12 months ago

0.8.88

12 months ago

0.8.85

12 months ago

0.8.84

12 months ago

0.8.87

12 months ago

0.8.86

12 months ago

0.8.81

1 year ago

0.8.80

1 year ago

0.8.83

12 months 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

1 year ago

0.8.58

1 year ago

0.8.57

1 year ago

0.8.52

1 year ago

0.8.51

1 year ago

0.8.54

1 year ago

0.8.53

1 year ago

0.8.50

1 year ago

0.8.102

11 months ago

0.8.101

11 months ago

0.8.100

11 months ago

0.8.99

11 months ago

0.8.96

11 months ago

0.8.95

11 months ago

0.8.98

11 months ago

0.8.97

11 months ago

0.8.92

11 months ago

0.8.91

11 months ago

0.8.94

11 months ago

0.8.93

11 months ago

0.8.90

11 months ago

0.8.103

11 months ago

0.8.45

1 year ago

0.8.44

1 year ago

0.8.47

1 year ago

0.8.46

1 year ago

0.8.41

1 year ago

0.8.40

1 year ago

0.8.43

1 year ago

0.8.42

1 year ago

0.8.49

1 year ago

0.8.48

1 year ago

0.8.34

1 year ago

0.8.33

1 year ago

0.8.36

1 year ago

0.8.35

1 year ago

0.8.30

1 year ago

0.8.32

1 year ago

0.8.31

1 year ago

0.8.37

1 year ago

0.8.39

1 year ago

0.8.23

1 year ago

0.8.22

1 year ago

0.8.25

1 year ago

0.8.24

1 year ago

0.8.21

1 year ago

0.8.20

1 year ago

0.8.27

1 year ago

0.8.26

1 year ago

0.8.29

1 year ago

0.8.28

1 year ago

0.8.19

1 year ago

0.8.18

1 year ago

0.8.17

1 year ago

0.8.16

1 year ago

0.8.15

1 year ago

0.8.12

1 year ago

0.8.14

1 year ago

0.8.11

1 year 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