summaryrefslogtreecommitdiff
path: root/odb/relational/mysql
AgeCommit message (Collapse)AuthorFilesLines
2018-05-24Update copyright yearKaren Arutyunov9-9/+9
2017-11-07Get rid of GCC 7 case fall-through warningsBoris Kolpackov1-6/+3
2017-04-06Map string keys to MySQL VARCHAR(128) instead of 255 to support 4-byte UTF-8Boris Kolpackov2-2/+2
This is a backwards-incompatible change in that it may change your schema. To obtain the old behavior you will have to explicitly re-map std::string with the id_type pragma or explicitly specify the database type for each affected id member with the type pragma.
2017-03-27Implement support for mixed auto/0 id assignment in MySQLBoris Kolpackov1-1/+12
Now one can do: odb::nullable<int64_t> id; And then, when used with NO_AUTO_VALUE_ON_ZERO, set the id to NULL to get auto-assignment or to 0 to use 0 as the id.
2017-01-03Update copyright yearBoris Kolpackov9-9/+9
2016-11-27Fix bug in handling section members that require growthBoris Kolpackov2-6/+7
2016-10-26Implement support for mixed auto/manual id assignment in SQLiteBoris Kolpackov1-1/+2
Now one can do: #pragma db id auto odb::nullable<int64_t> id; And then set the id to NULL to get auto-assignment or to the actual value to use a manual id.
2016-05-04Ignore section logic when dealing with container elementsBoris Kolpackov1-1/+5
The container member itself can be in a section.
2015-07-02C++ type mapping support for container elementsasBoris Kolpackov4-26/+41
2015-02-06Update copyrightBoris Kolpackov9-9/+9
2015-02-06Implement join types support in viewsBoris Kolpackov1-0/+13
2015-02-04Implement object loading viewsBoris Kolpackov4-177/+27
See section 10.2 in the manual for details.
2015-01-23Handle SQL name limits in MySQL and SQL ServerBoris Kolpackov1-1/+13
2014-11-25Implement bulk database operation support for Oracle and SQL ServerBoris Kolpackov1-0/+1
2013-12-04Implement on_delete pragma for object pointersBoris Kolpackov1-0/+18
Translates to the ON DELETE SQL clause.
2013-10-15Automatically map C++11 enum classes (strong enums)Boris Kolpackov1-32/+27
2013-09-16Implement summary soft-deletion for composite value typesBoris Kolpackov1-2/+34
2013-09-10Schema versioning support for rest of databaseBoris Kolpackov1-3/+56
2013-08-14Add support for object sectionsBoris Kolpackov2-11/+23
Sections are an optimization mechanism that allows the partitioning of data members of a persistent class into groups that can be separately loaded and/or updated.
2013-04-26Add support for extra database info in primary keyBoris Kolpackov1-1/+1
Use that to handle Oracle sequence name and SQLite lax auto ids.
2013-04-26Add support for table options in changelog, use to handle MySQL engineBoris Kolpackov2-10/+26
2013-04-25Add support for schema version tableBoris Kolpackov1-6/+41
2013-04-10Clean up class order in schema generatorsBoris Kolpackov1-44/+49
2013-04-10Get rid of ALTER TABLE callback since it is the same for all databasesBoris Kolpackov1-2/+2
2013-04-10Use single ALTER TABLE to add foreign keys on pass 2Boris Kolpackov1-30/+66
2013-04-10Generate add/drop foreign key migration statementsBoris Kolpackov1-192/+237
Also add the --fkeys-deferrable-mode option. General schemas generation rework.
2013-04-10Explicitly specify NULL for nullable columns in generated schemaBoris Kolpackov1-23/+0
2013-04-10Generate alter column migration statementsBoris Kolpackov1-0/+12
2013-04-10Generate add/drop index migration statementsBoris Kolpackov1-0/+15
2013-04-10Generate add/drop table migration statementsBoris Kolpackov1-29/+59
2013-02-09Update copyright yearBoris Kolpackov9-9/+9
2013-02-07Use multi-pass table creation in MySQLBoris Kolpackov1-25/+204
This deals with table creation order and circular dependencies. Unfortunately, there doesn't seem to be a way in MySQL to drop a foreign key only if it exists without resorting to stored procedures.
2013-01-24Add support for mapping char[N] to CHAR/VARCHAR database typesBoris Kolpackov2-4/+35
Also improve query support for arrays (decaying).
2013-01-14Add support for MSSQL ROWVERSIONBoris Kolpackov1-6/+6
ODB can now use ROWVERSION column as an optimistic concurrency version.
2012-12-12Add support for SQL name transformationsBoris Kolpackov2-12/+2
2012-11-21Add dynamic multi-database query supportBoris Kolpackov1-1/+1
2012-11-20Merge branch '2.1'Boris Kolpackov1-0/+6
2012-11-20Ignore polymorphic id reference when generating grow()2.1.12.1Boris Kolpackov1-0/+6
2012-10-08Ground work for multi-database supportBoris Kolpackov2-2/+3
All generated code now includes database id. The database-specific database class interface has been updated to include all the database operations. The database-specific tests now use this interface.
2012-09-04NULL handling improvementsBoris Kolpackov1-21/+23
Add support for specifying NULL-ness for types with built-in mapping. Handle Oracle [N]VARCHAR2 and SQLite FLOAT oddities using this mechanism instead of overriding it at the schema generation level. Also use the is_null argument that is passed to value_traits::init_image() to indicate whether the value can be NULL.
2012-07-27Add support for defining indexesBoris Kolpackov1-0/+30
New db pragma qualifier: index. New tests: common/index, mysql/index, pgsql/index.
2012-07-27Move indexes from model scope to table scopeBoris Kolpackov1-14/+0
Conceptually, indexes belong to tables and some databases (MySQL, MSSQL) indeed treat them as such (i.e., you can have indexes with the same name in different tables).
2012-07-10Add support for custom database type mappingBoris Kolpackov4-59/+128
New pragma qualifier, map, and specifiers: as, to, from. New tests: <database>/custom.
2012-04-27Add support for NULL pointers to objects with composite object idsBoris Kolpackov1-0/+43
2012-04-23Polymorphic inheritance supportBoris Kolpackov3-124/+15
2012-03-07Use RAII to free select statement resultsBoris Kolpackov1-0/+1
2012-02-22Add support for composite object idsBoris Kolpackov6-526/+82
New pragma id_type (member). New test: common/composite-id. The composite example has also been updated.
2012-01-29Update copyright yearBoris Kolpackov8-8/+8
2012-01-29Remove author field from file headerBoris Kolpackov8-8/+0
Too much effort to maintain.
2012-01-26Implement support for database schemaBoris Kolpackov3-9/+38
New pragma qualifier: namespace. New pragma specifier: schema. The table specifier was extended to accept a schema prefix. New option: --default- schema. The common/schema test was extended to cover the new functionality.