certs.gen.go 16 KB

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