[FLOW3-general] static db table content

[David Sporer]

Hi Thomas,

I'd say e.g. create a model for countries and import all countries.
Now the other data has a 1:n relationship to countries an you only use
references.
So do you want to know how to create a model and relationships to that model?
In TYPO3 Flow you don't deal with the database directly so crating a
table means creating a model and adding data to that table means
creating objects of that model and persist them.
static_info_tables is also just creating a bunch of tables and fills
them with standard data if I remember right.

Regards
David

Am 17.12.2012 um 19:57 schrieb Thomas Mammitzsch <thomas at visualworx.de>:

> Hi David,
>
> yes, i could do it that way and maybe i do. But that will spam my table with repetitive strings which stands against normalization. Besides that i'm curious how that can be solved. Think of static_info_tables from TYPO3, how would such a thing be realized in Flow?
>
> regards, Thomas
>
> On 17.12.2012 17:35, David Sporer wrote:
>> Hi Thomas,
>>
>> Ok but I don't get your point.
>> Do you need those integer values? Why don't you merge the CSV-files before
>> importing and import the strings along with the other data?
>>
>> Regards
>> David
>>
>>
>> 2012/12/17 Thomas Mammitzsch <thomas at visualworx.de>
>>
>>> Hi David,
>>>
>>> i do bulk import lots of csv data to objects which then are persisted to
>>> database. This objects have integer references to some simple strings from
>>> another csv. This has been made because of normalization mostly i think.
>>>
>>> Does Flow support fixtures? I think that could work.
>>>
>>> regards, Thomas
>>>
>>>
>>> On 17.12.2012 17:18, David Sporer wrote:
>>>
>>>> Hi Thomas,
>>>>
>>>> why do you want to do this?
>>>> Can you give an example?
>>>> I think it would be better to store static content in templates or
>>>> configuration files.
>>>>
>>>> Regards
>>>> David
>>>>
>>>>
>>>> 2012/12/17 Thomas Mammitzsch <thomas at visualworx.de>
>>>>
>>>>  hi list,
>>>>> whats the best way to create database tables with static content?
>>>>>
>>>>> regards, Thomas
>>>>> ______________________________****_________________
>>>>> FLOW3-general mailing list
>>>>> FLOW3-general at lists.typo3.org
>>>>> http://lists.typo3.org/cgi-****bin/mailman/listinfo/flow3-****general<http://lists.typo3.org/cgi-**bin/mailman/listinfo/flow3-**general>
>>>>> <http://lists.typo3.**org/cgi-bin/mailman/listinfo/**flow3-general<http://lists.typo3.org/cgi-bin/mailman/listinfo/flow3-general>
>>>>>  ______________________________**_________________
>>>> FLOW3-general mailing list
>>>> FLOW3-general at lists.typo3.org
>>>> http://lists.typo3.org/cgi-**bin/mailman/listinfo/flow3-**general<http://lists.typo3.org/cgi-bin/mailman/listinfo/flow3-general>
>>>>
>>> ______________________________**_________________
>>> FLOW3-general mailing list
>>> FLOW3-general at lists.typo3.org
>>> http://lists.typo3.org/cgi-**bin/mailman/listinfo/flow3-**general<http://lists.typo3.org/cgi-bin/mailman/listinfo/flow3-general>
>>>
>> _______________________________________________
>> FLOW3-general mailing list
>> FLOW3-general at lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow3-general
>
> _______________________________________________
> FLOW3-general mailing list
> FLOW3-general at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow3-general