Solution: Create a new tmp table Copy data to tmp table Delete original table Rename the tmp table’s name to original one’s # Step 1: CREATE TABLE tmp_table ( # your new column types ); # If you don't need Read more…
Problem Description: const [data, setData] = useState([]); data.push(1); setData(data); When I modify the origin array data and set it back, the page won’t refresh. Analysis: In vue and react, if you update a mutable object, it will cause the view Read more…
SpringRunner is an alias for the SpringJUnit4ClassRunner. @RunWith(SpringRunner.class) tells JUnit to run using Spring’s testing support. SpringRunner is the new name for SpringJUnit4ClassRunner, it’s just a bit easier on the eye. SpringRunner is only available after spring-test 4.3. SpringRunner class extends SpringJUnit4ClassRunner. Read the doc source code Read more…
In order for the unit test to run a batch job, the framework must load the job’s ApplicationContext. Two annotations are used to trigger this: @RunWith(SpringJUnit4ClassRunner.class): Indicates that the class should use Spring’s JUnit facilities. @ContextConfiguration(locations = {…}): Indicates which Read more…
1. If <select id="findActiveBlogWithTitleLike" resultType="Blog"> SELECT * FROM BLOG WHERE state = ‘ACTIVE’ <if test="title != null"> AND title like #{title} </if> </select> 2. Choose, When, Otherwise <select id="findActiveBlogLike" resultType="Blog"> SELECT * FROM BLOG WHERE state = ‘ACTIVE’ <choose> # Read more…
Six Attributes collection: There are three formats: list, array, and map, according to the type of parameter passed. item: the parameter name of the set of objects in the tag. separator: the separator at the end of each sub-loop, usually Read more…
Last time, we have successfully displayed a Markdown article on the website and automatically generated a catalogue. Now, we wanted to generate a more practical fixed sidebar navigation. Solution 1: We can use ‘markdown-navbar’. However, this plugin has requirements for Read more…
The @media screen rules are used to create responsive design in CSS so that web pages render the best appearance and layout on different devices. You can define different CSS rules to apply different styles within a specific range of Read more…
@ExtendWith(MockitoExtension.class) class ArticleManagerTest { @Mock ArticleDatabase database; @Mock User user; @Spy @InjectMocks private ArticleManager manager; @BeforeEach void setup(){ // some initialization codes } @Test void shouldDoSomething() { // TODO perform some tests with this managers when(database.some(param)).thenReturn(data); Object res = manager.exe(); Read more…
Recently, my wibesite often meet Out of Memory Problem. And apache will be automatically killed the memory is full. So I decided to add a cron service to moniter the memory usage and restart the apache service. #!/bin/sh TOTAL=`cat /proc/meminfo Read more…