Skip to content
Flavio Lionel Rita edited this page Aug 19, 2022 · 1 revision

labs

Lab northwind

In this laboratory we will see:

Creating the northwind sample database tables and loading it with sample data. This database presents several non-standard cases such as: - Name of tables and fields with spaces - Tables with composite primary keys - Tables with auto-numeric ids and others with ids strings

Since this is the database that was used for many examples and unit tests, you can test the example queries that are in the documentation. We will also see some example queries to execute from CLI

source code

Lab 01

In this laboratory we will see:

  • How to use the Lambdaorm-cli commands
  • how to create a project that uses lambda ORM
  • How to define a schema
  • how to run a bulkInsert from a file
  • how to export data from a schema
  • how to import data into a schema from a previously generated export file

source code

Schema:

schema

Lab 02

In this laboratory we will see:

  • how to create a project that uses lambda ORM
  • How to define a schema
  • how to extend entities using abstract entities
  • How to insert data from a file.
  • how to run queries from cli to perform different types of queries

source code

Schema:

schema

Lab 03

In this laboratory we will see:

  • How to insert data from a file to more than one table.
  • how to extend entities using abstract entities
  • how to extend a schema to create a new one, overwriting the mapping
  • how to work with two schemas and databases that share the same model
  • how to use imported data from one database to import it into another

source code

Schema:

schema

Lab 04

In this laboratory we will see:

  • How to insert data from a file to more than one table.
  • how to extend entities using abstract entities
  • how to define a schema that works with entities in different databases
  • how to run a bulkInsert on entities in different databases
  • how to export and import entity data in different databases

source code

Schema:

schema

Clone this wiki locally