Content

New in version 15.0.0

You can find information about existing projects upgrading in the article Upgrade project.

• New features

  • High level abstraction features for working with databases

• Added

  • 4446 unit tests.
  • CDateTime can now be initialized both with local and UTC time depending on boolean constructor parameter local_time. It also got 3 new methods to convert to string: asDateString(), asDateTimeString() and asTimeString().
  • DbDate structure has got four more comparison operators >, >=, <, <=.
  • DbTime structure has got four more comparison operators >, >=, <, <=.
  • DbDateTime structure has got four more comparison operators >, >=, <, <=. It has also got assignment (=) operators and a few constructors.
  • Feature handling methods to IApplication and all its implementations.
  • Query builder and migration handling methods to IDb and all its implementations.
  • IFeature interface and CFeature base class.
  • TDbActiveQuery template class to work with Active Record models.
  • TDbActiveRecord template class supposed to be a base class for Active Record models.
  • TDbRelation template class used to add relations to Active Record models.
  • CDbCondition class representing different conditions for query building.
  • CDbDelete class responsible for high level representation of deleting from database operations.
  • CDbInsert class responsible for high level representation of inserting into database operations.
  • CDbUpdate class responsible for high level representation of updating database data operations.
  • CDbQuery class responsible for high level representation of querying from database operations.
  • CDbMigration base class responsible for high level representation of database structure changing operations.
  • CDbMigrationColumn class responsible for high level description of database table column.
  • CDbMigrationKey class responsible for high level description of database table keys and indices.
  • CDbModel base class representing a model (not connected to database).
  • DbOrder enumeration describing sorting order in queries.
  • CDbQueryBuilderMySql class responsible for translation high level query objects into SQL for MySQL/MariaDB database engines.
  • DbSchema helper class providing high level abstraction to fetch some additional information about tables and columns.
  • CDbTransaction helper class providing high level abstraction and simple deal with transactions.
  • CDbValidator base class providing common functionality of validators.
  • IDbActiveRecord interface describing minimum required functionality from Active Record model.
  • IDbAttribute interface describing minimum required functionality from Active Record model attribute.
  • IDbMigration interface describing minimum required functionality from migration.
  • IDbMigrationColumn interface describing minimum required functionality from migration column description.
  • IDbMigrationKey interface describing minimum required functionality from migration key description.
  • IDbQuery interface describing minimum required functionality from high level abstraction of database query.
  • IDbQueryBuilder interface describing minimum required functionality from query builder.
  • IDbRelation interface describing minimum required functionality from Active Record model relation.
  • IDbValidator interface describing minimum required functionality from attribute validator.
  • Following exception classes used in migrations, query builders and active records:
    1. DbExceptionBuildQuery
    2. DbExceptionCreateStatement
    3. DbExceptionExecuteStatement
    4. DbExceptionNoAttributes
    5. DbExceptionNoColumnName
    6. DbExceptionNoConnection
    7. DbExceptionNoQueryBuilder
    8. DbExceptionNoResult
    9. DbExceptionNoStatement
    10. DbExceptionNoTableName
    11. DbExceptionQueryPrimaryKeys
    12. DbExceptionRevertNotImplemented
  • Following aliases used in migrations, query builders and active records:
    1. DbActiveRecordPrimaryKey
    2. DbCondition
    3. DbConditions
    4. DbOrderBy
    5. DbOrderByArray
    6. DbSet
  • Following validators:
    1. CDbValidatorBoolean
    2. CDbValidatorCompare
    3. CDbValidatorDate
    4. CDbValidatorDateTime
    5. CDbValidatorDefault
    6. CDbValidatorEmail
    7. CDbValidatorExists
    8. CDbValidatorMatch
    9. CDbValidatorNumber
    10. CDbValidatorRange
    11. CDbValidatorRequired
    12. CDbValidatorString
    13. CDbValidatorTime
    14. CDbValidatorTrim
    15. CDbValidatorUnique
    16. CDbValidatorUrl
  • Following utility functions to build conditions:
    1. db::Expression()
    2. db::Equals()
    3. db::NotEquals()
    4. db::Greater()
    5. db::GreaterEquals()
    6. db::Less()
    7. db::LessEquals()
    8. db::And()
    9. db::Or()
    10. db::Not()
    11. db::Between()
    12. db::NotBetween()
    13. db::In()
    14. db::NotIn()
    15. db::Like()
    16. db::NotLike()
    17. db::Exists()
    18. db::NotExists()
    19. db::expr()
    20. db::eqcc()
    21. db::eqcv()
    22. db::eqvc()
    23. db::eqvv()
    24. db::eqce()
    25. db::eqec()
    26. db::eqee()
    27. db::eqve()
    28. db::eqev()
    29. db::necc()
    30. db::necv()
    31. db::nevc()
    32. db::nevv()
    33. db::nece()
    34. db::neec()
    35. db::neee()
    36. db::neve()
    37. db::neev()
    38. db::gtcc()
    39. db::gtcv()
    40. db::gtvc()
    41. db::gtvv()
    42. db::gtce()
    43. db::gtec()
    44. db::gtee()
    45. db::gtve()
    46. db::gtev()
    47. db::gecc()
    48. db::gecv()
    49. db::gevc()
    50. db::gevv()
    51. db::gece()
    52. db::geec()
    53. db::geee()
    54. db::geve()
    55. db::geev()
    56. db::lscc()
    57. db::lscv()
    58. db::lsvc()
    59. db::lsvv()
    60. db::lsce()
    61. db::lsec()
    62. db::lsee()
    63. db::lsve()
    64. db::lsev()
    65. db::lecc()
    66. db::lecv()
    67. db::levc()
    68. db::levv()
    69. db::lece()
    70. db::leec()
    71. db::leee()
    72. db::leve()
    73. db::leev()
    74. db::a()
    75. db::o()
    76. db::n()
    77. db::btcсc()
    78. db::btcсv()
    79. db::btcсe()
    80. db::btcvc()
    81. db::btcvv()
    82. db::btcve()
    83. db::btcec()
    84. db::btcev()
    85. db::btcee()
    86. db::btvcc()
    87. db::btvcv()
    88. db::btvce()
    89. db::btvvc()
    90. db::btvvv()
    91. db::btvve()
    92. db::btvec()
    93. db::btvev()
    94. db::btvee()
    95. db::btecc()
    96. db::btecv()
    97. db::btece()
    98. db::btevc()
    99. db::btevv()
    100. db::bteve()
    101. db::bteec()
    102. db::bteev()
    103. db::bteee()
    104. db::nbcсc()
    105. db::nbcсv()
    106. db::nbcсe()
    107. db::nbcvc()
    108. db::nbcvv()
    109. db::nbcve()
    110. db::nbcec()
    111. db::nbcev()
    112. db::nbcee()
    113. db::nbvcc()
    114. db::nbvcv()
    115. db::nbvce()
    116. db::nbvvc()
    117. db::nbvvv()
    118. db::nbvve()
    119. db::nbvec()
    120. db::nbvev()
    121. db::nbvee()
    122. db::nbecc()
    123. db::nbecv()
    124. db::nbece()
    125. db::nbevc()
    126. db::nbevv()
    127. db::nbeve()
    128. db::nbeec()
    129. db::nbeev()
    130. db::nbeee()
    131. db::inc()
    132. db::inv()
    133. db::ine()
    134. db::nic()
    135. db::niv()
    136. db::nie()
    137. db::lkc()
    138. db::lkv()
    139. db::lke()
    140. db::nlc()
    141. db::nlv()
    142. db::nle()
    143. db::ex()
    144. db::ne()

• Fixed

  • Utility number conversion functions StringTo* convert now only entire string and throw exception if string was not converted completely (there are one or more characters left unused in conversion). Similarly, TryStringTo* functions in such a case return false value.

• Improved

  • IReleasable and its implementation in CReleasable class now can handle multiple listeners.
  • ReleasablePtr template has been improved to work with multiple copies referencing the same releasable object. Also new const operators -> and * have been added to the template class.
  • DbValue has got constructors and assignment operators to work with char* and wchar_t* arguments.
  • DbValue has got Convert() method to convert it to a specified value type.

• Removed

  • RegisterReleaseListener() and UnregisterReleaseListener() from IDbConnection interface and all its implementations as that methods are now a part of a base interface.
  • RegisterReleaseListener() and UnregisterReleaseListener() from IDbStatement interface and all its implementations as that methods are now a part of a base interface.