Fictive Table - Model Based On File, Not Table

Yii 1.1 General Discussion
1

Hi guys…

I have a txt file which can be parsed and saved into DB. But I don’t want to save it to DB, I just need to create a fictive table in memory (using Active Recod for example) and I need to sort it, group it and select values. Very often the file is changed and the old version is useless. Each row of the file has length of 128 signs and I know that 9 chars = name, 9 chars = surname, 6 chars = born date etc (no delimiters)

example of file:




Peter    Moris    050686 M  p.moris@gmail.com     USA  California   San Francisco    21 Cool Drive

Clair    Kelly    121089 F  clair.k@barbie.com    UK   UK           London           13 Funny Road 

...

...

Can this be done? Or should I load it to DB?

2

You can parse in a php array and then use CArrayDataProvider.

Anyway, I think that writing a command for load the file in the database will save you a lot of time.