A.bursakov в 19:48, 17 декабря 2025

2025-12-17T19:48:16Z

← Предыдущая версия		Версия от 19:48, 17 декабря 2025
Строка 77:		Строка 77:
	commit;		commit;
	</syntaxhighlight>		</syntaxhighlight>

	~~test~~

A.bursakov в 19:48, 17 декабря 2025

2025-12-17T19:48:03Z

← Предыдущая версия		Версия от 19:48, 17 декабря 2025
Строка 77:		Строка 77:
	commit;		commit;
	</syntaxhighlight>		</syntaxhighlight>

			test

D.bizyukov: /* Entering authentication data for sending push notifications */

2022-05-11T14:22:21Z

Entering authentication data for sending push notifications

← Предыдущая версия		Версия от 14:22, 11 мая 2022
Строка 53:		Строка 53:
	systemid)		systemid)
	VALUES (		VALUES (
	nextval('~~pc_split_pusher_credentials_id_seq~~'),		nextval('pc_split_pusher_creds_seq'),
	'%appid%',		'%appid%',
	'{"google_api_key":"%google_api_key%"}',		'{"google_api_key":"%google_api_key%"}',
Строка 68:		Строка 68:
	systemid)		systemid)
	VALUES (		VALUES (
	nextval('~~pc_split_pusher_credentials_id_seq~~'),		nextval('pc_split_pusher_creds_seq'),
	'%appid%',		'%appid%',
	'{"apns_key_file":"%key file path%","apns_key_id":"%apns_key_id%","apns_team_id":"%apns_team_id%"}',		'{"apns_key_file":"%key file path%","apns_key_id":"%apns_key_id%","apns_team_id":"%apns_team_id%"}',

D.bizyukov: Новая страница: «=Entering authentication data for sending push notifications= {{Предупреждение|For non-PostgreSQL DBMS, change the sequence method}} For '''MSSQL'…»

2022-05-11T13:04:56Z

Новая страница: «=Entering authentication data for sending push notifications= {{Предупреждение|For non-PostgreSQL DBMS, change the sequence method}} For '''MSSQL'…»

Новая страница

=Entering authentication data for sending push notifications=
{{Предупреждение|For non-PostgreSQL DBMS, change the sequence method}}

For '''MSSQL''' you need to use a string <code>NEXT VALUE FOR pc_split_pusher_creds_seq,</code> instead of string <code>nextval('pc_split_pusher_creds_seq'),</code>.

For '''Oracle''' you need to use a string <code>pc_split_pusher_creds_seq.NEXTVAL,</code> instead of string <code>nextval('pc_split_pusher_creds_seq'),</code>.

==To the PayConfirm app==
To enter authentication data for sending push notifications to the PayConfirm application, you must perform the following queries to the PC Pusher database, replacing the %SYSTEMID% values with the correct one.

Note that the percent signs '''need to be removed'''.
After executing the requests, you need to [[Руководство_администратора_PayControl_v5#Запуск и остановка служб сервера PayControl|restart]] the PC Pusher Wildfly server.

Example for СУБД PostgreSQL:
<syntaxhighlight lang="sql">INSERT INTO pc_split_pusher_credentials (
id,
appid,
credentials,
os,
systemid)
VALUES (
nextval('pc_split_pusher_creds_seq'),
'org.payconfirm.app',
'{"google_api_key":"AAAA4H70m7M:APA91bFsaPiXXiIuRyj4h-xGZpyd0-I3B9F1udIIergxaK8uL9vPPvUQXOvPfau2w8E-xur_6TlTzmhb2JsO13hBCxVDrNybD6Rj8k4hZKXfs7tC5fnJuWmCIB3-O_4dLo0QHlhfSbGn"}',
'Android',
'%SYSTEMID%');

INSERT INTO pc_split_pusher_credentials (
id,
appid,
credentials,
os,
systemid)
VALUES (
nextval('pc_split_pusher_creds_seq'),
'org.payconfirm.app',
'{"apns_key_file":"C:\\wildfly\\safetech-apns-JVBQX52N5Z.p8","apns_key_id":"QCC684AGC4","apns_team_id":"B98K5P3YHV"}',
'iOS',
'%SYSTEMID%');</syntaxhighlight>

==To another mobile app==
To enter authentication data for sending push notifications, you need to make a request to the PC Pusher database, replacing the value %SYSTEMID%, %appid%, %key file path%, %apns_key_id%, %apns_team_id%, %google_api_key% with the correct ones. (this data, with the exception of %SYSTEMID%, can be obtained from the owners of the account under whose name the application is published), and '''deleting''' the percent signs:

Example for СУБД PostgreSQL:
<syntaxhighlight lang="sql">
INSERT INTO pc_split_pusher_credentials (
id,
appid,
credentials,
is_default,
os,
systemid)
VALUES (
nextval('pc_split_pusher_credentials_id_seq'),
'%appid%',
'{"google_api_key":"%google_api_key%"}',
1,
'Android',
'%SYSTEMID%');

INSERT INTO pc_split_pusher_credentials (
id,
appid,
credentials,
is_default,
os,
systemid)
VALUES (
nextval('pc_split_pusher_credentials_id_seq'),
'%appid%',
'{"apns_key_file":"%key file path%","apns_key_id":"%apns_key_id%","apns_team_id":"%apns_team_id%"}',
1,
'iOS',
'%SYSTEMID%');

commit;
</syntaxhighlight>

PC Pusher 5.1 En - История изменений

A.bursakov в 19:48, 17 декабря 2025

A.bursakov в 19:48, 17 декабря 2025

D.bizyukov: /* Entering authentication data for sending push notifications */

D.bizyukov: Новая страница: «=Entering authentication data for sending push notifications= {{Предупреждение|For non-PostgreSQL DBMS, change the sequence method}} For '''MSSQL'…»