The CEO wears many hats at a start up so he'll be assigned to multiple teams. Then, I'll assign the employees to two teams: engineering and sales. Now, I'm going to populate the database with a few employees here at DoltHub. If you want system to generate a Dolt commit for every transaction use the system variable, Insert some data In this case, I am running the database with AUTOCOMMIT on, so each SQL statement is automatically generating a transaction COMMIT. Note, a Dolt commit is different than a standard SQL transaction COMMIT.
Your schema is created and you have a Dolt commit tracking the creation, as seen in the dolt_log system table. | vluuhvd0bn59598utedt77ed9q5okbcb | Tim Sehn | | 16:33:59.531 | Initialize data repository | | ne182jemgrlm8jnjmoubfqsstlfi1s98 | Tim Sehn | | 16:35:49.277 | Created initial schema | | commit_hash | committer | email | date | message |
Mysql> call dolt_commit('-m', 'Created initial schema') Mysql> call dolt_add('teams', 'employees', 'employees_teams') So, we add and commit our new schema like so. If you know Git, the version control procedures and system tables should feel familiar. For named arguments like sending a message into the dolt_commit command use two arguments in sequence like ('-m', 'This is a message'). For instance, to specify tables to add, send the table names in as options to the dolt_add procedure. Passing options also follows the command line model. So dolt add on the CLI becomes dolt_add as a stored procedure. The naming of the system tables and stored procedures follows the dolt_ pattern. In SQL, Dolt exposes version control read operations as system tables and version control write operations as stored procedures. On the command line, Dolt commands map exactly to their Git equivalent with the targets being tables instead of files. Make a Dolt commit whenever you want to restore or compare to this point in time.ĭolt exposes version control functionality through a Git-style interface. A Dolt commit allows you to time travel and see lineage.
It's time to use your first Dolt feature. It's a modern, feature-rich SQL database. Foreign key (team_id) references teams(id),įoreign key (employee_id) references employees(id)) ĭolt supports foreign keys, secondary indexes, triggers, check constraints, and stored procedures.
0 kommentar(er)
