Welcome Guest, Not a member yet? Register   Sign In
CodeExtinguisher 2.0 Release Candidate 14.2

[eluser]gusa[/eluser]
Don't forget to sign here if you use MS SQL Server.

[eluser]edwardmolasses[/eluser]
hi there,

I'm new to code extinguisher and thinking of using it for our system backend. I was wondering though, is it possible to have an edit form for two different tables? We have a lot of tables that are linked by ids and it would be helpful to have the info of both tables editable on the same page. From what i've read in the docs, the general practice seems to be to select only one table for each controller.

I guess if not, we'd just have to use old-fashioned code igniter for those linked tables, but i'm hoping for a code extinguisher shortcut :-)

thanks!

[eluser]Majd Taby[/eluser]
There are three bundled plugins of interest: DbDropDown, ManyToMany, and OneToMany. Look at the bundled example for a template on how to use them.

DbDropDown populates a dropdown with the contents of the other table
ManyToMany sets up a many-to-many relationship between two tables (where many fields in this table can be paired with many fields from the other table)
OneToMany sets up a one-to-many relationship between the two tables (where each field may relate to many fields in the other table, but each record in the other table can be paired with only one record in this table)

You can google the relationships to see how they work.

[eluser]edwardmolasses[/eluser]
dang, forgot to check the plugins. Thank you!

[eluser]trkan[/eluser]
Found a bug.

libraries/codextemplates.php

line55:

inlineCSS function.

instead of ('removed' is a script tag)
Code:
function inlineCSS ($identifier, $code){
        if(!in_array($identifier,$this->loaded_objects['inlineCSS'])){
            $this->loaded_objects['inlineCSS'][$identifier] = '[removed]'.$code.'[removed]'."\n";
        }
    }

should be


Code:
function inlineCSS ($identifier, $code){
        if(!in_array($identifier,$this->loaded_objects['inlineCSS'])){
            $this->loaded_objects['inlineCSS'][$identifier] = '<style type="text/css">'.$code.'</style>'."\n";
        }
    }

[eluser]webberoo[/eluser]
Jtaby,

One of the organisations I work has asked me to build a web version of their cd library database. The db was previously setup using access and I have moved the data across to mysql. At the moment I have a table called library which has around 30,000 rows in it which I need to build a CRUD for.
I thought I'd see how it ran without setting up a yaml file and upon opening I get a php script timeout. This doesn't bother me to much as I can just alter the php.ini file to make the execution time longer but ideally I'd like the script to run under 30 sec's anyway.

My question is. Will codex be able to handle a db table of over 30000 rows?

Love your work
-Toby

[eluser]trkan[/eluser]
[quote author="webberoo" date="1223042459"]Jtaby,

One of the organisations I work has asked me to build a web version of their cd library database. The db was previously setup using access and I have moved the data across to mysql. At the moment I have a table called library which has around 30,000 rows in it which I need to build a CRUD for.
I thought I'd see how it ran without setting up a yaml file and upon opening I get a php script timeout. This doesn't bother me to much as I can just alter the php.ini file to make the execution time longer but ideally I'd like the script to run under 30 sec's anyway.

My question is. Will codex be able to handle a db table of over 30000 rows?

Love your work
-Toby[/quote]


You are getting this error, because at the moment, Code Extinguisher is using client-side pagination. Meaning all 30000 records are first sent to your browser.

There is a post earlier post about using a server-side pagination, it is not that hard to implement, since all of the hooks are still in the code. CE was doing server-side pagination before.

And, yes, with the server-side pagination t should work w/o any problems

[eluser]webberoo[/eluser]
[quote author="trkan" date="1223198177"][quote author="webberoo" date="1223042459"]Jtaby,

One of the organisations I work has asked me to build a web version of their cd library database. The db was previously setup using access and I have moved the data across to mysql. At the moment I have a table called library which has around 30,000 rows in it which I need to build a CRUD for.
I thought I'd see how it ran without setting up a yaml file and upon opening I get a php script timeout. This doesn't bother me to much as I can just alter the php.ini file to make the execution time longer but ideally I'd like the script to run under 30 sec's anyway.

My question is. Will codex be able to handle a db table of over 30000 rows?

Love your work
-Toby[/quote]


You are getting this error, because at the moment, Code Extinguisher is using client-side pagination. Meaning all 30000 records are first sent to your browser.

There is a post earlier post about using a server-side pagination, it is not that hard to implement, since all of the hooks are still in the code. CE was doing server-side pagination before.

And, yes, with the server-side pagination t should work w/o any problems[/quote]

That totally makes sense. thanks for that I'll search out the ppost on serverside pagination and then post a tutorial on the wiki.

[eluser]webberoo[/eluser]
[quote author="jTaby" date="1219785785"]Hey guys, for those of you who wanted traditional pagination (i.e. load only 50 records at a time), i did that recently, and here is a zip file with the files i changed. This is untested and probably has bugs, but it works fine so far for me. Just replace the files in the zip with the ones you have:

http://jtaby.com/bucket/Archive.zip[/quote]

Hey guys,

Have applied this patch and some weirdness has ensued. In the pager at the bottom of the page it will only show the first 78 rows ie using 20 records per page show 1/3 pages
The weird thing is when I search I can get results from deeper in the database I'm guessing some of the maths is out on the pager setup I just can't find what i need to change.

--
OK after a couple of hours of trawling the net and looking through the codex code. Can someone point out where the jquery pager plugin gets its query information from?

[eluser]webberoo[/eluser]
Jtaby you around man? I know your probably busy but if you got a spare minute can you explain to me how the jquery table pager grabs data from the database tables.




Theme © iAndrew 2016 - Forum software by © MyBB