1
0

certs.gen.go 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563
  1. // Code generated by gorm.io/gen. DO NOT EDIT.
  2. // Code generated by gorm.io/gen. DO NOT EDIT.
  3. // Code generated by gorm.io/gen. DO NOT EDIT.
  4. package query
  5. import (
  6. "context"
  7. "strings"
  8. "gorm.io/gorm"
  9. "gorm.io/gorm/clause"
  10. "gorm.io/gorm/schema"
  11. "gorm.io/gen"
  12. "gorm.io/gen/field"
  13. "gorm.io/plugin/dbresolver"
  14. "github.com/0xJacky/Nginx-UI/model"
  15. )
  16. func newCert(db *gorm.DB, opts ...gen.DOOption) cert {
  17. _cert := cert{}
  18. _cert.certDo.UseDB(db, opts...)
  19. _cert.certDo.UseModel(&model.Cert{})
  20. tableName := _cert.certDo.TableName()
  21. _cert.ALL = field.NewAsterisk(tableName)
  22. _cert.ID = field.NewInt(tableName, "id")
  23. _cert.CreatedAt = field.NewTime(tableName, "created_at")
  24. _cert.UpdatedAt = field.NewTime(tableName, "updated_at")
  25. _cert.DeletedAt = field.NewField(tableName, "deleted_at")
  26. _cert.Name = field.NewString(tableName, "name")
  27. _cert.Domains = field.NewField(tableName, "domains")
  28. _cert.Filename = field.NewString(tableName, "filename")
  29. _cert.SSLCertificatePath = field.NewString(tableName, "ssl_certificate_path")
  30. _cert.SSLCertificateKeyPath = field.NewString(tableName, "ssl_certificate_key_path")
  31. _cert.AutoCert = field.NewInt(tableName, "auto_cert")
  32. _cert.ChallengeMethod = field.NewString(tableName, "challenge_method")
  33. _cert.DnsCredentialID = field.NewInt(tableName, "dns_credential_id")
  34. _cert.ACMEUserID = field.NewInt(tableName, "acme_user_id")
  35. _cert.KeyType = field.NewString(tableName, "key_type")
  36. _cert.Log = field.NewString(tableName, "log")
  37. _cert.DnsCredential = certBelongsToDnsCredential{
  38. db: db.Session(&gorm.Session{}),
  39. RelationField: field.NewRelation("DnsCredential", "model.DnsCredential"),
  40. }
  41. _cert.ACMEUser = certBelongsToACMEUser{
  42. db: db.Session(&gorm.Session{}),
  43. RelationField: field.NewRelation("ACMEUser", "model.AcmeUser"),
  44. }
  45. _cert.fillFieldMap()
  46. return _cert
  47. }
  48. type cert struct {
  49. certDo
  50. ALL field.Asterisk
  51. ID field.Int
  52. CreatedAt field.Time
  53. UpdatedAt field.Time
  54. DeletedAt field.Field
  55. Name field.String
  56. Domains field.Field
  57. Filename field.String
  58. SSLCertificatePath field.String
  59. SSLCertificateKeyPath field.String
  60. AutoCert field.Int
  61. ChallengeMethod field.String
  62. DnsCredentialID field.Int
  63. ACMEUserID field.Int
  64. KeyType field.String
  65. Log field.String
  66. DnsCredential certBelongsToDnsCredential
  67. ACMEUser certBelongsToACMEUser
  68. fieldMap map[string]field.Expr
  69. }
  70. func (c cert) Table(newTableName string) *cert {
  71. c.certDo.UseTable(newTableName)
  72. return c.updateTableName(newTableName)
  73. }
  74. func (c cert) As(alias string) *cert {
  75. c.certDo.DO = *(c.certDo.As(alias).(*gen.DO))
  76. return c.updateTableName(alias)
  77. }
  78. func (c *cert) updateTableName(table string) *cert {
  79. c.ALL = field.NewAsterisk(table)
  80. c.ID = field.NewInt(table, "id")
  81. c.CreatedAt = field.NewTime(table, "created_at")
  82. c.UpdatedAt = field.NewTime(table, "updated_at")
  83. c.DeletedAt = field.NewField(table, "deleted_at")
  84. c.Name = field.NewString(table, "name")
  85. c.Domains = field.NewField(table, "domains")
  86. c.Filename = field.NewString(table, "filename")
  87. c.SSLCertificatePath = field.NewString(table, "ssl_certificate_path")
  88. c.SSLCertificateKeyPath = field.NewString(table, "ssl_certificate_key_path")
  89. c.AutoCert = field.NewInt(table, "auto_cert")
  90. c.ChallengeMethod = field.NewString(table, "challenge_method")
  91. c.DnsCredentialID = field.NewInt(table, "dns_credential_id")
  92. c.ACMEUserID = field.NewInt(table, "acme_user_id")
  93. c.KeyType = field.NewString(table, "key_type")
  94. c.Log = field.NewString(table, "log")
  95. c.fillFieldMap()
  96. return c
  97. }
  98. func (c *cert) GetFieldByName(fieldName string) (field.OrderExpr, bool) {
  99. _f, ok := c.fieldMap[fieldName]
  100. if !ok || _f == nil {
  101. return nil, false
  102. }
  103. _oe, ok := _f.(field.OrderExpr)
  104. return _oe, ok
  105. }
  106. func (c *cert) fillFieldMap() {
  107. c.fieldMap = make(map[string]field.Expr, 17)
  108. c.fieldMap["id"] = c.ID
  109. c.fieldMap["created_at"] = c.CreatedAt
  110. c.fieldMap["updated_at"] = c.UpdatedAt
  111. c.fieldMap["deleted_at"] = c.DeletedAt
  112. c.fieldMap["name"] = c.Name
  113. c.fieldMap["domains"] = c.Domains
  114. c.fieldMap["filename"] = c.Filename
  115. c.fieldMap["ssl_certificate_path"] = c.SSLCertificatePath
  116. c.fieldMap["ssl_certificate_key_path"] = c.SSLCertificateKeyPath
  117. c.fieldMap["auto_cert"] = c.AutoCert
  118. c.fieldMap["challenge_method"] = c.ChallengeMethod
  119. c.fieldMap["dns_credential_id"] = c.DnsCredentialID
  120. c.fieldMap["acme_user_id"] = c.ACMEUserID
  121. c.fieldMap["key_type"] = c.KeyType
  122. c.fieldMap["log"] = c.Log
  123. }
  124. func (c cert) clone(db *gorm.DB) cert {
  125. c.certDo.ReplaceConnPool(db.Statement.ConnPool)
  126. return c
  127. }
  128. func (c cert) replaceDB(db *gorm.DB) cert {
  129. c.certDo.ReplaceDB(db)
  130. return c
  131. }
  132. type certBelongsToDnsCredential struct {
  133. db *gorm.DB
  134. field.RelationField
  135. }
  136. func (a certBelongsToDnsCredential) Where(conds ...field.Expr) *certBelongsToDnsCredential {
  137. if len(conds) == 0 {
  138. return &a
  139. }
  140. exprs := make([]clause.Expression, 0, len(conds))
  141. for _, cond := range conds {
  142. exprs = append(exprs, cond.BeCond().(clause.Expression))
  143. }
  144. a.db = a.db.Clauses(clause.Where{Exprs: exprs})
  145. return &a
  146. }
  147. func (a certBelongsToDnsCredential) WithContext(ctx context.Context) *certBelongsToDnsCredential {
  148. a.db = a.db.WithContext(ctx)
  149. return &a
  150. }
  151. func (a certBelongsToDnsCredential) Session(session *gorm.Session) *certBelongsToDnsCredential {
  152. a.db = a.db.Session(session)
  153. return &a
  154. }
  155. func (a certBelongsToDnsCredential) Model(m *model.Cert) *certBelongsToDnsCredentialTx {
  156. return &certBelongsToDnsCredentialTx{a.db.Model(m).Association(a.Name())}
  157. }
  158. type certBelongsToDnsCredentialTx struct{ tx *gorm.Association }
  159. func (a certBelongsToDnsCredentialTx) Find() (result *model.DnsCredential, err error) {
  160. return result, a.tx.Find(&result)
  161. }
  162. func (a certBelongsToDnsCredentialTx) Append(values ...*model.DnsCredential) (err error) {
  163. targetValues := make([]interface{}, len(values))
  164. for i, v := range values {
  165. targetValues[i] = v
  166. }
  167. return a.tx.Append(targetValues...)
  168. }
  169. func (a certBelongsToDnsCredentialTx) Replace(values ...*model.DnsCredential) (err error) {
  170. targetValues := make([]interface{}, len(values))
  171. for i, v := range values {
  172. targetValues[i] = v
  173. }
  174. return a.tx.Replace(targetValues...)
  175. }
  176. func (a certBelongsToDnsCredentialTx) Delete(values ...*model.DnsCredential) (err error) {
  177. targetValues := make([]interface{}, len(values))
  178. for i, v := range values {
  179. targetValues[i] = v
  180. }
  181. return a.tx.Delete(targetValues...)
  182. }
  183. func (a certBelongsToDnsCredentialTx) Clear() error {
  184. return a.tx.Clear()
  185. }
  186. func (a certBelongsToDnsCredentialTx) Count() int64 {
  187. return a.tx.Count()
  188. }
  189. type certBelongsToACMEUser struct {
  190. db *gorm.DB
  191. field.RelationField
  192. }
  193. func (a certBelongsToACMEUser) Where(conds ...field.Expr) *certBelongsToACMEUser {
  194. if len(conds) == 0 {
  195. return &a
  196. }
  197. exprs := make([]clause.Expression, 0, len(conds))
  198. for _, cond := range conds {
  199. exprs = append(exprs, cond.BeCond().(clause.Expression))
  200. }
  201. a.db = a.db.Clauses(clause.Where{Exprs: exprs})
  202. return &a
  203. }
  204. func (a certBelongsToACMEUser) WithContext(ctx context.Context) *certBelongsToACMEUser {
  205. a.db = a.db.WithContext(ctx)
  206. return &a
  207. }
  208. func (a certBelongsToACMEUser) Session(session *gorm.Session) *certBelongsToACMEUser {
  209. a.db = a.db.Session(session)
  210. return &a
  211. }
  212. func (a certBelongsToACMEUser) Model(m *model.Cert) *certBelongsToACMEUserTx {
  213. return &certBelongsToACMEUserTx{a.db.Model(m).Association(a.Name())}
  214. }
  215. type certBelongsToACMEUserTx struct{ tx *gorm.Association }
  216. func (a certBelongsToACMEUserTx) Find() (result *model.AcmeUser, err error) {
  217. return result, a.tx.Find(&result)
  218. }
  219. func (a certBelongsToACMEUserTx) Append(values ...*model.AcmeUser) (err error) {
  220. targetValues := make([]interface{}, len(values))
  221. for i, v := range values {
  222. targetValues[i] = v
  223. }
  224. return a.tx.Append(targetValues...)
  225. }
  226. func (a certBelongsToACMEUserTx) Replace(values ...*model.AcmeUser) (err error) {
  227. targetValues := make([]interface{}, len(values))
  228. for i, v := range values {
  229. targetValues[i] = v
  230. }
  231. return a.tx.Replace(targetValues...)
  232. }
  233. func (a certBelongsToACMEUserTx) Delete(values ...*model.AcmeUser) (err error) {
  234. targetValues := make([]interface{}, len(values))
  235. for i, v := range values {
  236. targetValues[i] = v
  237. }
  238. return a.tx.Delete(targetValues...)
  239. }
  240. func (a certBelongsToACMEUserTx) Clear() error {
  241. return a.tx.Clear()
  242. }
  243. func (a certBelongsToACMEUserTx) Count() int64 {
  244. return a.tx.Count()
  245. }
  246. type certDo struct{ gen.DO }
  247. // FirstByID Where("id=@id")
  248. func (c certDo) FirstByID(id int) (result *model.Cert, err error) {
  249. var params []interface{}
  250. var generateSQL strings.Builder
  251. params = append(params, id)
  252. generateSQL.WriteString("id=? ")
  253. var executeSQL *gorm.DB
  254. executeSQL = c.UnderlyingDB().Where(generateSQL.String(), params...).Take(&result) // ignore_security_alert
  255. err = executeSQL.Error
  256. return
  257. }
  258. // DeleteByID update @@table set deleted_at=strftime('%Y-%m-%d %H:%M:%S','now') where id=@id
  259. func (c certDo) DeleteByID(id int) (err error) {
  260. var params []interface{}
  261. var generateSQL strings.Builder
  262. params = append(params, id)
  263. generateSQL.WriteString("update certs set deleted_at=strftime('%Y-%m-%d %H:%M:%S','now') where id=? ")
  264. var executeSQL *gorm.DB
  265. executeSQL = c.UnderlyingDB().Exec(generateSQL.String(), params...) // ignore_security_alert
  266. err = executeSQL.Error
  267. return
  268. }
  269. func (c certDo) Debug() *certDo {
  270. return c.withDO(c.DO.Debug())
  271. }
  272. func (c certDo) WithContext(ctx context.Context) *certDo {
  273. return c.withDO(c.DO.WithContext(ctx))
  274. }
  275. func (c certDo) ReadDB() *certDo {
  276. return c.Clauses(dbresolver.Read)
  277. }
  278. func (c certDo) WriteDB() *certDo {
  279. return c.Clauses(dbresolver.Write)
  280. }
  281. func (c certDo) Session(config *gorm.Session) *certDo {
  282. return c.withDO(c.DO.Session(config))
  283. }
  284. func (c certDo) Clauses(conds ...clause.Expression) *certDo {
  285. return c.withDO(c.DO.Clauses(conds...))
  286. }
  287. func (c certDo) Returning(value interface{}, columns ...string) *certDo {
  288. return c.withDO(c.DO.Returning(value, columns...))
  289. }
  290. func (c certDo) Not(conds ...gen.Condition) *certDo {
  291. return c.withDO(c.DO.Not(conds...))
  292. }
  293. func (c certDo) Or(conds ...gen.Condition) *certDo {
  294. return c.withDO(c.DO.Or(conds...))
  295. }
  296. func (c certDo) Select(conds ...field.Expr) *certDo {
  297. return c.withDO(c.DO.Select(conds...))
  298. }
  299. func (c certDo) Where(conds ...gen.Condition) *certDo {
  300. return c.withDO(c.DO.Where(conds...))
  301. }
  302. func (c certDo) Order(conds ...field.Expr) *certDo {
  303. return c.withDO(c.DO.Order(conds...))
  304. }
  305. func (c certDo) Distinct(cols ...field.Expr) *certDo {
  306. return c.withDO(c.DO.Distinct(cols...))
  307. }
  308. func (c certDo) Omit(cols ...field.Expr) *certDo {
  309. return c.withDO(c.DO.Omit(cols...))
  310. }
  311. func (c certDo) Join(table schema.Tabler, on ...field.Expr) *certDo {
  312. return c.withDO(c.DO.Join(table, on...))
  313. }
  314. func (c certDo) LeftJoin(table schema.Tabler, on ...field.Expr) *certDo {
  315. return c.withDO(c.DO.LeftJoin(table, on...))
  316. }
  317. func (c certDo) RightJoin(table schema.Tabler, on ...field.Expr) *certDo {
  318. return c.withDO(c.DO.RightJoin(table, on...))
  319. }
  320. func (c certDo) Group(cols ...field.Expr) *certDo {
  321. return c.withDO(c.DO.Group(cols...))
  322. }
  323. func (c certDo) Having(conds ...gen.Condition) *certDo {
  324. return c.withDO(c.DO.Having(conds...))
  325. }
  326. func (c certDo) Limit(limit int) *certDo {
  327. return c.withDO(c.DO.Limit(limit))
  328. }
  329. func (c certDo) Offset(offset int) *certDo {
  330. return c.withDO(c.DO.Offset(offset))
  331. }
  332. func (c certDo) Scopes(funcs ...func(gen.Dao) gen.Dao) *certDo {
  333. return c.withDO(c.DO.Scopes(funcs...))
  334. }
  335. func (c certDo) Unscoped() *certDo {
  336. return c.withDO(c.DO.Unscoped())
  337. }
  338. func (c certDo) Create(values ...*model.Cert) error {
  339. if len(values) == 0 {
  340. return nil
  341. }
  342. return c.DO.Create(values)
  343. }
  344. func (c certDo) CreateInBatches(values []*model.Cert, batchSize int) error {
  345. return c.DO.CreateInBatches(values, batchSize)
  346. }
  347. // Save : !!! underlying implementation is different with GORM
  348. // The method is equivalent to executing the statement: db.Clauses(clause.OnConflict{UpdateAll: true}).Create(values)
  349. func (c certDo) Save(values ...*model.Cert) error {
  350. if len(values) == 0 {
  351. return nil
  352. }
  353. return c.DO.Save(values)
  354. }
  355. func (c certDo) First() (*model.Cert, error) {
  356. if result, err := c.DO.First(); err != nil {
  357. return nil, err
  358. } else {
  359. return result.(*model.Cert), nil
  360. }
  361. }
  362. func (c certDo) Take() (*model.Cert, error) {
  363. if result, err := c.DO.Take(); err != nil {
  364. return nil, err
  365. } else {
  366. return result.(*model.Cert), nil
  367. }
  368. }
  369. func (c certDo) Last() (*model.Cert, error) {
  370. if result, err := c.DO.Last(); err != nil {
  371. return nil, err
  372. } else {
  373. return result.(*model.Cert), nil
  374. }
  375. }
  376. func (c certDo) Find() ([]*model.Cert, error) {
  377. result, err := c.DO.Find()
  378. return result.([]*model.Cert), err
  379. }
  380. func (c certDo) FindInBatch(batchSize int, fc func(tx gen.Dao, batch int) error) (results []*model.Cert, err error) {
  381. buf := make([]*model.Cert, 0, batchSize)
  382. err = c.DO.FindInBatches(&buf, batchSize, func(tx gen.Dao, batch int) error {
  383. defer func() { results = append(results, buf...) }()
  384. return fc(tx, batch)
  385. })
  386. return results, err
  387. }
  388. func (c certDo) FindInBatches(result *[]*model.Cert, batchSize int, fc func(tx gen.Dao, batch int) error) error {
  389. return c.DO.FindInBatches(result, batchSize, fc)
  390. }
  391. func (c certDo) Attrs(attrs ...field.AssignExpr) *certDo {
  392. return c.withDO(c.DO.Attrs(attrs...))
  393. }
  394. func (c certDo) Assign(attrs ...field.AssignExpr) *certDo {
  395. return c.withDO(c.DO.Assign(attrs...))
  396. }
  397. func (c certDo) Joins(fields ...field.RelationField) *certDo {
  398. for _, _f := range fields {
  399. c = *c.withDO(c.DO.Joins(_f))
  400. }
  401. return &c
  402. }
  403. func (c certDo) Preload(fields ...field.RelationField) *certDo {
  404. for _, _f := range fields {
  405. c = *c.withDO(c.DO.Preload(_f))
  406. }
  407. return &c
  408. }
  409. func (c certDo) FirstOrInit() (*model.Cert, error) {
  410. if result, err := c.DO.FirstOrInit(); err != nil {
  411. return nil, err
  412. } else {
  413. return result.(*model.Cert), nil
  414. }
  415. }
  416. func (c certDo) FirstOrCreate() (*model.Cert, error) {
  417. if result, err := c.DO.FirstOrCreate(); err != nil {
  418. return nil, err
  419. } else {
  420. return result.(*model.Cert), nil
  421. }
  422. }
  423. func (c certDo) FindByPage(offset int, limit int) (result []*model.Cert, count int64, err error) {
  424. result, err = c.Offset(offset).Limit(limit).Find()
  425. if err != nil {
  426. return
  427. }
  428. if size := len(result); 0 < limit && 0 < size && size < limit {
  429. count = int64(size + offset)
  430. return
  431. }
  432. count, err = c.Offset(-1).Limit(-1).Count()
  433. return
  434. }
  435. func (c certDo) ScanByPage(result interface{}, offset int, limit int) (count int64, err error) {
  436. count, err = c.Count()
  437. if err != nil {
  438. return
  439. }
  440. err = c.Offset(offset).Limit(limit).Scan(result)
  441. return
  442. }
  443. func (c certDo) Scan(result interface{}) (err error) {
  444. return c.DO.Scan(result)
  445. }
  446. func (c certDo) Delete(models ...*model.Cert) (result gen.ResultInfo, err error) {
  447. return c.DO.Delete(models)
  448. }
  449. func (c *certDo) withDO(do gen.Dao) *certDo {
  450. c.DO = *do.(*gen.DO)
  451. return c
  452. }