Class: LgPodPlugin::LSqliteDb

Inherits:
Object
  • Object
show all
Includes:
Singleton
Defined in:
lib/lg_pod_plugin/database.rb

Constant Summary collapse

K_USER_TABLE = 
"user_tab"
K_USER_PROJECTS = 
"user_projects"
K_POD_LATEST_REFS = 
"user_pod_latest_refs"

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize ⇒ LSqliteDb

初始化 db



84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
 
# File 'lib/lg_pod_plugin/database.rb', line 84

def initialize
  root_path = LFileManager.download_director.join("database")
  db_file_path = root_path.join("my.db")
  if !root_path.exist? || !db_file_path.exist?
    FileUtils.mkdir(root_path)
    FileUtils.chdir(root_path)
    FileUtils.touch("my.db")
  end
  # FileUtils.chdir(root_path)
  self.db = SQLite3::Database.new(db_file_path.to_path)
  #添加用户表
  sql1 = "create table if not exists #{K_USER_TABLE}(
    id varchar(100) primary key not null,
    username varchar(100),
   password varchar(100),
   host varchar(100),
    access_token varchar(100),
    refresh_token varchar(100),
    expires_in TimeStamp NOT NULL DEFAULT CURRENT_TIMESTAMP);"
  self.db.execute(sql1)

  #添加项目表
  sql2 = "create table if not exists #{K_USER_PROJECTS}(
    id varchar(100) primary key not null,
    name varchar(100),
   desc varchar(100),
   path varchar(100),
    ssh_url_to_repo varchar(100),
    http_url_to_repo varchar(100),
    web_url varchar(100),
    name_with_namespace varchar(100),
    path_with_namespace varchar(100)
   );"
  self.db.execute(sql2)

  #添加项目表
  sql3 = "create table if not exists #{K_POD_LATEST_REFS}(
    id varchar(100) primary key not null,
    name varchar(100),
   git varchar(100),
   branch varchar(100),
    tag varchar(100),
    sha varchar(100)
    );"
  self.db.execute(sql3)

  super
end

Class Method Details

.shared ⇒ Object 



79
80
81
 
# File 'lib/lg_pod_plugin/database.rb', line 79

def self.shared
  return LSqliteDb.instance
end

Instance Method Details

#insert_pod_refs(name, git, branch, tag, commit) ⇒ Object 



196
197
198
199
200
201
202
203
204
205
206
207
208
 
# File 'lib/lg_pod_plugin/database.rb', line 196

def insert_pod_refs(name, git, branch, tag , commit)
  id = LPodLatestRefs.get_pod_id(name, git)
  pod = LPodLatestRefs.new(id, name, git, branch, tag, commit)
  if self.query_pod_refs(id) != nil
    self.db.execute_batch(
      "UPDATE #{K_POD_LATEST_REFS} SET name = (:name), git = (:git), branch = (:branch), tag = (:tag), sha = (:sha) where (id = :id)", { "name" => pod.name, "git" => pod.git, "sha" => pod.commit, "branch" => pod.branch, :tag => pod.tag, :id => pod.id}
    )
  else
    self.db.execute("INSERT INTO #{K_POD_LATEST_REFS} (id, name, git, branch, tag, sha)
        VALUES (?, ?, ?, ?, ?, ?)", [pod.id, pod.name, pod.git, pod.branch, pod.tag, pod.commit])
  end

end

#insert_project(project) ⇒ Object

保存项目信息到数据库



165
166
167
168
169
170
171
172
173
174
 
# File 'lib/lg_pod_plugin/database.rb', line 165

def insert_project(project)
  if self.query_project_info(project.name, project.http_url_to_repo) != nil
    self.db.execute_batch(
      "UPDATE #{K_USER_PROJECTS} SET name = (:name), desc = (:desc), path = (:path), ssh_url_to_repo = (:ssh_url_to_repo), http_url_to_repo = (:http_url_to_repo), web_url = (:web_url), name_with_namespace = (:name_with_namespace), path_with_namespace = (:path_with_namespace) where (id = :id)", { "name" => project.name, "desc" => project.description, "path" => project.path, "ssh_url_to_repo" => project.ssh_url_to_repo, :http_url_to_repo => project.http_url_to_repo, :web_url => project.web_url, :id => project.id , :path_with_namespace => project.path_with_namespace, :name_with_namespace => project.name_with_namespace}
    )
  else
    self.db.execute("INSERT INTO #{K_USER_PROJECTS} (id, name, desc, path, ssh_url_to_repo, http_url_to_repo, web_url,name_with_namespace, path_with_namespace)
        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", [project.id, project.name, project.description, project.path, project.ssh_url_to_repo, project.http_url_to_repo, project.web_url, project.name_with_namespace, project.path_with_namespace])
  end
end

#insert_user_info(user) ⇒ Object 



135
136
137
138
139
140
141
142
143
144
145
146
 
# File 'lib/lg_pod_plugin/database.rb', line 135

def (user)
  # pp "user.id => #{user.id}"
  if self.(user.id) != nil
    self.db.execute_batch(
      "UPDATE #{K_USER_TABLE} SET username = (:username), password = (:password), host = (:host), access_token = (:access_token), expires_in = (:expires_in), refresh_token = (:refresh_token) where (id = :id)", { "username" => user.username, "password" => user.password, "host" => user.host, "access_token" => user.access_token, :expires_in => user.expires_in, :id => user.id, :refresh_token => user.refresh_token }
    )
  else
    self.db.execute("INSERT INTO #{K_USER_TABLE} (id, username, password, host, access_token,refresh_token, expires_in)
        VALUES (?, ?, ?, ?,?,?,?)", [user.id, user.username, user.password, user.host, user.access_token, user.refresh_token, user.expires_in])
  end

end

#query_pod_refs(id) ⇒ Object 



210
211
212
213
214
215
216
217
218
219
220
221
222
 
# File 'lib/lg_pod_plugin/database.rb', line 210

def query_pod_refs(id)
  pod_info = nil
  self.db.execute("select * from #{K_POD_LATEST_REFS} where id = '#{id}';") do |row|
    id = row[0]
    name = row[1]
    git = row[2]
    branch = row[3]
    tag = row[4]
    commit = row[5]
    pod_info = LPodLatestRefs.new(id, name, git, branch, tag, commit)
  end
  return pod_info
end

#query_project_info(name, git = nil) ⇒ Object

通过名称查询项目信息



177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
 
# File 'lib/lg_pod_plugin/database.rb', line 177

def query_project_info(name, git = nil)
  project_info = nil
  self.db.execute("select * from #{K_USER_PROJECTS} where name = '#{name}' or path = '#{name}' ;") do |row|
    name_with_namespace = row[7]
    path_with_namespace = row[8]
    next unless git.include?(name_with_namespace) || git.include?(path_with_namespace)
    id = row[0]
    path = row[3]
    name = row[1]
    web_url = row[6]
    description = row[2]
    ssh_url_to_repo = row[4]
    http_url_to_repo =  row[5]
    project_info = ProjectModel.new(id, name, description, path, ssh_url_to_repo, http_url_to_repo, web_url, name_with_namespace, path_with_namespace)
    return project_info
  end
  return project_info
end

#query_user_info(user_id) ⇒ Object 



149
150
151
152
153
154
155
156
157
158
159
160
161
162
 
# File 'lib/lg_pod_plugin/database.rb', line 149

def (user_id)
   = nil
  self.db.execute("select * from #{K_USER_TABLE} where id = '#{user_id}';") do |row|
     = LUserAuthInfo.new
    .id = row[0]
    .username = row[1]
    .password = row[2]
    .host = row[3]
    .access_token = row[4]
    .refresh_token = row[5]
    .expires_in = row[6]
  end
  
end