Blame view

thinkphp/library/think/db/builder/Pgsql.php 2.54 KB
2db47680   hexiaodong   chore: 初始提交 php 遗...
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
  <?php
  // +----------------------------------------------------------------------
  // | ThinkPHP [ WE CAN DO IT JUST THINK ]
  // +----------------------------------------------------------------------
  // | Copyright (c) 2006~2018 http://thinkphp.cn All rights reserved.
  // +----------------------------------------------------------------------
  // | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )
  // +----------------------------------------------------------------------
  // | Author: liu21st <liu21st@gmail.com>
  // +----------------------------------------------------------------------
  
  namespace think\db\builder;
  
  use think\db\Builder;
  
  /**
   * Pgsql数据库驱动
   */
  class Pgsql extends Builder
  {
      protected $insertSql    = 'INSERT INTO %TABLE% (%FIELD%) VALUES (%DATA%) %COMMENT%';
      protected $insertAllSql = 'INSERT INTO %TABLE% (%FIELD%) %DATA% %COMMENT%';
  
      /**
       * limit分析
       * @access protected
       * @param mixed $limit
       * @return string
       */
      public function parseLimit($limit)
      {
          $limitStr = '';
          if (!empty($limit)) {
              $limit = explode(',', $limit);
              if (count($limit) > 1) {
                  $limitStr .= ' LIMIT ' . $limit[1] . ' OFFSET ' . $limit[0] . ' ';
              } else {
                  $limitStr .= ' LIMIT ' . $limit[0] . ' ';
              }
          }
          return $limitStr;
      }
  
      /**
       * 字段和表名处理
       * @access protected
       * @param mixed  $key
       * @param array  $options
       * @return string
       */
      protected function parseKey($key, $options = [], $strict = false)
      {
          if (is_numeric($key)) {
              return $key;
          } elseif ($key instanceof Expression) {
              return $key->getValue();
          }
  
          $key = trim($key);
          if (strpos($key, '$.') && false === strpos($key, '(')) {
              // JSON字段支持
              list($field, $name) = explode('$.', $key);
              $key                = $field . '->>\'' . $name . '\'';
          } elseif (strpos($key, '.')) {
              list($table, $key) = explode('.', $key, 2);
              if ('__TABLE__' == $table) {
                  $table = $this->query->getTable();
              }
              if (isset($options['alias'][$table])) {
                  $table = $options['alias'][$table];
              }
          }
          if (isset($table)) {
              $key = $table . '.' . $key;
          }
          return $key;
      }
  
      /**
       * 随机排序
       * @access protected
       * @return string
       */
      protected function parseRand()
      {
          return 'RANDOM()';
      }
  
  }