https://www.prisma.io/ logo
Join Slack
Powered by
I tried the same thing in mysql and similarly coul...
# orm-help
a
I tried the same thing in mysql and similarly could only find the following:
Copy code
mysql> show tables;
+-------------------+
| Tables_in_prisma  |
+-------------------+
| InternalMigration |
| Migration         |
| Project           |
| TelemetryInfo     |
+-------------------+
4 rows in set (0.00 sec)
n
did you run 
prisma deploy
?
a
Yes I did :) I can even see the migrations in the database but not the data itself
Oh and I can confirm that a query for all the Speaker objects does return a list of the ones I inserted :)
n
what's the endpoint property in prisma.yml?
a
endpoint: <http://localhost:4466>
n
and, you're using MySQL?
a
yes
n
In your output, you are in the "prisma" database. You need to change to the "default$default" database for the endpoint you shared
a
The first one you mean?
n
Then you'll see a Speaker table, for example.
a
aha!
Is this described somewhere in your docs?
n
I don't think so 🙂 we should definitely add this information, could you please open a new issue for this here: https://github.com/prismagraphql/prisma
a
👍
🙏 1
And just to be a pain in the ass, what is the corresponding thing for postgres? 😛
n
postgres has an additional hierarchy level, but the rest stays the same
a
Copy code
root@34b174250836:/# psql -U prisma -l
                                 List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges
-----------+----------+----------+------------+------------+-----------------------
 postgres  | postgres | UTF8     | en_US.utf8 | en_US.utf8 |
 prisma    | postgres | UTF8     | en_US.utf8 | en_US.utf8 |
 template0 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
none of them have any relations ;o
Open in Slack
PreviousNext
Powered by