Comments (3)
Hi @nook24,
I don't believe this is actually possible in the current crate-dbal - we use the underlying DBAL library to get table details:
Here, when getting table information, it only retrieves columns, indexes and foreign keys - no options. I'll look into extending to this, to see if we can retrieve the options of a table alongside the other information.
from crate-dbal.
Hi @nook24 - I've just released version 2.3.0 of the DBAL driver, which contains a feature to retrieve CrateDB specific table options when you retrieve tables from createSchema()
. So your above code would result in something like this:
Array
(
[create_options] => Array
(
)
[sharding_routing_column] => id
[sharding_num_shards] => 6
[partition_columns] => Array
(
[0] => parted
[1] => date
)
[table_options] => Array
(
[codec] => default
[routing.allocation.include] =>
[routing.allocation.require] =>
[routing.allocation.exclude] =>
[routing.allocation.enable] => all
[routing.allocation.total_shards_per_node] => -1
[mapping.total_fields.limit] => 1000
[refresh_interval] => 1000
[translog.flush_threshold_size] => 536870912
[translog.sync_interval] => 5000
[translog.durability] => REQUEST
[blocks.metadata] =>
[blocks.read] =>
[blocks.read_only] =>
[blocks.write] =>
[merge.scheduler.max_thread_count] =>
[merge.scheduler.max_merge_count] =>
[store.type] => fs
[unassigned.node_left.delayed_timeout] => 60000
[write.wait_for_active_shards] => ALL
[warmer.enabled] => 1
[number_of_replicas] => 0-2
[column_policy] => strict
)
)
I'll close this issue now, as I believe it is now resolved. But if you encounter further issues, please don't hesitate to reopen it. 🚀
Thanks again for reporting this!
from crate-dbal.
Works as expected, many thanks :)
from crate-dbal.
Related Issues (20)
- test
- Add compatibility with PHP 8.0 HOT 5
- Add compatibility with Doctrine DBAL 3.x and 4.x HOT 1
- Check if CrateDB DBAL can be used with PostgreSQL PDO instead of CrateDB PDO
- Incompatibility to current doctrine/dbal 2.13.* HOT 2
- Locking dependencies HOT 6
- Update to PHP 8.3
- PHP Fatal error: Uncaught Declaration of `PDOCrateDB::prepare` should be compatible with `PDO::prepare` HOT 2
- Symfony and Laravel not supported any longer HOT 7
- BOOLEAN support for Crate-DBAL HOT 3
- PHP 7 support HOT 2
- UNIQUE handling HOT 2
- Not compatible with 2.3.5 HOT 3
- Latest DBAL v. 0.3.1 not compatible with Crate.io v. 2.3 HOT 1
- Flush functionality HOT 3
- How to define number of shards and replicas? HOT 7
- DBAL 2.10 HOT 1
- upgrade docs build system HOT 5
- How to get column options
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from crate-dbal.