2.43.1 • Published 2 years ago

@apollosproject/data-connector-postgres v2.43.1

Weekly downloads
349
License
-
Repository
github
Last release
2 years ago

@apollosproject/data-connector-postgres

Provides a data-connector to manage and read/write data stored in postgres (or potentially other SQL databases)

Setup

Models can be created by calling and exporting defineModel function, and then optionally by calling and exporting the configureModel function. The defineModel is used to setup the schema of your database model, while the configureModel function can be used to setup relationships between other models (ie: defining foreign keys). These are two seperate functions so that circular import issues caused by models needing to import each other can be avoided. Below is an example of a models.js file. 

// model.js

import { DataTypes } from 'sequelize';
import { defineModel, configureModel } from '../postgres';

const createModel = defineModel({
  modelName: 'content_item',
  attributes: {
    title: DataTypes.TEXT,
    summary: DataTypes.TEXT,
    coverImageUrl: DataTypes.STRING,
    publishedAt: DataTypes.DATE,
    htmlContent: DataTypes.TEXT,
  },
  external: true,
});

const setupModel = configureModel(({ sequelize }) => {
  // eslint-disable-next-line camelcase
  const { content_item, media } = sequelize.models;
  content_item.hasMany(media, {
    foreignKey: 'mediableId',
    constraints: false,
    scope: {
      mediableType: 'content_item',
    },
  });
  media.belongsTo(content_item, {
    foreignKey: 'mediableId',
    constraints: false,
  });

  content_item.belongsTo(media, {
    scope: { mediableType: 'image' },
    foreignKey: 'coverImageId',
    as: 'coverImage',
  });

  content_item.belongsTo(content_item, {
    foreignKey: 'parentId',
    as: 'parent',
    constraints: false,
  });

  content_item.hasMany(content_item, {
    foreignKey: 'parentId',
    as: 'children',
    constraints: false,
  });
});

export { createModel, setupModel };
// index.js
export * as models from './model';

And then in your dataSource

import ApollosConfig from '@apollosproject/config';
import { PostgresDataSource } from '../postgres';

export default class ContentItem extends PostgresDataSource {
  initialize(...args) {
    super.initialize(...args);
    this.model = this.sequelize.models.content_item;
  }
}

Usage

You can use the postgres datasource like you would any other Datasource. In order for your schema to updated to match the config you have created in your models, you'll need to sync. The easiest way to do that is import sync from @apollosproject/data-connector-postgres and call it on app boot.

hyphenation.en-ushypherlodashpgpg-hstoresequelizeumzug
@infinitebrahmanuniverse/nolb-_apo@everything-registry/sub-chunk-74
2.47.9

2 years ago

2.47.7

2 years ago

2.47.4

2 years ago

2.47.6

2 years ago

2.47.5

2 years ago

2.47.3

2 years ago

2.46.9

2 years ago

2.46.8

2 years ago

2.46.5

2 years ago

2.46.4

2 years ago

2.46.7

2 years ago

2.46.6

2 years ago

2.46.1

2 years ago

2.46.0

2 years ago

2.46.3

2 years ago

2.46.2

2 years ago

2.45.0

2 years ago

2.45.1

2 years ago

2.46.79

2 years ago

2.46.78

2 years ago

2.46.77

2 years ago

2.44.3

2 years ago

2.44.4

2 years ago

2.46.72

2 years ago

2.46.71

2 years ago

2.46.70

2 years ago

2.46.76

2 years ago

2.46.75

2 years ago

2.46.74

2 years ago

2.46.73

2 years ago

2.46.89

2 years ago

2.46.88

2 years ago

2.46.83

2 years ago

2.46.82

2 years ago

2.46.81

2 years ago

2.46.80

2 years ago

2.46.87

2 years ago

2.46.86

2 years ago

2.46.85

2 years ago

2.46.84

2 years ago

2.46.99

2 years ago

2.46.90

2 years ago

2.46.94

2 years ago

2.46.93

2 years ago

2.46.92

2 years ago

2.46.91

2 years ago

2.46.98

2 years ago

2.46.97

2 years ago

2.46.96

2 years ago

2.46.95

2 years ago

2.46.36

2 years ago

2.46.35

2 years ago

2.46.34

2 years ago

2.46.33

2 years ago

2.46.39

2 years ago

2.46.38

2 years ago

2.46.37

2 years ago

2.46.109

2 years ago

2.46.108

2 years ago

2.46.107

2 years ago

2.46.102

2 years ago

2.46.101

2 years ago

2.46.100

2 years ago

2.46.106

2 years ago

2.46.32

2 years ago

2.46.105

2 years ago

2.46.31

2 years ago

2.46.104

2 years ago

2.46.30

2 years ago

2.46.103

2 years ago

2.46.47

2 years ago

2.46.46

2 years ago

2.46.45

2 years ago

2.46.44

2 years ago

2.46.120

2 years ago

2.46.49

2 years ago

2.46.48

2 years ago

2.46.119

2 years ago

2.46.118

2 years ago

2.46.113

2 years ago

2.46.112

2 years ago

2.46.111

2 years ago

2.46.110

2 years ago

2.46.117

2 years ago

2.46.43

2 years ago

2.46.116

2 years ago

2.46.42

2 years ago

2.46.115

2 years ago

2.46.41

2 years ago

2.46.114

2 years ago

2.46.40

2 years ago

2.46.58

2 years ago

2.46.57

2 years ago

2.46.56

2 years ago

2.46.55

2 years ago

2.46.59

2 years ago

2.46.50

2 years ago

2.46.54

2 years ago

2.46.53

2 years ago

2.46.52

2 years ago

2.46.51

2 years ago

2.46.69

2 years ago

2.46.68

2 years ago

2.46.67

2 years ago

2.46.66

2 years ago

2.46.61

2 years ago

2.46.60

2 years ago

2.46.65

2 years ago

2.46.64

2 years ago

2.46.63

2 years ago

2.46.62

2 years ago

2.46.14

2 years ago

2.46.13

2 years ago

2.46.12

2 years ago

2.46.11

2 years ago

2.46.18

2 years ago

2.46.17

2 years ago

2.46.16

2 years ago

2.46.15

2 years ago

2.46.19

2 years ago

2.46.10

2 years ago

2.46.25

2 years ago

2.46.24

2 years ago

2.46.23

2 years ago

2.46.22

2 years ago

2.46.29

2 years ago

2.46.28

2 years ago

2.46.27

2 years ago

2.46.26

2 years ago

2.46.21

2 years ago

2.46.20

2 years ago

2.46.193

2 years ago

2.46.192

2 years ago

2.46.191

2 years ago

2.46.190

2 years ago

2.46.197

2 years ago

2.46.196

2 years ago

2.46.195

2 years ago

2.46.194

2 years ago

2.46.189

2 years ago

2.46.188

2 years ago

2.46.187

2 years ago

2.46.198

2 years ago

2.46.171

2 years ago

2.46.170

2 years ago

2.46.175

2 years ago

2.46.174

2 years ago

2.46.173

2 years ago

2.46.172

2 years ago

2.46.168

2 years ago

2.46.167

2 years ago

2.46.166

2 years ago

2.46.165

2 years ago

2.46.169

2 years ago

2.46.182

2 years ago

2.46.181

2 years ago

2.46.180

2 years ago

2.46.186

2 years ago

2.46.185

2 years ago

2.46.184

2 years ago

2.46.183

2 years ago

2.46.179

2 years ago

2.46.178

2 years ago

2.46.177

2 years ago

2.46.176

2 years ago

2.46.153

2 years ago

2.46.152

2 years ago

2.46.151

2 years ago

2.46.150

2 years ago

2.46.146

2 years ago

2.46.145

2 years ago

2.46.144

2 years ago

2.46.143

2 years ago

2.46.149

2 years ago

2.46.148

2 years ago

2.46.147

2 years ago

2.46.160

2 years ago

2.46.164

2 years ago

2.46.163

2 years ago

2.46.162

2 years ago

2.46.161

2 years ago

2.46.157

2 years ago

2.46.156

2 years ago

2.46.155

2 years ago

2.46.154

2 years ago

2.46.159

2 years ago

2.46.158

2 years ago

2.46.131

2 years ago

2.46.130

2 years ago

2.46.129

2 years ago

2.46.124

2 years ago

2.46.123

2 years ago

2.46.122

2 years ago

2.46.121

2 years ago

2.46.128

2 years ago

2.46.127

2 years ago

2.46.126

2 years ago

2.46.125

2 years ago

2.46.142

2 years ago

2.46.141

2 years ago

2.46.140

2 years ago

2.46.135

2 years ago

2.46.134

2 years ago

2.46.133

2 years ago

2.46.132

2 years ago

2.46.139

2 years ago

2.46.138

2 years ago

2.46.137

2 years ago

2.46.136

2 years ago

2.47.0

2 years ago

2.47.2

2 years ago

2.47.1

2 years ago

3.0.0-canary.59

2 years ago

2.44.1

2 years ago

2.44.0

2 years ago

2.44.2

2 years ago

2.43.1-canary.5

2 years ago

2.41.1-canary.3

2 years ago

2.41.1-canary.9

2 years ago

2.41.1-canary.5

2 years ago

2.41.1-canary.8

2 years ago

3.0.0-canary.55

2 years ago

3.0.0-canary.58

2 years ago

3.0.0-canary.48

2 years ago

3.0.0-canary.47

2 years ago

3.0.0-canary.52

2 years ago

3.0.0-canary.51

2 years ago

3.0.0-canary.54

2 years ago

2.41.1-canary.18

2 years ago

3.0.0-canary.53

2 years ago

3.0.0-canary.50

2 years ago

2.41.1-canary.14

2 years ago

2.41.1-canary.10

2 years ago

2.41.1-canary.11

2 years ago

2.43.0

2 years ago

2.43.1

2 years ago

2.42.0

2 years ago

2.42.1-canary.9

2 years ago

2.42.1-canary.0

2 years ago

2.42.1-canary.1

2 years ago

2.39.1-canary.17

2 years ago

2.41.0

2 years ago

2.42.1-canary.19

2 years ago

2.42.1-canary.18

2 years ago

2.40.0

2 years ago

3.0.0-canary.34

2 years ago

3.0.0-canary.33

2 years ago

3.0.0-canary.36

2 years ago

3.0.0-canary.35

2 years ago

3.0.0-canary.41

2 years ago

2.43.2-canary.6

2 years ago

3.0.0-canary.40

2 years ago

3.0.0-canary.43

2 years ago

3.0.0-canary.27

2 years ago

3.0.0-canary.28

2 years ago

3.0.0-canary.22

2 years ago

3.0.0-canary.25

2 years ago

3.0.0-canary.32

2 years ago

3.0.0-canary.8

2 years ago

3.0.0-canary.16

2 years ago

3.0.0-canary.7

2 years ago

3.0.0-canary.15

2 years ago

3.0.0-canary.6

2 years ago

3.0.0-canary.5

2 years ago

3.0.0-canary.4

2 years ago

3.0.0-canary.12

2 years ago

3.0.0-canary.3

2 years ago

3.0.0-canary.11

2 years ago

3.0.0-canary.13

2 years ago

3.0.0-canary.21

2 years ago

3.0.0-canary.20

2 years ago

3.0.0-canary.10

2 years ago

2.40.1-canary.3

2 years ago

2.38.1-canary.4

2 years ago

2.38.1-canary.8

2 years ago

2.38.1-canary.5

2 years ago

2.36.4-canary.2

2 years ago

2.39.1-canary.1

2 years ago

2.39.1-canary.5

2 years ago

2.39.1-canary.3

2 years ago

2.39.1-canary.9

2 years ago

2.39.1-canary.6

2 years ago

2.39.1-canary.7

2 years ago

2.39.0

2 years ago

2.39.1-canary.10

2 years ago

2.38.0

2 years ago

2.37.0

2 years ago

2.37.1-canary.1

2 years ago

2.36.4-canary.0

3 years ago

2.36.2-canary.4

3 years ago

2.36.2-canary.2

3 years ago

2.36.3-canary.0

3 years ago

2.36.3

3 years ago

2.36.2

3 years ago

2.35.1-canary.6

3 years ago

2.36.0

3 years ago

2.36.1

3 years ago

2.34.1-canary.0

3 years ago

2.35.0

3 years ago

2.34.0

3 years ago

2.33.5-canary.7

3 years ago

2.33.4

3 years ago

2.33.4-canary.7

3 years ago

2.33.4-canary.4

3 years ago

2.33.4-canary.0

3 years ago

2.33.3

3 years ago

2.33.3-canary.1

3 years ago

2.33.3-canary.0

3 years ago

2.33.2

3 years ago

2.33.2-canary.0

3 years ago

2.33.1

3 years ago

2.33.0

3 years ago

2.32.3-canary.4

3 years ago

2.32.3-canary.3

3 years ago

2.32.3-canary.2

3 years ago

2.32.3-canary.1

3 years ago

2.32.2

3 years ago

2.32.1

3 years ago

2.32.2-canary.0

3 years ago

2.31.1-canary.9

3 years ago

2.32.0

3 years ago

2.31.1-canary.5

3 years ago

2.31.1-canary.2

3 years ago

2.31.1-canary.7

3 years ago

2.31.1-canary.6

3 years ago

2.30.1-canary.13

3 years ago

2.30.1-canary.12

3 years ago

2.31.0

3 years ago

2.30.1-canary.3

3 years ago

2.30.0

3 years ago

2.29.4-canary.13

3 years ago

2.29.4-canary.17

3 years ago

2.30.1-canary.0

3 years ago

2.30.1-canary.1

3 years ago

2.29.4-canary.10

3 years ago

2.29.4-canary.11

3 years ago

2.29.4-canary.12

3 years ago

2.29.4-canary.3

3 years ago

2.29.4-canary.6

3 years ago

2.29.4-canary.7

3 years ago

2.29.4-canary.9

3 years ago

2.29.3

3 years ago

2.29.4-canary.0

3 years ago

2.29.4-canary.1

3 years ago

2.29.4-canary.2

3 years ago

2.29.3-canary.7

3 years ago

2.29.3-canary.0

3 years ago

2.28.1-canary.3

3 years ago

2.29.0

3 years ago

2.29.2

3 years ago

2.29.1

3 years ago

2.29.1-canary.0

3 years ago

2.29.2-canary.0

3 years ago

2.28.1-canary.0

3 years ago

2.28.0

3 years ago

2.27.3-canary.9

3 years ago

2.27.3-canary.7

3 years ago

2.27.3-canary.4

3 years ago

2.27.3-canary.3

3 years ago

2.27.2

3 years ago

2.27.1

3 years ago

2.27.2-canary.2

3 years ago

2.27.2-canary.1

3 years ago

2.27.1-canary.2

3 years ago

2.27.1-canary.3

3 years ago

2.27.0

3 years ago

2.27.1-canary.1

3 years ago

2.26.1-canary.6

3 years ago

2.26.0

3 years ago

2.25.1-canary.15

3 years ago

2.25.1-canary.16

3 years ago

2.25.1-canary.17

3 years ago

2.25.1-canary.12

3 years ago

2.25.1-canary.13

3 years ago

2.25.1-canary.10

3 years ago

2.25.1-canary.11

3 years ago

2.24.1-canary.7

3 years ago

2.24.1-canary.8

3 years ago

2.25.1-canary.8

3 years ago

2.25.1-canary.1

3 years ago

2.25.0

3 years ago

2.24.1-canary.2

3 years ago

2.24.1-canary.1

3 years ago

2.24.0

3 years ago

2.23.2-canary.3

3 years ago

2.23.1

3 years ago

2.22.1-canary.4

3 years ago

2.23.0

3 years ago

2.22.0

3 years ago

2.21.3-canary.2

3 years ago

2.21.3-canary.1

3 years ago

2.22.1-canary.2

3 years ago

2.21.2

3 years ago

2.21.0

3 years ago

2.21.1

3 years ago

2.20.0

3 years ago

2.19.1-canary.7

3 years ago

2.19.0

3 years ago

2.18.2-canary.5

3 years ago

2.18.2-canary.4

3 years ago

2.18.2-canary.1

3 years ago

2.18.1

3 years ago

2.18.0

3 years ago

2.14.1-canary.4

3 years ago

2.14.1-canary.7

3 years ago

2.13.2-canary.23

3 years ago

2.17.0

3 years ago

2.15.0

3 years ago

2.16.1-canary.4

3 years ago

2.15.1-canary.4

3 years ago

2.15.1-canary.2

3 years ago

2.16.0

3 years ago

2.14.0

3 years ago

2.13.0

3 years ago

2.13.1

3 years ago

2.12.1-canary.2

3 years ago

2.12.0

3 years ago

2.11.1-canary.8

3 years ago

2.11.1-canary.6

3 years ago

2.11.0

3 years ago

2.10.1-canary.1

3 years ago

2.10.0

3 years ago

2.9.1-canary.8

3 years ago

2.9.1-canary.10

3 years ago

2.9.1-canary.7

3 years ago

2.9.1-canary.0

3 years ago

2.9.0

3 years ago

2.9.1-canary.1

3 years ago

2.8.0

3 years ago

2.8.1-canary.6

3 years ago

2.8.1-canary.0

3 years ago

2.7.1-canary.2

3 years ago

2.6.1-canary.6

3 years ago

2.7.0

3 years ago

2.7.1-canary.0

3 years ago

2.6.0

3 years ago

2.5.1-canary.4

3 years ago

2.5.1-canary.1

3 years ago

2.5.0

3 years ago

2.4.1-canary.5

3 years ago

2.4.1-canary.7

3 years ago

2.4.1-canary.1

3 years ago

2.4.1-canary.3

3 years ago

2.4.1-canary.2

3 years ago

2.4.1-canary.4

3 years ago

2.4.0

3 years ago

2.3.2-canary.8

3 years ago

2.3.2-canary.7

3 years ago

2.3.2-canary.5

3 years ago

2.3.2-canary.4

3 years ago

2.3.2-canary.3

3 years ago

2.3.2-canary.2

3 years ago

2.3.0

3 years ago

2.3.1

3 years ago

2.3.2-canary.0

3 years ago

2.3.1-canary.0

3 years ago

2.2.1-canary.12

3 years ago

2.2.1-canary.10

3 years ago

2.2.1-canary.3

3 years ago

2.2.1-canary.4

3 years ago

2.2.1-canary.5

3 years ago

2.2.1-canary.7

3 years ago

2.2.1-canary.8

3 years ago

2.2.1-canary.9

3 years ago

2.2.0

3 years ago

2.1.2-canary.6

3 years ago

2.1.1

3 years ago

2.1.0

3 years ago

2.0.1-canary.20

3 years ago

2.0.1-canary.17

3 years ago

2.0.1-canary.16

3 years ago

2.0.1-canary.14

3 years ago

3.0.0-canary.2

3 years ago

2.0.1-canary.2

3 years ago

2.0.1-canary.0

3 years ago

2.0.1-canary.15

3 years ago

2.0.1-canary.13

3 years ago

2.0.1-canary.12

3 years ago

2.0.1-canary.8

3 years ago

2.0.1-canary.7

3 years ago

2.0.1-canary.6

3 years ago

1.8.0-alpha.11

3 years ago

2.0.1-alpha.0

3 years ago

2.0.0-beta.4

3 years ago

2.0.0

3 years ago

1.8.0-alpha.8

3 years ago

2.0.0-beta.3

3 years ago

2.0.0-2.0.0-alpha.16.0

3 years ago

2.0.0-beta.2

3 years ago

2.0.0-beta.1

3 years ago

2.0.0-alpha.1

3 years ago

2.0.0-alpha.15

3 years ago