luizdamim
Change table name (source) to uppercase on MySQL/MariaDB
Is it possible to change the table name (source) of an Ecto schema based on the Repo or the Adapter?
I need to connect to two databases, a PostgreSQL and a MySQL.
Tables on the MySQL server were created with uppercase names, so for example when querying all users, the generated SQL (SELECT ... FROM `users` ) works on PostgreSQL but gives an error on MySQL as the table doesn’t exist, it exists as USERS.
Both are beyond my control, I don’t have permission to change either config. If I had access to the database I could change the config allowing case insensivity (https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html).
Marked As Solved
benwilson512
You can from u in {"users", User} and from u in {"USERS", User} where the first item is the table name and the second is the schema to cast to.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Enabling companies to succeed by building software people love.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"