Skip to content

Add indexes for sql, add mssql support and enforce database type limits #26

Add indexes for sql, add mssql support and enforce database type limits

Add indexes for sql, add mssql support and enforce database type limits #26

GitHub Actions / Test Results succeeded Sep 24, 2024 in 0s

All 64 tests pass in 6s

  6 files  ± 0    6 suites  ±0   6s ⏱️ -1s
 64 tests + 4   64 ✅ + 4  0 💤 ±0  0 ❌ ±0 
203 runs  +21  203 ✅ +21  0 💤 ±0  0 ❌ ±0 

Results for commit 9324a60. ± Comparison against earlier commit a49701d.

Annotations

Check notice on line 0 in .github

See this annotation in the file changed.

@github-actions github-actions / Test Results

64 tests found

There are 64 tests, see "Raw output" for the full list of tests.
Raw output
org.geysermc.databaseutils.RepositoryImplementationGenerationTest ‑ testAdvancedCompilation()
org.geysermc.databaseutils.RepositoryImplementationGenerationTest ‑ testBasicCompilation()
org.geysermc.databaseutils.delete.DeleteTests ‑ H2
org.geysermc.databaseutils.delete.DeleteTests ‑ MariaDB
org.geysermc.databaseutils.delete.DeleteTests ‑ MongoDB
org.geysermc.databaseutils.delete.DeleteTests ‑ MySQL
org.geysermc.databaseutils.delete.DeleteTests ‑ Oracle Database
org.geysermc.databaseutils.delete.DeleteTests ‑ PostgreSQL
org.geysermc.databaseutils.delete.DeleteTests ‑ SQL Server
org.geysermc.databaseutils.delete.DeleteTests ‑ SQLite
org.geysermc.databaseutils.exists.ExistsTests ‑ H2
org.geysermc.databaseutils.exists.ExistsTests ‑ MariaDB
org.geysermc.databaseutils.exists.ExistsTests ‑ MongoDB
org.geysermc.databaseutils.exists.ExistsTests ‑ MySQL
org.geysermc.databaseutils.exists.ExistsTests ‑ Oracle Database
org.geysermc.databaseutils.exists.ExistsTests ‑ PostgreSQL
org.geysermc.databaseutils.exists.ExistsTests ‑ SQL Server
org.geysermc.databaseutils.exists.ExistsTests ‑ SQLite
org.geysermc.databaseutils.insert.InsertTests ‑ H2
org.geysermc.databaseutils.insert.InsertTests ‑ MariaDB
org.geysermc.databaseutils.insert.InsertTests ‑ MongoDB
org.geysermc.databaseutils.insert.InsertTests ‑ MySQL
org.geysermc.databaseutils.insert.InsertTests ‑ Oracle Database
org.geysermc.databaseutils.insert.InsertTests ‑ PostgreSQL
org.geysermc.databaseutils.insert.InsertTests ‑ SQL Server
org.geysermc.databaseutils.insert.InsertTests ‑ SQLite
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [10] input=findOrderByUsername, variables=[username], action=find, projection=null, byFactors=null, orderByFactors=[VariableOrderByFactor[columnName=username, direction=ASCENDING]]
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [10] input=findOrderByUsernameAscOrPassword, variables=[username, password], action=find, projection=null, byFactors=null, orderByFactors=[VariableOrderByFactor[columnName=username, direction=ASCENDING], org.geysermc.databaseutils.processor.query.section.factor.OrFactor@23471f48, VariableOrderByFactor[columnName=password, direction=ASCENDING]]
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [11] input=findByUsernameOrderByUsernameAndPassword, variables=[username, password], action=find, projection=null, byFactors=[VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=[VariableOrderByFactor[columnName=username, direction=ASCENDING], org.geysermc.databaseutils.processor.query.section.factor.AndFactor@51617b93, VariableOrderByFactor[columnName=password, direction=ASCENDING]]
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [11] input=findOrderByUsernameAsc, variables=[username], action=find, projection=null, byFactors=null, orderByFactors=[VariableOrderByFactor[columnName=username, direction=ASCENDING]]
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [12] input=findByUsernameOrderByUsername, variables=[username], action=find, projection=null, byFactors=[VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=[VariableOrderByFactor[columnName=username, direction=ASCENDING]]
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [12] input=findByUsernameOrderByUsernameAscOrPasswordDesc, variables=[username, password], action=find, projection=null, byFactors=[VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=[VariableOrderByFactor[columnName=username, direction=ASCENDING], org.geysermc.databaseutils.processor.query.section.factor.OrFactor@23471f48, VariableOrderByFactor[columnName=password, direction=DESCENDING]]
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [13] input=findByUniqueIdLessThanOrUsernameOrderByUniqueIdAndPingDesc, variables=[uniqueId, username, ping], action=find, projection=null, byFactors=[VariableByFactor[columnName=uniqueId, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.LessThanKeyword@1], org.geysermc.databaseutils.processor.query.section.factor.OrFactor@23471f48, VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=[VariableOrderByFactor[columnName=uniqueId, direction=ASCENDING], org.geysermc.databaseutils.processor.query.section.factor.AndFactor@51617b93, VariableOrderByFactor[columnName=ping, direction=DESCENDING]]
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [13] input=findByUsernameOrderByUsernameAsc, variables=[username], action=find, projection=null, byFactors=[VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=[VariableOrderByFactor[columnName=username, direction=ASCENDING]]
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [14] input=findByUsernameOrderByUsernameDesc, variables=[username], action=find, projection=null, byFactors=[VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=[VariableOrderByFactor[columnName=username, direction=DESCENDING]]
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [15] input=findByUniqueIdOrderByUsername, variables=[uniqueId, username], action=find, projection=null, byFactors=[VariableByFactor[columnName=uniqueId, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=[VariableOrderByFactor[columnName=username, direction=ASCENDING]]
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [16] input=findByUsernameLessThanOrderByUniqueId, variables=[username, uniqueId], action=find, projection=null, byFactors=[VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.LessThanKeyword@1]], orderByFactors=[VariableOrderByFactor[columnName=uniqueId, direction=ASCENDING]]
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [17] input=findByUniqueIdLessThanOrderByUniqueId, variables=[uniqueId], action=find, projection=null, byFactors=[VariableByFactor[columnName=uniqueId, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.LessThanKeyword@1]], orderByFactors=[VariableOrderByFactor[columnName=uniqueId, direction=ASCENDING]]
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [1] input=findTop3DistinctTitle, variables=[title], action=find, projection=[ProjectionFactor[keyword=org.geysermc.databaseutils.processor.query.section.projection.keyword.TopProjectionKeyword@d3b026d0, columnName=null], ProjectionFactor[keyword=org.geysermc.databaseutils.processor.query.section.projection.keyword.DistinctProjectionKeyword@150f933b, columnName=null], ProjectionFactor[keyword=null, columnName=title]], byFactors=null, orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [1] input=update, variables=[], action=update, projection=null, byFactors=null, orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [2] input=find, variables=[], action=find, projection=null, byFactors=null, orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [2] input=findByUsernameAndPassword, variables=[username, password], action=find, projection=null, byFactors=[VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1], org.geysermc.databaseutils.processor.query.section.factor.AndFactor@51617b93, VariableByFactor[columnName=password, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [3] input=findByUniqueIdAndPassword, variables=[uniqueId, password], action=find, projection=null, byFactors=[VariableByFactor[columnName=uniqueId, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1], org.geysermc.databaseutils.processor.query.section.factor.AndFactor@51617b93, VariableByFactor[columnName=password, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [3] input=findTitle, variables=[title], action=find, projection=[ProjectionFactor[keyword=null, columnName=title]], byFactors=null, orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [4] input=findByUniqueIdAndUniqueName, variables=[uniqueId, uniqueName], action=find, projection=null, byFactors=[VariableByFactor[columnName=uniqueId, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1], org.geysermc.databaseutils.processor.query.section.factor.AndFactor@51617b93, VariableByFactor[columnName=uniqueName, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [4] input=findTop3Title, variables=[title], action=find, projection=[ProjectionFactor[keyword=org.geysermc.databaseutils.processor.query.section.projection.keyword.TopProjectionKeyword@d3b026d0, columnName=null], ProjectionFactor[keyword=null, columnName=title]], byFactors=null, orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [5] input=findByUsernameLessThanAndPassword, variables=[username, password], action=find, projection=null, byFactors=[VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.LessThanKeyword@1], org.geysermc.databaseutils.processor.query.section.factor.AndFactor@51617b93, VariableByFactor[columnName=password, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [5] input=updateByUsername, variables=[username], action=update, projection=null, byFactors=[VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [6] input=findByUniqueIdLessThanOrMyHash, variables=[uniqueId, myHash], action=find, projection=null, byFactors=[VariableByFactor[columnName=uniqueId, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.LessThanKeyword@1], org.geysermc.databaseutils.processor.query.section.factor.OrFactor@23471f48, VariableByFactor[columnName=myHash, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [6] input=findByUsername, variables=[username], action=find, projection=null, byFactors=[VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [7] input=findByUniqueId, variables=[uniqueId], action=find, projection=null, byFactors=[VariableByFactor[columnName=uniqueId, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [7] input=findTop3TitleByUsername, variables=[title, username], action=find, projection=[ProjectionFactor[keyword=org.geysermc.databaseutils.processor.query.section.projection.keyword.TopProjectionKeyword@d3b026d0, columnName=null], ProjectionFactor[keyword=null, columnName=title]], byFactors=[VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [8] input=findByUsernameLessThan, variables=[username], action=find, projection=null, byFactors=[VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.LessThanKeyword@1]], orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [8] input=findTop3DistinctTitleByUsernameAndPassword, variables=[title, username, password], action=find, projection=[ProjectionFactor[keyword=org.geysermc.databaseutils.processor.query.section.projection.keyword.TopProjectionKeyword@d3b026d0, columnName=null], ProjectionFactor[keyword=org.geysermc.databaseutils.processor.query.section.projection.keyword.DistinctProjectionKeyword@150f933b, columnName=null], ProjectionFactor[keyword=null, columnName=title]], byFactors=[VariableByFactor[columnName=username, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1], org.geysermc.databaseutils.processor.query.section.factor.AndFactor@51617b93, VariableByFactor[columnName=password, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.EqualsKeyword@1]], orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [9] input=findByUniqueIdLessThan, variables=[uniqueId], action=find, projection=null, byFactors=[VariableByFactor[columnName=uniqueId, keyword=org.geysermc.databaseutils.processor.query.section.by.keyword.LessThanKeyword@1]], orderByFactors=null
org.geysermc.databaseutils.processor.query.KeywordsReaderTests ‑ [9] input=findOrderByUsernameOrEmail, variables=[username, email], action=find, projection=null, byFactors=null, orderByFactors=[VariableOrderByFactor[columnName=username, direction=ASCENDING], org.geysermc.databaseutils.processor.query.section.factor.OrFactor@23471f48, VariableOrderByFactor[columnName=email, direction=ASCENDING]]
org.geysermc.databaseutils.update.UpdateTests ‑ H2
org.geysermc.databaseutils.update.UpdateTests ‑ MariaDB
org.geysermc.databaseutils.update.UpdateTests ‑ MongoDB
org.geysermc.databaseutils.update.UpdateTests ‑ MySQL
org.geysermc.databaseutils.update.UpdateTests ‑ Oracle Database
org.geysermc.databaseutils.update.UpdateTests ‑ PostgreSQL
org.geysermc.databaseutils.update.UpdateTests ‑ SQL Server
org.geysermc.databaseutils.update.UpdateTests ‑ SQLite