Closed IgorMaksymov closed 8 years ago
@Delete("UPDATE user_event " +
ALTER TABLE user_event DROP CONSTRAINT user_event_pkey, ADD COLUMN unassignDate TIMESTAMP DEFAULT NULL, ADD COLUMN unassignReason VARCHAR(250)DEFAULT NULL, ADD id SERIAL PRIMARY KEY NOT NULL;
"INSERT INTO user_event " + "SELECT #{user.id}, #{event.id} " + "WHERE NOT EXISTS( " + "SELECT 1 FROM user_event " + "where user_id = #{user.id} AND event_id = #{event.id} AND unassigndate IS NULL)"
"testAssignUserEvent_initial.xml"
@Delete("UPDATE user_event " +неправильная аннотацияALTER TABLE user_event DROP CONSTRAINT user_event_pkey, ADD COLUMN unassignDate TIMESTAMP DEFAULT NULL, ADD COLUMN unassignReason VARCHAR(250)DEFAULT NULL, ADD id SERIAL PRIMARY KEY NOT NULL;(отступ, camel_case)[https://github.com/JuniorsJava/itevents/wiki/SQL-expressons-style]"INSERT INTO user_event " + "SELECT #{user.id}, #{event.id} " + "WHERE NOT EXISTS( " + "SELECT 1 FROM user_event " + "where user_id = #{user.id} AND event_id = #{event.id} AND unassigndate IS NULL)"(CAPITAL KEY WORD)[https://github.com/JuniorsJava/itevents/wiki/SQL-expressons-style]"testAssignUserEvent_initial.xml"в каком тесте он initial?