I have a process that takes yaml files describing DB tables (actually they’re all views), keeps track of changes and drop/create the table when the file changes. It’s the kind of thing that would normally be done with something like Flyway but wasn’t for a couple of reasons:
- Flyway doesn’t support the database being used
- We only create views, the process doesn’t deal with data
- The current system doesn’t support the “traditional” migration. If we want to add a column to a view we just update the original file which is fine for our use.
The current system looks like this:
resources/tables/ contains yaml files like this:
table: table_name schema: |- id int, name string, age int
Along with each
yaml file is a
md5 file that contains the md5 value for the last “version” that was created. The script proceeds like this:
- Get the md5 of all the yaml files and compare with the value in their associated .md5 file.
- For all modified files:
- Use the schema from the file and run
CREATE TABLE ...
- Calculate the new md5 and update the related
I’ve started planning the classes and what they’re role is going to be but I’m getting stuck in details. The classes so far:
TableSchema: Mostly a data object. A yaml file is read and becomes a
TableUpdater: Entry point of the entire thing. I think right now this is doing a bit too much. It looks at the
resources/tables/ and turns each file into a
Should there be a class responsible for reading the yaml files and returning
Any guidance on the structure of this project would be great. Thanks!
✓ Extra quality
ExtraProxies brings the best proxy quality for you with our private and reliable proxies
✓ Extra anonymity
Top level of anonymity and 100% safe proxies – this is what you get with every proxy package
✓ Extra speed
1,ooo mb/s proxy servers speed – we are way better than others – just enjoy our proxies!
USA proxy location
We offer premium quality USA private proxies – the most essential proxies you can ever want from USA
Our proxies have TOP level of anonymity + Elite quality, so you are always safe and secure with your proxies
Use your proxies as much as you want – we have no limits for data transfer and bandwidth, unlimited usage!
Superb fast proxy servers with 1,000 mb/s speed – sit back and enjoy your lightning fast private proxies!
99,9% servers uptime
Alive and working proxies all the time – we are taking care of our servers so you can use them without any problems
No usage restrictions
You have freedom to use your proxies with every software, browser or website you want without restrictions
Perfect for SEO
We are 100% friendly with all SEO tasks as well as internet marketing – feel the power with our proxies
Buy more proxies and get better price – we offer various proxy packages with great deals and discounts
We are working 24/7 to bring the best proxy experience for you – we are glad to help and assist you!