Hi, what it's the most simple way to clear local database? (graphcool on local docker)

@fabien0102 You can access the underlying mysql database .. https://www.graph.cool/docs/reference/deployment/database-access-eif6eing5o

Fair enough, it was my first idea 😉

graphcool local stop

followed by

docker volume prune

will completely reset your local environment

Nice! I prefer this solution 🙂

Not a docker expert.. but what I do is connect to the container on on port 3306 and delete all tables I care about for more rapid experimentation.. but @agartha’s solution is probably cleaner

To just clear data for a single service, yours is probably easier.

@steve if you have a sql command to erase all the tables in one command, I take it (it should be quicker to reset)

I try to stay away from direct database manipulation. For one, you won't clear the functions container.

@agartha It was my thought, it's why I ask in this channel ^^

@agartha is right.. learned this the hard way. But when i'm just trying to figure something out and need a tight feedback loop I clear the tables I know about by name as they are the same name as your types

I use different local clusters for different services, so I can always safely use my method without destroying other locally deployed services. It's quite an overhead though, so it's not ideal either...

But maybe it exists a command to reset a docker container?

The

prune

command above will do that

@steve you are right, when you didn't make any changes to your service or schema and just want to reset the data, your method is perfectly safe.

Perfect, now I know how to reset all, I can try all your methods 😉

@fabien0102 here is a quick script i threw together.. you will need to pass it the tables name you want to delete and the project id (you'll need to modify it to fit your needs) ..

import mysql from 'mysql';
import projectId from '../tests/utils/projectId';

const createDbConnection = projectId => mysql.createConnection(
    {
        host     : 'localhost',
        port     :  3306,
        user     : 'root',
        password : 'graphcool',
        database : projectId
    }
);

const clearTables = (connection, tables) => {
    const query = (query) => new Promise(
        (resolve, reject) => {
            connection.query(query, (err, results) => (
                ((err && reject(err) && false) ||
                resolve(results))
            ))
        }
    )
    return Promise.all(tables.map(t => query(`delete from ${t};`)));  
};

export default (tables) => {
    const conn = createDbConnection(projectId());
    tables = [].concat(tables);
    conn.connect();
    return clearTables(conn, tables).then(()=>new Promise((res)=> conn.end(res)))
};

It can be useful to add the reset snippet to the doc btw

That's on the roadmap for 1.0: https://github.com/graphcool/framework/issues/1330

data import 😮

Current proposal here: https://github.com/graphcool/framework/issues/1299

Nice, I really need to read all this issues, many cool stuff on it 🙂

Especially everything marked as 1.0. Everyone's feedback is valuable

Noted 😉

https://github.com/graphcool/framework/pull/1318 is a great entry point into what's going on currently 🙂