当前位置: 首页>>代码示例>>TypeScript>>正文


TypeScript pg.Client类代码示例

本文整理汇总了TypeScript中pg.Client的典型用法代码示例。如果您正苦于以下问题:TypeScript Client类的具体用法?TypeScript Client怎么用?TypeScript Client使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。


在下文中一共展示了Client类的9个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的TypeScript代码示例。

示例1: Client

      .then((location) => {
        let client = new Client({
          host: location.hostname,
          port: location.port || 5432,
          database: database,
          user: user,
          password: password,

          parseInputDatesAsUTC: true // not in the type
        } as any);

        client.on('drain', client.end.bind(client)); // disconnect client when all queries are finished
        client.connect();

        //query is executed once connection is established and PostgreSQL server is ready for a query
        let q = client.query(new (Query as any)(query) as any);

        // ToDo: use node-pg-cursor or node-pg-query-stream here instead
        q.on('row', function(row: any) {
          stream.push(row);
        });

        q.on('error', function(err: any) {
          stream.emit('error', err);  // Pass on any errors
        });

        q.on('end', function() {
          stream.push(null);  // pushing null, indicating EOF
        });
      })
开发者ID:implydata,项目名称:plywood-postgres-requester,代码行数:30,代码来源:postgresRequester.ts

示例2: Client

export async function query<T>(config: ConnectionConfig, queryText: string, values: any[] = []) {
  const client = new Client(config)
  await client.connect()
  const result = await client.query(queryText, values)
  await client.end()
  return result as QueryResult<T>
}
开发者ID:chbrown,项目名称:pg-meta,代码行数:7,代码来源:index.ts

示例3: places

 return new Promise<string>((resolve, reject) => {
     const client = new pg.Client(conString)            
     client.connect()
     client.query('INSERT INTO places (description, location, place_id) VALUES ($1, $2, $3)',
         [place.description, '('+place.location.lat+','+place.location.lng+')', place.id], ( error, result) => {
         if(error) reject(error)
         if(result) resolve('OK')
         client.end()
     })
 })
开发者ID:GaryGolf,项目名称:radar,代码行数:10,代码来源:estate.ts

示例4: resolve

 return new Promise<boolean>((resolve, reject) => {
     
     const client = new pg.Client(conString)            
     client.connect()
     client.query('SELECT place_id FROM places WHERE description = \'' + input + '\' LIMIT 1', ( error, result) => {
         if(error)   reject(error)
         if(result.rowCount) resolve(true)
         else resolve(false)
         client.end()
     })
 })
开发者ID:GaryGolf,项目名称:radar,代码行数:11,代码来源:estate.ts

示例5: getClient

export async function getClient(): Promise<Client> {

    var client: Client;
    try {
        client = await pool.connect();
    } catch (error) {
        if (client)
            client.release();
        throw error;
    }

    return new Promise<Client>((resolve: (client: Client) => void, reject) => {
        resolve(client);
        client.release();
    });
}
开发者ID:nicholas-robson,项目名称:dkydev_webapp,代码行数:16,代码来源:db.ts

示例6: start

  public async start() {
    this.counter = 0;
    this.client = new Client(this.config);
    await this.client.connect();

    console.log("Database started");
  }
开发者ID:hung-phan,项目名称:cyclus,代码行数:7,代码来源:database.ts

示例7: reject

 await new Promise<void>((resolve, reject) => connection.end((err) => {
   if (err) {
     reject(err);
   } else {
     resolve();
   }
 }));
开发者ID:yruan,项目名称:inceptum,代码行数:7,代码来源:PostgresClient.ts

示例8: queryPrimaryKeys

 async queryPrimaryKeys(schemaName: string): Promise<PrimaryKey[]> {
   return this.client
     .query(
       `SELECT tc.table_name, kc.column_name
      FROM information_schema.table_constraints tc
      JOIN information_schema.key_column_usage kc 
        ON kc.table_name = tc.table_name 
        AND kc.table_schema = tc.table_schema
        AND kc.constraint_name = tc.constraint_name
      WHERE tc.constraint_type = 'PRIMARY KEY'
      AND tc.table_schema = $1::text
      AND kc.ordinal_position IS NOT NULL
      ORDER BY tc.table_name, kc.position_in_unique_constraint;`,
       [schemaName.toLowerCase()],
     )
     .then(keys => {
       const grouped = _.groupBy(keys.rows, 'table_name')
       return _.map(grouped, (pks, key) => {
         return {
           tableName: key,
           fields: pks.map(x => x.column_name),
         } as PrimaryKey
       })
     })
 }
开发者ID:dhruvcodeword,项目名称:prisma,代码行数:25,代码来源:postgresConnector.ts

示例9: createPersons

function createPersons() {
    const persons = createArray(numberOfPersons, i => {
        return [
            i,
            faker.name.findName(),
            faker.address.streetAddress(),
            faker.phone.phoneNumber(),
            faker.date.past(),
        ]
    })
    return client
        .query(
            'create table person (personid decimal(9), name varchar(400), address varchar(400), phone varchar(100), stamp TIMESTAMP, primary key(personid))'
        )
        .then(
            commentColumns('person', [
                ['personid', 'Person id test'],
                ['name', 'Full name'],
                ['address', 'Home address'],
                ['phone', 'Phonenumber'],
                ['stamp', 'Timestamp'],
            ])
        )
        .then(
            innsertArray('insert into person values($1,$2,$3,$4,$5)', persons)
        )
}
开发者ID:jakobrun,项目名称:gandalf,代码行数:27,代码来源:generatePgData.ts


注:本文中的pg.Client类示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。