schizoduckie / createreadupdatedelete.js Goto Github PK

Hello SchizoDuckie,

I need to alter a table and fire a one time function after the migration.
Is this possible?

Kind regards,
Mario

Hi, are you interested in publish this library into npm? That would be easier to manage it.

Hello SchizoDuckie,

Question: Should this work?
It works in your demo: http://jsfiddle.net/SchizoDuckie/p7kta1mv/
But I am not sure this is old source.
But I get CRUD.FindCount is not a function (tried in and out quotes)

CRUD.FindCount('Food').then(function(count) {
    total.innerHTML = count;  
});

Kind regards,
Mario

Hello SchizoDuckie,

The following code works fine on Chrome but not on the mobile:
Any idea where to look for?

        Object.observe(CRUD.stats, function(newValues) {
           progress.innerHTML = Math.floor((CRUD.stats.writesExecuted / CRUD.stats.writesQueued) * 100);
           writesQueued.innerHTML = CRUD.stats.writesQueued;
           writesExecuted.innerHTML = CRUD.stats.writesExecuted; 
            if(CRUD.stats.writesQueued == CRUD.stats.writesExecuted) {
                updateCount();
            }
        });

Kind regards,
Mario

Hi, your gh-pages branch don't have any .html file, so it's broken. Could you please, fix it?

I could access your docs and demo with /demo and /docs btw
Cheers

Hello SchizoDuckie,

I tried it but CRUD.Find does not seem to support: WHERE column_name IN (value1,value2,...)

If it should please tell me how and if not do we have a workaround?

Kind regards,
Mario

Hello SchizoDuckie,

I am building a table and fill it with data.
I am running into problems when I run these 2 actions in serie because sometimes the table is not build when I want to insert the data.
Can I get a completed trigger when a table is build?

Kind regards,
Mario

Hello SchizoDuckie,

Our present project is a sharepoint mobile extension with which we use the SharePoint API to sync the data from and to remote.
For another project we are free to choose a remote server sync. Do you have experience and can advise a solution that works good and can scale up to large data traffic?

Kind regards,
Mario

Hello CRUD team,

When calling the database with the basic code below I get this alert: ERROR TypeError: Cannot read property 'onConnect' of undefined
Everthing else seems to work fine.

window.dbAdapter = new CRUD.SQLiteAdapter('mydatabase.sqlite');

Please advise.
Kind regards,
Mario

Is there a way to set and retrieve additional attributes on a join/connector table?

Hello SchizoDuckie,

Tried everything I can think of but cannot get migration to work.
Can you advise on the code below?

I get error code:
message: "could not prepare statement (1 table challengestest has no column named description)"

    function ChallengesTest() {
        CRUD.Entity.call(this);
    }

    CRUD.define(ChallengesTest, {
        className: 'ChallengesTest',
        table: 'challengestest',
        primary: 'ID_Challenge',
        fields: [
            'ID_Challenge',
            'title',
            'description'
        ],
        orderProperty: 'startDate',
        orderDirection: 'DESC',
        indexes: [
            'title'
        ],
        createStatement: 'CREATE TABLE challengestest (ID_Challenge TEXT PRIMARY KEY, title TEXT, description TEXT)',
        migrations: {
            1: [
                'ALTER TABLE challengestest RENAME TO challengestest_bak',
                'CREATE TABLE challengestest (ID_Challenge TEXT PRIMARY KEY, title TEXT)',
                'INSERT OR IGNORE INTO challengestest (ID_Challenge, title) select ID_Challenge, title from challengestest_bak',
                'DROP TABLE challengestest_bak'
            ]
        },
        relations: [],
        fixtures: [{
            ID_Challenge:'CH13',
            title:'PUSH-UP'
        }]
    }, {});

    CRUD.DEBUG = true;

    CRUD.setAdapter(new CRUD.SQLiteAdapter('MyPTtest', { 
      estimatedSize: 25 * 1024 * 1024 
    }));

    function addItem(){
        var ChallengesTestItem = new ChallengesTest();
        ChallengesTestItem.title = 'Arrow';
        ChallengesTestItem.description = 'description';

        ChallengesTestItem.Persist().then(function(result) {
            console.log("ChallengesTestItem persisted! ", result);
        });
    }

Hello SchizoDuckie,

(Hope this is a Crud question:-)
I want to read x fields from table1 and y fields from a related table 2 (1 on 1)
(And as a result show them in a table.)
How do we do this the crud way?

Kind regards,
Mario

Hello SchizoDuckie,

Adding a relationship to a table probably modifies the object structure?
I ask because after adding the relationship below function findFood() only returns objects and I don't know how to get inside the objects.
The function findFoodFav = the related table and also only return an [object Object]

function findFood(){
    CRUD.Find('Food', {}, { limit: '0,10000' }).then(function(results) {
        return results.map(function(entity) {return entity.asObject()})
        }).then(function(result){
            console.log(JSON.stringify("Food: "+result));
    });
}

function findFoodFav(){     
    CRUD.FindOne('Food', { ID_Food: 3}).then(function(food) {
        food.Find('FoodFav').then(function(foodfav) {
            console.log("FoodFav: "+foodfav);
        });
    });
}

Can you advise?

Kind regards,
Mario