nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DD config basics

Adam Stoller

Environment

Find more posts tagged with

Comments

nakumar

Do I have to include the CREATE and SELECT sections in the DD config file? (I imagine so, but if I don't it saves me some time)
- Is the example on page 175 accurate with regard to CREATE?
- and the code on the previous page (174) needed for SELECT?

Answer:-
No need to give CREATE or SELECT statement in deployment configuration for deploying DCR's to DB tables by default.

However if there is an requirement to create a table other than mentioned in dbschema section, we can explicitly create table using SQL action=CREATE

If I have the 'path' field, then can I use that in a filter so that it will only process files of a particular type despite being given a filelist that contains files of other types?
What about if I don't have a 'path' field??

Answer:- Yes we can use. Please refer Page-125 DDadmin guide "Data filters"

If you don't have 'Path' has a column, then think of some other existing column which can be used for filtering.

How do I indicate an identity column in the dbschema, i.e. a column which is populated automatically on the db-site whenever an insertion is performed, but which is likely to also be a primary key for the able?

Answer:- Yes we can associate primary key columns too. Something like this:

[html]

[/html]

Please refer Page-139 of DD admin guide (OD 620)

You can check either log files or the database tables to confirm the tables and its data got deployed.

Adam Stoller

Is that clearer?

nakumar

External Data Source (EDS) is one solution for this. Other can be table level trigger, i.e. whenever dd tries to insert a row, automatically insert some values using triggers.

Not sure about the second one i.e triggers. Please see ddadmin p123-125.

Migrateduser

[QUOTE=ghoti]

quick comment on this, are you using that (id) key for anything.. I tend to store the ID in the DCR (using a callserver that just pulls a unique ID from a sequence and puts in in a hidden field) and that way I know 1 - its always unique2 - stays the same for that piece of content3 - stays consistent across multiple environments (i.e. the ID in a preview or stage DB would match that of the production DB).. not sure if that helps you, but I found the goind the EDS route actually causes more problems then it solves.. also instead of value-from-field="/some/0/xpath/0/here/0" you can just do value="" (like if you wanted to pass in a static value or something).. that might let the autoincrement work (though as per my above, I am not sure I would use autoincrement)... you might need to say allows-null="yes" so DD wont fail it though.. have but I have not tried it that way..

moonkhanna

Path & State columns (data provided if reference provided) - thanks
CREATE & SELECT sections (not needed in scenario described) - thanks
Filtering on path field (code segment accurate) - thanks
How do I indicate an identity column in the dbschema, i.e. a column which is populated automatically on the db-site whenever an insertion is performed, but which is likely to also be a primary key for the able?
I guess I wasn't clear - the example code you provided here does not seem to respond to my question, so I'll try again.

The table, in the database, has a column (we'll call it "ID") for which there is no corresponding field in the DCT/DCR. Whenever a new record is created and inserted (not updated) into the database - the database automatically populates this column with a unique value (probably sequential).

Given that, where I do not have a field in my DCR for this ID field, but it exists in the database:
Do I have to reference the field at all in my dbschema section of the configuration file?
If so - how is it written? It wouldn't be
data-from-field='/article/0/id'
- because I don't have any such field in my DCT/DCR
Do I (can I) consider / use the column as a "primary key"?
Do I have to write Java code to perform some sort of pre-insertion magic to retrieve the ID before the actual insertion of the data??
Something like the information starting on page 153 of the DD Admin manual? "External Data Source"?
OR
Do I have to create the field in my DCT (hidden, no value?) / DCR so that I can reference it in the dbschema and assume that the DB will "do its thing" by:
Ignoring the empty value in the field if the column is part of a table row being updated
Ignoring and populating the column if it is a table row being inserted?
Is that clearer?

Hi Adam,

Its been long since I have written a DD Config as well however I believe with UDS, you need not define each and every column of the database in your ddconfig. Yes, if you have a column which is not being auto populated or does not has a default value, you will have to push some value to the column.

In your case, if the column in the Dtaabase table is auto increment or alike, it will automatically insert the value when you push a new row so you need not mention this column in your dbschema

Adam Stoller

Working with Support I've managed to get some of my questions answered - my case though became a bit more complicated that originally thought. While I don't have it completely working yet, here's what I have so far:

Hopefully tomorrow I'll be able to verify if it works. If not, the developer will probably spend some time re-vamping his code so that it doesn't require the ID field at all and just uses the other unique field..