HOW TO ADD NEW COLUMN

[ctw28]

i need to add some column field in same file. can u tell how? cause in README.md i only found add column when create new file. thank you

[gam6itko]

@ctw28 unfortunately there is currently no way to add a new column to an existing file. If you really need it, I can start developing this feature.

[ctw28]

yes, i need it, and i would say thank you if you want to develop this feature. and i think, it will be great feature.

[JohnnyQ352]

You can add a column to an existing table in Laravel before you set data

use Illuminate\Support\Facades\DB;
DB::raw('ALTER TABLE '.$FullTableLocationPath.' ADD COLUMN new_column_name VARCHAR(255)');

$dbfTable = new WritableTable($FullTableLocationPath, [
'editMode' => WritableTable::EDIT_MODE_CLONE,
]);

foreach ($query as $row) {
$record = $dbfTable->appendRecord();

foreach ($row as $field => $value) {
	$column = strtolower($field);
	$record->set($column, $value);
}
$dbfTable->writeRecord()->save();

}

$dbfTable->close();
}

You can do it using PDO in laravel as well

$dsn = 'dbase://your_path/to/your_dbase_file';
$pdo = new PDO($dsn);

$sql = 'ALTER TABLE your_table_name ADD COLUMN new_column_name VARCHAR(255)';
$pdo->exec($sql);

.... Then do set data parts here..

[JohnnyQ352]

Adding notes about adding columns. The 2.2.0 version now has a way to add columns to a new table.
You can read all the columns in an existing structure and then create a new table with the extra columns.
This will allow you to create a table with the added columns, then just fill the new table with the old table's
data and while you do, add the data to the new column.

Note: This is good if the table is not too big. I have tables I would not do this with because they are huge, like in the millions of records from old DBASE software. But if they are not so big, then pump the jam man. Good Luck!