Hi there, I need to load another cfconfig file (aside from server and web) on server startup. I am looking at the possibility of using the

scripts:onServerStart

But doing the following to debug and see exactly when they are triggered doesnt seem to do any output:

"scripts":{
        "preServerStart":"echo '---------preServerStart'",
        "onServerStart":"echo '---------onServerStart'",
        "onServerInstall":"echo '---------onServerInstall'",
        "onServerStop":"echo '---------onServerStop'",
        "preServerForget":"echo '---------preServerForget'",
        "postServerForget":"echo '---------postServerForget'"
    }

When I do

server start --debug

@Mark Drew (he/him) Did you put those in your

box.json

or your

server.json

?

server.json

What version of CommandBox are you on?

I am just checking. 5.5.something

Ok, because server scripts was added in 5.5.0

• allow a comma-delimited list of files in the

server.json

• allow a file glob which could match multiple files

I like either or both of those options!

And FWIW, the existing CFConfig interceptor listens to

onServerInstall

OK, I think it was my local (non docker/prod/actualdev) environment

FWIW, the scripts work for me

does server.json:cfconfig.web allow comma delimted or globbing patterns already or as feature request?

It would be a feature request

upgrading fixed it locally 🙂

if( serverJSON.keyExists( 'web' ) && serverJSON.web.keyExists( 'rules' ) ) {
			if( !isArray( serverJSON.web.rules ) ) {
				throw( message="'rules' key in your server.json must be an array of strings.", type="commandException" );
			}
			serverInfo.webRules.append( serverJSON.web.rules, true);
		}
		if( serverJSON.keyExists( 'web' ) && serverJSON.web.keyExists( 'rulesFile' ) ) {
			if( isSimpleValue( serverJSON.web.rulesFile ) ) {
				serverJSON.web.rulesFile = serverJSON.web.rulesFile.listToArray();
			}
			serverInfo.webRules.append( serverJSON.web.rulesFile.reduce((predicates,fg)=>{
				fg = fileSystemUtil.resolvePath( fg, defaultServerConfigFileDirectory );
				return predicates.append( wirebox.getInstance( 'Globber' ).setPattern( fg ).matches().reduce( (predicates,file)=>{
						if( lCase( file ).endsWith( '.json' ) ) {
							return predicates.append( deserializeJSON( fileRead( file ) ), true );
						} else {
							return predicates.append( fileRead( file ).listToArray( chr(13)&chr(10) ), true );
						}
					}, [] ), true );
			}, []), true );
		}
		if( defaults.keyExists( 'web' ) && defaults.web.keyExists( 'rules' ) ) {
			serverInfo.webRules.append( defaults.web.rules, true);
		}

		if( defaults.keyExists( 'web' ) && defaults.web.keyExists( 'rulesFile' ) ) {
			var defaultsRulesFile = defaults.web.rulesFile;
			if( isSimpleValue( defaultsRulesFile ) ) {
				defaultsRulesFile = defaultsRulesFile.listToArray();
			}
			serverInfo.webRules.append( defaultsRulesFile.reduce((predicates,fg)=>{
				fg = fileSystemUtil.resolvePath( fg, defaultwebroot );
				return predicates.append( wirebox.getInstance( 'Globber' ).setPattern( fg ).matches().reduce( (predicates,file)=>{
						if( lCase( file ).endsWith( '.json' ) ) {
							return predicates.append( deserializeJSON( fileRead( file ) ), true );
						} else {
							return predicates.append( fileRead( file ).listToArray( chr(13)&chr(10) ), true );
						}
					}, [] ), true );
			}, []), true);
		}

☝️ All that just to allow for a server.json or server defaults list of file globbing patterns

Now to see how to add that file under certain conditions

I wasn't keen to write all that again for CFConfig files so I just kept it simple, lol

I think the issue I am trying to fix (maybe context helps) is that I have a massive config file (as we do) but for one environment (and one environment only) I need to overwrite a datasource

So, for example, you could set both

cfconfigfile
cfconfigserver

env vars and set both

cfconfigFile 
cfconfig.file

in the

server.json

and basically get 4 files imported right there!

I am using cfconfig.web if that is what you mean?

No, that's a different setting that goes into the web context. There aren't as many ones that go there, but you could set the

cfconfigweb

env var and use

cfconfig.web

in your

server.json

and the would both get loaded

I think the issue here would be othe order

As far as your specific use case-- it's worth noting, CFConfig will never remove a datasource. it will only add additional datasources on top of the existing ones

Cos that's the issue there for me 😕

So I'm not sure if any of these options actually work for you

Would it replace a datasource?

You could toss in a

cfconfig datasource remove

command, but the issue would be getting it to run at the right time (after the cfconfig imports, not before)

.cfconfig-web.json <- has all settings and datasources including "bob" .cfconfig-bob.json <- only has the bob datasource

So cfconfigweb loaded first and then cfconfig.web ?

Um, that's not necessarily a documented behavior, but glancing at the code, it seems we check env vars prior to JSON files.

Makes sense. I feared that was the case.

because I thought you were doing the former, but your last example with bob seems the opposite

I have a bob datasrouce to Microsoft SQL, in localdev we want bob datasource to use MSQL

So you still want a datasource named bob, you just want it to use a different type?

Yarp!

Exactly how many bits of bob are different?

Ahh, you mean using env variables to replace it? I think rather a lot, but going to check now

well hold on, I have two specific suggestions, but I want to understand just how much is different between prod and dev first before I present them

DM'ing you the diff.

I just need to know what keys are different

There are a few differences, as in one we have username, password and in the other we dont

Ok, so here are three possible (and fairly similiar) approaches. The first is to make the actual JSON have placeholders for everything that may be different

"password":"${DB_PASSWORD}",
"class":"${DB_CLASS}",
"dbdriver":"${DB_DBDRIVER}",
etc...

Then provide the proper env vars in each environment. The second option is to override the individual bits with env vars like so:

cfconfig_datasources_bob_password=myPass
cfconfig_datasources_bob_class=my.class
cfconfig_datasources_bob_dbdriver=MySQL
etc...

The third option is the same as above, but do it with one big env var that simply contains JSON

cfconfig_datasources_bob={"password":"myPass","class=":"my.class","dbdriver":"MySQL",etc..}

escaping as necessary based on how/where you set that

I think I like option 1 as that is how we do everything else.

Yep, really the best flow will just depend on how your team is used to dealing with this stuff

Basically I am rationalising a bunch of configs into one

@Mark Drew (he/him) sorry for jumping into the discussion late. I noticed you wanted to use MySQL locally due to cost of MS SQL. In case you weren't aware, there is a free Developer Edition of MS SQL you can run locally for dev/testing (and it has all of the functionality of MS SQL Enterprise Edition). You don't have to buy a seat to develop locally. You can also install MS SQL Express (also free) which has pretty much the same functionality as MS SQL Standard Edition, but it has resource limits (size of database, 1 CPU thread, etc.). Just thought I'd throw that out there.

@cfvonner I was actually just making up a scenario, it's more about using another database that takes too long to setup for local development. 🙂