IZ
ЛУЧШЕ ВСЕГО не использовать такие имена
Size: a a a
IZ
IZ
SP
IZ
`CREATE TABLE IF NOT EXISTS token (
id SERIAL PRIMARY KEY,
PaymentToken_id TEXT,
PaymentToken_creator TEXT,
PaymentToken_expdate TEXT,
PaymentToken_type TEXT,
PaymentToken_status TEXT,
PaymentToken_creatorStatus TEXT,
PaymentToken_wallet TEXT,
PaymentToken_deviceType TEXT,
PaymentToken_lang TEXT,
PaymentToken_deviceTelNum TEXT,
PaymentToken_deviceIp TEXT,
PaymentToken_deviceId TEXT,
PaymentToken_deviceName TEXT,
PaymentToken_activationCode TEXT,
PaymentToken_activationExpiry TEXT,
PaymentToken_activationMethod TEXT,
PaymentToken_activationMethodData TEXT
);
SP
SB
SP
CREATE TABLE IF NOT EXISTS PaymentToken (
id SERIAL PRIMARY KEY,
PaymentToken_id TEXT,
PaymentToken_creator TEXT,
PaymentToken_expdate TEXT,
PaymentToken_type TEXT,
PaymentToken_status TEXT,
PaymentToken_creatorStatus TEXT,
PaymentToken_wallet TEXT,
PaymentToken_deviceType TEXT,
PaymentToken_lang TEXT,
PaymentToken_deviceTelNum TEXT,
PaymentToken_deviceIp TEXT,
PaymentToken_deviceId TEXT,
PaymentToken_deviceName TEXT,
PaymentToken_activationCode TEXT,
PaymentToken_activationExpiry TEXT,
PaymentToken_activationMethod TEXT,
PaymentToken_activationMethodData TEXT
);
[ERROR] CreateTable() failed. Error: pq: syntax error at or near "PaymentToken"
SP
SP
CREATE TABLE IF NOT EXISTS Payment (2. написал тест на инсерт
id SERIAL PRIMARY KEY,
PaymentToken_id TEXT
);
INSERT INTO PAYMENTTOKEN(RETURNING id
PaymentToken_id,
VALUES($1)
syntax error at or near "("SP
INSERT INTO PAYMENTTOKEN(
PaymentToken_id,
)
VALUES($1)
RETURNING id
SP
syntax error at or near "("SB
INSERT INTO PAYMENTTOKEN(
PaymentToken_id,
)
VALUES($1)
RETURNING id
SP
SB
SP
SP
INSERT INTO PAYMENT (
PaymentToken_id,
)
VALUES($1)
RETURNING id
`,
IZ
CREATE TABLE IF NOT EXISTS Payment (2. написал тест на инсерт
id SERIAL PRIMARY KEY,
PaymentToken_id TEXT
);
INSERT INTO PAYMENTTOKEN(RETURNING id
PaymentToken_id,
VALUES($1)
syntax error at or near "("AҚ
AҚ
IZ