Commit Graph

436 Commits

Author SHA1 Message Date
901cf23820 missing condition deleted = false 2024-06-04 16:25:43 +03:00
c75ba5ee69 update sqlc gen 2024-06-03 16:49:05 +03:00
8d572f3e31 update sqlc gen 2024-06-03 11:36:10 +03:00
221e131f34 add query for decrement manual privilege 2024-06-03 16:39:37 +03:00
8adb6cdc04 update sqlc gen 2024-06-03 11:34:42 +03:00
f623068d98 add return userID in expired privilege queries 2024-06-03 11:45:35 +03:00
e733f020c5 update sqlc gen 2024-06-03 11:33:19 +03:00
4cb450c5ee add new query for check count expired privilege 2024-06-03 11:24:58 +03:00
4eb7f623fc update sqlc gen 2024-06-02 11:38:41 +03:00
afcd896807 update account create query, now return created data 2024-06-02 11:35:53 +03:00
16ea424441 update sqlc gen 2024-06-01 20:54:33 +03:00
8bca2a49aa update InsertAnswers query 2024-06-01 20:51:11 +03:00
8d5d3e6973 Merge branch 'answerUTM' into 'main'
Answer utm

See merge request backend/quiz/common!19
2024-05-24 12:51:32 +00:00
4512122488 avoid non template templaiting 2024-05-20 17:55:24 +03:00
c74e1f3954 update sqlcgen 2024-05-19 15:22:35 +03:00
bfce6075df update query, now utms getting from answer start where sesion = session resut answer 2024-05-19 15:20:21 +03:00
b898091905 update sqlcgen 2024-05-17 21:55:38 +03:00
168a6d8fec commented utms methods 2024-05-17 21:54:53 +03:00
83b2c9e22a update sqlcgen 2024-05-17 21:50:51 +03:00
b8f7fa08cb update sqlcgen 2024-05-17 21:46:36 +03:00
9f317e2fa6 migrate del table utms, and column utms from rules and commented all queries with utms 2024-05-17 21:43:21 +03:00
da0213dd93 update sqlcgen 2024-05-17 20:53:00 +03:00
e041a2a49a change text utm to jsonb, and add type map for utm 2024-05-17 20:51:59 +03:00
4b40faa60f update sqlcgen 2024-05-17 20:22:23 +03:00
c005af4b60 add utm in answer struct and init new mig files for add column utm to db 2024-05-17 20:19:56 +03:00
7cc340ddf9 update sqlcgen 2024-05-13 15:36:12 +03:00
526a1ca20f refactor template copy 2024-05-17 17:03:02 +03:00
bd96977e0c update sqlc gen 2024-05-13 15:31:39 +03:00
f466afc76b update getting steps, now by pipeline id 2024-05-15 20:45:01 +03:00
e6c3cb41f5 remove migrate init 2024-05-14 17:18:40 +03:00
024f47a56d Merge remote-tracking branch 'origin/amoCRM' 2024-05-13 19:25:48 +03:00
04773c7fce update sqlc gen 2024-05-13 15:30:37 +03:00
14acd815cb update query tmpl copy 2024-05-13 15:29:39 +03:00
a3bce771c9 update sqlc gen 2024-05-13 14:05:04 +03:00
38170308bd add new query for copy quiz on account from tmpl 2024-05-13 14:03:10 +03:00
6ff56437fd update sqlc gen 2024-05-10 12:02:17 +03:00
0c30ce306d add new query foe fetch field by amoid 2024-05-10 11:58:09 +03:00
767c884ae0 update sqlc gen 2024-05-07 20:47:49 +03:00
9f3b71ecd5 add new queries 2024-05-07 20:44:20 +03:00
61cc3891ac update sqlc gen 2024-05-07 20:26:13 +03:00
7cb5ac8273 update sqlc gen 2024-05-07 20:24:35 +03:00
506efb40fc update sqlc gen 2024-05-07 20:20:07 +03:00
358bd8cd34 add queries foe batching delete amo entity 2024-05-07 20:17:53 +03:00
1fd151e8c2 fix: remove stats copying 2024-05-07 19:22:48 +03:00
8f231d8033 update amo dal initialize 2024-05-07 16:40:29 +03:00
edeece4bfb update sqlc gen 2024-05-06 23:07:10 +03:00
db80ad28a0 update sqlc gen 2024-05-06 21:40:34 +03:00
1d429fceee remove answer id in updating 2024-05-06 21:38:35 +03:00
8fbefe5fe0 update sqlc gen 2024-05-06 20:45:19 +03:00
3d390409ec add amo repo method 2024-05-06 20:43:50 +03:00
ff72e7b041 update sqlc gen 2024-05-06 20:36:24 +03:00
3f402879a6 add new query for update amoCRM statuses 2024-05-06 20:33:18 +03:00
eeb6853b6a update sqlc gen 2024-05-06 14:06:55 +03:00
f57e343116 update sqlc gen 2024-05-06 14:00:28 +03:00
e12c66a560 update query 2024-05-06 13:58:59 +03:00
f1911fda2c update sqlc gen 2024-05-06 12:57:14 +03:00
52015d8136 update schema and add setting deal query 2024-05-06 12:55:45 +03:00
4a3c0925fa update sqlc gen 2024-05-04 13:40:24 +03:00
ba2d1c25c7 update query add performer name 2024-05-05 10:42:43 +03:00
10b5336acf update schema 2024-05-04 15:59:43 +03:00
f1d3073dc9 update amorepo init 2024-05-04 15:35:52 +03:00
68df239d7d update sqlc gen 2024-05-04 13:39:08 +03:00
7b3e64c1e7 update query 2024-05-04 13:49:49 +03:00
c1155b2bb2 update sqlc gen 2024-05-04 13:37:43 +03:00
c6d6e8c09c update sqlc gen 2024-05-04 13:33:50 +03:00
0343a1093a add new query 2024-05-04 13:31:59 +03:00
23fa6ca17d add new table for reserching amo fields post statuses 2024-05-04 12:54:23 +03:00
fe2fac1eac update sqlc gen 2024-05-03 18:00:30 +03:00
450d3330d6 update queries 2024-05-03 17:58:28 +03:00
f6c3470bd8 update sqlc gen 2024-05-03 11:20:31 +03:00
2ce1a36bbb update sqlc gen 2024-05-03 10:09:06 +03:00
c5932c3859 update name column size = title question size 2024-05-03 10:07:16 +03:00
3f70f243f7 update sqlc gen 2024-05-02 15:34:03 +03:00
a865b8f3f4 update schema 2024-05-02 15:32:13 +03:00
4cdd0c2784 update sqlc gen 2024-05-02 14:06:49 +03:00
b7c2876b44 update queries 2024-05-02 14:05:33 +03:00
f784e0847d update schema 2024-05-02 12:58:06 +03:00
ab927207fd update schema 2024-05-02 12:53:29 +03:00
71d30df53f update sqlc gen 2024-05-02 12:35:03 +03:00
23ddff0250 update schema and add new query 2024-05-02 12:33:36 +03:00
5192490c05 add new que repo method, and add in amodal struct que repo 2024-05-02 10:42:31 +03:00
17d5622ed1 update sqlc gen 2024-05-02 10:35:17 +03:00
f3052eef0b add new sql query 2024-05-02 10:33:15 +03:00
77355a3a32 update sqlc gen 2024-04-30 01:29:07 +03:00
ff9d34fa84 update sqlc gen 2024-04-30 00:45:58 +03:00
9803bbdff8 update queries 2024-04-30 00:42:31 +03:00
283cc69264 update sqlc gen 2024-04-30 00:26:23 +03:00
93bae2af57 chage CheckUtms 2024-04-30 00:24:45 +03:00
dea1519ce2 update sqlc gen 2024-04-29 15:21:02 +03:00
642347a247 fix query 2024-04-29 15:19:26 +03:00
8d81ca1f33 update sqlc gen 2024-04-29 13:55:02 +03:00
1be4abee5d add new query 2024-04-29 13:52:46 +03:00
6581709257 update sqlc gen 2024-04-29 13:25:59 +03:00
2e8be22953 add new query for update utm 2024-04-29 13:24:36 +03:00
673f4ebb60 update schema 2024-04-29 12:36:30 +03:00
6021decc20 update schema 2024-04-29 12:32:12 +03:00
019e94b8ff update sqlc gen 2024-04-29 11:41:16 +03:00
a611381964 update sqlc gen 2024-04-29 11:37:50 +03:00
785465b7ad update sqlc gen 2024-04-29 10:42:48 +03:00
1f5d80d625 add check utms query 2024-04-29 10:39:57 +03:00
66093eefe3 amofieldID in utm may be null default 0 2024-04-28 23:41:22 +03:00
0f28fe5439 update sqlc gen 2024-04-28 17:49:17 +03:00
017c49a59e add to GetUserUTMByListIDs retunrning entity field 2024-04-28 17:48:06 +03:00
a976fa2bc6 update sqlc gen 2024-04-28 17:19:44 +03:00
8768bbe3e6 get utms by ids list 2024-04-28 17:18:05 +03:00
e4cdfcace2 update sqlcgen with new enub type 2024-04-28 16:06:06 +03:00
6d80f5c5e8 init field type enum 2024-04-28 16:03:05 +03:00
268f16f54d update sqlc gen 2024-04-23 18:04:31 +03:00
5a487f6994 add webhook delete query 2024-04-23 18:02:15 +03:00
9cbe8b6b27 init rule methods in amo repo 2024-04-23 15:04:24 +03:00
b6b8f67cb6 update sqlc gen 2024-04-23 14:48:15 +03:00
ebf5c9f4de add rule querys 2024-04-23 14:42:13 +03:00
60b55541d6 Merge branch 'rpcquery' into 'main'
Rpcquery

See merge request backend/quiz/common!12
2024-04-23 10:26:06 +00:00
6f084f52a6 add paxeholder 2024-04-22 21:36:31 +03:00
ab32ce154e update sqlc gen 2024-04-22 21:33:18 +03:00
95ff5e4894 update query 2024-04-22 21:31:29 +03:00
fe83874203 update sqlc gen 2024-04-22 18:15:03 +03:00
cc0512de5e update amo repo 2024-04-22 18:13:59 +03:00
4ca35ec382 update sqlc gen 2024-04-22 17:45:39 +03:00
33c04c20f3 update sqlc gen 2024-04-22 17:43:11 +03:00
87cdea8e08 update sqlc gen 2024-04-22 17:25:42 +03:00
8a0237ee6e update queries 2024-04-22 17:13:18 +03:00
4a6ed865a7 update sqlc gen 2024-04-22 13:44:18 +03:00
1f6a5c6ee6 update sqlc gen 2024-04-22 13:43:09 +03:00
e01edb871e update migrate schema 2024-04-22 13:39:34 +03:00
b6e53fdff7 update sqlc gen 2024-04-22 11:37:07 +03:00
c17fb92c50 update sqlc gen 2024-04-22 11:33:25 +03:00
30192e61cb update sqlc gen 2024-04-21 18:18:53 +03:00
134018576f update sql queryes 2024-04-21 18:15:10 +03:00
96cbd85a2d update sqlc gen 2024-04-21 16:57:43 +03:00
f056b6ffcc update sqlc gen 2024-04-21 16:52:25 +03:00
b7afcb01b1 update sqlc gen 2024-04-21 13:07:44 +03:00
17590bde8e update query 2024-04-21 13:16:20 +03:00
759ec37def update sqlc gen 2024-04-20 12:22:38 +03:00
9a0b7b45cf update sqlc gen 2024-04-20 12:01:25 +03:00
775d9d32cf update schema 2024-04-20 11:59:16 +03:00
64e45ebed8 fix token value size 2024-04-19 17:41:25 +03:00
b6b37bac24 update sqlc gen 2024-04-19 11:31:54 +03:00
f1be15ae1b update queries 2024-04-19 11:30:09 +03:00
582afc3395 update sqlc gen 2024-04-19 11:02:20 +03:00
92cf86e26b rework query 2024-04-19 10:59:51 +03:00
07644bfbf0 test 2024-04-18 23:05:49 +03:00
460f903f3e separate queries 2024-04-18 20:32:07 +03:00
0bb1040195 update sqlc gen 2024-04-18 17:59:24 +03:00
95fd5f2412 add restincs 2024-04-18 18:14:14 +03:00
091f7e72f4 update sqlc gen 2024-04-18 17:58:32 +03:00
dccb464f9e add restincs 2024-04-18 17:57:34 +03:00
a38933b45d update sqlc gen 2024-04-18 17:03:29 +03:00
1a0cc487cb fix 2024-04-18 17:02:39 +03:00
78dc91629c update sqlc gen 2024-04-18 16:50:25 +03:00
50f5b8cdf0 fix 2024-04-18 16:49:45 +03:00
56036e7c35 update sqlc gen 2024-04-18 16:16:19 +03:00
ad18b4a788 update querys 2024-04-18 16:15:20 +03:00
9c1fb0644e update sqlc gen 2024-04-18 15:52:22 +03:00
5f2e01f9a0 add another check queryes 2024-04-18 15:50:11 +03:00
105a18f646 init new amo repo methods 2024-04-18 14:00:02 +03:00
8fea5d95c3 reworked schema and new sqlc generate 2024-04-18 13:16:03 +03:00
42ba11f5a0 fix sql 2024-04-18 13:10:59 +03:00
ae01145ce6 add query check tags 2024-04-18 12:16:25 +03:00
2841043cde gen with sqlc 2024-04-17 21:10:42 +03:00
b36797b22d add some methods repo in amo repo 2024-04-17 21:09:09 +03:00
24b7942061 gen with sqlc 2024-04-17 20:43:28 +03:00
286f65ee38 some update pagination query 2024-04-17 20:42:13 +03:00
670d4d88a6 gen with sqlc 2024-04-17 20:18:52 +03:00
0c528d5afb add some amo sql queries for account and webhook 2024-04-17 20:14:12 +03:00
ff64fa15e4 removed foreign keys from new tables only implicit relationship 2024-04-17 19:28:46 +03:00
9b6327b695 update migrate files 2024-04-17 18:37:04 +03:00
35f553ab1d add jsonb column to questions table 2024-04-17 18:17:07 +03:00
111207f0f3 add new tables for amo integration 2024-04-17 17:48:38 +03:00
b73bae1966 init amo repo in common repo 2024-04-17 12:30:19 +03:00
6e6e28d492 add new varible to getting question title 2024-04-16 14:07:18 +03:00
a84f95429f add page sort for getting questions page 2024-04-16 13:29:30 +03:00
5c23a0151e remove auth client for avoid cycle import 2024-04-14 01:18:08 +03:00
8e83ed89fa return questiontype as string 2024-04-11 20:17:01 +03:00
9e923b7a2c update sqlc gen 2024-04-07 13:59:53 +03:00
f756683012 fix question statistic query 2024-04-10 17:31:20 +03:00
5136009e94 Merge branch 'fixwc' into 'main'
Fixwc

See merge request backend/quiz/common!4
2024-04-09 16:00:49 +00:00
4495237cb3 lil fix question title 2024-04-08 21:28:39 +03:00
126d5822d5 add some data to funnel and filter start from questions 2024-04-08 01:30:35 +03:00
da9b7336d2 remove insert privilegeWC 2024-04-07 11:51:07 +03:00
38eec37140 fix: add last rigth value to series and refactor general stats 2024-04-07 03:46:42 +03:00
2e3402cb1c fix: add last rigth value to series and refactor general stats 2024-04-07 03:07:42 +03:00
1e67bb6da0 update sqlc gen 2024-04-05 16:27:04 +03:00
4305a04063 fix calculate onchanged answers in ques stats 2024-04-05 16:22:11 +03:00
a2dc4ba4bb add new query for rpc 2024-04-03 19:08:10 +03:00
cb140aafb3 скопировал миграцию 2024-04-02 02:41:06 +03:00
8a6ba24090 add device, browser etc to answers obtaining 2024-04-01 14:55:17 +03:00
a4e684242f merge staats 2024-03-30 02:23:16 +03:00
4e1b1b45d0 update sqlc gen 2024-03-29 11:37:16 +03:00
e4b40cc929 -- 2024-03-29 02:51:52 +03:00
76b883af11 fix: move quiz request 2024-03-29 01:23:08 +03:00
9eea1d69da update sqlc gen 2024-03-28 22:31:00 +03:00
4f61bc17b0 add minioClient to answer Repo 2024-03-28 15:22:54 +03:00
f54a40e2ac add minioClient to answer Repo 2024-03-28 14:53:12 +03:00
8957585976 update sqlc gen 2024-03-28 13:37:43 +03:00
afb94fcb49 update query 2024-03-28 13:35:38 +03:00
1b82e14c43 update sqlc gen 2024-03-25 11:34:07 +03:00
bec22dd0b5 add new AllServiceStatistics query 2024-03-25 11:30:06 +03:00
0f69edc9d0 update sqlc gen 2024-03-19 20:09:44 +03:00
33e5180c5f add GetQidOwner query 2024-03-22 14:31:37 +03:00