Issue: Persist Generates DB Client Before Pulling Dependencies

[chathushkaayash]

Description

Issue Description

When building a Ballerina project with the persist module, the build process attempts to generate the database client (persist(generate-db-client)) before pulling dependencies. This causes following errors when dependencies like ballerinax/persist.sql are missing, especially on systems or environments without a cache (e.g., Choreo deployments).

Executing Build Tools
        persist(generate-db-client)
ERROR [Ballerina.toml:(1:1,22:1)] unexpected error occurred while generating the client
the model definition file(model.bal) has errors.
ERROR [model.bal:(3:1,3:31)] cannot resolve module ballerinax/persist.sql as sql
ERROR [model.bal:(6:5,6:19)] undefined annotation Generated
ERROR [model.bal:(6:5,6:19)] undefined module sql
ERROR [model.bal:(29:5,29:19)] undefined annotation Generated
ERROR [model.bal:(29:5,29:19)] undefined module sql

Steps to Reproduce

Steps to Reproduce

1. Clear the Ballerina cache

2. Create a new Ballerina project:

   • Initialize the project using the following command:

     bal new persist-sample

   • Navigate to the project directory:

     cd persist-sample

3. Initialize Ballerina Persist:

   • Run the following command to add Persist to the project:

     bal persist init

4. Add a model.bal file with the following content:

   import ballerina/persist as _;
   import ballerina/time;
   import ballerinax/persist.sql;
   
   type User record {|  
       @sql:Generated  
       readonly int id;  
       string name;  
       string email;  
       string password;  
       string number;  
       string profilePic;  
       string role;  
       string status;  
   
       time:Civil? lastLogin;  
   
       time:Civil createdAt;  
       time:Civil updatedAt;  
       time:Civil? deletedAt;  
   |};
   

5. Run the build command:

   bal build
   
   

Version

Ballerina version: 2201.10.2

Environment Details (with versions)

Ballerina version: 2201.10.2
OS: Windows