| | |
| | | "import com.lunhan.xxx.entity.dto.*;", |
| | | "import com.lunhan.xxx.entity.enums.*;", |
| | | "import com.lunhan.xxx.repository.BasicMapperImpl;", |
| | | "import org.springframework.stereotype.Repository;" |
| | | "import org.springframework.stereotype.Repository;", |
| | | "", |
| | | "import java.util.List;" |
| | | }; |
| | | //endregion |
| | | |
| | |
| | | sql = ""; |
| | | |
| | | // 触发器:自动赋值最后更新时间 |
| | | sql += "CREATE TRIGGER \"TG_" + tableName + "\" BEFORE INSERT OR UPDATE OF \"update_time\" ON \"public\".\"" + tableName + "\"\n" + |
| | | sql += "CREATE TRIGGER \"TG_" + tableName + "\" BEFORE INSERT OR UPDATE ON \"public\".\"" + tableName + "\"\n" + |
| | | "FOR EACH ROW\n" + |
| | | "EXECUTE PROCEDURE \"public\".\"update_timestamp_column\"();"; |
| | | result = GenCodeGauss.execSql(connect, sql); |